Fusion and CSV files: How do I import values for a multi-select field? | Community
Skip to main content
JohnJOSullivan
JohnJOSullivan
Level 6
March 29, 2023
Solved

Fusion and CSV files: How do I import values for a multi-select field?

  • March 29, 2023
  • 1 reply
  • 1230 views

Quick Question: I have a process I'm building out for creating Issues from a CSV file. Most of it is pretty straightforward and simple...except for when it comes to multi-select fields. How would I take a list with commas, grab those fields, and have Fusion apply them for that field?

 

This feels like it should be easier than it is...but welcome to Fusion. 😄

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by JohnJOSullivan

Okay, I think I nailed it. I ended up using "split" and turned the list into sub strings, then integrated the selections when I created the issue:

 

 

 

 

 

1 reply

Kurt_Jones
Community Advisor
Kurt_JonesCommunity Advisor
Community Advisor
March 29, 2023

Hi John, if you're using the issue kickstart then typically the pipe |  is the default to separate multiple-select items.  Example, say I have custom field Test Product and it has the following choices, apple, orange, plum, pear.  Say my first issue I chose apple and pear then for a second issue I choose orange and plum.  Here is what the column would look like for that 

DE:Test Product

apple|pear

orange|plum

 

Hopefully I understood properly and this helps.  Well, re-reading, I misunderstood, sorry.  You're using Fusion.  In that case, for your custom field, you can click the map toggle button and input something similar but with commas, example  orange, plum

If my response answered your question, please mark it answered, so others can find the answer
JohnJOSullivan
JohnJOSullivanAuthor
Level 6
March 29, 2023

So, I've tried commas (with spaces), commas (without spaces), values in quotes, semi-colons, pipes...nothing works. I'm assuming Fusion is reading the field in the CSV and thinking it's one huge value, as I get the following error: 

 

The operation failed with an error. [422] Invalid Parameter: <custom form field> value "apple, orange, tomato"

JohnJOSullivan
JohnJOSullivanAuthorAccepted solution
Level 6
March 29, 2023

Okay, I think I nailed it. I ended up using "split" and turned the list into sub strings, then integrated the selections when I created the issue:

 

 

 

 

 

Terms & ConditionsAccessibility statement

Loading footer...