How to serialize an array in CSV for import

Hi everyone,

I have a very hefty CSV file that I need to import users from. I’ve done this successfully on a previous install of s2member, but this time one of my custom fields is a multi select checkbox.

The CSV is 3000 lines, but I’ll be splitting that for import. My custom field value field is currently looking like this:

“Greater Manchester, Merseyside, Lancashire”

Each term, ie. Greater Manchester, refers to one of the values of the checkboxes. How do I import this file so that the relevant checkboxes are checked? I understand I need to serialize the array but I’m unsure how/when to do this.

Kimberley,

The best way to figure that out is to simply create a user with the Custom Fields configured the way you want and then run an export and copy the serialized array from that user’s row.