User Tools

Site Tools


system:convertstats

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

system:convertstats [2013/08/19 21:01]
phplist created
system:convertstats [2013/08/19 21:02] (current)
phplist
Line 1: Line 1:
 +===== Convert statistics ======
 +
 +==== introduction ====
 +
 +Version 2.11, and now 3.0 introduced a new way to track click statistics. Therefore when you had clicktracking enabled in version 2.10 you will need to convert it.
 +
 +==== converting ====
 +
 +In the main admin page, select "​Statistics overview"​. If you have data in the old statistics table it will tell you and you can choose to convert it. This will convert a small amount at a time, and you may need to run it several times to convert all data.
 +
 +Alternatively,​ if you have a lot of data, you can run it from the commandline:​
 +
 +<​code>​
 +
 +php /​path/​to/​admin/​index.php -c /​path/​to/​config.php -pconvertstats
 +</​code>​
 +
 +This will convert more entries at a time, and you may need to run it several times as well.
 +
 +==== issues ====
 +
 +=== large conversion ===
 +
 +When there are many entries, it may take quite some time. I recently converted a system with 7 million click track entries, and it took about 20 hours. In that case **you will want to run in on commandline**.
 +
 +The following code may come in handy. 7 Million is 140 runs of 50000 (which is the amount phpList will convert on commandline).
 +
 +<​code>​
 +C=0; while [ $C -lt 140 ]; do 
 +  C=$(( $C + 1 )); 
 +  echo $C; 
 +  echo $(date); ​
 +  php lists/​admin/​index.php -c /​var/​www/​phplist/​lists/​config/​config.php -pconvertstats; ​
 +  done
 +>> convertstats.log &
 +</​code>​
 +
 +Don't forget the last &, and you can go off do something else and come back 20 hours later.
 +
 +Then use 
 +<​code>​
 +tail -f convertstats.log
 +</​code>​
 +
 +to see how far it has got and keep an eye on the end.
 +
 +=== recent campaign ===
 +
 +The links in campaigns require the entries in the database to work. Therefore, if you recently sent out a campaign, and you convert the statistics, the links will stop working.
 +
 +To avoid this, phpList will only convert links for campaigns that are older than a week. So, there may be a need to run the conversion again a week later.
 +
 +
 +
  
system/convertstats.txt · Last modified: 2013/08/19 21:02 by phplist

Resources
Contact Us

e: info@phplist.com

Boring Bit

phpList is a registered limited company

UK Company No. 07582966

VAT Registration 122 0788 37

© phpList 2016