Find Jobs
Hire Freelancers

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.
Project ID: 717539

About the project

2 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
User Avatar
I am a dba with an experience of over 12 years and keen to deliver you the solution
$250 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Palm Springs, United States
4.9
8
Payment method verified
Member since May 11, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.