Thomas S

I’m going to close this thread as there hasn’t been any feedback to my questions.

If you need more help, please either create a new topic, or respond to this one!

Hi,

Thank you for downloading and trying to use my plugin!

The file can be found in the plugins/pmpro-import-members-from-csv/examples directory on your WordPress server. It’s called import.csv

There’s apparently a bug in how the plugin generates the link to the example import.csv file, sorry!

Thank you for the input.

The ['cm_search_clause'] clause is added by a 3rd party plugin to support both ordering by metadata _and_ searching for a list of meta key/values.

The missing .post_title search may have been me being a little aggressive in editing the copy/paste (don’t recall whether i did or not, but the clause is included in every test I’ve done for the past 2-3 weeks, so…)

Wound up using the posts_request filter to move the parenthesis.

Agreed it’s potentially flakey, but I can’t get the query parser to change behavior… As long as I need both clause in the meta_query section to orderby a configurable/custom meta value _and_ I need to search in multiple meta_keys for a value _and_ I need to include the taxonomies as a limiter, this I’ve been unable to change the placement of the parenthesis.

• This reply was modified 5 years, 6 months ago by Thomas S. Reason: Marking as solved

Hi,

At my initial pass, I can’t see anything explicitly incorrect in the CSV file so I’ll need to investigate this further.

Hi Sam,

From the stack trace, it seems as if there may be an unexpected interaction with the PMPro Approvals add-on…

What options on the Import settings page do you have active when attempting to upload/import the .csv file?

• This reply was modified 5 years, 6 months ago by Thomas S. Reason: Added email notification

It may depend on what you had as the membership_startdate value for the import…

Would you be able to share a pastebin of an example .CSV file import file entry with the header intact?

There isn’t a paid version of Paid Memberships Pro.

There’s a “access to support as well as access to one-click updates for the add-ons” option available. That’s what you pay for when you sign up on their site.

PMPro and its add-ons are 100% GPLv2.

As a result, all of the source code is available for download from github.com (including as .zip archives that could be used to install using the WordPress Plugin upload feature).

Hi,

I’m not quite sure what you’re asking for here, sorry… ??

Are you asking if it’s possible to apply multiple discount codes to a membership level cost (serially)?

Or are you using custom code to calculate the discounted prices and there’s a problem with the result you’re seeing?

If you have an account that purchases a group package that allows sponsored members, what happens if they downgrade their account to less members? What happens if they upgrade to more members?

According to the sources of the Sponsored Members add-on, the excess sponsored accounts may be deactivated and the confirmation message for the sponsor will contain the following text:

Your current membership has fewer seats than you had sponsored accounts. The accounts have been deactivated. You must have your sponsored accounts checkout again using your code

Thanks! ??

Found the issue and pushed the update for the plugin.

V5.4, available now, should include the fix.

Hi @jaco44,

Thank you for the feedback.

My apologies for not seeing this until now (forgot to subscribe to the support threads!), but I’ll take a look at your issue ASAP.

Hi Jennifer.

Thank you for the feedback!

Would you mind (in the support area) sharing some context around glitches you’ve found so I can isolate and fix them?

Hi,

Thank you for reporting this issue and for your patience(!).

You may have discovered that the correct column to use in order to update the “Joined” date is the user_registered column.

For legacy reasons – to indicate when the user first joined the site, not when they signed up for the current membership level – Jason is using the WordPress user registration date/time and not the membership_startdate date/time in the PMPro Members List.

My plugin does attempt to update the user_registered date if it finds a value in the user_registered column (using a valid date format of YYYY-MM-DD HH:MM:SS).

Hi,

Thank you for reporting this issue!

I’m working on an update for the add-on so there is a new release in the pipeline (though not certain of the ETA at the moment, sorry).

However, the plugin uses the pmpro_changeMembershipLevel() function, which triggers the pmpro_after_change_membership_level action, This, in turn, results in triggering the pmpromc_pmpro_after_change_membership_level() handler in the PMPro MailChimp Add-on.

So, _if_ the plugin finds valid membership info in the import record, there isn’t a reason for the user to not get added to the mailchimp list (other than a fundamental change in how PMPro & the PMPro MailChimp add-on behaves, or a bug/fatal error in custom code that also uses the pmpro_after_change_membership_level action).

A feature in PMPro that behaves similarly is when you edit a User Profile and change their Membership Level from “None” to a valid (with a MC list linked) membership (So you can add a new – clean, never before seen – user to a membership, which should trigger the action chain above and let you see if this is an Import plugin issue, or something else.

Hope this helps!