nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Joseph Chung Yin

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

All comments

Dannica Capistrano

Please see attached mapping

Joseph Chung Yin

@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

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.

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_15t9iq

This is what worked for me

Name,Family
myasset,Fam1||Fam2

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

Screenshot 2025-02-12 162208.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

csv

cloud

import

jira-service-management-cloud

jira-service-management

aql

cardinality