This page is dedicated to frequently asked questions and answers about our QAD Excel Integrated solutions initiated by our clients. If you do not find information here, please contact us .
Q. How does 25.13.1 Loader handle transaction is out of balance problem?
A. The program checks overall transactional balance as well as balance per each entity, similar to QAD 25.13.1. The difference is if Journal Entry on the spreadsheet is out of balance the loader won’t upload – “hard stop”, whereas QAD 25.13.1 still accepts transaction with “soft warning”.
Q. When uploading 10,000 rows it works fine, takes 3 minutes, when I try 15,000 it just sits there, so my guess is 10,000 is the limit? Is there a limitation how many records can be uploaded at once? If so, what factors it depends on?
A. It has to do with QAD server settings, particularly -L progress server startup parameter, it holds the number of locks. The bigger the number the more records one can upload per batch. When user hits this limit QAD server just disconnects Excel user and quits progress session, user gets “time out” message. Technically it’s safe operation, but leaves user clueless since it does not provide much details what happens. It will be addressed in the future.
Increasing the -L value will consume a bit more server resources. Some cases, this can be a good solution, please coordinate with your DBA.
The number of locks does not correspond to the number of records in Excel spreadsheet, but rather one excel record to many records in QAD database. For instance 1.10.1.1 QAD standard program updates many records in a few different tables at once for one pricelist record.
As general recommendation, when large updates to be performed, we would suggest to run them in hours when less users are logged in to QAD and less batch processes are run. This will allow more server resources to be allocated to excel updates.
Workaround, using “chunks”:
In yous situation above where you have 30K on the spreadsheet, but only 10K can be processed at a time, we would recommend insert a blank row in row in row 10,000, click upload – and only first top 10K records will be uploaded. The program stops at blank row 10000. Once completed, delete first 10K records from the spreadsheet and insert blank row again into row 10000, upload again, etc..
Q. Every time I open excel template it warns me about macro security and I have to enable macro content. Is there a way to switch off Security Alert Macro? I want security only enable macro content of 32Soft excel files automatically, but block all other files. How this can be done?
A.The simplest way will be defining a trusted location in Excel to your server where all 32Soft files will be stored. Alternatively, you may order code signing certificates from Certificate Authority 3rd party company, such as e-trust, Verisign or similar. We will add the certificate to your excel templates.
Q. Is there a quick way to find all errors on the spreadsheet?
A. Use Find command CTRL-F, type ERROR in the “Find What” field. Select Options, select “look in comments”, click on “Find All”. You will see the whole list of errors on the sheet and will be able quickly navigate to them.
Q. What is the difference between Excel loader programs and web applications you are offering?
A. Each our excel loader module has been designed to perform a specific business function. These tools are meant for individual end users, who must perform lots of changes or transactions in the system within short period of time. Whereas web applications are meant to share real time information to larger group of people and perform smaller transactions or updates in QAD.