View Single Post
  #2 (permalink)  
Old May 25th, 2007, 19:49
bmj_23 bmj_23 is offline
Senior Member and Blogger
 
Join Date: May 2007
Posts: 170
Thanks: 4
Thanked 31 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
bmj_23 will become famous soon enough
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.