[plugin] Display message open statistics

3rd party code for phpList

Re: [plugin] Display message open statistics

Postby yogesh » 12:56pm, Mon 06 Sep, 2010

hello duncanc,

i have commented following lines in openstats.php to disable the Pager.php requriement and now I'm able to view the stats for all the mailers successfully.

Till the Pager.php compatibility with my php ver. 4 is resolved, I will use this modified version of your plugins.

Once again Thanks You for the plugin.
=================
in openstats.php following changes have been made.

line 2 :
// require_once dirname(__FILE__).'/Pager.php';

line 21 and 22:
$ls = new WebblerListing("msg");
// $ls = new Pager("msg");

line 85 and 86 :
$ul = new WebblerListing('email');
// $ul = new Pager('email', 'viewed');

line 106 and 107:
$ul3 = new WebblerListing('users');
// $ul3 = new Pager('users', 'notviewed');
Last edited by yogesh on 1:17pm, Mon 06 Sep, 2010, edited 1 time in total.
yogesh
phpLister
 
Posts: 9
Joined: 12:26pm, Mon 30 Aug, 2010

Re: [plugin] Display message open statistics

Postby duncanc » 12:59pm, Mon 06 Sep, 2010

You might have misunderstood my last post. I have made some further changes to be compatible with php4. The changes work with php5 but I was pointing out that I could not test them with php4.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] Display message open statistics

Postby jlpinheiro » 4:41pm, Fri 29 Oct, 2010

I really think that this should be a nice addon, very usefull.
However... I install it, I got the drop down working fine.
But,... It allways show every mensage as not read by all users, allways regardless.
I look and look into the source, but I really do not know enough PHP to fix it.

Can anyone please give a pointer or some help?
I do want this AddOn working, it looks to be able to do something that I belive it is very important for my analisys of the newsletters I send.

Do I need to put some marker in the sent emails?

It allways looks like the image bellow
Image
those are some test emails I am using while checking all the functions I need to implemente prior to real use.
To have knowledge over who see the messages or not, percentages, etc... Allows to tune the system to avoid sending useless emails.
It allways says the messages are not read, allways.

And having that info is important for me.

Thank you.
jlpinheiro
phpLister
 
Posts: 13
Joined: 3:38pm, Tue 26 Oct, 2010

Re: [plugin] Display message open statistics

Postby duncanc » 7:29pm, Fri 29 Oct, 2010

You need to include the placeholder [USERTRACK] in the message in order to generate statistics.

See http://docs.phplist.com/MessageTracking
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] Display message open statistics

Postby jlpinheiro » 11:09am, Thu 04 Nov, 2010

Thank you very much
Works almost perfectly :)
It did not consider a nonexistent email as bounce. Can it be solved?

I have just one more question regarding this AddOn.
How will it behave if I send a message for 2.000 users?
Will it try to display all the emails at once? Or will it split them in pages of 50 or 100 each?
Because if it tries to display all at once, it will be a really lonnnnngggggggggggg page.
jlpinheiro
phpLister
 
Posts: 13
Joined: 3:38pm, Tue 26 Oct, 2010

Re: [plugin] Display message open statistics

Postby duncanc » 7:40pm, Thu 04 Nov, 2010

I'm not sure which version of the plugin you are using but my modified version from this post viewtopic.php?f=7&t=748&start=60#p78805 lets you page through the results.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] Display message open statistics

Postby jlpinheiro » 9:26am, Tue 09 Nov, 2010

It did not consider a nonexistent email as bounce. Can it be solved?

This is the last doubt I have.
jlpinheiro
phpLister
 
Posts: 13
Joined: 3:38pm, Tue 26 Oct, 2010

Re: [plugin] Display message open statistics

Postby duncanc » 9:44pm, Tue 09 Nov, 2010

jlpinheiro wrote:
It did not consider a nonexistent email as bounce. Can it be solved?

This is the last doubt I have.

That isn't related to the plugin. Have you followed the instructions on configuring bounces here http://docs.phplist.com/Documentation
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] Display message open statistics

Postby Craxx » 11:43am, Mon 06 Dec, 2010

Hy duncanc,

i have same problem like yogesh .... Your script (viewtopic.php?f=7&t=748&start=60#p78805) doesn´t work, the old one (from dragonrider viewtopic.php?f=7&t=748&p=72153#p71438) does....

Please could you make an update to get it working.

best regards
Craxx;)
Craxx
PL Nut
 
Posts: 20
Joined: 7:11pm, Fri 26 Nov, 2010

Re: [plugin] Display message open statistics

Postby duncanc » 12:09pm, Mon 06 Dec, 2010

It works for me!

You'll need to be a bit clearer about what doesn't work, and which versions of phplist and php you are using.
My config is php 5.2.13 and phplist 2.10.12.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] Display message open statistics

Postby Craxx » 12:44pm, Mon 06 Dec, 2010

Hy duncanc,

i forgot so set the php to 5!!!
Now i use php version 5.2.14 and phplist 2.10.12

Now it works, but i get this error:

Database error 1064 while doing query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND um.viewed IS NOT NULL' at line 3
Database error 1064 while doing query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND um.viewed IS NOT NULL order by um.viewed LIMIT 0, 0' at line 5

The MySQL-Version: 5.0.91

Perhaps, because i deleted all messages that i send?

best regards
Craxx;)
Craxx
PL Nut
 
Posts: 20
Joined: 7:11pm, Fri 26 Nov, 2010

Re: [plugin] Display message open statistics

Postby duncanc » 2:04pm, Mon 06 Dec, 2010

I thought that it handled the case of there being no messages to display, but doesn't!

Will fix it later today and upload the new version.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] Display message open statistics

Postby Craxx » 5:28pm, Mon 06 Dec, 2010

THX that would be nice:)

With news in database it works;)

best regards
Craxx;)
Craxx
PL Nut
 
Posts: 20
Joined: 7:11pm, Fri 26 Nov, 2010

Re: [plugin] Display message open statistics

Postby duncanc » 9:52pm, Mon 06 Dec, 2010

I have updated my original post with a new attachment that should fix the problem when there are no 'sent' messages to view.
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: [plugin] Display message open statistics

Postby Craxx » 5:16pm, Tue 07 Dec, 2010

THX i have updatet new version, but now i have messages inside so i can´t test. Did you change more that the 0 error?

best regards
Craxx;)
Craxx
PL Nut
 
Posts: 20
Joined: 7:11pm, Fri 26 Nov, 2010

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 2 guests