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 

Inventory export, clean-up, import

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



Joined: 06 Apr 2018
Posts: 3

PostPosted: Mon Apr 16, 2018 11:54 pm    Post subject: Inventory export, clean-up, import Reply with quote

I'd like to clean up our inventory items. The process I'd like to take is to export all items to Excel, clean-up, delete, modify, etc. each item, then import back in overwriting the old inventory. Is this possible? What would happen to items that I deleted from the spreadsheet? After exporting should I delete all inventory items, then import the new file? What happens to invoice history, etc. if I do this?
Back to top
View user's profile Send private message
imagicsupport
Site Admin


Joined: 16 Dec 2006
Posts: 2223

PostPosted: Wed Apr 18, 2018 1:49 pm    Post subject: Reply with quote

Hi Christopher(?),

Thanks for the post on tidying a database using Excel.

At present, there isn't any direct way to do what you are wanting using Excel.

You could partially do what you are wanting. In that, you could export your inventory items, rename, update them as required. Then import them back into iMagic Inventory with the 'overwrite' option enabled.

You couldn't though delete items in Excel. Since when you import there would be no way to know that they had been deleted. Since they wouldn't exist.

I would suggest backing up your database before this process just-in-case. As the changes can be significant.

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