Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Assigning Imported Assets to a Jira Object Type Based on a CSV Field

Logan Kitchen May 18, 2023

I am importing a complete CSV export of another Asset system into Jira Data Center Assets.  

There are various fields holding serial numbers, models, etc. Among those fields is a field called "Category" that groups the assets into sub-sets like "Laptop", "Monitor", and "Mobile Phone".

I have created a large Object Schema with an object type related to each of these categories.

To test the import I have a CSV Import configuration that has an Object Type Mapping for "Laptop". All fields map properly, but it imports ALL objects (rows) in the CSV to the Laptop Object Type. I have the "Filter data source by AQL" field set to Category = "Laptop", which seems to be valid AQL according to the docs, but it doesn't filter the CSV at all. 

Can I filter these imported assets to multiple Object type mappings based on a column of my CSV? If so, what am I misunderstanding here?

2 answers

0 votes
Els Bassant
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 27, 2023

Hi @Logan Kitchen ,

Did you find a solution for this?

I'm running into the same issue where I want to split the data from a single CSV over multiple object types based on a value in the CSV. The source data comes from a different system, and this import will run on a monthly schedule. So manually splitting it is not an option for now.

 

Kind regards, 

Els

0 votes
Kris Dewachter
Community Champion
May 24, 2023

Hi @Logan Kitchen ,

Can you check if the answer provided here solves your issue?

https://community.atlassian.com/t5/Jira-Service-Management/Filter-data-source-by-AQL-in-Assets/qaq-p/2205329

I had a similar issue trying to filter objects from the source by "Hardware Type", which was a referenced object. I had to turn it into a regular attribute for the source filter to work.

 

I hope this helps.

 

Best regards,

Kris

Logan Kitchen May 24, 2023

Unfortunately it doesn't. My field isn't an object, just a simple text value, so it is already a regular attribute. I appreciate the input though. I am trying some of the AQL variations you have in your ticket to see if they help.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events