Data import
Asset Administrators can import asset-related data into the ITAM database via:
•The Ivanti Neurons Platform, using a connector designed for your data source (for ITAM Cloud only). For details, see Importing from the Ivanti Neurons Platform.
•The Ivanti Neurons Platform, by integrating with Ivanti Neurons for Spend Intelligence (in this case, imports are restricted to software-related contracts and contract line items). For details, see Integrating with Ivanti Neurons for Spend Intelligence. (For ITAM Cloud only)
•The Ivanti Neurons Platform, by integrating with Ivanti Neurons for Discovery (for ITAM On-Premises installations only). For details, see Integrating with Ivanti Neurons for Discovery (ITAM On-Premises).
•Ivanti Neurons for ITSM platform connectors. For details, see the Ivanti Neurons for ITSM online help at help.ivanti.com. As a starting point, refer to these topics:
•Ivanti Neurons for ITSM and Endpoint Manager Connector
• A set of Excel spreadsheets provided by Ivanti to import data (recommended for an initial data import only and discussed below).
After importing your data, see the Next steps section in Getting started.
Importing data via Excel spreadsheets
Ivanti provides a set of spreadsheets with appropriate columns already created that you can populate with your data and then import directly into the product. These spreadsheets include some sample data to give you an indication of the form your data needs to take. Remember to remove these examples.
The set of spreadsheets you'll want to download depends on your region (USA, EMEA, or Asia) and system landscape (staging or production). In each .ZIP file, you'll find an ImportGuide.DOCX file that lists the recommended order for importing your spreadsheets.
Download the .ZIP file containing the spreadsheets most relevant to your environment as listed below:
USA
•Staging – USA-Staging-Import-Templates.ZIP
•Production – USA-Production-Import-Templates.ZIP
EMEA
•Staging – EMEA-Staging-Import-Templates.ZIP
• Production – EMEA-Production-Import-Templates.ZIP
Asia
•Staging – Asia-Staging-Import-Templates.ZIP
•Production – Asia-Production-Import-Templates.ZIP
Mandatory and allowed values
Some of the columns in the spreadsheets are mandatory, and some are optional. Mandatory columns have bold column headers that require values in every row.
Other columns can take only certain allowed values, which are documented in AM_DataImport_AllowedValues.XLSX. This file is included in each of the above .ZIP files and contains a worksheet for each of the spreadsheets. The worksheets have columns named to match the columns in the import spreadsheets that take only specific values and that show the allowed values for those columns.
It's vital that these columns in your import spreadsheets contain only values matching those in the AM_DataImport_AllowedValues.XLSX file or values that match any new values that you've added to the corresponding validation list.
Populating your import spreadsheets
The first stage of importing is to populate the import spreadsheets with your data.
To populate your import spreadsheets
1.Open AM_DataImport_AllowedValues.XLSX (included in each of the above .ZIP files) and display the worksheet that matches the import spreadsheet you want to populate.
2.Open each of your import spreadsheets in turn and add your data, making sure you use only the allowed values from AM_DataImport_AllowedValues.XLSX in any columns that are included in that spreadsheet.
Importing the spreadsheets
The second stage is to import the spreadsheets via the Administrator Configuration Console's Settings page.
To import the spreadsheets
1.Log in as Asset Administrator.
2.Click the 
icon at the top right side of the user console. The Configuration Console displays in a new browser tab.
3.In the left navigation pane, expand Extend > Integration Tools > Data Import Connections. We recommend that you import the spreadsheets in a specific order—refer to the Import Guide included in your .ZIP file, or use the table below for guidance.
Some of the spreadsheets are imported multiple times using different mappings and filters. For example, AM_Assets.XLSX is imported as part of the connection AM Excel - Assets for each asset type.
Only one of these mappings can be active at any time, so click the OFF switch to ON alongside the mapping that you want to import.
If you have specialized devices that are unmanaged or that don't map well to the available asset types (for example, various medical devices, IoT assets, Cloud Service assets, etc.), map them to the General Assets type in AM_Assets.XLSX. Once they're imported, you can manually change these records to a more accurate asset type if needed. For details, see the procedure below.
4.Click Run Now next to each connection you want to import, then follow the prompts. Import spreadsheets in the following order:
| Purpose | Name | Connection Source | Mapping |
|---|---|---|---|
| Asset Sub Types | AM Excel - Asset Types | AM_Asset_Types.xlsx | Asset Types |
| Countries | AM Excel - Countries | AM_Countries.xlsx | Countries |
| Locations | AM Excel - Locations | AM_Locations.xlsx | Locations |
| Location Parents | AM Excel - Locations | AM_Locations.xlsx | Location Parents |
| Storage Spaces | AM Excel - Storage Spaces | AM_Storage_Spaces.xlsx | Storage Spaces |
| Consumable Types | AM Excel - Consumables | AM_Consumables.xlsx | Consumable Types |
| Consumables | AM Excel - Consumables | AM_Consumables.xlsx | Consumables |
| Financial Owners | AM Excel - Financial Owners | AM_Financial_Owners.xlsx | Financial Owners |
| Financial Owner Parents | AM Excel - Financial Owners | AM_Financial_Owners.xlsx | Financial Owner Parents |
| Teams | AM Excel - Teams | AM_Teams.xlsx | Teams |
| Job Titles | AM Excel - Job Titles | AM_Job_Titles.xlsx | Job Titles |
| Users Without Managers | AM Excel - Users | AM_Users.xlsx | Users |
| User Managers | AM Excel - Users | AM_Users.xlsx | Managers |
| Manufacturers | AM Excel - Manufacturer | AM_Manufacturers.xlsx | Manufacturers |
| Vendor Contacts (ExternalContact) | AM Excel - Vendor Contacts | AM_Vendor_Contacts.xlsx | Vendor Contacts |
| Vendors | AM Excel - Vendors | AM_Vendors.xlsx | Vendors |
| Vendor Contact Links External | AM Excel - Vendor Contact Links | AM_Vendor_Contact_Links.xlsx | External Contacts |
| Vendor Contact Links Internal | AM Excel - Vendor Contact Links | AM_Vendor_Contact_Links.xlsx | Internal Contacts |
| Product Catalog Items | AM Excel - Product Catalog Items | AM_Product_Catalog_Items.xlsx | Catalog Items |
| Product Catalog Item Replacements | AM Excel - Product Catalog Items | AM_Product_Catalog_Items.xlsx | Replacements |
| Approved Vendor Records | AM Excel - Catalog Approved Vendors | AM_Catalog_Approved_Vendors.xlsx | Vendor Items |
| Software Products | AM Excel - Software Products | AM_SoftwareProducts.xlsx | Software Assets |
| Contracts | AM Excel - Contracts | AM_Contracts.xlsx | Contracts |
| Contract Line Items: Entitlements | AM Excel - Contract Entitlements | AM_Contract_Entitlments.xlsx | Entitlements |
| Contract Line Items: Extended Warranties | AM Excel - Contract Extended Warranties | AM_Contract_Extended_Warranties.xlsx | Extended Warranties |
| Contract Line Items: Leases | AM Excel - Contract Leases | AM_Contract_Leases.xlsx | Leases |
| Contract Line Items: Maintenance | AM Excel - Contract Maintenance | AM_Contract_Maintenance.xlsx | Maintenance |
| Contract Line Items: NDAs | AM Excel - Contract NDA | AM_Contract_NDAs.xlsx | NDAs |
| Contract Line Items: Purchase Contracts | AM Excel - Contract Purchase | AM_Contract_Purchases.xlsx | Purchase Contracts |
| Contract Line Items: Services | AM Excel - Contract Services | AM_Contract_Services.xlsx | Services |
| Contract Line Items: Support | AM Excel - Contract Support | AM_Contract_Support.xlsx | Support |
| Contract Line Items: Volume Purchases | AM Excel - Contract Volume Purchases | AM_Contract_Volume_Purchases.xlsx | Volume Purchases |
| Purchase Orders | AM Excel - Purchase Orders | AM_Purchase_Orders.xlsx | Purchase Orders |
| Purchase Line Items | AM Excel - Purchase Line Items | AM_Purchase_Line_Items.xlsx | Purchase Line Items |
| Invoices | AM Excel - Invoices | AM_Invoices.xlsx | Invoices |
| Shipments | AM Excel - Shipments | AM_Shipments.xlsx | Shipments |
| Computers | AM Excel - Assets | AM_Assets.xlsx | Computers |
| Mobile Devices | AM Excel - Assets | AM_Assets.xlsx | Mobile Devices |
| Infrastructure | AM Excel - Assets | AM_Assets.xlsx | Infrastructure |
| Peripheral Devices | AM Excel - Assets | AM_Assets.xlsx | Peripheral Devices |
| General Assets | AM Excel - Assets | AM_Assets.xlsx | General Assets |
| Assign multiple Contract Line Items to an Asset | AM Excel - Asset to LineItems | AM_Assets_to_ContractLineItems.xlsx | Assets to LineItems |
| Assign users to multiple teams | AM Excel - User to Teams | AM_Users_to_Teams.xlsx | Users to Teams |
The final two items in the table correspond to many-to-many relationships and as such update the FusionLink table. We recommend that these are the final files you import.
Changing the asset type
Finally, for any specialized devices that imported as a General Asset but require a more accurate asset type, you can change the type using the More drop-down menu.
To change the asset type of a device
1.Open the Hardware Assets workspace. The list of managed devices in your database displays by default.
2.Double-click a General Asset device to open its asset record.
3.Click the More drop-down menu at the top right of the page, then click Administration Actions > Change Asset Type.
4.Select the new Asset Type and Asset Subtype, then click OK. The asset record should update with the new type and subtype.
For details about working with managed asset records, see Hardware assets.