import_logs.px --> invalid log lines


#1

Hej guys I hope you can help me,

I googled the last days arround my Problem with the import_logs.py and already resolved some issues.
But now all my loglines get ignored. Are there mandantory fields that need to be defined in the custom regex?

my commandline on windows looks like this:


c:\xampp\htdocs\piwik\misc\log-analytics>import_logs.py --url http://localhost/piwik/ --dry-run --idsite=1 --login=piwik --password=20pua04915 C:\xampp\htdocs\piwik\misc\log-analytics\kombinierter.log --regex-group-to-page-cvar="userName=User Name" --log-format-regex="(?P<date>[0-9]{4}-[0-9]{2}-[0-9]{2}[0-9]{2}:[0-9]{2}:[0-9]{2},[0-9]{3}),\"[0-9]+\",\"(?P^<path^>.*?)\",\".*?",\"(?P^<userName^>.*?)\",\".*?\",\"(?P^<status^>[0-9]{3})\""

Here is an example log-line:
“2015-03-06 00:01:06,056”,“23068”,"/ControlPanel/GetPushNotification",“7ac9db4c-20ca-4939-b583-ba119b50481a”,“username@company.com”,“POST”,“200”,“OK”

Some fields are unknown to me but I guess:

“Date”,“length”,“path”,“CustomProductID”,“CustomerID”,“RequestType”,“ErrorCode”,“ErrorString”

Maybe my regex is wrong or I don’t supply enough parameter?
How to debug this?

Greetings Christoph


(Matthieu Aubry) #2

hi there

one of your " is missing a \ before hand.

around: ?)",".*?",\

there is one \ missing after ?


#3

Hej,

maybe this was the error. I can check it in 3 days. Until then i am not at work.

But this could be the solution.

I will give feedback if i checked with right quoting.

Greetings Christoph