Expand my Community achievements bar.

Creating WF Issues from a CSV file via Fusion and mapping multi-select options for the custom form

Avatar

Level 3

I want to create a small Fusion scenario that takes in a .csv file and uses the information therein to create Issues in a project in Workfront. This means mapping the fields from the .csv to the corresponding fields in the custom form to create the issue.

Most of the fields are straightforward and map across with no problem, but there are 3 multi-select fields (at least one answer must be given, but there could be multiple answers). I am a bit lost as to how to get this to work!

 

I've tried leaving them blank vs selecting all of the options but neither work as hoped. Do I need to create an array variable grabbing the selected options from the .csv? 

 

If anyone has an example or can show me what to do this would be really helpful.

Thanks

 

The .csv fields of Segment, Market (region) and Platform that can have multiple options

csv1.png

 

The issue created but the multi-select fields aren't mapped

csv2.png

Set up of the create Issue module, I'm not sure how to map these here, have tried selecting all options, selecting no options etc but neither give the desired result.

csv3.png

 

The Issue created in Workfront, you can see the custom form fields do not show any answers.

csv4.png

    

5 Replies

Avatar

Community Advisor

Good morning!

 

To map in your values from your CSV, first in the Workfront module (image 3), check the "map" toggle. This will allow you to map values into those fields.

The next step is converting your string in your CSV into an array. Multiselect fields are treated as arrays by Workfront, so you have to format your data to match. Looking at your sample data, the easiest way would be to use split, so split({csvValue};|). Note, the values need to be a strict match, or the module will error out and not create anything.

Avatar

Level 3

Thanks @ChrisStephens I think I am inching closer to a solution...

I am trying to implement your solution but the module is erroring out. The character that demarks where the split should be is a semi-colon, not sure if this is what is causing the problem?

 

How the data comes in from the csv

Screenshot 2023-06-27 143355.png

My updated mapping with the split function

Screenshot 2023-06-27 143245.png

Screenshot 2023-06-27 143931.png

The error when the scenario is run.

Screenshot 2023-06-27 143105.png

   

Thanks!

 

Avatar

Community Advisor

Oof yeah, that's a problem. Notice how the semicolon is inside of a darker-grey box? That means that Fusion is going to try to use it in it's coding, it thinks that it's part of the split command. Is there any way you can demark it with a different symbol in your csv file?

Avatar

Community Advisor

Or, I just found a workaround.

 

You have to type in a semicolon before you type in anything else, and then put the split({yourString;;), where the second semi-colon there is the one you originally typed in.

Avatar

Level 3

Thanks Chris, using the split function for this worked for my needs.

Thanks for your help.

 

PoppyJennings_0-1688983879293.png