Bulk import comments into Assets via CSV

[Sam Thornton]

Hey all,

One of our teams wants to import devices into Assets to use as their main asset management system, but one of their requests was whether they can import comments as well through the CSV import.

I've given it a go using the same theory as with normal issues (Adding a header 'Comment' and then using the correct formatting), but I haven't had much success.

Is there any way I can do this import natively through Assets or through Scriptrunner, perhaps?

If not, the other way might be to create a text field and have free text notes (comments) be added there from the import, but this doesn't feel particularly clean to do.

I'm using Jira Service Management Data Center, currently on version 5.4.14 (and upgrading to the latest version later in the year).

Any help or advise is appreciated.

Thanks!

[Alonzo Kennedy]

Hello @Marc - Devoteam 

Would you be able to help with this questions?

Asset Management Import 

[Marc - Devoteam]

Hi @Sam Thornton 

Assets don't contain Jira field related options.

Assets exist of object types, objects and attributes.

You would need a text area attribute and store the information in there.

Also note that there is no formatting availabe.

[Sam Thornton]

Thanks for your reply @Marc - Devoteam :)

Yeah, I knew about the make-up of Assets, but thought I'd give it a go anyway just on the off chance that it would recognise Comments as a heading within the CSV.

I think an attribute as an initial note will be fine, as long as the team doesn't care about formatting. 

Do you know whether anything is possible in Scriptrunner? I've looked through the Adaptavist library.

[Marc - Devoteam]

Hi @Sam Thornton 

Not that I'm aware and due to the fact Assets doesn't support formatting, I don't see how scriptrunner would be able to make this work

[Sam Thornton]

No problem, worth an ask!

Thank you for your help! You confirmed my suspicions.

Have a good afternoon.