How to use the Import Utility

Nov 09, 2007 4 Replies

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?



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

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

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

What version of rms are you using?

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

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

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required