Release Notes for Release 1.2
Version: 1.2
Date: September 2011
Related Documentation: User Guide: QAD QXtend Excelerator (70-3191A)
New Features
Supported Client Operating Systems
Excelerator has now been certified against Windows XP, Windows 7, and Windows Server 2003 on the client side.
Support for Microsoft Excel 2010
Excelerator client is now integrated with Excel 2010 as well as Excel 2007.
Option to Retain Data after Template Change
Previously, after you changed the data integration worksheet template—whether it is adding or removing a table or a field—all existing data in the worksheet would be lost. Now, when you change the template design and update the worksheet, the system prompts you to retain existing data in the worksheet. If you choose to retain the existing data, all the rows in the worksheet are marked as Processed. Use Update QAD|Process All later to update data to the target QAD application.
CSV Files Import and Export
Excelerator now provides the new CSV files import and export functionality under QAD Tools.
You can import the CSV file—either a single CSV file containing all the tables or separate CSV files each containing one table—into the Excelerator worksheet.
Using the CSV export tool, you can export data from the Excelerator worksheet into a single CSV file or multiple CSV files, one for each table. The structure of the exported CSV file strictly follows that defined in the imported CSV file.
Worksheet Template Types
There are now two Excelerator worksheet template types:
• Data load template: It is the system default worksheet template type and used for loading or updating master data into QAD Enterprise Applications.
• Business transaction template: Use this template type when you want to create from Excelerator new business transaction records (for example, sales orders) in QAD Enterprise Applications that require key field values or business document numbers (for example, sales order numbers) to be generated by the target system. This feature is realized by using the key prefix. When processing the updates to QAD, the temporary key prefix is removed and replaced with the system generated key (for example, the sales order number).
Previously, you could only create one business transaction record at a time by leaving the key field blank in the Excelerator worksheet.
Fixes
|
Fix Description
|
Internal ID
|
Affected Versions
|
|
The system has been modified so that after you delete data from the worksheet, the parent-child data binding is no longer lost.
|
QXE-33
|
1.0+
|
|
The following issues relating to the data grid functionality have been fixed:
• Rows could not be deleted in the Data Grid view.
• When you added new rows either at the top or the child level, data binding to the worksheet could not be maintained correctly.
|
QXE-35
|
1.0+
|
|
The installation media now has two folders—Excel 2007 and Excel 2010—that contain the installer and associated files for installing Excelerator against the two versions of Microsoft Excel respectively. In the previous release, the Excelerator installer did not work for Microsoft Excel 2010.
|
QXE-43
|
1.0+
|