QAD QXtend Excelerator Release Notes
July 2013
These release notes include information about the latest fixes and changes to QAD QXtend Excelerator. These changes may affect the way you implement and use the product.
Important: Review this document and the QAD QXtend Excelerator errata before proceeding with any phase of a QAD QXtend Excelerator implementation.
These release notes are cumulative, with the most recent changes described first. Review the notes for all releases after your currently installed release. Installation and configuration changes may have occurred in those intermediate releases, and unless otherwise noted, apply to the release where they were announced, as well as subsequent releases.
QAD highly recommends that you implement the latest QAD QXtend Excelerator release available. Check the QAD Web site to make sure that you have the latest QAD QXtend Excelerator release notes, installation guide, installation media, and errata information:
Use the following list to find release notes for a specific product:
Release Notes for Current Release
Version: 1.3
Date: July 2013
Related Documentation: User Guide: QAD QXtend Excelerator (70-3191-1.3)
New Features
Support for Microsoft Excel 2013
Excelerator client is now integrated with Excel 2013, Excel 2010, and Excel 2007.
Error Message for Mismatch between QXtend Profile and Excelerator API
In this release, when you execute Query QAD, if the root table in Excelerator is not found in the response QDoc, an error message pops up.
Message Windows
Previously, some pop-up message windows extended beyond the screen. The OK or Cancel buttons were invisible on the screen, which prevented you from being able to close the message window. In this version, the message windows are resizable or come with a scroll bar.
Automatic Conversion of Values When Importing CSV Data
Previously, before importing an exported CSV file, you needed to manually replace the value “Yes” with “True” and “No” with “False” in the CSV file. The manual replacement sometimes caused a failed import. In this release, Excelerator automatically converts the values during import.
Query Cancelation
This Excelerator release provides a Cancel button on the Processing Query screen. You can cancel a query in process using the Cancel button.
Special Characters in CSV Files
Previously, if the fields in CSV files contained special characters, such as commas and quotes, importing the CSV files failed. In this version, you can import CSV files containing special characters.
Filter for Selecting Tables & Field
Excelerator provides a filter on the Select Tables & Fields window for you to easily search the fields that you need when you design the template.
New Configuration Options
• Scope Transaction option is available now in the QAD QXtend Excelerator Settings window.
• Debug Level field is now available in the QAD QXtend Excelerator Settings window for you to specify debug level for financial QDocs.
Export Errors Button
Excelerator provides an Export Errors button on the QAD Tools bar for you to export errors to a text file.
Support a Space as Field Value
Excelerator now allows users to input a space in the date field in a worksheet to have the date field with no value included in the QDoc.
Fixes
|
Fix Description
|
Internal ID
|
Affected Versions
|
|
Fixed the issue that Excelerator does not pass authentication to QXI query service receiver.
|
QXE-4
|
1.0
|
|
In the Select Tables & Fields window, the field labels are always displayed regardless of the Process Response QDoc setting.
|
QXE-57
|
1.2+
|
|
Previously, when using a comma as the decimal point in a decimal figure, Exelerator failed to import/export data from/to CSV files. Now this issue has been fixed.
|
QXE-66
|
1.0+
|
|
If a query QDoc was deployed from a profile containing a dash or underscore in the name, Excelerator reported it as a non-existent profile when you executed Query QAD. Now this issue has been fixed.
|
QXE-69
|
1.2
|
|
Previously, if the primary key of a QDoc contained a string in date type, Excelerator could not load the data. Now this issue has been fixed.
|
QXE-70
|
1.2
|
|
Excelerator can now correctly handle integer data type, which was previously handled as string.
|
QXE-72
|
1.2
|
|
Previously, if you set a tomcat port higher than 32767, you could not save the settings to QXtendWorkbookConfig.xml. Now this issue has been fixed.
|
QXE-73
|
1.2
|
|
Excelerator can now display errors that caused it to fail loading schema labels.
|
QXE-88
|
1.0+
|
Known Issue
When Excelerator 1.3 works with QXtend versions before 1.8.4, decimal data using a comma as the decimal separator cannot be loaded into QXtend.
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.2+
|
|
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.2+
|
|
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.2+
|