My test CSV file contains:<\/p>\n
\n
<\/a>Name,Manufacturer,Device Type,Model,IP Address,Serial Number,Location,Operating System
\ncopier1,Apple,Copier,test,192.168.168.115,test,Austin,test
\nfax1,Acme,Fax,Latitude D830,test,45322221,Round Rock,Fax Plus Bios
\nfax2,Acme,Fax,Latitude D830,test,45322222,Cedar Park,Fax Plus Bios
\nfax3,Acme,Fax,Latitude D830,test,45322223,Round Rock,Fax Plus Bios<\/h2>\n
Advertisement
When I enter the code via cmd I receive this:<\/p>\n
Logging into Spiceworks…
\nImporting assets…
\nError: no name attribute given in {:manually_added=>true, “—_”=>“Name”, nil=>\"
\nOperating System \", “serial_number”=>nil, “description”=>“manually imported from
\ncsv file”}
\nHad exception importing: exit
\nbulk_import.rb:13:in exit' bulk_import.rb:13:in <\/code>eputs’
\nbulk_import.rb:133:in block in <main>' bulk_import.rb:125:in <\/code>each’
\nbulk_import.rb:125:in `’
\ngoodbye!<\/p>\nC:\\Program Files\\Spiceworks\\bin><\/p>\n
Any idea what I am doing wrong?<\/p>","upvoteCount":2,"answerCount":5,"datePublished":"2011-12-08T09:10:56.000Z","author":{"@type":"Person","name":"slackboy0568","url":"https://community.spiceworks.com/u/slackboy0568"},"acceptedAnswer":{"@type":"Answer","text":"
in your csv file … if you open it with notepad or something other than excel… do you see a bunch of commas below the last rows of your text or does it only show the rows of valid data? sometimes if rows below the valid ones had any formatting it will try and comma delimit those rows which are blank<\/p>\n
just make sure your file has only this and nothing more (when viewed in notepad)<\/p>\n
Name,Manufacturer,Device Type,Model,IP Address,Serial Number,Location,Operating System
\ncopier1,Apple,Copier,test,192.168.168.115,test,Austin,test
\nfax1,Acme,Fax,Latitude D830,test,45322221,Round Rock,Fax Plus Bios
\nfax2,Acme,Fax,Latitude D830,test,45322222,Cedar Park,Fax Plus Bios
\nfax3,Acme,Fax,Latitude D830,test,45322223,Round Rock,Fax Plus Bios<\/p>\n
the error looks as if it sees a row with hyphens or nothing at all.<\/p>","upvoteCount":0,"datePublished":"2011-12-08T09:25:28.000Z","url":"https://community.spiceworks.com/t/uploading-inventory-list-into-spiceworks-error/115884/2","author":{"@type":"Person","name":"skeletalflames","url":"https://community.spiceworks.com/u/skeletalflames"}},"suggestedAnswer":[{"@type":"Answer","text":"
I am trying to load a CSV file into spiceworks. I have followed the how-to<\/a> post.<\/p>\nMy test CSV file contains:<\/p>\n
\n<\/a>Name,Manufacturer,Device Type,Model,IP Address,Serial Number,Location,Operating System
\ncopier1,Apple,Copier,test,192.168.168.115,test,Austin,test
\nfax1,Acme,Fax,Latitude D830,test,45322221,Round Rock,Fax Plus Bios
\nfax2,Acme,Fax,Latitude D830,test,45322222,Cedar Park,Fax Plus Bios
\nfax3,Acme,Fax,Latitude D830,test,45322223,Round Rock,Fax Plus Bios<\/h2>\nWhen I enter the code via cmd I receive this:<\/p>\n
Logging into Spiceworks…
\nImporting assets…
\nError: no name attribute given in {:manually_added=>true, “—_”=>“Name”, nil=>\"
\nOperating System \", “serial_number”=>nil, “description”=>“manually imported from
\ncsv file”}
\nHad exception importing: exit
\nbulk_import.rb:13:in exit' bulk_import.rb:13:in <\/code>eputs’
\nbulk_import.rb:133:in block in <main>' bulk_import.rb:125:in <\/code>each’
\nbulk_import.rb:125:in `’
\ngoodbye!<\/p>\nC:\\Program Files\\Spiceworks\\bin><\/p>\n
Any idea what I am doing wrong?<\/p>","upvoteCount":2,"datePublished":"2011-12-08T09:10:56.000Z","url":"https://community.spiceworks.com/t/uploading-inventory-list-into-spiceworks-error/115884/1","author":{"@type":"Person","name":"slackboy0568","url":"https://community.spiceworks.com/u/slackboy0568"}},{"@type":"Answer","text":"
No there are no blank rows… I have attached a screenshot.<\/p>\n
Error:<\/p>\n
Logging into Spiceworks…
\nImporting assets…
\nError: NoMethodError: undefined method operating_system_=' for #<Unknown:0x8e6f 9a8> Had exception importing: exit bulk_import.rb:13:in <\/code>exit’
\nbulk_import.rb:13:in eputs' bulk_import.rb:147:in <\/code>block in ’
\nbulk_import.rb:125:in each' bulk_import.rb:125:in <\/code>’
\ngoodbye!<\/p>\nC:\\Program Files\\Spiceworks\\bin><\/p>\n
![\"Capture.JPG\"](\"https://us1.discourse-cdn.com/spiceworks/optimized/4X/4/7/9/479f6944b11b8a22e51b575f447a4518eb9de4ce_2_690x124.jpeg\")
\nImporting assets…
\nError: no name attribute given in {:manually_added=>true, “—_”=>“Name”, nil=>\"
\nOperating System \", “serial_number”=>nil, “description”=>“manually imported from
\ncsv file”}
\nHad exception importing: exit
\nbulk_import.rb:13:in
exit' bulk_import.rb:13:in <\/code>eputs’
\nbulk_import.rb:133:in block in <main>' bulk_import.rb:125:in <\/code>each’
\nbulk_import.rb:125:in `’
\ngoodbye!<\/p>\nC:\\Program Files\\Spiceworks\\bin><\/p>\n
Any idea what I am doing wrong?<\/p>","upvoteCount":2,"answerCount":5,"datePublished":"2011-12-08T09:10:56.000Z","author":{"@type":"Person","name":"slackboy0568","url":"https://community.spiceworks.com/u/slackboy0568"},"acceptedAnswer":{"@type":"Answer","text":"
in your csv file … if you open it with notepad or something other than excel… do you see a bunch of commas below the last rows of your text or does it only show the rows of valid data? sometimes if rows below the valid ones had any formatting it will try and comma delimit those rows which are blank<\/p>\n
just make sure your file has only this and nothing more (when viewed in notepad)<\/p>\n
Name,Manufacturer,Device Type,Model,IP Address,Serial Number,Location,Operating System
\ncopier1,Apple,Copier,test,192.168.168.115,test,Austin,test
\nfax1,Acme,Fax,Latitude D830,test,45322221,Round Rock,Fax Plus Bios
\nfax2,Acme,Fax,Latitude D830,test,45322222,Cedar Park,Fax Plus Bios
\nfax3,Acme,Fax,Latitude D830,test,45322223,Round Rock,Fax Plus Bios<\/p>\n
the error looks as if it sees a row with hyphens or nothing at all.<\/p>","upvoteCount":0,"datePublished":"2011-12-08T09:25:28.000Z","url":"https://community.spiceworks.com/t/uploading-inventory-list-into-spiceworks-error/115884/2","author":{"@type":"Person","name":"skeletalflames","url":"https://community.spiceworks.com/u/skeletalflames"}},"suggestedAnswer":[{"@type":"Answer","text":"
I am trying to load a CSV file into spiceworks. I have followed the how-to<\/a> post.<\/p>\nMy test CSV file contains:<\/p>\n
\n<\/a>Name,Manufacturer,Device Type,Model,IP Address,Serial Number,Location,Operating System
\ncopier1,Apple,Copier,test,192.168.168.115,test,Austin,test
\nfax1,Acme,Fax,Latitude D830,test,45322221,Round Rock,Fax Plus Bios
\nfax2,Acme,Fax,Latitude D830,test,45322222,Cedar Park,Fax Plus Bios
\nfax3,Acme,Fax,Latitude D830,test,45322223,Round Rock,Fax Plus Bios<\/h2>\nWhen I enter the code via cmd I receive this:<\/p>\n
Logging into Spiceworks…
\nImporting assets…
\nError: no name attribute given in {:manually_added=>true, “—_”=>“Name”, nil=>\"
\nOperating System \", “serial_number”=>nil, “description”=>“manually imported from
\ncsv file”}
\nHad exception importing: exit
\nbulk_import.rb:13:in exit' bulk_import.rb:13:in <\/code>eputs’
\nbulk_import.rb:133:in block in <main>' bulk_import.rb:125:in <\/code>each’
\nbulk_import.rb:125:in `’
\ngoodbye!<\/p>\nC:\\Program Files\\Spiceworks\\bin><\/p>\n
Any idea what I am doing wrong?<\/p>","upvoteCount":2,"datePublished":"2011-12-08T09:10:56.000Z","url":"https://community.spiceworks.com/t/uploading-inventory-list-into-spiceworks-error/115884/1","author":{"@type":"Person","name":"slackboy0568","url":"https://community.spiceworks.com/u/slackboy0568"}},{"@type":"Answer","text":"
No there are no blank rows… I have attached a screenshot.<\/p>\n
Error:<\/p>\n
Logging into Spiceworks…
\nImporting assets…
\nError: NoMethodError: undefined method operating_system_=' for #<Unknown:0x8e6f 9a8> Had exception importing: exit bulk_import.rb:13:in <\/code>exit’
\nbulk_import.rb:13:in eputs' bulk_import.rb:147:in <\/code>block in ’
\nbulk_import.rb:125:in each' bulk_import.rb:125:in <\/code>’
\ngoodbye!<\/p>\nC:\\Program Files\\Spiceworks\\bin><\/p>\n