How to import checkbox values?

  • Hilmar Schneider
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
7 years 1 month ago #111629 by Hilmar Schneider
How to import checkbox values? was created by Hilmar Schneider
I've added a custom field of type checkbox called Interests which has values Hiking, Paddling, Cycling. It all looks good and I get checkboxes that have the labels Hiking, Paddling and Cycling. When I export the subscribers I have a field osm_interests which has a value based on the checked boxes (e.g. "Hiking, Paddling")
The problem I have is importing a subscriber: I added a field "osm_interests" with some values. When I go to edit the subscriber, all the check boxes are unchecked. If I export the subscriber list my osm_interests values are there. If I save the subscriber then the osm_interests value is cleared.

I get the impression that osm_interests is not the actual place the checkbox values are stored. Are there other DB fields to represent the individual checkboxes?

I've renamed and uploaded the import file.
Attachments:

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #111636 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic How to import checkbox values?
Hi

The data for that field need to in this format ["Hiking","Natural History","Downhill Skiing"]

Please try to change it, then import again. It should work

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • Hilmar Schneider
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
7 years 1 month ago #111704 by Hilmar Schneider
Replied by Hilmar Schneider on topic How to import checkbox values?
That work but makes for messy data entry since quotes and commas are special characters:

,"[""Hiking"", ""Natural History"", ""Downhill Skiing""]" ,

Please Log in or Create an account to join the conversation.