[plugin] User History Report

3rd party code for phpList

[plugin] User History Report

Postby duncanc » 10:15pm, Wed 28 Jul, 2010

This plug-in shows user history records from the user_history table. The core phplist shows user history for each individual user but not an aggregated view. This is useful to see, for example, recent subscribers. The plugin can show:
  • all records in reverse chronological order, i.e. most recent first
  • records from a specified date in chronological order
  • records whose summary or detail field contains a specified string or regular expression, e.g. Subscription
ScreenShot006.gif
ScreenShot006.gif (11.04 KiB) Viewed 10377 times

Install
See this topic for the plugin files that need to be downloaded and installation instructions http://forums.phplist.com/viewtopic.php?f=7&t=37421

The inital view is user history entries in reverse chronological order.
Enter a "since" date in the format yyyy-mm-dd, e.g 2010-07-01 and all user history entries since that date will be displayed in chronological order.
Enter a pattern or regular expression and all user history records with a matching summary are displayed.
The user email address is a link to the user record.

Developed on php version 5.2.13, phplist version 2.10.17 and uses object-oriented code that does not work with earlier php versions, particularly 4.x.x.

2012-12-10 - this plugin has been combined with the User Details and User Subscriptions plugins into a single plugin, Users Plugin.

2012-02-29 - now searches detail as well as summary of an event. Can download results as a CSV file.
Last edited by duncanc on 6:14pm, Sat 30 Oct, 2010, edited 2 times in total.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby reedededge » 3:54pm, Thu 29 Jul, 2010

installed and serves our purposes beautifully thanks DuncanC!
reedededge
phpLister
 
Posts: 9
Joined: 9:25pm, Mon 26 Jul, 2010

Re: [plugin] User History Report

Postby duncanc » 10:14pm, Fri 04 Feb, 2011

I have updated the plugin to be able to search for a string in the Summary field. See the original post to download it.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby duncanc » 9:01pm, Tue 12 Jul, 2011

A new version of the plugin is attached to the first post of this topic. This version uses the latest version of the Pager class, which reduces the vertical space used for the search fields.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby duncanc » 7:50am, Wed 07 Sep, 2011

A new version of the User History Report plugin is attached to the first post of this topic. This version has some internal changes to be compatible with the latest CommonPlugin.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby duncanc » 7:03pm, Fri 11 Nov, 2011

A new version of the User History Report plugin is attached to the first post of this topic. This version includes
  • translation into French
  • help text
  • some internal changes to be compatible with the latest CommonPlugin
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby RonFred » 6:03am, Sat 17 Dec, 2011

Hi DuncanC

This is a fantastic plugin - and works well with your user history plugin [same CommonPlugin code directory for both too] on 2.10.17. Thank you, happy holidays and New Year for 2012.

Ron Fredericks
Co-founder LectureMaker LLC, and video producer.
RonFred
phpLister
 
Posts: 14
Joined: 7:23pm, Thu 27 Apr, 2006
Location: Sunnyvale, CA USA

Re: [plugin] User History Report

Postby duncanc » 10:18am, Sat 17 Dec, 2011

Thanks for the feedback!
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby duncanc » 5:49pm, Thu 02 Feb, 2012

A new release of the plugin to be compatible with the latest CommonPlugin. See the first post of this topic for how to download.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby duncanc » 7:49pm, Wed 29 Feb, 2012

A new release of the plugin with these enhancements:
  • now searches the event detail as well as the summary for the text string/regular expression
  • can download the results as a CSV file
  • better handling of mysql rejecting a regular expression
See the first post of this topic for how to download.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby duncanc » 11:02am, Thu 22 Mar, 2012

There is a new release of the plugin to work with the latest CommonPlugin, both version 20120322. The CommonPlugin now provides buttons to display phpinfo results and display the config.php file.
See the first post of this topic for how to download and install.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby duncanc » 11:16am, Tue 28 Aug, 2012

A new release of the plugin that includes French translation in UTF-8 format as well as the default ISO-8859-1. So, if you have modified the French language_info file to use UTF-8 then the plugin's captions should now be displayed correctly. This requires the latest (20120828) CommonPlugin to be installed.

Thanks to Julien Lusson for the translations.

See the first post of this topic for how to download and install.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby duncanc » 3:15pm, Thu 31 Jan, 2013

A new release of the plugin that fixes a problem with the download button introduced when I merged the three User plugins. The button always downloaded the user details, even when on the history tab or the subscriptions tab.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] User History Report

Postby Pewit » 1:14pm, Tue 05 Feb, 2013

Is it also possible to change the display on the History tab in the Users Plugin?

I would like to see the date they last received a message as well as the list it was sent to.
Pewit
phpLister
 
Posts: 13
Joined: 5:51pm, Sat 11 Mar, 2006


Return to Contributions: Plug-ins, Add-ons, Mods

Who is online

Users browsing this forum: No registered users and 2 guests

cron