morphin
Posts: 572
Joined: 4/26/2002 From: Switzerland Status: offline
|
I don't understand the import process from this utility. i had a look at the witp.log file. it is quite SQL. So i try to reproduce it on my SQL Server 2005 Database. it works with some modification quite well. So the last lines from this log is something like this: ----------------------- INSERT INTO "ShipClasses" VALUES(1459,20,'Medium APA (USN)',18,20,35,12000,0,0,0,0,0,0,0,0,NULL,0,0,'',NULL,NULL,NULL,6,43) DELETE FROM "ShipClasses" WHERE "shipclassID"=1459 ----------------------------------- So it tries to insert shipclasses. What's strange is that the upgradeClass column for the shipclassID=1459 is empty (''), but on the WITPcls.csv file it is not empty (it is shipclassid=1459)!. So the importprocess removes some content of the shipupgradeClass column, but why? Morpin
|