Cannot Import Members

[nwebster]

I'm trying to import members using the Pro version of s2Member.

Here's my steps so far:

- I made the csv, imported, didn't work.
- Then I tried the import text with comma separation, that worked ok but didn't bring custom fields over.
- Then I went in and tried to modify just a record so I could export the members and see how the csv file was configured, but then I got this error:

Code: Select all

Catchable fatal error: Object of class __PHP_Incomplete_Class could not be converted to string in /home/ypci/public_html/wp-includes/functions.php on line 1526.

Line 1526 in my functions file is:

Code: Select all

$array[$k] = addslashes( $v );

Any idea what's happening here? I've really got to get these members imported in ASAP!

[Cristián Lávaque]

- I made the csv, imported, didn't work.

Could you post here the first 3 rows of your CSV file? x'ing out any private information.

- Then I tried the import text with comma separation, that worked ok but didn't bring custom fields over.

Could you post here what you imported that didn't add the custom fields?

- Then I went in and tried to modify just a record so I could export the members and see how the csv file was configured, but then I got this error

Where did you try to modify the record? You mean edit an existing user's profile before export?

[nwebster]

CSV import:
http://xxxx.net/troubleshooting/xxxxxx.csv


Comma separation:
"","nwebster","","Nxxxxx","Wxxxx","Nxxxxx Wxxxx","xxxxxxxxx@gmail.com","","1","","","08/01/2010","08/01/2010","08/01/2011","08/01/2011","","","authnet","101 West St","Suite 111","Indianapolis","IN","12345","317-4xx-xxxx","317-4xx-xxxx","BlackWhite","Interactive Producer","Marketing","","317-4xx-xxxx"


Modify record:
I went to s2Member < Browse Members and clicked on a username. Then in that user's profile I added in info into all the custom fields. When I saved the edits, that's when I got the PHP errors.

[Cristián Lávaque]

Thanks!

OK, the CSV file gave me an error on import until I removed the column headers and left only the row to be imported. I'd suggest double-quoting the values to avoid any problems with a value that has a comma in it.

Custom fields weren't imported because of the format you used. You had a column per field, but that's now how s2Member imports them in the current version, instead it uses ID-value pairs as shown in the documentation:

Additional extended information can also be included; even Custom Fields:
"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", ...

Also, remember the custom fields need to exist before you can import data to them. WP Admin -> s2Member -> General Options -> Custom Registration Fields/Options -> Add New Field

If you're still getting the error when trying to save the profile edits, try disabling other plugins to see if the resolves the problem, then you'll know what's causing it and do something to solve it.

[nwebster]

Do I need to add double quotes in the CSV file too? Or are the double quotes only for pasting in direct input?

[Cristián Lávaque]

It is better to use them in the CSV file as well. I believe Excel or OOMath have a setting to double-quote the values for you.

[nwebster]

I'm getting members to import in now, thank you for your help with that.

My questions now pertain to 1) the Member Profile and 2) the Cancel Membership options.

1) When a user logs into their Member Profile they see their basic user info, which is great. But can we add to this in any way? Like can we add the date their membership expires? Then add a link to extend it?

2) I've made a 2 column format on the Membership Profile page that a user sees once they login. There's a side bar that details benefits of the membership and also has a cancellation option. I imported a user and tried to cancel that account... and it says "Nothing to cancel. You're NOT a paid Member." What's going on with that? When importing I was sure to set Role, Registration Date, First Payment Date, Last Payment Date, and Paid Subscr. Gateway. It's not an Auto-EOT type of membership so that wasn't added.

[Cristián Lávaque]

1) You could edit the template to show it. This thread may help viewtopic.php?f=4&t=10385

Just keep in mind that the EOT time is only set with Buy Now transactions or when a subscription is ended in some way, or if you set it manually. If the subscription is ongoing, then his EOT will be left blank as long as the subscription continues (because it's not yet known when it ends).

2) Did you add an existing paid subscriber ID for the gateway? The cancellation would happen on the gateway, but if you're not telling it what to cancel, it won't work. Where did you get the error message?