Custom Import Issue

I’m trying to convert an existing DAP membership system to S2 for my client. They already have a separate table in the database that has a registration and an expiration date tied to their WP_user table. Is there a way to run a db query to update the expiration date for these users without having to export using S2 and then manually try to merge two different files?

Thank you for your inquiry.

I’m trying to convert an existing DAP membership system to S2 for my client. They already have a separate table in the database that has a registration and an expiration date tied to their WP_user table. Is there a way to run a db query to update the expiration date for these users without having to export using S2 and then manually try to merge two different files?

You can do that like this:

<?php
update_user_option ($user_id, 's2member_auto_eot_time', $eot);

Hi Bruce,

Can you give me a little more detail?

This is the documentation for the function Bruce used in his example: http://codex.wordpress.org/Function_Reference/update_user_option

Also, did you see this article? Knowledge Base » How to Migrate to s2Member Pro from Other Software

Thanks Christian,

For some reason I had trouble with the function but was able to create my own function to do the massive update. My only problem now is that it doesn’t appear that even with an EOT, that the cron job is changing the status from Level 1 to Level 0 for expired users.

So the users have an s2Member Level 1 (s2member_level1) role and an EOT time in the past, but the EOT behavior is not happening?

Could you verify in the user’s profile what role he has and if the EOT time looks okay?

If that doesn’t help, could you submit your site’s info so I take a look? Please leave a reply here after you send it. Thanks! s2Member® » Private Contact Form

Hi Cristian,
Yes, the EOT looks fine and was even updated to proper formatting after the import. For a given member they show s2member_level1 and an EOT in the past. If the user logs in, they have access to restricted content. I’ll create an admin access for you and send the information in the private forum.

Thanks, I looked at the user and even made the EOT time into 2010-01-01 and so far he hasn’t been demoted. Let’s give it a bit more time (sometimes wp-cron doesn’t happen immediately).

But I’m suspecting that maybe something in your installation is affecting the way wp-cron works. I’d try these: Knowledge Base » Common Troubleshooting Tips

You can also try your own cron job. [hilite path]Dashboard -› s2Member® -› PayPal® Options -› Automatic EOT Behavior -> Enable[/hilite]

Perhaps the cron job is taking a long time to complete? Does it only do a few records at a time?

Did you import a lot of members with EOT times already expired? If so, it may be that they are being demoted little by little to avoid timeouts. But if you already needs a demotion, I’d simply import him at Level 0 instead of an expired Level 1.