Trouble importing multi-select values from .csv to HubDB

Developer Support CMS Development
1

Hi,

I’m trying to import values from a .cvs file to a multi-select field in a HubDB, but unfortunately every attempt has resulted with blank multi-select fields in the HubDB.

It’s looking like HubSpot’s import dialogue recognizes the multiple values intended for the multi-select field, but then once the import finishes the fields are empty.

29091i1C5C8C109AE7AF5B.png
29091i1C5C8C109AE7AF5B.png914×610 29.3 KB

29092iADFF08B36943D562.png
29092iADFF08B36943D562.png693×383 11.3 KB

Please let me know if I’m missing something.

Thanks,

Nathan

2

Hi, @NBoo.

It looks like you’re delimiting values with commas (,). Could you try using semicolons (;) instead?
Per this article, the HubSpot CRM looks for semicolons between multiple checkbox property values and I believe the same logic applies to HubDB.

3

I exported a HubDB with a multi-select field to CSV to see what format it’s in. This is what I got:

Customer management,Reputation management,Upselling,Guest communication

It’s comma separated, but seems like it might be case sensitive so maybe worth checking for that.

4

Thanks piersg! Case sensitivity was the problem. Appreciate you taking the time to look at this.

Thanks again,

Nathan