Share
ReportThis is a related question from a previous post about TI.
What I am trying to do is create a new shipping address for every customer in the database. The only real difference is the name of the ShipToID and the TaxID1 of the address. Everything else will be copied from the default address for each customer.
We have about 6,600 customers. The problem that I have is creating a data file out of the customer information I export from Excel. I can export the "Default" address for each customer into a CSV file. Obviously there is one line per address. The data file for TI, however, needs Level0 and Level1. I don't know how to create an Excel file with two lines per customer from the single line in the .CSV without a ton of manual labor. Basically I would have to turn 6,600 rows into 13,200 rows by hand. So, here are my questions:
1. Is there a relatively easy way to create the Excel file I need that can then be exported to CSV for TI?
2. If not, can I create a data file that just has the level0 records for the customer ID and then hard code the changes into the Control Macro? The reality is that I am happy to accept the default address for all fields but the two that I require to change to create the new address which are the ShipToID and the TaxID1 fields.
In testing that I did today I found that even if I hard code the new data into the control macro, TI does not create the new addresses. I am assuming that is because I don't have any Level1 information in the data file and thus TI doesn't try to create a new address. When I run TI on my test data I see it open each customer and then immediately close it. Again I assume that is because there is nothing in the data file to prompt it to enter any level 1 data.
Any tips or tricks to get this done?
Thank you for your time.
*This post is locked for comments
All responses (
Answers (
16
