Cannot import using CSV or pasted data

I’m trying to import a site membership as a CSV file, or pasting it into the import box, using precisely the description provided on that page. (page=ws-plugin–s2member-pro-import-export)

The fields match the description given – ie:
“ID”,”Username”,”Password”,”First Name”,”Last Name”,”Display Name”,”Email”

and I’ve also included all of the custom field from S2, using the field IDs, in exactly the same order as follows:
“id”,”username”,”password”,”First Name”,”Last Name”,”Display Name”,”Email”,”Name”,”address”,”address1″,”city”,”county”,”postcode”,”phone”,”fax”,”size”,”type”,”marketing_budget”,”num_roll”,”notes”,”logo”,”add_date”,”subscription_paid”,”subscription_rate”,”assign_mentor”,”contact_name”,”contact_surname”,”job_title”,”contact_responsibilities”,”contact_responsibilities_other”,”contact_salary”,”contact_part_full”,”contact_phone”,”contact_school_phone”,”contact_association”,”contact_qualification”,”contact_email”,”date_joined”,”association_orig”,”type_orig”,”twitter”,”school_website”,”school_flickr”,”attended”,”newsletter-optin”

All the data is correctly formatted and exported to CSV using Open Office and double quotes.

When importing, the fields import correctly up to “Email”, and after that, they don’t import properly, if at all.

I’m guessing that there’s an omission in the instructions, and the other default WordPress fields need to be included (and blanked in the data if required) after “Email”.

Please can you detail a precise procedure, including a complete list of required fields, which will work.

Thanks.

I’ve found the ‘guide’ from another post.

A few points –
1
Open office, or any other spreadsheet, WILL NOT output “” (double quotes) for no-value cells with numeric fields. So, you need to make the entire sheet “text” before outputting to CSV in order to meet the S2 format – otherwise it all falls apart.
2
From your guide here: http://www.s2member.com/kb/how-to-migrate-to-s2member-pro-from-other-software/#step2

“ID”,”Username”,”Password”,”First Name”,”Last Name”,”Display Name”,”Email”,”Website”,”Level[0-9]+ or Role ID”,”Custom Capabilities”,”Registration Date ( mm/dd/yyyy )”,”First Payment Date ( mm/dd/yyyy )”,”Last Payment Date ( mm/dd/yyyy )”,”Auto-EOT Date ( mm/dd/yyyy )”,”Custom Value ( starts w/domain )”,”Paid Subscr. ID”,”Paid Subscr. Gateway”,”Custom Field ID #1″,”Custom Field Value #1″,”Custom Field ID #2″,”Custom Field Value #2″, …

What do you mean by this – “Custom Field ID #1″,”Custom Field Value #1″,”Custom Field ID #2″,”Custom Field Value #2” – it doesn’t make sense. Can you provide an example?

Does it mean I have to insert the field ID, as well as the value, into the spreadsheet data?!

I’m guessing that there’s an omission in the instructions, and the other default WordPress fields need to be included (and blanked in the data if required) after “Email”.

Maybe because it’s not a valid email address? Could you try “test@test.com”? Same for the other fields that expect a certain format, try to use it, e.g. dates. The row you copied from the documentation describes what goes in each value, not necessarily an example of the value.

What do you mean by this – “Custom Field ID #1″,”Custom Field Value #1″,”Custom Field ID #2″,”Custom Field Value #2″ – it doesn’t make sense. Can you provide an example?

It’s talking about the s2Member custom profile fields from [hilite path]Dashboard -› s2Member® -› General Options -› Registration/Profile Fields[/hilite].

So, if you you have a field named “favoritecolor”, then in the CSV you’d have that (the field’s name) and its value: [hilite mono],"favoritecolor","red"[/hilite]. The pairs thing is only for the custom profile fields.

We’re changing this format in the new s2Member, but for now it’s like that in the current one.