1

Hey SW community!

Just looking for help importing CSV data in order to mass-update information on workstations in Spiceworks Inventory. I searched around but I kept getting non-related topics.

The import feature requires “Name” and “serial_number” to be mandatory fields in the CSV to properly locate the devices I need, however, I do not see a “Serial Number” field in Spiceworks Inventory, only Service Tag. Service tag = Serial Number?

I need to simply update 2 fields currently unused in our Inventory from a report in order to help with tracking, but if I need to go and pull every service tag for all 200 workstations it will be a frivolous task, might there be an easier way to have the CSV formatted so it updates the 2 fields without much hassle?

I’ve tried inputting other data in the Serial Number field which appears to create a whole new device, so I want to make sure I’m doing this right.

Thanks so much!

1 Spice up
2

Hi,

Every device should have a serial number. It should be listed on the General Info tab of a device.

If you are looking to change fields in multiple devices at the same time, why not try the Easy Asset Editor? Take a look at the app center at this app. It allows you to edit multiple devices at the same time.

3

Thanks for the response Jaime!

I’ve tried Easy Asset Editor, however I have 2 unique IDs I am adding to the 200+ workstations and this method doesn’t appear to allow an easy mass edit for unique numbers. Currently I have a report that runs daily on our network that fetches these IDs as they sometimes change or new ones are added. We were trying to add these IDs to the workstations in Spiceworks so we can utilize one organized area that we can tend to rather than using a spreadsheet and a lot of hopping back and forth.

So my ideal would be the bulk import with CSV, however I can’t find the best way to pull and insert all 200 service tag/serial numbers for the CSV in order for it to import correctly. The system looks fine for adding new devices with the CSV, but updating existing ones seems trickier.

Thanks!

4

Yeah, its going to be a bit tricky. Why not do this, run a report that pulls all devices from your database. Something basic like: select * from devices.

Export that report to a CSV file and use that to start off. It should have the serial number and name already listed. You should be able to simply add the information you need.

Would something like that work?

5

Perfect I hadn’t thought of using reports in Spiceworks! I think this should get me to where I need to be, thank you so much!