IIS-W3C import error (import_logs.py)

Support & Bugs
1

Hello,

I have to import several IIS-logfiles. The format:

#Fields: date time c-ip cs-username s-sitename s-computername s-ip s-port cs-method cs-uri-stem cs-uri-query sc-status sc-win32-status sc-bytes cs-bytes time-taken cs-version cs-host cs(User-Agent) cs(Cookie) cs(Referer) sc-substatus

Example:
2017-04-24 11:2:15 2.247.245.17 - W3SVC - 127.0.0.1 80 GET /produkte/demo.htm - 200 - 7436 - - HTTP/1.0 www.abc.de Mozilla/5.0+(Linux;+Android+4.4.2;+Cynus+F6+Build/KOT49H)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/55.0.2883.91+Mobile+Safari/537.36 __cfduid=d03a795f463ba8b75d7ebec54fdd537611493024533 https://www.google.de/ -

Using:
import_logs.py --url=‘http://localhost/piwik’ --idsite=2 --recorders=4 --enable-http-errors --enable-http-redirects --enable-static --enable-bots --log-format-name=w3c_extended --w3c-time-taken-millisecs --w3c-fields=’#Fields: date time c-ip cs-username s-sitename s-computername s-ip s-port cs-method cs-uri-stem cs-uri-query sc-status sc-win32-status sc-bytes cs-bytes time-taken cs-version cs-host cs(User-Agent) cs(Cookie) cs(Referer) sc-substatus’ /home/bb/apache-logs/XXX

gives the following error: “invalid log lines”. Debugging only says: “line did not match”.

I dont’t see any error, please help!

TIA, Rainer

2

I have same problem . An error occurs when use --idsite .

python C:\piwik\misc\log-analytics\import_logs.py --login=xxxx --password=xxxx --url=http://example.piwik.com/ --idsite=8 --recorders=4 --enable-http-errors --enable-http-redirects --enable-static --enable-bots C:\logs\LogFiles\W3SVC\u_ex.log

Traceback (most recent call last):

File “C:\piwik\misc\log-analytics\import_logs.py”, line 2413, in resolver = config.get_resolver()
File “C:\piwik\misc\log-analytics\import_logs.py”, line 1023, in get_resolver

return StaticResolver(self.options.site_id)

File “C:\piwik\misc\log-analytics\import_logs.py”, line 1455, in init “cannot get the main URL of this site: %s” % site.get(‘message’)
File “C:\piwik\misc\log-analytics\import_logs.py”, line 2400, in fatal_error
print >> sys.stderr, ‘Fatal error: %s’ % error
File “c:\Python27\lib\encodings\cp437.py”, line 12, in encode
return codecs.charmap_encode(input,errors,encoding_map)
UnicodeEncodeError: ‘charmap’ codec can’t encode characters in position 51-52: character maps to