Importing old statistics - Reports don't show up!


#1

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!


#2

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 Aubry) #3

Good point. I added your point in a comment in: Allow visits, pages and conversions (orders, cart updates) to be recorded for days in the past · Issue #2584 · matomo-org/matomo · GitHub