1

I will list the steps and the problem I am having.

Steps:

  1. Exported vendor list from track-it.

  2. Exported vendor list from spiceworks via SQLite manager.

  3. I kept the headings from the spiceworks vendor list but I replaced the fields with the track_it Vendor list.

  4. I imported my newly created vendor list into spice works using SQLite manager.

Issues:

Before I explain my issues I want to point out that I had three vendors already in spiceworks. With that said, when I opened spice works it only shows three vendors but what is weird is that they are my vendors from track-it.

Question:

How do I get it to show all my vendors that I imported?

1 Spice up
2

Currently we don’t have a way to import Vendors, but you can import purchases after your Vendors are already present in Spiceworks.

Here’s how to create vendors in Spiceworks:

How many vendors do you need to add? If you have fewer than 20 or 30 it would probably be easiest to key them in.

We don’t recommend editing your database directly because it can corrupt the database. However, the agreements table stores all of the Vendor information, including vendors for your Cloud Services. Vendors and Cloud Services are generated in two different places in Spiceworks.

  • Purchases > My Vendors
  • Inventory > Cloud Services

If you choose to make changes to your database directly, be sure you create a backup beforehand from Settings > Backup Configuration.

1 Spice up
3

I have about 200 vendors. Thanks! I will give that a try.

4

You say we can import purchases? What is the best method on doing that?

5

It isn’t well documented, but the script is located here:

  • C:\Program Files (x86)\Spiceworks\pkg\gems\spiceworks-6.2.00873\bulk_purchase_import.rb

You should be able to closely follow the instructions we have for importing devices:

The bottom of the script file (.rb) will list out the accepted CSV columns, and the appropriate values. I think this was written specifically to import CDW purchases, but would likely work with any properly formatted CSV.

I’d be glad to help you get it working - could you send me a small sample of the CSV? If so, I can do some testing and help you get it formatted properly and interpret the script.

EDIT: I was wrong about the documentation - see Eric’s post below with a couple of how-to’s on using the script. Thanks Eric. :slight_smile:

1 Spice up
6

As Ben mentioned, you can use the import script to bulk-add purchases.

I’ve also created 2 How-To’s that might help walk you through the details.

Importing from a CSV you create:

http://community.spiceworks.com/how_to/show/1733-import-purchases-into-spiceworks-from-a-csv-file

Importing from a CDW purchase history:

http://community.spiceworks.com/how_to/show/2380-import-cdw-purchases-into-spiceworks-from-a-csv-file

1 Spice up
7

Thanks! Attached is the .csv

8

I’m in the process of importing it all now. Thanks so much again.