Jump to content

Issues importing CSV files


almacmichael

Recommended Posts

Hi

I am trying to import a csv of our data into Inventoria but is doesnt seem to work.

 

After choosing the file and uploading the 'Match CSV Fields' box doesnt allow me to match anything and the left hand side is completely blank.

 

Any ideas?

 

Maybe it just because I am a noob

 

Thanks

 

Al

Link to comment
Share on other sites

  • 7 months later...

You need to ensure that row 1 of the csv you wish to import has the exact headings as required by Inventoria and that they are in the correct order i.e. "ItemCode, Description, Category, Location, Quantity, Cost, Sell".

When you import the csv the headings will appear on the left. On the right you will see the Inventoria headings and if you click to the right of one of these headings you should receive a lookup box with your headings. Just click the appropriate heading to create a match. Both left and right headings should now turn green. When all headings are matched click OK. Please note that any headings on the left which remain black are not matched and will not be imported.

 

I have also found (but it might just be me) that I can only import stock once. Any subsequent imports doesn't change the data. So you need to delete all existing data before you can import a new batch. Unless of course you have used "Bill of Materials" or any "orders" or "sales" in which case you cannot delete the stock items and therefore have to manually change those.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...