WordPress.org

1. dmokaren
   Member
   Posted 4 months ago #
   

   Am trying to work thru your scripts and associated dbs to work out a solution for importing existing or offline memberships into PMPRO. I've exported data from wp-usermeta to see some of the sandbox transactions I've done. In some of the earlier user data, I see unfilled fields for
   pmpro_bfirstname, pmpro_blastname, pmpro_baddress1, pmpro_baddress2. pmpro_bcity, pmpro_bstate, pmpro_bzipcode, pmpro_bcountry, pmpro_bphone
   pmpro_bemail, pmpro_CardType, pmpro_AccountNumber, pmpro_ExpirationMonth, and
   pmpro_Expir

   In the later transactions, these are not listed. (If one goes in and adds the userdata into the db fields, the info shows up in the Member Report) But what I'm asking is: where might I have screwed up for these fields to have 'disappeared' in the newer transactions. I have restored a fresh checkout.php

   http://wordpress.org/extend/plugins/paid-memberships-pro/

2. strangerstudios
   Member
   Plugin Author
   Posted 4 months ago #
   

   Some tips here RE importing:
   http://www.paidmembershipspro.com/2012/06/how-to-mass-import-members-into-wordpresspmpro/

   Those fields would be empty for users who didn't pay for their membership... i.e. free membership levels or manually created members.

   Those fields aren't too critical. They are only used to prepopulate the checkout field when users checkout again. The real billing information is stored in the orders table.

   I'd be able to give you more support at http://www.paidmembershipspro.com

3. dmokaren
   Member
   Posted 3 months ago #
   

   Still messing with import of member dat. Looking at memberlist-csv, I see this, which tells me that data is NOT stored in the orders table, but actually in usermeta, users AND orders table.....

   $theusers = $wpdb->get_results($sqlQuery);
   	$csvoutput = "id,username,firstname,lastname,email,billing firstname,billing lastname,address1,address2,city,state,zipcode,country,phone,membership,initial payment,fee,term,joined,expires";
   
   	//these are the meta_keys for the fields (arrays are object, property. so e.g. $theuser->ID)
   	$default_columns = array(
   		array("theuser", "ID"),
   		array("theuser", "user_login"),
   		array("metavalues", "first_name"),
   		array("metavalues", "last_name"),
   		array("theuser", "user_email"),
   		array("metavalues", "pmpro_bfirstname"),
   		array("metavalues", "pmpro_blastname"),
   		array("metavalues", "pmpro_baddress1"),
   		array("metavalues", "pmpro_baddress2"),
   		array("metavalues", "pmpro_bcity"),
   		array("metavalues", "pmpro_bzipcode"),
   		array("metavalues", "pmpro_bzipcode"),
   		array("metavalues", "pmpro_bcountry"),
   		array("metavalues", "pmpro_bphone"),
   		array("theuser", "membership"),
   		array("theuser", "initial_payment"),
   		array("theuser", "billing_amount"),
   		array("theuser", "cycle_period")
   		//joindate and enddate are handled specifically below
   	);

   [Please post code or markup snippets between backticks or use the code button. Your posted code may now have been permanently damaged by the forum's parser.]

4. dmokaren
   Member
   Posted 3 months ago #
   

   er... sorry about posting the code without backticks....

Reply

You must log in to post.