Category Archives: xls4oracle

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

New template to Load Pricelist

Posted on 15. July 2010 by tlu

New template added for extract existing pricelist, update existing or enddate existing and create new. Just enter pricelist name on the bind sheet and execute the sql. Data sheet only need: Pricelist name item no list price start date If … Continue reading →

Posted in 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

New template for updating People

Posted on 28. April 2010 by tlu

Pls. chk: Update People

Posted in Templates | Leave a comment

Start Concurrent Requests: Added sql for extract

Posted on 17. April 2010 by tlu

You can now extract concurrent request from one environment and restart concurrent request on any environment, as many times as needed. Excellent for perfomance  or unit testing.

Posted in Templates | Leave a comment

Release 3.6.8.219 – requires new vstor.exe!!!

Posted on 6. February 2010 by tlu

The 3.6.8.219 release is checking for existense of this vstor.exe: Microsoft Visual Studio 2005 Tools for Office Second Edition Runtime (build 8.0.50727.940) (x86) Pls. install this vstor.exe before installing xls4oracle 3.6.8.219.

Posted in Known Issues, installation, xls4oracle | Leave a comment

6 new customer templates added

Posted on 5. February 2010 by tlu

update organizations – posted 05-02-2010 update locations – posted 05-02-2010 update party site – posted 05-02-2010 update cust account site – posted 05-02-2010 update cust account site use – posted 05-02-2010 update cust account – posted 05-02-2010 Extract scripts is … Continue reading →

Posted in Templates, xls4oracle | Leave a comment

Release 3.6.8.219 – ready for production

Posted on 3. February 2010 by tlu

The dataload form is now completed. This enables validation of all parameters before dataload. Passwords are now encrypted and a new feature enables a lock on dataload and system sheet to prevent unintended updates of validated workbooks. The user manual … Continue reading →

Posted in xls4oracle | Leave a comment

Two new customer templates added

Posted on 30. January 2010 by tlu

The “update customer profile” and “update customer profile amounts” templates will enable you to extract profile and profile amounts (sql extracts included) – and do updates. The templates is using HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUST_PROFILE_AMT and HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE procedures for update.

Posted in Templates | Leave a comment

xls4oracle ½ day workshop

Posted on 16. January 2010 by tlu

A workshop is now planned to intruduce new users for the xls4oracle tool. The agenda for this workshop is: Update customer data Customizations of a customer template (add new column) Update item data Customizations of an item template (add new … Continue reading →

Posted in Workshop, xls4oracle | Leave a comment