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

Question

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?

Els Bassant · Answer

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

Logan Kitchen · Answer

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.

Kris Dewachter · Answer

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