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?
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
Hi @Logan Kitchen ,
Can you check if the answer provided here solves your issue?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.