1

untitled.png

I am running spiceworks on a local machine and I have around 1 thousand devices that need to be added. I have followed the steps on community spiceworks but it says there is no such file or directory. Can anybody tell me what I am doing wrong.

Many Thanks

1 Spice up
2

Put the absolute path for Book1.csv (e.g. C:\Users\Admin\Desktop\Books1.csv

If there are spaces you may need to include " around the path "

1 Spice up
3

u.pngThis is now the error i’m getting, any ideas?

4

Does your CSV file have the attributes name on the top row?

5

no, sorry what do you mean by that?

6

The CSV file needs to have the top row that specifies what the attributes are that you are importing.

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

7

Yes I have done that, I even copied the example of the csv file and still having no luck. This is what comes up when i used the example csv file.

Name,Manufacturer,Device Type,Model,IP Address,Serial Number,Location,Operating System

copier1,Apple,Copier,“”,192.168.168.115,“”,Austin,“”

fax1,Acme,Fax,Latitude D830,“”,45322221,Round Rock,Fax Plus Bios

fax2,Acme,Fax,Latitude D830,“”,45322222,Cedar Park,Fax Plus Bios

fax3,Acme,Fax,Latitude D830,“”,45322223,Round Rock,Fax Plus Bios

Spiceworks_error.png

8

It seems to be reading the CSV file as expectred and attempting to import the copier1.

Try working with the actual copier record. Instead of using “” put something else (e.g. unknown). I have since issues when importing “” where it doesn’t seem to recognize that it’s a “nothing”

Try " " (with a space between the quotes) and then try words.

9

Some fields can’t be blank. Serial Number, for instance, needs to have something in there. For the other blanks (like operating system), try using the term NULL.

Try tacking on the -V at the end of the command line, to give you a verbose output of what’s happening. That may help.