[Dave Lee]

Hi,

I have compile a list of tables require when uploading configuration data into OTM.

Location

· LOCATION
· CORPORATION
· LOCATION_REFNUM
· LOCATION_CORPORATION
· LOCATION_ADDRESS
· LOCATION_ROLE_PROFILE
· CONTACT

THU

· SHIP_UNIT_SPEC

Equipment

· EQUIPMENT_GROUP
· EQUIPMENT_GROUP_PROFILE
· EQUIPMENT_GROUP_PROFILE_D


Rates

· HNAME_SET
· HNAME_SET_MEMBER
· X_LANE
· LANE
· RATE_SERVICE
· SERVICE_TIME
· RATE_VERSION

Does anyone have the tables for Rate Offerring, Rate Record and Itineries.

Thanks

Regards,
Dave Lee

[oliver]

Hi Dave,

i guess the ERD gives you the info that you need, like for itinerary :
- itinerary
- itinerary_detail
- leg
- transport_mode
- region
- etc......

Rgds
Oliver

[Dave Lee]

Thanks. Do you know where can i get the ERD from? One more question, for migration between UAT environment to Production environment, is there other better methods beside data upload via CSV in OTM?

[jeff.depaul]

Dave,
There is a better way, you can post the data load to the CSVUtil servlet. The call would look something like this:
"java glog.database.admin.CSVUtil -command iu -maxError 1 -connectionId <<db_name>> -dataDir $FILEDIR/ -dataFileName $TABLENAME -runsqlloader -debug -xvalidate Y"

We wrapped the call to this in a shell script which reads the tables in order from another file recursively (similar to what you mentioned above) - specifically we used for loading rates. The program takes some time to get setup just right but once set, you can use it for loading just about any data that you would load csv from the front end.

-Jeff

[arunk]

Originally Posted by Dave Lee

Thanks. Do you know where can i get the ERD from? One more question, for migration between UAT environment to Production environment, is there other better methods beside data upload via CSV in OTM?

Dave,

FYI - a related post on ERD.
http://www.otmfaq.com/forums/f63/otm-erwin-diagram-702/ (OTM Erwin Diagram) (OTM Erwin Diagram)