Get started with Jira Service Management for admins
Your first stop for learning how to get started with Jira Service Management.
Assets Data Manager for Jira Service Management Cloud is currently rolling out in Open Beta and will be available to all Premium + Enterprise sites by end of October 2024.
This task requires Data Manager admin permissions to complete. How permissions and roles work in Data Manager.
To create a new job using a flat file, such as a CSV or TXT file, as a data source:
Select Assets in the top navigation bar.
Under the Asset and configuration management title, select Data Manager.
Select Adapters in the left menu bar. This will open a new tab to the Adapters screen.
Select Create a job in the left menu bar.
Under General, select Flat Files.
Once you have created a new job, you must complete all of the Required (*) fields before the job can be successfully saved.
In the Flat File Configuration screen, configure details about the data source:
In the Name field, enter a name for your job. This name will be used to identify your job when you run the Adapters client.
Ensure the Enabled toggle is set to Enabled (dark blue). Disabled jobs cannot be run.
In the Object Class field, select the Object Class destination for this data. Object Classes currently available in Data Manager.
In the Data Source Type field, select an existing Data source type or create a new data source type, below.
In the Data Source Name field, enter a name for the Data Source that will be created when this job is run. This is typically the same as the Name, above.
In the File Path field, enter a file path where the flat file can be found. You must use the correct file path, including the filename and the filename extension. Here’s an example of a file path that you might see in a MacOS system:
1
/data-manager-files/CMDBComputers.csv
And here’s an example of a file path you might see in a Windows PC system:
1
C:\data-manager-files\CMDBComputers.csv
In the Skip line field, enter an integer value if the headers of your data file are not on the first line of the file. By default this field is set to 0.
In the Delimiter field, you can enter the delimiter character that separates the values when viewed within a text file. The default is the comma ,.
In the Qualifier field, you can enter a unicode character that wraps a string and marks it as a single value. The most common qualifier is the double-quote character ".
The End with delimiter toggle should be enabled only if each line in your flat file file ends with a delimiter as well.
The Wildcard toggle should be enabled if multiple flat files are grouped together with the same column structure. For example, data-file-*.csv will consume data-file-1.csv, data-file-2.csv, etc. If using a Wildcard, this Field Path field will exclude the file name and extension.
The Column Mappings section allows you to configure Column Mappings for each column in our file. Each column mapping can be further configured:
The Source Column Name field is the name of the source column in the data file.
The Source Column Type allows you to select the data type to use for the data in that column.
When the Source Column Type is a date, the Date Format field displays and allows you to select a date format to mask date and time information. If this field doesn’t contain date or time information, it can be left empty.
The Destination Column Name field is the name assigned to this field in Data Manager.
A data source type contains information about a group of data sources, and you are required to select a data source type when creating a job.
If you don’t have any data source types created:
Go to Flat File Configuration
Select the Data Source Type and enter the name for the new type
Select Add item in the dropdown box that appears
The Auto Generate button allows you to automatically generate column mappings. Copy and paste the flat file headers (separated with your chosen delimiter, such as commas) from your data source into the field and select Auto Generate.
The Column Mappings section allows you to configure Column Mappings for each column in our file. Each column mapping can be further configured:
Select Add Mapping for each column you want to add.
The Source Column Name field is the name of the source column in the data file.
The Source Column Type allows you to select the data type to use for the data in that column.
When the Source Column Type is a date, the Date Format field displays and allows you to select a date format to mask date and time information. If this field doesn’t contain date or time information, it can be left empty. If your data date format is not in the list, you can create it in the settings.
The Destination Column Name field is the name assigned to this field in Data Manager.
You won't be able to map data to a NULL column for CSV/TXT for a Flat File. This is true even if you create column mappings manually.
The mapping will not be possible as the data type for that column will be set to string by default. To map data in this situation, use the Transform function to convert the string to another data type.
Once all required fields have been filled and all columns in the data source have been mapped, you can Save this job. Your new job should be visible in the All Jobs screen.
Was this helpful?