1

Hi to all!
I already all the topics about this issue. none of them solved my problem.

No matter what I type in the CSV, I get the same “warning”:

I[15:34:25.46 2d28c4] Successfully imported 0 devices. Failed importing 0 devices.
I[15:34:25.46 2d28c4] Skipping device because name or serial number is missing: {:nameserial_number=>“test;0951530A00001”}
I[15:34:25.46 2d28c4] Started importing inventory data.

I created a new and fresh file, with two simple lines (name and serial_number). It doesnt work either.

As I said, traied all the topics opened but anyone did the trick. Anything else I can try?

Thanks in advanced

1 Spice up
2

Just so you know, any items you import via CSV will not be scanned or updated in the future, it’s a static list

3

Are you following this guide?

https://community.spiceworks.com/support/inventory/docs/import-inventory

4

Just after I post it, I tried another thing and it works.

The same csv file with two lines, instead of using one cell for the attribute, I separated by a “,”

But, I need to import a 2400 lines of this (I´m actually using GLPI and I want to test further spiceworks).

So, it´s a little difficult to build the CSV with “,” instead of using the cells.

Is there another way or I just need use the “,”? Followed the link you mention. no luck.

thanks ind advanced

5

When you save the file as a CSV the comma is put in between cells by default, that’s why it’s a CSV.

Just note that 2400 devices or items is above the recommended limit of Spiceworks anyway, and for clarifications, you wont be able to scan these items, they will be static data

You mention cells and it being difficult to use , which suggests you are using an excel file not a CSV (or at least another table based system)

6

ROD-IT,

Thanks for the information. Where can I see the limitation? Is there any way to expand it?

Yes, I know the devices are statics. It´s what I need. I work for an education goverment and we have 2400 netbooks for all the students. So, I need to inventory them and track them manually. Also, I want to invetory desktop, notebooks, switches and a large of equipement but Switches, desktop, etc will be scanned. Only netbooks will be static.

The last paragraph you wrote give me an idea… Tested and worked like a charm.

Steps:

  1. Create a CSV as you mentioned (see the link)
  2. For custom fields, I downloaded sqllite and see the table “devices” (I created 3 custom fields). So, I took note the fields.
  3. Build the CSV and save as “CSV UTF-8”
    Here is what I discover:
  4. Open the CSV file with notepad++. All the lines are separated with semicolon
  5. Ctrl + H (search and replace). replace all semicolon with comma
  6. Save
  7. Import. Done!

Succefully imported 15 (just for test).

Thanks anyway for your help and the quicly reply.

@kptim

7

Odd tag

You cant see the limit, it’s not documented nor a hard limit, I am giving you the advice that 1200 is about the limit before you start to see degradation in performance.

Even more so since you suggested 2400 static entries and now more that will be scanned

8

Ok. I will keep it in mind. Thanks for the advice and help.

Regards,

9

Also note the windows installer is likely to fade away, you might want to look at cloud inventory (also free), based on agents