Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to import and filter from CSV to Insight

I am looking to import assets from the old version of Insight to the new version. I have been able to export without a problem for individual objects which are separated by different years. I have also exported users from the Atlassian Admin panel and since then have created a separate Object Schema which houses the users who will need to be matched from the users from the initial exported CSV.

Screen Shot 2021-05-27 at 7.13.50 PM.png

 

Since then, I have made the attempt to match the "Users Assigned" field which is what I used on the last iteration of Insight to match the "Owner" object which is pulling from the Object Schema (as indicated by the objectTypeID (29)).Screen Shot 2021-05-27 at 7.37.17 PM.png

 

Once the assets are imported, they are all appended with one user from the users and not entirely sure why that would happen.Screen Shot 2021-05-27 at 7.44.05 PM.png

 

Any help on this would be greatly appreciated. 

1 answer

1 accepted

1 vote
Answer accepted

Hi, 

The IQL placeholders for importing is not easy to understand. I'll try to explain it to you :)

For each imported row, the IQL should give as result the connected object in the referenced object type - in your case Employees. Depending on how the user data looks in your file you need to make the IQL condition on a matching attribute in your Employee object type. 

Example: If your input data for the "User Assigned" column is a user id and there is a User attribute in the Employee object type called "Jira User",  then the IQL mapping should look like this: 

"Jira User" IN (${User Assigned})

Thus the placeholder ${User Assigned} will be replaced for each row by the value in that column. Then the IQL filter will be run in the Employee object type looking for matching Employee(s) 

 

If there had been multiple values in the imported data in this column, you would need to write "Jira User" IN (${User Assigned${0}}) to match a list of items in the file. The items need then to be separated by ||, for example xxx||yyy||zzz

Hope this helps

Björn

Hello Björn,

This was very helpful! I needed to make some slight variations to what data was being pulled from the CSV and also choosing the right object that was being sourced, but this got me on the correct track. Really appreciate the assist with this one!

 

Many thanks,

Jawanza

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM June ask me anything (AMA)

Hello Community members! We’re wrapping up the end of JSM June with an Ask Me Anything (AMA) with the Jira Service Management product team. This is your chance to ask all your ITSM questions to o...

146 views 9 10
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you