Import CSV Into SW Inventory

douglaspilot0144 · 2014-04-01T11:05:02.000Z

I have a .CSV file I’ve created from our old workstation inventory spreadsheet. In SW the network scan has inventoried our whole network nicely. I created custom fields for devices to match what I have in the .CSV file. example "user’, ‘Operating System’, ‘Phone Extension’.

I copied the bulk import tool into the bin folder and tried using this:

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

Doesn’t seem to work, getting errors. Is there a way to use this tool to import the CSV info into the existing inventory?

swearyprincess · 2014-04-01T11:10:20.000Z

What errors are you getting?

And what version of Spiceworks are you using?

douglaspilot0144 · 2014-04-01T11:14:59.000Z

v. 7.1.00035

Logging into Spiceworks…
Importing assets…
Error: ActiveRecord::AssociationTypeMismatch: User(#39556990) expected, got Stri
ng(#6284890)
Had exception importing: exit
bulk_import.rb:14:in exit' bulk_import.rb:14:in eputs’
bulk_import.rb:155:in block in <main>' bulk_import.rb:131:in each’
bulk_import.rb:131:in `’
goodbye!

swearyprincess · 2014-04-01T11:16:00.000Z

If you break your CSV up into blocks, do you get it with every block? That’ll let us know if it’s all data, or just one or two records.

douglaspilot0144 · 2014-04-01T11:17:36.000Z

only using one as a test. I’ve attached it here

vnc.csv (120 Bytes)

swearyprincess · 2014-04-01T11:19:30.000Z

It won’t let me download that

If you enter your full profile that will boost your rating, allowing you to post links and then you can put it on Dropbox or something and link to that instead.

douglaspilot0144 · 2014-04-01T12:37:33.000Z

sorry, looks like this

douglaspilot0144 · 2014-04-01T14:42:24.000Z

ok i guess my screenshot didnt come through

swearyprincess · 2014-04-02T05:44:29.000Z

You probably need to ‘level up’ before posting screenshots.

The simplest way to do this is to fill out your full profile (including adding a profile picture)