|Posted: Sunday Mar 24th, 2013 at 4:52 pm #45599|
I’ve got a paid copy of s2member pro, and I’m really, really struggling with mass importation of users via the Import/Export functions.
I’ve read the page s2Member® | Import (or Mass Update) Users in some detail, and have spent the last 5 hours trying to import a CSV exported from an Excel spreadsheet without success. I’m using custom fields because the s2member database will become the main member database (it’s currently in Zoho which is dire). I’ve looked at the CSV exported from s2member, and have tried to edit my spreadsheet accordingly. I’ve copied the CSVs below as I can’t attach them to this post.
When I try to import a CSV with custom fields the same name as the fields defined in s2member, all that comes over is the user’s name and email – all the custom fields are blank. So, do the custom fields need to be specified in a particular order? Would it be simpler to write and run a SQL UPDATE query, and if so what form should it be? What is going wrong?
I’ve spent at least 50 hours on s2member already, a long time for a plugin which I’d expected to save me time, and in which time I could have designed and implemented my own membership database. Because I’ve spent so much time on it, which would be lost forever if I ditched s2member, and because I’ve coughed up, I’ll have to fight to get the thing working as it should. I can see that it’s a great plugin if you’re starting a site from scratch, but my organisation (www.eurocall-languages.org) has some 300 paid-up members already and I really, really need to import their details into s2member else I’ll have to manually create all these records one-by-one, which thought makes me want to jump off a building.
TIA for any advice/sympathy/solidarity.
Test CSV to import to s2member:
- s2Member® Products