Import multiple values into single field

[Dannica Capistrano]

Hi,

Requesting your advise on importing multiple values into a Single Field.

Trying to import the Roles however some Roles have multiple Department

Department is an Object configured with Unlimited values "cardinality = unlimited"

CVS format:

Role, Department, Department
"Will Call CS OPS Associate", Customer Service, Shipping

[Joseph Chung Yin · Accepted solution]

@Dannica Capistrano -

As documented by Atlassian -

• To divide multiple values (for the Insight attributes with multiple cardinalities), you can use “||” (2 pipe characters) within the CSV file.

• If you wish to join multiple values into one Insightattribute, you can use a concatenator in the CSV file. The default is a dash symbol “-”. If the data is concatenated with a space, you can enter “/s” in the Concatenation field when creating an import configuration.

Hope this helps.  Here is the actual KB link for your reference - https://support.atlassian.com/jira-service-management-cloud/docs/import-a-csv-file-into-insight/

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[Dannica Capistrano]

Hi Joseph,

Tried to import using below details but issue persists. I put IQL: Department=${Department}" and Concatenator is empty. Did I missed anything?

CSV Format:

"Role", "Department"
"Will Call CS Ops Associate", "Customer Service"||"Shipping"

[Dannica Capistrano]

I just removed the "quote" then added the || pipe. For the IQL, I used Department IN (${Department${0}})

[Joseph Chung Yin]

So, are you still having issue?  Please advise.

Best, Joseph

[Dannica Capistrano]

not anymore, this issue is resolved. thank you! :)

[O'Brien, Tristan]

@Dannica Capistrano what made you update Department=${Department} to Department IN (${Department${0}}) ?

I was having the same issue trying to import two objects to a single attribute. I went from Name IN ${JSM Project Filter} to Name IN (${JSM Project Filter${0}}) and its worked.

[Commercial Account Scolution]

This would actually be a very helpful information for us, too.

[Commercial Account Scolution]

Found it, it is documented here: https://confluence.atlassian.com/servicemanagementserver/2-create-object-type-and-attribute-mapping-1044784497.html

[Aaron P.]

Well, I still have the same problem.
When I export from Assets and there is more than one value in a field, for example 2 managers of a department, the system separate them with a double pipe (||), but if I import it back to Assets it simply omits this field, leaving the manager empty.

CSV:
Manager, Department
user1@mail.com||user2@mail.com,HR

Import: (Sorry, the image is in spanish)

Result:
Responsible| Department
   (VOID)     |        HR

How do I configure the import so that it adds the 2 managers in the corresponding field?
Of course, the Responsible attribute allows unlimited values.

[Aaron P.]

nobody? 😔

[Rodislav Moldovan]

This is what worked for me

Name,Family
myasset,Fam1||Fam2

Label IN (${Family${0}})

[Cornelius Gillner]

@Joseph Chung Yin 
> you can enter “/s” in the Concatenation field when creating an import configuration.

Is there a way to concatenate with a non-whitespace (or "nothing")?
In regEx that would be "\S" (with a capital S) but that produces a slash after the import.

[Dannica Capistrano]

Please see attached mapping