IT Glue's CSV import feature was designed to help you import large amounts of data to populate flexible assets or deploy IT Glue without syncing in data from a PSA integration.

The instructions for importing are broken down into the following sections:

• Creating a test environment
• Creating your CSV file
• Saving your CSV file
• Importing into a single organization
• Importing into multiple organizations

Prerequisites

• You must be an Administrator or a Manager who has access to all organizations. For any large or complex imports, you should be an Administrator to have full visibility to all data.
• We strongly recommend that you review our File Import and Matching Guide KB article before starting your import. This article contains full instructions on how the matching data works.
• The import file must be encoded in UTF-8 and less than 100 MB. For best results, save the CSV file exactly as described below.
• Organization names and manufacturers/models must be written exactly as they appear in IT Glue. The importer won't do any fuzzy matching tests. It doesn't know, for example, that Happy Frog is the same organization as Happy Frog Inc., or that Dell Inspiron is the same model as Dell Insprion. It will create new organizations or manufacturers/models when no match exists.

Instructions

Creating a test environment

If you make a mistake with your list import, you cannot undo it, and there is currently no bulk edit functionality. You would need to work through changes one at a time. Therefore, we suggest you set up a test organization in your account and make a few tests before you import large amounts of data into a "production" organization. It's easy to delete the test organization afterward.

While you're testing, make sure your data is formatted for our field types. When the test import finishes, open the Global > Assets list view and compare it against your spreadsheet.

Creating your CSV file

When setting up a new IT Glue account, your existing data can be imported as a CSV file. These steps will help you create your CSV file so that it will import successfully.

Import the data

Two ZIP files are provided at the bottom of this article.

Download one of these ZIP files to start importing data into the following areas of IT Glue:

• Sample Excel import files with required fields highlighted (Save as CSV when you're ready to import.)
• Sample CSV import files
  • Organizations
  • Locations
  • Contacts
  • Configurations
  • Passwords
  • Domains 
  • SSL certificates

1. Open the file you want to use and delete the sample data, but not the header row.
2. Copy data from the matching columns in your existing spreadsheets into the IT Glue sample file. Note that you can change the order of the columns if needed, but make sure you leave the values of the header cells intact.

Flexible asset imports

For flexible asset imports, we recommend adding one or two test flexible assets to IT Glue manually, which you can then export and populate with your real data:

1. Create your flexible asset type from template or from scratch.
2. Open your test organization and click the name of the flexible asset from the left sidebar.
3. Create one or more test flexible assets using placeholder data, completing all the fields.
4. Export your data. This requires an Administrator role.
5. Open the exported CSV file and delete the placeholder data.
6. You're now ready to populate this CSV file with real data and then import it into IT Glue.

Saving your CSV file

When you save the file, make sure you save it as a CSV file.

• If on a PC, save as CSV (Comma delimited) (*.csv).
• If on a Mac, save as Windows Comma Separated (.csv).

Importing into a single organization

1. Navigate to Account > Import Data and click the + New button. Then, choose the type of import you want to create.

   
   

2. Select Single Organization and then select the organization you'd like to import data into.
   
   
3. Click Choose File to select the saved CSV file.
   
   
4. Set Allow partial imports to "No," which means the whole import will fail if there are any non-UTF-8 characters or missing required fields in the CSV. If that happens, you can rerun the import and allow partial imports to find out which rows have errors.
5. Click Continue.
6. Click Run Import.
7. Wait a few minutes for the import to complete.
8. Once the import is done, you'll get an email from support@itglue.com that includes a link to view imported rows or details regarding errors in your import.

You can verify your import was successful by waiting for the email confirmation or by navigating to Account > Import Data and then clicking on the link for your import. You can also navigate to the Global > Assets area to view the information that you imported.

Importing into multiple organizations

1. Click Account from the top navigation bar.
2. Click Import Data from the sidebar.
   
   
3. On the next screen, click the + New button and then choose the type of import you want to create.
4. Select Multiple Organizations.
   
   
5. Click Choose File to select the saved CSV file.
   
   
6. Set Allow partial imports to "No," which means the whole import will fail if there are any non-UTF-8 characters or missing required fields in the CSV. If that happens, you can rerun the import and allow partial imports to find out which rows have errors.
7. Click Continue.
8. Click Run Import.
9. Wait a few minutes for the import to complete.
10. Once the import is done, you'll get an email from support@itglue.com that includes a link to view imported rows or details regarding errors in your import.

You can verify your import was successful by waiting for the email confirmation or by navigating to Account > Import Data and then clicking on the link for your import. You can also navigate to the Global > Assets area to view the information that you imported.

Sample Download Files

Sample import files have been provided below. The XLS files highlight the fields required by each asset for the import to work. The CSV files are the correct file format for importing. Both sets of samples include a line of sample data which should be removed prior to your import.