Replacement for AMR users plugin - display and export all User info

#1

It took me two years to realize amr-users was no longer being supported (RIP Anmari).

It just worked. I could identify new members, renewing members, and search for special fields we set up for their interests. I viewed the file daily and exported it weekly to feed a google sheet that other club members used.

What do other people do to keep track of their users?
I exported my entire s2 database - all 232 columns, plus added a columns to convert datetimes into readable formats.
Then I run a macro to pull in the columns I want, in order, and save THAT file.
It works, but I miss being able to just look at who’s joined or renewed recently.
WP’s User screen shows me EOT, but not last payment info.

Suggestions?

Yes, I tried s2member-list, but I can only get the first few fields. I can’t figure out the exact syntax to pull fields other than the exact ones in the examples.
I don’t see a way to display each user on one row, or export the info.
-Sue

#2

TBH this sounds like something you would have to code up yourself or have someone do it for you. I’ve written my own code to display my members within my own /wp-admin/users.php screen. My admin area shows Last Login Time, Register Date and Last Seen; as well as some other bits of data like name and membership type.

It’s doable…

#3

What data did you find missing/needed on that page? I’m curious.

s2Member list can show a lot of information, but for some things it may need customization.

The fields you can show, are the ones you’d get from get_user_field.

show_fields Optional, defaults to "" (an empty string, i.e., no fields). This is one of the most useful shortcode attributes. You can build a list of fields for each user. For instance, if you have Custom Registration/Profile Fields configured with s2Member you can provide a comma-delimited list of unique Field IDs here. If the user has a value for that field it will be displayed in the final output. e.g., show_fields="user_login,user_registered,custom_field_id" . The list of field IDs can include anything compatible with s2Member’s get_user_field() function.

s2Member-List doesn’t export, you’d use the advanced Pro users exporter for that (not the basic one). The info is all there, but some of it will be as serialized arrays, and most times as unix timestamps.

:slight_smile:

#4

To my astonishment I’ve never ever used this, opting instead for the /wp-admin/users.php screen and having a bookmark with the users in decreasing order by last login.

But of the top of my head I could imagine making sure S2member includes a variety of sortable columns would be useful.

add_filter('manage_users_sortable_columns', 'add_user_sortable_column_registered' );

To include “Registration time”, “Last login time”, “Last Seen”, “Last Payment time” and/or “User EOT”.

Having an option to cache the data used to display the EOT would be useful, with a user defined length of time the data is cached. That would make displaying that data more manageable.

Is that sort of what you mean?

1 Like
#5

Thaks for the comments.

Here’s all the info I found on the amr plugins - standard and +s2 fields version:
WP Users screen has no payment fields.
I bought amr-users including the s2 fields options early on, to add that, plus other s2 fields.

See this post: Legacy Support for anmari users


There is a link to the security hole that caused WP to flag the plugin as unsafe and a GitHub archive of the amr-users code.

This is what I used this plugin to do:
I set up the fields I wanted, including date display formats, and designed the report(s) I wanted. amr also handled fields that allowed multiple selections/entries

I exported my main report to CSV weekly, and imported the file into an existing Google sheet that calculated # of current members of each type and membership stats by year (new/renewed/canceled, etc.)

Example of the main report’s fields:
Id User name First name Last name Email Expiry Date (EOT) Wp S2m Last Payment Time User Registered First Role Comments (user) Wp S2m Notes Admin Comments
plus a bunch of other profile fields

I just bought the Payments Log plugin; maybe this will solve some of the above issues.
-Sue

#6

I’m not sure if the Payments Log does all you need, but it’s not bad to have. I’d be interested in your feedback about it, so I can look at what things I could improve there. Let me know when you’ve had a chance to use it for a bit.

:slight_smile: