Kick start import of multi-select Dropdown issue | Community
Skip to main content
T
TGuido1
Level 1
September 24, 2024
Solved

Kick start import of multi-select Dropdown issue

  • September 24, 2024
  • 1 reply
  • 816 views

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?

Best answer by imgrund

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

1 reply

VicSellers
Community Advisor
VicSellersCommunity Advisor
Community Advisor
September 24, 2024

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

T
TGuido1Author
Level 1
September 25, 2024

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

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
September 25, 2024

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

    Terms & ConditionsAccessibility statement

    Loading footer...