Csv Integration
Create or update assets from a CSV file. Map the matching key, categories, names and descriptions, then review the synchronization result.
Import assets from a CSV file to create new records or update existing ones. The following sections cover configuration and examples.
CONFIGURATION
Before configuring the integration, you must have an asset category created in the Admin Panel under Assets → Asset Definition. If it does not exist, create a new one and, if needed, define custom fields within that category. This documentation assumes that an asset category and two custom fields are already set up.
The integration process begins by navigating to the Assets tab and then to the Assets Integrations submenu. The main view presents a table of saved configurations with the following columns:
- Name – Configuration name
- Definition Name – Short name of the configuration type selected from the list during creation
- Definition Type – Description of the selected configuration type
- Action – Column with Edit and Delete buttons
To create a new configuration, click the “Plus” button in the upper-right corner of the page.
This opens the Create Integration page, where you enter a name in the Name field (any value) and select the Definition Type as CSV (CSV assets integration).
Once the details are filled in and saved, you are redirected to the configuration settings.
Complete Set Asset Configuration:
-
Map assets by type – This field determines which column or custom field the importer will use to recognize the uniqueness of assets in Mint Service Desk. If the value in the selected column exists, the importer will update the corresponding asset. If it does not exist, a new asset will be created. Available options:
-
Id – Corresponds to the asset’s unique system number in Mint Service Desk
-
Subject – Corresponds to the asset’s name
-
CustomField – Selecting this displays a new field: CustomField attributeID key column name.
In this field you can select an existing custom field and assign it as the primary key for the asset. First, choose the asset category from the dropdown, then select the associated custom field.
-
Once selected, this field becomes the primary key for the importer.
-
Key column name – Name of the column in the CSV file that corresponds to the key column selected in Map Assets by Type.
-
Category map type – Determines how the importer assigns an asset to a category:
-
Constant – You manually select an asset category from the Mint Service Desk system. The importer will only add or update assets in this specific category.
-
FieldsValue – You specify the column in the CSV file that contains category values. The category values must be in GUID format (e.g., a816f0ec-15d6-40fd-818a-fc9687c4c77c) and must match category IDs in the Mint Service Desk database.
-
FieldsValueWithMapping – Allows mapping category names from the CSV file that may not exactly match those in Mint Service Desk. This configuration enables name mapping between the CSV and the system. After selecting this option, the Category field mapping section appears with Set external category value field and New row button.
In the field with the placeholder Set external category value, we indicate which column in the CSV file corresponds to the asset category. After clicking New row, the first entry (#1) appears with the fields Set external category value, Asset category, and the Delete button.
In entry #1, in the Set external category value field, we specify the first value from the CSV column, while in the Asset category dropdown list, we select the category to which this value will correspond. For example, in the CSV file, we have a column named IT Hardwares with the first value Computers. We want Computers to be treated as a category, but in Mint Service Desk, this category is named Laptops. Therefore, we configure it as follows:
and the configuration with the CSV file:
This means: Take the data from the “AssetCategories” column in the CSV file, and if a value in this column matches “Computers,” assign the asset from that row to the “Laptops” category in Mint Service Desk. In this way, we can assign multiple assets to multiple categories simultaneously.
-
-
Asset name column name – Name of the CSV column that corresponds to the Name field of the asset in Mint Service Desk.
-
Description column name – Name of the CSV column that corresponds to the Description field of the asset in Mint Service Desk.
In Section File Configuration, set the CSV options:
- Delimiter – Default is a semicolon (;).
- Import File Button – Upload the CSV file for import.
The last section displays Synchronization history, including:
- Start time
- Result
- Execution date
- Errors (if any)
EXAMPLES
The examples below show how to import new assets and update existing records.
Importing New Assets
This example uses an existing asset definition named Laptops.
The asset database is initially empty.
Import five assets named Asset1, Asset2, Asset3, Asset4 and Asset5. Each should have Sample description in its description field.
Steps
Create a CSV file with the asset details.
Next, we create a new import configuration in the Asset Integrations tab (as described in Configuration part) and fill in the Section Asset Configuration section.
In Category map type, we select Constant and choose Laptops asset category
Keep the semicolon as the file delimiter and click Update to save.
Click Import file and select the CSV file from disk. Notifications appear in the top right corner and synchronization starts.
If another ongoing synchronization is already running in the background, we receive a notification:
In the Synchronizations section, we can see our synchronization with the status In Progress.
We can click on it to enter its details and see progress:
Once completed, the status changes to Success, and the assets are created in the system.
Modifying Existing Assets
After importing the assets, we want to update their names and descriptions. In the CSV file, before the update we have:
After the update we want:
As the Primary key, we select the asset’s ID. It is important that the asset ID in CSV matches the ID in Mint Service Desk.
If incorrect IDs are used, new assets will be created instead of updating existing ones.
Import the updated CSV file using the same steps as for new assets, then check the changes in Asset Management.