Importing old statistics - Reports don't show up!

littleguy · November 18, 2011, 9:53am

I am importing old statistics from the beginning of 2010 to the end of September 2011 on a brand new Piwik install.

I am using setForceVisitDateTime() to force the visit date.

I see new additions to piwik_log_link_visit_action and piwik_log_visit as the entries are added.

However, after having imported the statistics, I can’t get it to show up on the overview pages (which I think you call “reports”.)

For example, if I pick year, 2010 is not available (even though there are hits in that year.)

If I manipulate the URL to show 2010, I get 0 visits. However if I go to the visitor log I can see the visits from 2010 just fine.

Please let me know how to resolve this!

littleguy · November 18, 2011, 10:05am

I fixed this by performing:
UPDATE piwik_site SET ts_created = FROM_UNIXTIME(1262304000) <-- 2010-01-01 01:00 GMT, but use your own value.

Basically I changed the time of creation for all sites to before the first entry, so now it works fine. Thanks!

matthieu · November 18, 2011, 10:37pm