BUG: Import via Excel - Custom checkbox import not working

Hi - I exported a record containing a custom field with checkbox selected values in Membership Pro version 2.15.3


I then changed the customer details and imported the same file to test the import feature ( I changed the email address and name and removed the record ID and user ID).

The record imported, but the custom checkbox did not import correctly. The other custom fields seemed to work.

Also the country STATE field was not correectly populated (it is a dropdown).

Can these be checked and fixed please ?

Thanks,
Pete

Hello Pete

What's the value of the custom checkbox? Right now, if you import, the value must be in json format. If it's a string, it won't be imported properly

I will try to find a way to address it, maybe you need to separate the value by comma and then we will procedure the data to json format before process importing

It will take sometime to implement it. I will inform you when it's available

Tuan

Hi Tuan,

The record is exported from Membership Pro and then re-imported.

The export is comma separated Field values (not ID's).

I suspect the issue is the same with the State select box as well..

This effectively means the import and export features are not compatible?

Its easy to replicate. Just make a checkbox group in a custom field and add values then create and export a membership with some of those fields selected.

You will see the missing ones once imported.

Thanks mate

Yes. For checkboxes, I think we have issue. I will see if I can address it. For state, I don't think we have any issue with it as the data for state field just be stored as normal string, not json

Tuan

Hi Tuan,

I investigated further. You are right - State is working - the initial copied record was not set !)

However, In a users subscription, a checkbox custom field, does not show selected checkboxes, even when I select them and save the record manually.. - the template/checkbox code, is not working properly..

So import AND display are not quite right.

Thanks!
Pete

Hi Tuan,
Did you manage to fix this ?

If not, what is the json format I need to use to make the checkboxes work? I have lots of imports to do in the next couple of days..

Thanks,
Pete

Hi Pete

I haven't had a chance to look at it yet. The format the data need to be in the below format for checkboxes:

["option1","option2"]

Tuan