How to import checkbox values?

  • Hilmar Schneider
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
7 years 5 months 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.

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

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
7 years 5 months 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 5 months 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.