Educational Software Thread, Spiceworks - Exporting and importing from CSV? in Technical; Hi
We are starting to use spiceworks as our network inventory. I was wondering if anyone has found a way ...
3rd July 2013, 10:09 PM #1
- Rep Power
Spiceworks - Exporting and importing from CSV?
We are starting to use spiceworks as our network inventory. I was wondering if anyone has found a way of exporting the information spiceworks gets on the network scans to something like a csv file. This would then allow me to bulk add device costs quickly in excel and then re-import it to spiceworks.
Is there a way to do this?
Just need to easily add the extra information we want each device to have.
I also need to import new devices via csv or something so for a batch of 50 new monitors i could just import a csv?
Any help would be great thanks
3rd July 2013, 11:55 PM #2
Have a look at this:
Import devices into Spiceworks from a CSV file - Spiceworks
If you created a report in Spiceworks with the same layout as the CSV file in this how to, you should be able to export everything, updated it and re import. Use the -m option so it updates devices not recreate them. Only thing you need to look up is the column headings for the database for costs etc. Heard SQL Lite extension in Firefox can be used?
Thanks to robyholmes from:
4th July 2013, 11:03 PM #3
- Rep Power
Hi the only bit i don't get is the -m option. Where would that go in the command i run?:
Originally Posted by robyholmes
C:\Program Files (x86)\Spiceworks\pkg\gems\spiceworks-5.3.75941\bin>ruby bulk_import.rb -e EMAIL -p PASS test.csv
By joseph in forum Windows Server 2008 R2
Last Post: 11th February 2013, 07:45 AM
By Edu-IT in forum General Chat
Last Post: 17th April 2011, 08:18 PM
By stevo1565 in forum Windows Server 2000/2003
Last Post: 19th July 2010, 09:01 PM
By LittleRedFoot in forum MIS Systems
Last Post: 20th October 2008, 07:52 PM
By Grommit in forum Windows
Last Post: 29th September 2008, 10:57 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)