+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    465
    Thank Post
    118
    Thanked 15 Times in 15 Posts
    Rep Power
    9

    Spiceworks - Exporting and importing from CSV?

    Hi

    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

  2. #2

    Join Date
    Jan 2010
    Location
    North Yorkshire
    Posts
    77
    Thank Post
    0
    Thanked 16 Times in 14 Posts
    Rep Power
    16
    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?

  3. Thanks to robyholmes from:

    tj2419 (4th July 2013)

  4. #3

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    465
    Thank Post
    118
    Thanked 15 Times in 15 Posts
    Rep Power
    9
    Quote Originally Posted by robyholmes View Post
    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?
    Hi the only bit i don't get is the -m option. Where would that go in the command i run?:

    C:\Program Files (x86)\Spiceworks\pkg\gems\spiceworks-5.3.75941\bin>ruby bulk_import.rb -e EMAIL -p PASS test.csv

    Thanks

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 11th February 2013, 07:45 AM
  2. Replies: 6
    Last Post: 17th April 2011, 08:18 PM
  3. Active Directory Export and Import
    By stevo1565 in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 19th July 2010, 09:01 PM
  4. SIMS AM7 -Export and Import Marksheet
    By LittleRedFoot in forum MIS Systems
    Replies: 4
    Last Post: 20th October 2008, 07:52 PM
  5. Replies: 12
    Last Post: 29th September 2008, 10:57 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •