Utility to export specific format from MySql table
$30-250 USD
Completed
Posted almost 14 years ago
$30-250 USD
Paid on delivery
I have a mysql database, in this database there is a table (table_incoming), and in this table there is a field called header. This is the header records of incoming mail records. The header field is long text. GAF REMOVED REFERENCES TO EMAIL ADDRESSES IN THE SAMPLE EXPORT... BUT YOU SHOULD STILL GET THE IDEA
I'm looking for a program to be written that I can run locally on my network, point it to my mysql database by ipaddress, username, password, database name.
Need to be able to select a date range to export. Then the program should go through the header records and parse out senders name, email address, and the ipaddress of their mail server.
A typical record would look like this:
X-Message-Delivery: Vj0xLjE7dXM9MDtsPTA7YT0xO0Q9MTtTQ0w9MA==
\nX-Message-Status: n:0
\nX-SID-PRA:
\nX-SID-Result: Pass
\nX-AUTH-Result: PASS
\nX-Message-Info: JGTYoYF78jHcTHAzELJgqkGv2+H7egmVfWiIfa2mn3KcfJfE8HzBRxvOjqP+N6q86tisyDXEy4z8uE/kL7K3wA+Ac0mC61A4O+R3/ZOAmik=
\nReceived: from [login to view URL] ([[login to view URL]]) by [login to view URL] with Microsoft SMTPSVC(6.0.3790.4675);
\n\t Sat, 19 Jun 2010 15:09:51 -0700
\nReceived: from [login to view URL] ([[login to view URL]]) by [login to view URL] with Microsoft SMTPSVC(6.0.3790.4675);
\n\t Sat, 19 Jun 2010 15:09:40 -0700
\nResent-Message-ID: <>
\nResent-To:
\nResent-Date: Sat, 19 Jun 2010 15:09:40 -0700
\nResent-From:
\nX-HM-Routing-Path:cO2+INs4TZ/3ZTIGJj5rAu2dSfqx0SY2B36T29fVAqCFsS77JVJDhkfH08ycskF3U7aqw+Pfh/QkdlNxW4tabyIVl6tBeW/UCRJ5g2153tJ3JwCpE2+v+FI0LBkfrMajeOY4vW9OqDSJ5EFdhEL1eu4oVFMJb1u9lrvppxPvJ3Kl+sNkfSwDEWSjVogiiJgLQ5P2gnCi6bM=
\nReceived: from [login to view URL] ([[login to view URL]]) by [login to view URL] with Microsoft SMTPSVC(6.0.3790.4675);
\n\t Sat, 19 Jun 2010 15:09:39 -0700
\nReceived: from [login to view URL] ([login to view URL] [[login to view URL]])
\n\tby [login to view URL] (Postfix) with ESMTP id 21367316E1
\n\tfor <>; Sat, 19 Jun 2010 15:09:39 -0700 (PDT)
\nReceived: by gyg13 with SMTP id 13so1640653gyg.25
\n for <>; Sat, 19 Jun 2010 15:09:38 -0700 (PDT)
\nDKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
\n d=[login to view URL]; s=gamma;
\n h=domainkey-signature:mime-version:received:received:received
\n :in-reply-to:references:date:message-id:subject:from:to:content-type;
\n bh=7v6pjV/Agz7uG2hSorMx6/38azEVjuHgO+sup0/3j8U=;
\n b=Rt11U3QYxTvZglGpE5k0nY6Sc/eLz3k9v8fEpUTKAFNDQsK8e3bO1vzK3ETmV85mWG
\n NOZYo0GhV494uSMAgBPUiu8WIcZAnCRRZwpv/fhFgEdmYxkllz9kdefkcpPcz4pLfRgK
\n ZX+hes5G92QJSCtk6dfS3jCxALZF7T6+4jJb4=
\nDomainKey-Signature: a=rsa-sha1; c=nofws;
\n d=[login to view URL]; s=gamma;
\n h=mime-version:in-reply-to:references:date:message-id:subject:from:to
\n :content-type;
\n b=lrb4zWRsq3FfHeQYxPEwyRYw69db8/9YRt0VzYPLbJc3FMps1Rc+E1maSrIw518O1A
\n 4JbKBokr2kIfKp65wotfr6CTzEkIIZjA/Itoy0yKfFLH9A5wVgLoSlcZIUA+TEAZXP7f
\n PnlGJwtrnjqvY+J9EPkTPVgH1JWbqh8Nr0uD8=
\nMIME-Version: 1.0
\nReceived: by [login to view URL] with SMTP id j21mr2355446anq.209.1276985378767;
\n\tSat, 19 Jun 2010 15:09:38 -0700 (PDT)
\nReceived: by [login to view URL] with HTTP; Sat, 19 Jun 2010 15:09:38 -0700 (PDT)
\nReceived: by [login to view URL] with HTTP; Sat, 19 Jun 2010 15:09:38 -0700 (PDT)
\nIn-Reply-To: <>
\nReferences: <>
\nDate: Sat, 19 Jun 2010 15:09:38 -0700
\nMessage-ID: <>
\nSubject: @@ I need Action 2NIGHT @@ - w4m - 25 (fresno)
\nFrom: long fellow <email removed by gaf>
\nTo:
\nContent-Type: multipart/alternative; boundary=0016e68ded46e283ac048969531b
\nReturn-Path: bounce-anon-HeidiConserobdad=
\nX-OriginalArrivalTime: 19 Jun 2010 22:09:40.0067 (UTC) FILETIME=[1CDDE330:01CB0FFC]
\n
\n
I need the email address in the From tag... in this case <email stripped by gaf>
I need the name in the From tag... in this case long fellow
I need the ip address of the mail server handling this message for the sender. This should be the first Received tag (there may be multiple). in this case... [login to view URL]
after job completion, I obtain all source code to the project.
Hi there. I'm a Hungarian freelancer, new to the site so don't get fooled by the low number of feedbacks, I'm working on it :) What you're asking is a fairly simple thing and thus my offer hopefully is as convenient as your requirement seems to me. I can probably do this for ya even in less than a day (after given all the details of course:). Hope that sounds favourable to you, too (:
Looking forward to your reply :)
$30 USD in 1 day
3.3 (2 reviews)
2.2
2.2
2 freelancers are bidding on average $140 USD for this job