Kick start import of multi-select Dropdown issue

[TGuido1]

I am attempting to upload a kickstart XLS and one of the columns is a multi-select dropdown.  When there is only one value, no problems.  The kickstart fails when there is more than one option in the cell.  I have the data entered in the cell as it is shown when reporting on the multi-select, with the values separated by a comma.  Has anyone gotten this type of kickstart to complete?

[VictoriaLinn]

Try using the vertical bar "|" as the separator. I've had luck with that for importing in multiple dropdown values. 

[TGuido1]

Thanks for the suggestion.  I tried the vertical bar with spaces between choices and no spaces between, and that doesn't work.  

[imgrund · Accepted solution]

Hi TGuido1 - Just happen to see this in my email digest and have had issues with this before so thought I'd share some troubleshooting things that I went through in the past that helped me out  

First: Make sure you haven't deleted the Preferences tab in your Kick-start excel (accidentally did that once).  If you do still have it there, double check it and see if you column D still has \| as the default value. If that is still the value, then the | with no spaces should still work.

Second: (This one probably doesn't apply to you since you are getting it to work when you have one value - but putting it for others in the future) Make sure the choice field you are looking to doesn't have separate values and labels. If it does, you need to use the values in the kick start, not the labels. 

Third: (Again, probably not for you since you are getting it to work for when you have one value)  Make sure you have setCategoryID to the custom form's ID as well.  And for the custom field, you have DE: in front of the field's name.

Do for column DE:Region you could have North America|Europe|Asia as one of the values and that should select North America, Europe, and Asia for that object when it is uploaded.

Hope this helps. (If not for you, at least for someone in the future as I know kick-starts can be very frustrating sometimes.) 

[TGuido1]

Thanks Imgrund and Victoria...

The vertical bar was the correct delimiter.

I also did not have the Preferences tab in my kickstart file.

Once I added, this resolved my problem.  Thanks to you both.