meta data for this page
  •  

Differences

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

Link to this comparison view

system:convertstats [2013/08/19 20:01] – created phplistsystem:convertstats [2013/08/19 20: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.
 +
 +
 +