Import custom variable from import_logs.py


#1

hello everyone,
i have a trouble here,
i can find my custom variable logs in table piwik_log_link_visit_action if i import using import_logs.py.

when i run it, it show like this :


Logs import summary
-------------------

    1 requests imported successfully
    0 requests were downloads
    0 requests ignored:
        0 invalid log lines
        0 requests done by bots, search engines, ...
        0 HTTP errors
        0 HTTP redirects
        0 requests to static resources (css, js, ...)
        0 requests did not match any known site
        0 requests did not match any requested hostname

Website import summary
----------------------

    1 requests imported to 1 sites
        1 sites already existed
        0 sites were created:

    0 distinct hostnames did not match any existing site:


and my apache access.log:


127.0.0.1 - - [17/Apr/2014:05:58:10 +0000] "GET /piwik.php?idsite=1&rec=1&apiv=1&r=550634&cip=12.232.22.2&_id=b6d3d33e191602c7&token_auth=6726376736ywuweudh774c3edd&_idts=1396514705&_idvc=398&_viewts=1397016655&cvar=%7B%221%22%3A%5B%22SEARCH_STATUS%22%2C%22OK%22%5D%2C%223%22%3A%5B%22SEARCH_USER%22%2C%22010%22%5D%2C%224%22%3A%5B%225D%7D&url=http%3A%2F%2Fwww.domain.me%2Fsearch%2Fsearch&urlref=http%3A%2F%2Fwww.mydomain.me%2Fsearch%2Fsearch=View+Media HTTP/1.1" 200 54 "-" "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.116 Safari/537.36"

how to get my custom variables recorded to table piwik_log_link_visit_action??
thanks


(Matthieu Aubry) #2

this should work and import your custom variables, is it not working?


#3

nope, isn’t working matt


(Matthieu Aubry) #4

in the log you have:


&cvar=%7B%221%22%3A%5B%22SEARCH_STATUS%22%2C%22OK%22%5D%2C%223%22%3A%5B%22SEARCH_USER%22%2C%22010%22%5D%2C%224%22%3A%5B%225D%7D

Which once URL decoded is:


{"1":["SEARCH_STATUS","OK"],"3":["SEARCH_USER","010"],"4":["5D}

So it is invalid JSON and this is why it wasn’t tracked. Cheers