On this page
In SolarWinds Service Desk (SWSD) you can choose to import new computers, contracts, incidents, mobile devices, other assets, and users via a comma-separated value (.csv) file. SolarWinds provides csv templates for easy importing.
Each asset type has a different template. In each template, some or all fields are required for successful import. Some fields have selection options available out of the box. If your organization has not created any specific selection options, you can use out-of-the-box options.
You cannot import sites or departments. Those must be set up in your instance of SWSD before you import any assets or users.
When uploading a csv, the upload will only create new records. It will not edit/update/change existing records already in your account. Also, if you are importing new users, SWSD will not send activation emails to csv-imported users.
SolarWinds recommends using a CSV template we provide for managing the data you will import. If you choose to use your own CSV file containing custom fields, you will be required to map your fields to the SWSD fields.
Use SolarWinds template
Before you begin
Be careful of your data entry. For example, if you are assigning a site or department to a device, be sure to exactly match the site and department in your import source file to those in SWSD.
If you use any custom fields in your import, create the custom fields in SWSD before performing your import. Otherwise, the content will not import properly.
Identify the template you need to use for the type of data you will import.
|Record type you are importing||Template(s)||Template fields
(see table footnotes)
To import, navigate to Assets > Computers.
Notice that serial number and model number are located in the BIOS column and are separated by a tilde (~). Serial number is indicated by ssn: followed by a space, and model number is indicated by model: followed by a space.
ESM customers can only import computers via CSV at the Organization level.
To import, navigate to Procurement > Contracts > [selected contract].
A list of contracts cannot be imported. You must first create the contract manually. You can then import contract information, such as items or purchases, to the existing contract. Items include the number of software licenses and version, while purchases cover information such as date of purchase, vendor, and cost. Contract renewal reminders can only be added to contracts manually. See Contracts for ITAM.
ESM customers can import contract information via CSV at the Organization level or the Service Provider level.
To import, navigate to Service Desk > Incidents.
You can backdate the Created_At field using the template. The following date formats are supported: yyyy-mm-dd, dd-mm-yyyy, yyyy/mm/dd, dd/mm/yyyy.
ESM customers can import incidents via CSV at the Organization level or the Service Provider level.
Be aware that importing incidents via CSV only imports the text of the incident. Attachments and screenshots are not imported directly from an incidents csv file.
To import, navigate to Assets > Mobile Devices.
ITSM administrators or an ESM administrator for the IT Service Provider can import mobile devices.
To import, navigate to Assets > Other Assets.
ESM customers can import other assets via CSV at the Organization level or the Service Provider level.
To import, navigate to Setup > Users & Groups > Users.
If you choose to import a group of users from a CSV file, match the sites and departments in your import source file so they are an exact match to the sites and departments already set up in SWSD.
Users can only be imported by an ITSM administrator or an ESM Organization level administrator.
To import, navigate to Service Desk > Solutions.
Solutions can be imported by an ESM service provider administrators.
Navigate to the proper index table that matches the type of data you are importing. (See navigation guidance in Column 1 of the table above.) For example, if you are importing users, navigate to the Users index page to perform the import.
On the index page, click the Actions dropdown in the top right corner.
In the Importing dialog, click Choose File, select the file you need to upload, and then click Open.
The mapping page opens. On the mapping page you can see a map of which columns will import into which fields.
Review the mapping and edit as needed.
The example below shows a mapping page resulting from an import of user records.
Be sure you have confirmed and changed mappings as described in Step 5. Click Import to begin the import process. Upon completion you will receive a notification email with a status report. The report will contain any errors encountered during the import.
Some csv templates contains fields that have options available. However, SolarWinds recommends that you use the field selection options available in your organization. To view the most current options available in your organization:
Navigate to the index table for the type of device you want to import, for example Assets > Computers, and then click Add .
From the new window that opens, open each drop-down menu to view the selection options for field included in the import template for the device type you want to import (for example, the Import_ Hardwares.csv if you are importing computers).
- Mac Desktop
- Mac Laptop
- NAS / File Server
- Server + VMware
- Server - Unix
- Thin Client
- VM: Microsoft
- VM: Parallels
- VM: SWSoft
- VM: Virtualization
- VM: VMWare
- VM: XenServer
- In Repair
- One Time
- SolarWinds Service Desk
For mobile devices
- Asset status selection options
- In Repair
- Device Type
- Media Player
For other assets
- Broadband Modem
- Cable Modem
- Coffee Machine
- External Storage
- Fax Machine
- Network Attached Storage
- Network Printer
- Office Chair
- Speaker Phone
- Storage Area Network
- Wireless Access Point
- In Repair
- Service Agent User
- Service Task User
Although many languages are available, SolarWinds recommends that you import users with Default and let users select their own language.
- Chinese Simplified
- Chinese Traditional
- Portuguese (Brazil)
- Portuguese (Portugal)
- Spanish (Latin America)