Import multiple values into single field

[dannica_c]

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

[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.

[Joseph Chung Yin]

@dannica_c -

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_c]

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_c]

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_c]

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

[Tristan O'Brien]

@dannica_c 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

[dannica_c]

Please see attached mapping