| Re: Location Loading Sequence OK, so my take it on would be:
1. Load the corporation Id via the UI - just key it in, its probably easier. If you want to, you can load a new corporation in to the corporation table.
2. Load the location table
3. Load the location_address table (assuming you have address information for your locations)
4. Load the location_corporation table (this will link the location gid you have loaded with your corporation gid)
5. Load the location_role_profile table (you will probably want a location_role_gid of SHIPFROM/SHIPTO for each location you are loading.
6. Load the contact table with reference to the location_xid that you to relate the contacts to.
With all of these things, the easiest way of doing it is to key one example in to the application via the UI and then unload the relevant tables in CSV. That will give you all of the data maps you need to do a mass load of the data you have. |