View Single Post
  #4 (permalink)  
Old August 21st, 2008, 04:17
jeff.depaul jeff.depaul is offline
Member
 
Join Date: Jun 2007
Posts: 37
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 1
Thanked 8 Times in 8 Posts
Rep Power: 0
jeff.depaul is on a distinguished road
Send a message via Yahoo to jeff.depaul
Re: Tables Requires for data upload via CSV

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
Reply With Quote
The Following User Says Thank You to jeff.depaul For This Useful Post:
Dave Lee (August 21st, 2008)