Design and code for Travelistics
addfromcsv.php is made to push data from a csv to piwik using the piwik API.
When loading historical data there are two important things to beware:
- change site creation date in (piwik_site) to be at the beginning of imported data
- drop all archive tables, which forces Piwik to recompute the data
When you have to process a lot of historical data it also comes handy to have the piwik/misc/cron/archive.sh script run from command line instead of accessing Piwik via web interface which will cause to process all historical data (after you dropped archive tables).