 |
iMagicSoft Support iMagic Software Support
|
View previous topic :: View next topic |
Author |
Message |
NMXKofG
Joined: 06 Apr 2018 Posts: 3
|
Posted: Mon Apr 16, 2018 11:54 pm Post subject: Inventory export, clean-up, import |
|
|
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 |
|
 |
imagicsupport Site Admin
Joined: 16 Dec 2006 Posts: 2316
|
Posted: Wed Apr 18, 2018 1:49 pm Post subject: |
|
|
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 |
|
 |
|
|
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
|