Category Archives: Dataload

New template to load Brazilian Fiscal Classifications

Posted on 28. July 2010 by tlu

A new template to load Brazilian Fiscal Classifications is added. Load BR Fiscal Classifications

Posted in Dataload, News, Templates, Templates Development, xls4oracle | Leave a comment

Template for Brazilian Tax Exemptions

Posted on 18. May 2010 by tlu

A new template is on its way. The template will load tax exemptions and legal messages. There is no API for this, so data is loaded directly into base tables. The template is validating all codes and getting the id’s needed. … Continue reading →

Posted in Dataload, Templates, Templates Development, xls4oracle | Leave a comment

Release 3.6.6.217 – ready for testing

Posted on 6. January 2010 by tlu

All reported bugs is closed. The sql extract is now many times faster…

Posted in Revision History | Leave a comment

How to prepare for a parallel load

Posted on 6. December 2009 by tlu

The load column (column A in the data sheet) will be subtracted by one when processed. This is a standard feature in xls4oracle. With this feature, you can generate multiple load scripts easy. To do this, you just enter the … Continue reading →

Posted in Dataload | Leave a comment

Updating customer profile class

Posted on 18. November 2009 by tlu

We just had a task of updating 500+ customers with a new profile class. Here is the howtO: Create new template Create Data sheet: – site number – profile class id   Create Dataload sheet with this code:   DECLARE  — … Continue reading →

Posted in Dataload, Templates, xls4oracle | Leave a comment

How to use xls4oracle to start hundreds of concurrent requests

Posted on 25. September 2009 by tlu

An ad hoc requirement was raised – where we needed to start hundreds of concurrent programs, the same program but with different responserbilities and parameters. This would have been a hell of a job to do manually. First we identified … Continue reading →

Posted in Dataload, xls4oracle | Leave a comment

Version 3.6.2.211 – Oracle / Excel date conversion fixed

Posted on 2. April 2009 by tlu

When using SQL, Oracle date will be conversted to Excel date. When using Dataload, Excel date will be converted to Oracle date. When system date format is empty, they will be defaultet.

Posted in Revision History | Leave a comment

Version 3.6.1.210 – New features added

Posted on 2. April 2009 by tlu

The 3.6.1 version has some new feature: utility to set the apps initialize progress form also in the sql tool maxline functionality updated Spoolname accepts: $filename, $timestamp, $seqnr Check for duplicate header names

Posted in Revision History | Leave a comment

Version 3.0.2.184 – Minor improvements

Posted on 31. October 2008 by tlu

Multiline load error count and error message corrected. Moved first save workbook to after cancel/continue descision. The log file will generate in csv file format. Excel For Oracle Applications

Posted in Revision History | Leave a comment

Version 3.0.0.180 – Improved performance and added functionality

Posted on 25. October 2008 by tlu

Dataload: Code has been optimized – the performance of the generate mapping section is now performing around 10 times faster. Added comment on heading line: mapping info. The ‘OK’ button on the status form is now defaulted – so you … Continue reading →

Posted in Revision History | Leave a comment