Devam Ediyor

Utility to export specific format from MySql table

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 [url removed, login to view] ([[url removed, login to view]]) by [url removed, login to view] with Microsoft SMTPSVC([url removed, login to view]);

\n\t Sat, 19 Jun 2010 15:09:51 -0700

\nReceived: from [url removed, login to view] ([65.55.34.8]) by [url removed, login to view] with Microsoft SMTPSVC([url removed, login to view]);

\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 [url removed, login to view] ([[url removed, login to view]]) by [url removed, login to view] with Microsoft SMTPSVC([url removed, login to view]);

\n\t Sat, 19 Jun 2010 15:09:39 -0700

\nReceived: from [url removed, login to view] ([url removed, login to view] [[url removed, login to view]])

\n\tby [url removed, login to view] (Postfix) with ESMTP id 21367316E1

\n\tfor <>; Sat, 19 Jun 2010 15:09:39 -0700 (PDT)

\nReceived: by gyg13 with SMTP id [url removed, login to view]

\n for <>; Sat, 19 Jun 2010 15:09:38 -0700 (PDT)

\nDKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;

\n d=[url removed, login to view]; 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=[url removed, login to view]; 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 [url removed, login to view] with SMTP id [url removed, login to view];

\n\tSat, 19 Jun 2010 15:09:38 -0700 (PDT)

\nReceived: by [url removed, login to view] with HTTP; Sat, 19 Jun 2010 15:09:38 -0700 (PDT)

\nReceived: by [url removed, login to view] 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... [url removed, login to view]

after job completion, I obtain all source code to the project.

Beceriler: .NET, C# Programlama, MySQL

Daha fazlasını görün: username gmail com password, source format, signature database, programming org, programming job address, programming from, programming 101, parse programming, out source programming, nx programming, net hotmail.com, mysql org, m.gmail, get the programming job, get job programming, first programming job, export job, date utility, c sharp job, craigslist x, craigslist fresno, code org 6 d, 0 hotmail com, microsoft info path, craigslist h

İşveren Hakkında:
( 8 değerlendirme ) Palm Springs, United States

Proje NO: #717539

Seçilen:

eyesee

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 Daha fazlası

1 gün içinde 30$ USD
(2 Değerlendirme)
2.2

2 freelancers are bidding on average $140 for this job

paleboyeh

I am a dba with an experience of over 12 years and keen to deliver you the solution

1 gün içinde 250$ USD
(0 Değerlendirme)
0.0