I would like to know if there is a way to IMPORT data into inventory.
For Example. I have a new restaurant location opening, so the install date and a lot of the information that needs to be the same for multiple devices is the same. I thought if we can create an export of the inventory file (as a csv), I can add the information quickly in Excel using copy/paste and then Import the data back into spiceworks. (price paid for the items, warranty information, etc…), instead of opening every single device and inputting the infoprmation.
1 Spice up
afaik the only way is editing the devices table in the database directly. download sqlite (sqlite.org) and open spiceworks\db\spiceworks_prod.db with the sqlite 3 shell.
