@anonymous-piwik-user opened this Issue on February 24th 2014

Hello, I am currently attempting to integrate piwik with our current logging system.

I am using the bulk tracking api, and submitting actions without any of these set (because i don't have them):

_idvc, _viewts, and _idts

It seems to me like piwik should still be smart enough to figure out all of these variables by itself, although i could see performance issues, where if you submit data in the past, it would be necessary to possibly modify all logs in the future. (whether at log accept time, or when running archive.php)

Anyways, the resulting weirdness:

mysql> select count(idvisit), visitor_returning from piwik_log_visit group by visitor_returning;
+----------------+-------------------+
| count(idvisit) | visitor_returning |
+----------------+-------------------+
| 4941056 | 0 |
| 312 | 1 |
+----------------+-------------------+

mysql> select count(temp.c) from (select count(idvisit) as c, hex(idvisitor) as id from piwik_log_visit group by idvisitor) as temp where temp.c>1
-> ;
+---------------+
| count(temp.c) |
+---------------+
| 615365 |
+---------------+

it seems to me like the first statement visitor_returning value should be always greater than or equal to the second statement value.

@mattab commented on February 27th 2014 Owner

I believe you can make things a bit better, by increasing this setting: http://piwik.org/faq/how-to/faq_190/

You make very good points about _idvc, _viewts, and _idts, we may be able to seed these values to much better defaults!

@anonymous-piwik-user commented on March 12th 2014

i have already made a workaround with a custom script for correcting the data in the mysql tables.

i am assuming that in order for the suggested setting to work, i would still have to insert all of my actions sorted by date, correct?

not sure if that suggested setting will be a perfect match for me but i will investigate.

what does the visitor_days_since_order field represent in piwik_log_visit?

thanks for all the hard work guys!

Powered by GitHub Issue Mirror