Transfer data between Excel and SAP with Quadrate software - version of erp C B C AE released

By: Quadrate  11-11-2011
Keywords: SAP, File Folder

Version of ERP²® Released

July 1, 2011 - Quadrate releases version of ERP². This version contains the following new features and bug fixes:

Version (July 1, 2011)

New Features:

  • Uploads containing more than 999 line items can now be uploaded.
  • Users can simulate data uploads without committing changes to SAP.
  • Long text can be changed in BDC recordings using the newer SAP text editor.
  • Multiple Templates and Upload Mappings can be exported and imported at once.
  • Enterprise Clients will prompt to auto update when Enterprise Server has been upgraded.
  • Installer is compatible with both 32 and 64-bit machines.
  • Improved performance with Office 2007 XLSX files.

Fixed Bugs:

  • Conditional scripts in upload mappings applied to the first line item of a loop would cause the upload to fail.
  • After updating the name of a field in the template editor a newly created load file would not reflect the changes made.
  • Moving a column from the detail to the header level in a same file mapping would not update the mapping.
  • Deleting tags while in use would throw an unexpected error.
  • Hitting enter on the duplicate template name message would attempt to start the recording again.
  • Groups would not be hidden after removing all the templates in a group.
  • Selecting another SAP system after a logon failure would never use the stored credentials.
  • The relationship editor would come up twice after closing a data source.
  • Users were unable to open data sources from the Data Sources tab in the Upload Mapping Browser.
  • The logs would not always refresh correctly when changing the log filter.
  • The template editor would prompt to download field descriptions when the Descriptions check box was unchecked.
  • Multiple same level loops could not be created without a field being modified between the loops.
  • A templates execute every x and then y line items was only saving a maximum value of 1000.
  • Canceling out of the log on dialog would present the user with an error message.
  • A message would not be displayed when a log was successfully exported.
  • The selected item in the upload section would not always scroll into view during a refresh.
  • The file explorer would attempt to load the Desktop folder first before loading the load file folder causing potential performance issues.
  • Backup sheets would automatically be mapped when Upload Mappings were created from Load Files and the Backup option was set.
  • Highlighting in the relationship editor was not showing with white text when an item was selected.
  • Attempting to restore the original template contents on a template that was renamed during import threw an error.

Keywords: File Folder, SAP

Contact Quadrate

Email - none provided

Print this page


Other products and services from Quadrate


SAP Data Upload & Extraction Solutions

Business users do not need to understand SAP tables or fields, they can create the query by stepping through a transaction in SAP's familiar GUI - this will record the fields the user has selected and will automatically create the complete query. ERP² enables accurate and rapid transfer of data from spreadsheets or databases into SAP in a simple three-step process.


Upload Excel & Access Data Files into SAP with ERP Squared (ERP

For a fraction of the cost of a regular inflexible custom-built ABAP upload program, ERP² can be used to upload Excel files and Accessfiles directly into SAP without any ABAP programming or technical expertise. Much of the data being uploaded into SAP already exists in a digital format such as Microsoft Excel spreadsheets or Microsoft Access databases.


Extraction & Reporting into Excel or Access

The extensive report writing functionality allows users to create complex business reports in minutes, and reports may be exported in several formats including Excel, TIFF, PDF and HTML. Quadrate's R/3 extraction solution for SAP data provides a simple and easy to use method for performing ad-hoc queries against an SAP system without any programming expertise.


Transfer data between Excel and SAP with Quadrate software - news

Cincinnati, OH, May 1, 2006 - Quadrate announces the launch of its US Operations on May 1, 2006. Our offices are located at 4555 Lake Forest Drive, Suite 650, Cincinnati, OH 45242. The United States is currently the largest SAP market and to..


Transfer data between Excel and SAP with Quadrate software - version of erp C B released

Fix for SAP systems that do not supply a Continue Without End logon option for multiple logons. Allow the backup of data from SAP transactions to allow rollback on certain transactions. Additional security checks for upload mappings with shared templates. Added the ability to change the system a upload is scheduled on. This version contains the following new features and bug fixes. 2010 - Quadrate releases version 9.9.302 of Data Workbench.


Most Common Uses of ERP² Identified by our Customers

Master Data creation, changes or deletions of vendor, customer, material and equipment master as well as fixed asset or functional location data. ERP² may be used to upload both Master and Transactional Data into SAP. Mass updates and changes for employees, prices, projects etc. Sales orders and vendor invoices with multiple line items. Creation of master data for testing business scenarios.