Category Archives: Dataload

Template for Brazilian Tax Exemptions

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 | Comments Off on Template for Brazilian Tax Exemptions

How to prepare for a parallel load

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 | Comments Off on How to prepare for a parallel load

Updating customer profile class

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  — 17-nov-2009 … Continue reading

Posted in Dataload, Templates, xls4oracle | Comments Off on Updating customer profile class

How to use xls4oracle to start hundreds of concurrent requests

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 | Comments Off on How to use xls4oracle to start hundreds of concurrent requests