random files are missing/skipped in bulk import

hakan40501560 · 2013-04-02T06:13:11.000Z

I have a list of 1586 hardware devices in a CSV file. but when i try to bulk import it , it only finds/adds 1350/1450 devices. is there a reason that it doesnt add all the devices that are listed. i have added the csv file as a attachment so maybe you could take a look at it.

SpiceworksTotaal.csv (93.7 KB)

Brendan-Spiceworks · 2013-04-02T17:39:28.000Z

Can you break it into smaller, more manageable chunks? That might help you identify if there’s a particular entry causing issues.

hakan40501560 · 2013-04-03T09:24:06.000Z

i have split it in lists of 100 devices, and still cant figure out the relation between the skipped/missing devices.

1 to 100 100 of 100

101 to 200 100 of 100

201 to 300 65 of 100

301 to 400 85 of 100

401 to 500 92 of 100

501 to 600 93 of 100

601 to 700 83 of 100

701 to 800 87 of 100

801 to 900 91 of 100

901 to 1000 99 of 100

1001 to 1100 84 of 100

1101 to 1200 94 of 100

1201 to 1300 99 of 100

1301 to 1400 99 of 100

1401 to 1500 90 of 100

1501 to 1586 79 of 100

Brendan-Spiceworks · 2013-04-08T19:08:56.000Z

Hi Hakan,

Have you been able to make any headway on this or figure out what the common cause is with the devices that aren’t importing?

hakan40501560 · 2013-04-10T05:32:37.000Z

hi Brendan,

Thanks for your reply, i still can’t figure out why it skips some devices while importing.

hakanyortanli2610 · 2013-04-23T12:25:00.000Z

I found the answer,

The serialnumber fields may not contain special characters or letters , only numbers.

Brendan-Spiceworks · 2013-04-23T13:47:53.000Z

Thanks for posting back with the answer! I wish I’d caught that earlier.