• Resolved Flexer

    (@flexer)


    Hello Thomas,

    Was alerted to your plugin by the folks at PMPro;
    I am trying to Approve a new member at time of import;
    The level requires approval with add-on https://www.paidmembershipspro.com/add-ons/approval-process-membership/

    I see that in the DB the value is in wp_DB_usermeta > meta_key pmpro_approval_1 > When approved the meta_value gets updated (see below)

    Do you think there is a way to update this meta-Value to approve the Member on upload?

    meta_value:
    s:6:”status”;s:8:”approved”;
    s:9:”timestamp”;i:1537887743;
    s:3:”who”;i:2;
    s:8:”approver”;
    s:6:”xxxxxx”;

    When Pending
    meta_value:
    s:6:”status”;s:7:”pending”;
    s:9:”timestamp”;i:1537889357;
    s:3:”who”;
    s:0:””;
    s:8:”approver”;
    s:0:””;

    Thanks
    Daveed

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Thomas S

    (@eighty20results)

    Hi Daveed,

    It should be possible to import an approval record to the wp_usermeta table with this plugin.

    You _would_ need to JSON encode (serialize) the data to use in the import .CSV file though.

    I’ve personally done this for a client using a spreadsheet (Apple Numbers) and a few formulas, but it can be a bit time consuming to generate the right set of spreadsheet formulas. Then you have to copy the result – by value – to a different cell column before the export operation again.

    If you’re not comfortable with this, feel free to reach out to myself or anybody else who’s familiar with how to manually serialize data and importing it (you may have to pay for that service).

    Otherwise there are a few different websites “out there” that serializes PHP data for you, but obviously there are limits to how effective that will be if you have hundreds of users to import.

    • This reply was modified 6 years, 2 months ago by Thomas S. Reason: Updated with the link I forgot!
    Thread Starter Flexer

    (@flexer)

    Hi Thomas,

    Thank you for giving me some direction;

    I’ll play around with this a bit and see if I can this done;
    Otherwise I’ll reach out;

    Best
    Daveed

    Plugin Author Thomas S

    (@eighty20results)

    No problem.

    I’ll close this topic as resolved, but please feel free to open a new topic as needed!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Approval Process for Membership Add On’ is closed to new replies.