iMagicSoft Support Forum Index iMagicSoft Support
iMagic Software Support
 
  SearchSearch   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Inquiry - Exporting inventory

 
Post new topic   Reply to topic    iMagicSoft Support Forum Index -> iMagic Inventory Software
View previous topic :: View next topic  
Author Message
imagicsupport
Site Admin


Joined: 16 Dec 2006
Posts: 2137

PostPosted: Fri Mar 03, 2017 10:37 am    Post subject: Inquiry - Exporting inventory Reply with quote

When I do an export of inventory, I get everything duplicated with a zero amount and all the zeros are missing in front of the product item #. This makes for a lot of manual work. Is there something I can do to avoid this?

Fern Conners
Back to top
View user's profile Send private message Visit poster's website
imagicsupport
Site Admin


Joined: 16 Dec 2006
Posts: 2137

PostPosted: Fri Mar 03, 2017 10:39 am    Post subject: Reply with quote

Hi Fern,

Thanks for the post.

It's difficult to comment without seeing the export, could you email over the CSV export you are getting?

My best guess would be that you're opening the file in Excel and the columns aren't being formatted correctly. So it sounds like the column is set as a 'number' rather than 'text'. This would make '000123' become '123'.

As for duplicated, it depends, if you have multiple locations then it would most likely be that the row is showing for each location. If that's not what you're wanting you could try another export option from iMagic Inventory or create a filter in Excel.

Also, I'm assuming you're using Excel to open the export? As you'd likely get a different result if you opened it in something like OpenOffice Sheets, etc.

Regards, John
_________________
iMagic Soft Support
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    iMagicSoft Support Forum Index -> iMagic Inventory Software All times are GMT + 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
iMagic Inventory Software home page


Powered by phpBB © 2001, 2005 phpBB Group