Learn how to import to Assets using CSV

[@jonathanandrews6077]

Brilliant video used this to import assets today so much easier to understand

[@jimiwikmanofficial]

I am glad you found it useful :)

[@familybullock-rodriguez6647]

So insanely helpful, thank you so much! Saved me a lot of time.

[@jimiwikmanofficial]

I am glad you had use for it :) I also appreciate the comment!

[@sidx001]

Wooohooo!!! This video saved me A LOT of work! Thank you so much for this! You are very correct in that the documentation on this is not very good and I have been beating my head on the wall trying to figure this out. Well done!!

[@jimiwikmanofficial]

I am so happy you said that :) That was precisely the goal of making this video. Assets is amazing, but the documentation can use some work, so I'll do my best to do videos on it.

[@sidx001]

Just as an update, the expressions "Label = $()" didn't work for me... I had to use "name = ${}" to get it to work right.

[@jimiwikmanofficial]

@@sidx001 Are you by any chance on Server or Data Center?

[@jerrodvan24]

@@jimiwikmanofficial I am on data center and neither label or name worked for me.. its been frustrating

[@M.AndrewPeercy]

@@jerrodvan24 I really struggled with this too. Hopefully this will work for you. Hope the generic syntax makes sense. For the attribute that you are trying to set with the import that maps to an Object, use this AQL: objectType = "" and "" = ${} This will locate the object and filter it to match the key field to the value you have in the import file. I think this same syntax will work to filter an object by a previous set attribute as well, but that gave me some trouble when running the import. I think the earlier comments might work but you would need to substitute "Label" or "Name" with the name of the key value you set in the object.

[@deividvalencadearaujo9993]

Thanks!! You just saved me hours of research

[@jimiwikmanofficial]

I am glad that you found it useful :)

[@MarkHiggins-f2m]

Thanks Jimi, you showed my in 10 minutes, what I could not find to do in hours. Much apprecited.

[@jimiwikmanofficial]

I am glad that you found it useful :)

[@DamanyHarden]

You're Amazing! Thanks

[@jimiwikmanofficial]

Thank you, that is very kind of you to say :) I am glad you found it helpful.

[@tetianamelnyk3439]

This video is incredibly helpful! Thank you, Jimi!

[@jimiwikmanofficial]

Glad you found it useful and I am sorry for this very late reply!

[@stevey8103]

Great tutorial! Would you do a tutorial on how scheduled sync would work? I can't find any good documentation on how we would streamline the process of adding Objects with attributes via a CSV upload. This could be a huge timesaver!

[@jimiwikmanofficial]

I'll see what I can do. Is there any particular integration you are most interested in?

[@stevey8103]

@@jimiwikmanofficial We're using Service Desk in the Data Center environment, but I'd hope the process would be similar for cloud. It seems the CSV upload is only seen as a one-time thing, but then there's the scheduler. I haven't figured out how to make good use of that, when we have incoming data that changes regularly. I have to go back and recreate the new mapping for each new upload. Thank you!

[@M.AngelCastelanLeyva]

What can I do when the field to import has unlimited cardinality, that is, several values ​​can be used, for example? I have an X server and this server has several applications installed: APP1||APP2||APP3, how do I get them to appear if application is an object? When importing, it does it correctly if the server only has one application, if it has more, it does not add any value.

[@jimiwikmanofficial]

If you have multiple values, then you need to map that as an array. It should look something like this (not tested) Name IN (${Application${0}}). This will then loop that value and make multiple connections based on the number of items you have in that field. You can see it referenced at the bottom of this page: support.atlassian.com/jira-service-management-cloud/docs/use-assets-query-language-aql/ Combining references, functions and AQL Functions, references, and AQL can be combined in powerful ways. For example, you could add multiple object references to a custom field attached to an object, and then search those references for a specific key: object HAVING inboundReferences(Key IN (${MyCustomField${0}})) Or a specific label, by using dot notation: object HAVING inboundReferences(Label IN (${Portfolios.label${0}}))

[@puzzlebrainiac5238]

Your JSM Assets videos have helped me. Thank you! Once assets have been imported, can Automation be used to create new assets instead of adding each asset individually? If so, would you please elaborate? We have a lot of devices that are assigned to employees regularly and would like to use a Jira service ticket to trigger the creation of new assets. Thank you

[@jimiwikmanofficial]

You have three actions related to Assets in your automation: Create object, Edit object and Lookup objects. So you can create new objects using automations and you can update existing ones as well. I am experimenting with my configuration settings, so I can automatically create new projects when requested and then also update the records through JSM requests. I will schedule a video for that to show you how it can be done.

[@Migey11]

Hey. I appreciate this video a lot, but I'm still having problems. I've set up my import and attribute mappings, and can successfully import into a schema. Problem is, when I try to change something about the csv, add it, and import again to update some of my new objects, it instead creates new objects out of every entry in the CSV! I'm using Key + Name as identifiers when importing, with Name as the label attribute. Do you have an idea what I'm doing wrong?

[@jimiwikmanofficial]

If you are matching the Key, then they should update properly, but there have been several bugs related to this, so one of those might still be around. Key is something that we can't really do much about, but try to set Name as unique if you do not have several items with the same name? Do that by configuring the attribute and check the Unique box. Let me know if that works for you, otherwise I'll see if I can replicate your problem and find another solution.