1

After following the bulk import steps in the How-To:
http://community.spiceworks.com/how_to/show/203-import-devices-into-spiceworks-from-a-csv-file

My problem isn’t with the script, I actually get no errors on the import. My problem is many of the items that I imported are missing from the device list. Upon investigating further, I determined that the devices are renaming themselves and then overwriting themselves in the inventory list.

When I look at the Timeline for the devices that remain it reads:

Name was DEVICE1, Now DEVICE2
Name was DEVICE2, Now DEVICE3
Name was DEVICE3, Now DEVICE4

That happens until I end up with a handful of devices from the original import list.

The devices are blackberries that are not detected by the network scans. I know they import because I can see in the Timeline that it only isn’t changing the name but all of the imported fields (Purchase Date, Serial Numbers, etc). None of these devices were ever in Spiceworks before.

I have deleted and re-imported. It always reverts back to the same remaining devices.

I have tried importing smaller batches and even one at a time. Same results.

1 Spice up
2

When you do the import, what flags are you using?

Specifically, are you using the “-m” optional flag at all?

3

Per the example and I just added the -m flag.

ruby bulk_import.rb -e jsmith@acme.com -p password -s spiceserver -P 9675 -m assetlist.csv

4

It shouldn’t be doing that with manual flagged devices, unless Spiceworks thinks those devices are other devices. Normally that only happens when devices have the same MAC address, or the serial numbers are the same or something.

Do the MAC address and Serial number fields have content? Are they different for each device?

5

MAC Address are blank and the Serial Numbers are unique. These devices never existed in Spiceworks before.

6

I’m going to go ahead and create a case for you. I think we’ll need to get a look at your logs to figure out what this is going on.

You should get an email from support@spiceworks.com in a few with some instructions.