{"action":"created","issue":{"url":"https://api.github.com/repos/MetricsGrimoire/MailingListStats/issues/72","repository_url":"https://api.github.com/repos/MetricsGrimoire/MailingListStats","labels_url":"https://api.github.com/repos/MetricsGrimoire/MailingListStats/issues/72/labels{/name}","comments_url":"https://api.github.com/repos/MetricsGrimoire/MailingListStats/issues/72/comments","events_url":"https://api.github.com/repos/MetricsGrimoire/MailingListStats/issues/72/events","html_url":"https://github.com/MetricsGrimoire/MailingListStats/issues/72","id":175826388,"number":72,"title":"mbox URL from Gnome and Apache HTTP Server does not extract data ","user":{"login":"MishiR","id":14334578,"avatar_url":"https://avatars.githubusercontent.com/u/14334578?v=3","gravatar_id":"","url":"https://api.github.com/users/MishiR","html_url":"https://github.com/MishiR","followers_url":"https://api.github.com/users/MishiR/followers","following_url":"https://api.github.com/users/MishiR/following{/other_user}","gists_url":"https://api.github.com/users/MishiR/gists{/gist_id}","starred_url":"https://api.github.com/users/MishiR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MishiR/subscriptions","organizations_url":"https://api.github.com/users/MishiR/orgs","repos_url":"https://api.github.com/users/MishiR/repos","events_url":"https://api.github.com/users/MishiR/events{/privacy}","received_events_url":"https://api.github.com/users/MishiR/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":20,"created_at":"2016-09-08T18:23:52Z","updated_at":"2016-09-22T19:22:53Z","closed_at":"2016-09-12T21:58:28Z","body":"Hi,\r\n\r\nI was unable to extract data from Apache HTTP and Gnome with command:\r\n\r\nmlstats --db-driver=sqlite --db-name=TEMP.db http://mail-archives.apache.org/mod_mbox/\r\n\r\nmlstats --db-driver=sqlite --db-name=TEMP.db https://mail.gnome.org/archives/devel-announce-list/\r\n\r\nPlease suggest!\r\nThanks \r\nMishi"},"comment":{"url":"https://api.github.com/repos/MetricsGrimoire/MailingListStats/issues/comments/249002655","html_url":"https://github.com/MetricsGrimoire/MailingListStats/issues/72#issuecomment-249002655","issue_url":"https://api.github.com/repos/MetricsGrimoire/MailingListStats/issues/72","id":249002655,"user":{"login":"MishiR","id":14334578,"avatar_url":"https://avatars.githubusercontent.com/u/14334578?v=3","gravatar_id":"","url":"https://api.github.com/users/MishiR","html_url":"https://github.com/MishiR","followers_url":"https://api.github.com/users/MishiR/followers","following_url":"https://api.github.com/users/MishiR/following{/other_user}","gists_url":"https://api.github.com/users/MishiR/gists{/gist_id}","starred_url":"https://api.github.com/users/MishiR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MishiR/subscriptions","organizations_url":"https://api.github.com/users/MishiR/orgs","repos_url":"https://api.github.com/users/MishiR/repos","events_url":"https://api.github.com/users/MishiR/events{/privacy}","received_events_url":"https://api.github.com/users/MishiR/received_events","type":"User","site_admin":false},"created_at":"2016-09-22T19:22:53Z","updated_at":"2016-09-22T19:22:53Z","body":"Hi Poo,\r\n\r\nI have extracted data from apache project link: http://mail-archives.apache.org/mod_mbox/httpd-dev/\r\nThe data using MLStat is extracted in tables. My requirement is to now fetch mailing messages which are not replied to. Am using the following query:\r\nSELECT message_id, is_response_of, subject,message_body, arrival_date, LTRIM (subject,'Re: Re: RE: AW:')\r\nas mymessages\r\nFROM messages\r\nwhere subject not like 'Re: %'\r\ngroup by mymessages\r\nhaving (count (mymessages) =1)\r\n\r\nIt doesn’t help, I still get messages that have response. Can you please suggest?\r\n\r\n/BR\r\n\r\nMehvish Rashid\r\n\r\nFrom: Germán Poo-Caamaño [mailto:notifications@github.com]\r\nSent: 09 September 2016 01:14\r\nTo: MetricsGrimoire/MailingListStats\r\nCc: Mehvish.Rashid; Author\r\nSubject: Re: [MetricsGrimoire/MailingListStats] mbox URL from Gnome and Apache HTTP Server does not extract data (#72)\r\n\r\n\r\nThere is a typo in the URL. It is gnome. not genome.\r\n\r\nHowever, in your first message the URL is correct (I copied it and pasted it when I tried it).\r\n\r\n—\r\nYou are receiving this because you authored the thread.\r\nReply to this email directly, view it on GitHub<https://github.com/MetricsGrimoire/MailingListStats/issues/72#issuecomment-245781726>, or mute the thread<https://github.com/notifications/unsubscribe-auth/ANq6clSCcX6PYrNfzpvEDbabUH6YBtZTks5qoKSrgaJpZM4J4TCs>.\r\n"}}
{"actor":{"display_login":"MishiR"}}