How to use the Import Utility

I have inventory list in a CSV I need to import I downloaded the import utility and am attempting to use it on the Inventory, So this is what I am doing. First I launch the import utility I Name the Session I browse to the location and choose the file I am importing I then Connect to the Live Database I Choose Inventory and the delimenator of comma I check both boxes and then next I then select the following fields Field 1 is reorder number field 2 is Item lookup code Field 3 Description Field 4 is Category Field 5 is Department Field 6 is Sub Description Field 7 is cost Field 8 is price Fields 10 Supplier Cost Field 11 Supplier then I click Next ANd I see the Review screen and it looks correct then I click Next Then I click Import, and I get this log Importing C:\Documents and Settings\Administrator\Desktop\Import Utility\test.csv Friday, November 09, 2007

-------------------------------------------------------------------------------- [00001 00003021] 1217600118,0303-8001,Pure 16 BK,BIKE,COMFORT,MSRP $399.99,215.99,399.99,1217600118,215.99,TREK

And It does not import, Am I missing a step?

Reply to
Dan white
Loading thread data ...

What does your csv look like... I have used OSCimport many times, ILC must be unique or make sure the field length does not exceed what is allowed. Is the dollar $ in your csv... it shouldn't be!

See sample CSV description,company number,cost,retail ,qty ordered,on hand,ILC,Department,Category,Company amelia designs,,22.5,45.99,1,1,47-8001,,,SM Inc genius selection guide,140002412,9,19.99,3,3,47-8002,,,SM Inc

--------------------------------------------------------------------------------

Reply to
Danny

--------------------------------------------------------------------------------

Reply to
Dan white

What version of rms are you using?

--------------------------------------------------------------------------------

Reply to
Danny

--------------------------------------------------------------------------------

Reply to
Dan white

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.