iMagicSoft Support

[NMXKofG]

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?

[imagicsupport]

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