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
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.
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I just removed the "quote" then added the || pipe. For the IQL, I used Department IN (${Department${0}})
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So, are you still having issue? Please advise.
Best, Joseph
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
not anymore, this issue is resolved. thank you! :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This would actually be a very helpful information for us, too.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Found it, it is documented here: https://confluence.atlassian.com/servicemanagementserver/2-create-object-type-and-attribute-mapping-1044784497.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is what worked for me
Name,Family
myasset,Fam1||Fam2
Label IN (${Family${0}})
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.