1

I need to add the vendor to over 700 devices. A bulk update would be great. What I can’t figure out is there is a thread from 2006 asking for this. The thread was closed because “This feature was added” Yet I can’t find it. Here is the thread:
http://community.spiceworks.com/feature_request/show/Inventory/142

yet I continue to see posts asking for this very thing. So is there a way to bulk update or not?

@Spiceworks

3 Spice ups
2

Use these instructions:

http://community.spiceworks.com/how_to/show/203-import-devices-into-spiceworks-from-a-csv-file

3

I am(was) concerned that the post is from so long ago that the script would not work with the latest version of Spiceworks.

Mark

4

there are responses stating that it works as early as this month. The link I sent was dated 2009, and it’s posted by a Spiceworks employee who is very active in the forums.

5

I will give it a try. However it would seem to me to be easy to add the the base program. Shift select some devices and modify the parameters.

6

Hi…

I am using 7.0.01308 version. Have been able to successfully do bulk upload of assets. However, if I try to update them the update doesnt work. Here is an example of what I tried.

  1. Bulk upload of Test6.csv, the file contained

name, serial_number

Test1, 7777

  1. This imported creating an asset Test 1.

  2. Then I wanted to add asset_tag to this, so I used Test6.csv with bulk_import.rb and “–no-manual” option.

name, serial_number, asset_tag

Test1, 7777, 88

  1. The script executed coming out with “imported device Test_1” however upon refreshing the asset Test_1, the asset_tag field was not updated.

Can someone help me with this please.

7

I am having a similar issue. the log shows that the devices were imported, but the field I need updated did not update.

this is the Ruby command I used:

Ruby bulk_import.rb -e email -p PW -s URL -P 10000 --no-manual updatejan30.csv

I am trying to update a custom location c_building (which is updating)

and the primary_owner_name (which is not)

I have tried a few times, first with just the serial number plus the fields to be updated, which failed saying the name field was missing.

I added the name field, then it worked, but some of the fields I had already filled in from the original import were changed to unknown (device_type). I added the device_type field and re-filled it, then reimported with the same command. Now device_type was updated with the original information, but primary_owner_name is still not updating.

Primary_owner_name worked on the original import, but not for the updates.

@Spiceworks