About: Tom Tolkien

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’ve now spent 48 hours – wasted – trying to use this plugin to import 400 members into a website. So far I’ve had to transcode a standard CSV file to your unique CSV format, alter the site login system to avoid conflicts and now the plugin won’t export so I can see the sequence of fields. Since every field has to be in perfect sequence to import via your import system, this renders it impossible to import from a CSV. Other CSV export plugins won’t see the S2 custom fields. Please can you get back to me with a fix or I’ll have no option but to ask for a refund. For a premium plugin this is too much like working on a beta.