Advertisement
I’m currently trying to import a CSV of devices into a test installation before confirming all is OK and importing into our live application. However only 27 appear in the application, even though in the command prompt it says “imported device xx” for all.<\/p>\n
I’ve also tried this on a new clean installation on another machine to see if it was a problem with our test server/application and I had the same problem.<\/p>\n
So with the above said, it appears to be a problem with the data, but I’m unable to figure out what, as nothing looks particularly faulty. I’ve also removed fields in various combinations and there doesn’t appear to be any pattern to it.<\/p>\n
I’ve attached a CSV with 1 faulty record and here’s the command I’m running:<\/p>\n
Command: C:\\Program Files (x86)\\Spiceworks\\bin> ruby “C:\\Program Files(x86)\\Spiceworks\\pkg\\gems\\spiceworks-7.4.0115\\bulk_import.rb” -e [email protected]<\/a> -s localhost “C:\\Users\\james.hart\\Downloads\\All Assets 2015 - Copy.csv”<\/p>\n All_Assets_2015_-_Copy.csv<\/a> (246 Bytes)<\/p>","upvoteCount":1,"answerCount":4,"datePublished":"2015-10-08T12:35:28.000Z","author":{"@type":"Person","name":"jameshart4","url":"https://community.spiceworks.com/u/jameshart4"},"acceptedAnswer":{"@type":"Answer","text":" I have been getting assistance from Spiceworks and it appears there’s a bug in the software. The developers are trying to get it fixed as soon as possible. The issue number is 69723.<\/p>","upvoteCount":1,"datePublished":"2015-10-15T05:59:39.000Z","url":"https://community.spiceworks.com/t/csv-import-missing-devices/441946/3","author":{"@type":"Person","name":"jameshart4","url":"https://community.spiceworks.com/u/jameshart4"}},"suggestedAnswer":[{"@type":"Answer","text":" I’m currently trying to import a CSV of devices into a test installation before confirming all is OK and importing into our live application. However only 27 appear in the application, even though in the command prompt it says “imported device xx” for all.<\/p>\n I’ve also tried this on a new clean installation on another machine to see if it was a problem with our test server/application and I had the same problem.<\/p>\n So with the above said, it appears to be a problem with the data, but I’m unable to figure out what, as nothing looks particularly faulty. I’ve also removed fields in various combinations and there doesn’t appear to be any pattern to it.<\/p>\n I’ve attached a CSV with 1 faulty record and here’s the command I’m running:<\/p>\n Command: C:\\Program Files (x86)\\Spiceworks\\bin> ruby “C:\\Program Files(x86)\\Spiceworks\\pkg\\gems\\spiceworks-7.4.0115\\bulk_import.rb” -e [email protected]<\/a> -s localhost “C:\\Users\\james.hart\\Downloads\\All Assets 2015 - Copy.csv”<\/p>\n