Monthly Archives: November 2009

The Update Customers template has been updated

Posted on 26. November 2009 by tlu

The update customers template has conformed sql for extract and update. On the sql sheet you will find: $cust_addr_su and $cust_rel_addr_su The $cust_addr_su will extract customer, address and site use info. The $cust_rel_addr_su will also extract relations. Some mappings is … Continue reading →

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