Сконвертировать .log файлы сервера в .csv

Hocok44
На сайте с 09.04.2010
Offline
68
1805

Здравствуйте.

Возможно ли конвертировать лог файлы сервера в excel файлы, чтобы можно было сортировать информацию?

Думаю, что да, иначе как-же анализировать их данные?

Гугл правда ничего внятного не подсказал по этому вопросу. Может здесь опытные люди подскажут..

Заранее спасибо за ответ.

Логи веб сервера такого плана:

185.34.244.165 - - [25/Feb/2014:00:03:54 +0400] "GET /account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=2&sortby=clicks&dir=desc&l=4&refresh=true HTTP/1.0" 200 8334 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=2&sortby=clicks&dir=desc&l=4" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"

185.34.244.165 - - [25/Feb/2014:00:03:55 +0400] "GET /account/calendar/calendar_form.php?objname=date3&selected_day=25&selected_month=02&selected_year=2014&year_start=1970&year_end=2020&dp=1&da1=&da2=&sna=&aut=&frm=&tar=&inp=&fmt=d-M-Y&dis=&pr1=&pr2=date4&prv=2014-02-25&pth=calendar/&spd=[[],[],[]]&spt=0&och=CampaignsFilter%28true%2C0%2C1%29%3B&str=0&rtl=&wks=&int=1&hid=1&hdt=1000 HTTP/1.0" 200 3398 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=2&sortby=clicks&dir=desc&l=4&refresh=true" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
185.34.244.165 - - [25/Feb/2014:00:03:55 +0400] "GET /account/calendar/calendar_form.php?objname=date4&selected_day=25&selected_month=02&selected_year=2014&year_start=1970&year_end=2020&dp=1&da1=&da2=&sna=&aut=&frm=&tar=&inp=&fmt=d-M-Y&dis=&pr1=date3&pr2=&prv=2014-02-25&pth=calendar/&spd=[[],[],[]]&spt=0&och=CampaignsFilter%28true%2C0%2C1%29%3B&str=0&rtl=&wks=&int=1&hid=1&hdt=1000 HTTP/1.0" 200 3398 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=2&sortby=clicks&dir=desc&l=4&refresh=true" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
223.255.231.41 - - [25/Feb/2014:00:04:03 +0400] "GET /click.php?c=59&key=44jw9k3379ve36g3lm8r1fyl&c1=1152127&c2=3468092&c3=samsung&c4=GT-P3100&c5=Hutchison+Telecom&c6=1ecb664d514983ec04207837a44e092f&c7=178473&c8=131080 HTTP/1.0" 302 574 "-" "Mozilla/5.0 (Linux; U; Android 4.1.2; id-id; GT-P3100 Build/JZO54K) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Safari/534.30"
182.12.121.22 - - [25/Feb/2014:00:04:09 +0400] "GET /click.php?c=59&key=44jw9k3379ve36g3lm8r1fyl&c1=1152127&c2=3466813&c3=alps&c4=CROSS-A20G&c5=TELKOMSEL&c6=f0028a5881d618e8139207b4bc3060da&c7=180827&c8=111182 HTTP/1.0" 302 576 "-" "Mozilla/5.0 (Linux; U; Android 4.1.1; id-id; CROSS-A20G Build/JRO03C) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30"
185.34.244.165 - - [25/Feb/2014:00:04:09 +0400] "GET /account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=2&sortby=clicks&dir=desc HTTP/1.0" 200 8368 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=2&sortby=clicks&dir=desc&l=4&refresh=true" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
185.34.244.165 - - [25/Feb/2014:00:04:09 +0400] "GET /account/calendar/calendar_form.php?objname=date3&selected_day=25&selected_month=02&selected_year=2014&year_start=1970&year_end=2020&dp=1&da1=&da2=&sna=&aut=&frm=&tar=&inp=&fmt=d-M-Y&dis=&pr1=&pr2=date4&prv=2014-02-25&pth=calendar/&spd=[[],[],[]]&spt=0&och=CampaignsFilter%28true%2C0%2C1%29%3B&str=0&rtl=&wks=&int=1&hid=1&hdt=1000 HTTP/1.0" 200 3398 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=2&sortby=clicks&dir=desc" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
185.34.244.165 - - [25/Feb/2014:00:04:09 +0400] "GET /account/calendar/calendar_form.php?objname=date4&selected_day=25&selected_month=02&selected_year=2014&year_start=1970&year_end=2020&dp=1&da1=&da2=&sna=&aut=&frm=&tar=&inp=&fmt=d-M-Y&dis=&pr1=date3&pr2=&prv=2014-02-25&pth=calendar/&spd=[[],[],[]]&spt=0&och=CampaignsFilter%28true%2C0%2C1%29%3B&str=0&rtl=&wks=&int=1&hid=1&hdt=1000 HTTP/1.0" 200 3398 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=2&sortby=clicks&dir=desc" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
65.255.37.203 - - [25/Feb/2014:00:04:20 +0400] "GET /click.php?c=59&key=44jw9k3379ve36g3lm8r1fyl&c1=1152127&c2=3467011&c3=samsung&c4=GT-S5360&c5=Hutchison+Telecom&c6=e7afbfda85af49676cc1dc1c0ac9bfef&c7=90339&c8=124061 HTTP/1.0" 302 572 "-" "Mozilla/5.0 (Linux; U; Android 2.3.6; id; GT-S5360 Build/GINGERBREAD) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 UCBrowser/9.5.0.360 U3/0.8.0 Mobile Safari/533.1"
185.34.244.165 - - [25/Feb/2014:00:04:39 +0400] "GET /account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=1&sortby=clicks&dir=desc HTTP/1.0" 200 7846 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=2&sortby=clicks&dir=desc" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
185.34.244.165 - - [25/Feb/2014:00:04:39 +0400] "GET /account/calendar/calendar_form.php?objname=date3&selected_day=25&selected_month=02&selected_year=2014&year_start=1970&year_end=2020&dp=1&da1=&da2=&sna=&aut=&frm=&tar=&inp=&fmt=d-M-Y&dis=&pr1=&pr2=date4&prv=2014-02-25&pth=calendar/&spd=[[],[],[]]&spt=0&och=CampaignsFilter%28true%2C0%2C1%29%3B&str=0&rtl=&wks=&int=1&hid=1&hdt=1000 HTTP/1.0" 200 3398 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=1&sortby=clicks&dir=desc" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
185.34.244.165 - - [25/Feb/2014:00:04:39 +0400] "GET /account/calendar/calendar_form.php?objname=date4&selected_day=25&selected_month=02&selected_year=2014&year_start=1970&year_end=2020&dp=1&da1=&da2=&sna=&aut=&frm=&tar=&inp=&fmt=d-M-Y&dis=&pr1=date3&pr2=&prv=2014-02-25&pth=calendar/&spd=[[],[],[]]&spt=0&och=CampaignsFilter%28true%2C0%2C1%29%3B&str=0&rtl=&wks=&int=1&hid=1&hdt=1000 HTTP/1.0" 200 3398 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=1&sortby=clicks&dir=desc" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
185.34.244.165 - - [25/Feb/2014:00:04:40 +0400] "GET /account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=1&sortby=clicks&dir=desc&refresh=true HTTP/1.0" 200 7850 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=1&sortby=clicks&dir=desc" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
185.34.244.165 - - [25/Feb/2014:00:04:41 +0400] "GET /account/calendar/calendar_form.php?objname=date3&selected_day=25&selected_month=02&selected_year=2014&year_start=1970&year_end=2020&dp=1&da1=&da2=&sna=&aut=&frm=&tar=&inp=&fmt=d-M-Y&dis=&pr1=&pr2=date4&prv=2014-02-25&pth=calendar/&spd=[[],[],[]]&spt=0&och=CampaignsFilter%28true%2C0%2C1%29%3B&str=0&rtl=&wks=&int=1&hid=1&hdt=1000 HTTP/1.0" 200 3398 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=1&sortby=clicks&dir=desc&refresh=true" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
185.34.244.165 - - [25/Feb/2014:00:04:41 +0400] "GET /account/calendar/calendar_form.php?objname=date4&selected_day=25&selected_month=02&selected_year=2014&year_start=1970&year_end=2020&dp=1&da1=&da2=&sna=&aut=&frm=&tar=&inp=&fmt=d-M-Y&dis=&pr1=date3&pr2=&prv=2014-02-25&pth=calendar/&spd=[[],[],[]]&spt=0&och=CampaignsFilter%28true%2C0%2C1%29%3B&str=0&rtl=&wks=&int=1&hid=1&hdt=1000 HTTP/1.0" 200 3398 "http://analysis.com/account/stats.php?campaign=59&status=0&group=8&source=5&groupby1=19&groupby2=0&groupby3=0&dateby=1&sortby=clicks&dir=desc&refresh=true" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
Антон Каленик
На сайте с 23.06.2008
Offline
131
#1
DV
На сайте с 01.05.2010
Offline
644
#2

Опытные люди сортируют прямо на сервере.

Утилиты grep, awk, sed вполне заменяют excel.

VDS хостинг ( http://clck.ru/0u97l ) Нет нерешаемых задач ( https://searchengines.guru/ru/forum/806725 ) | Перенос сайтов на Drupal 7 с любых CMS. ( https://searchengines.guru/ru/forum/531842/page6#comment_10504844 )
zhitov
На сайте с 30.01.2005
Offline
219
#3

Hocok44, есть программы - анализаторы логов.

Строительные калькуляторы ( https://www.zhitov.com/ )
D
На сайте с 05.10.2006
Offline
56
#4

Можно открыть сразу в Excel с разделителями пробел/табуляция

Авторизуйтесь или зарегистрируйтесь, чтобы оставить комментарий