View Single Post
  #3 (permalink)  
Old June 1st, 2007, 15:15
ebauchwitz ebauchwitz is offline
Junior Member
 
Join Date: Jan 2007
Location: Andover, MN
Posts: 14
Thanks: 6
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
ebauchwitz is on a distinguished road
Re: Location Loading Sequence

I was able to successfully upload all of the following tables except for the Corporation.csv.

The following were sucessfully uploaded...
Location.csv
Location_Corporation.csv
Location_Role_Profile.csv
Contact.csv

Since we have over 400 locations to add into OTM, manually adding the Corporation ID's would be a very time consuming process. While loading the Corporation ID through a csv upload, I received the following error message.
- <Error>
<TableName>corporation</TableName>
<Exception>ORA-00921: unexpected end of SQL command</Exception>
<Data>AL.SVU070180528,SVU070180528,SVU070180528,N, AL</Data>
</Error>
<ProcessCount>0</ProcessCount>
<ErrorCount>1</ErrorCount>
<SkipCount>0</SkipCount>
</ProcessCSV>
</CSVUtil>
</CSVUtilServlet>

I wonder if there's another corporation table that I may be missing. Any ideas?