Tool to receive emails, parse them and store data in a Firebird SQL table (Delphi code)


I need a small tool programmed in Delphi (source and exe, Win 10 64bit) which does the following:

1. Every x hours check a certain POP3 mailbox (login details saved in a config file etc)

2. If emails were received then download all emails, store them in a database table INCOMINGEMAILS and when all emails have been downloaded then parse them

3. Based on the data which has been parsed, create an entry in another database table in the FDB file and store the parsed data from the email in there (each table row has about 10 fields, very simple)

4. Mark the email as parsed in INCOMINGEMAILS so it will not be processed again, delete it from the email mailbox

5. If certain essential fields (I will specify) could not be parsed AND the email was sent from a pre-approved domain name (ending with [login to view URL]) then send a response email to the sender that the email could not be parsed and the data has not been recorded.

if email was sent from some unauthorized domain, then do not respond at all and just delete email from server and also from the INCOMINGEMAILS table, or even better check if it comes from an authorised domain before making an entry in the INCOMINGEMAILS table

6. When data has been parsed and added to the database send a confirmation email to the sender with a predefined subject line (Time entry added) and the parsed data in the email body. Please include an option so that this confirmation function can be switched off for each sender email.

I will provide detailed instructions how to parse the email body in due course. It is very simple.

Software does not have to run as a service. No requirements for the GUI, just a config file or control window where I can set the time interval for email checking etc. I will provide the FDB file in due course.

Budget 120 USD.

Will prefer Russian speaking programmers (I speak English).

I have many follow up projects if this goes well.

Many thanks

Készségek: Delphi, Emailkezelés, Programozás, Szoftverarchitektúra

Bővebben: android code store data sql server database retrieve, extract data emails parse, store serial port receive data ms sql database, email handling, delphi, database programming, programming, store data asp net websites registration form database sql server, radgrid editor data insert sql table, access project data entry sql table, pthon parse html store data mysql, parse pdf data sql server, copy data data servers sql store procedure, parse xml data sql php, net sql store data, store data sql, store data time oracle sql server aspnet, import data access sql, store image database sql fileupload

A munkaadóról:
( 3 értékelés ) Singapore, Singapore

Projektazonosító: #16938301



I have more than 15 years experience of Delphi Developer. I started with Delphi 5 and working with XE10.2 Tokyo now. I have experience in Windows API, Network API, COM-Port, DataSnap, Client/Server, parsing big fi Több

$100 USD 7 napon belül
(10 értékelés)

8 szabadúszó tett átlagosan $138 árajánlatot erre a munkára


Hello I have several years of experience with Java programming and I am Russian speaker Also, I have experience with POP3 protocol

$100 USD 4 napon belül
(837 vélemény)
$120 USD 10 napon belül
(93 vélemény)

Good morning, I am a very skilled delphi developer and I would like to help you in this project. Whcih database components do you use to access firebird? Best regards, Augusto Pellis

$155 USD 10 napon belül
(34 vélemény)

Hello. My name is Denis. I have 10+ years experience in Delphi (Delphi 3 - Delphi 10.2) RTL/VCL/FMX. I developed with 3rd party visual components: Developer Express, TMS Components Pack, EhLib. I worked with various Több

$200 USD 3 napon belül
(43 vélemény)

Hello, I speak also Russian, so we can continue the interview in language of your choice. I have a great experience with all Delphi versions and Interbase/Firebird. I recommend the last, XE 10.2 Tokyo, but can us Több

$120 USD 4 napon belül
(28 vélemény)

I have experience with delphi & neworking. Mainly I works with http protocol but also have libraries that I develop for own purposes that works with pop3, imap and smtp protocols. This works in threads so dont freeze m Több

$111 USD 10 napon belül
(7 vélemény)

Hi, I am Simon from Australia. I have 7+ years in web designing & development with good experience in following skills ... 1. HTML5 2. CSS,CSS 3 & LESS 3. JS (Angular JS, Backbone JS,React JS, node.js, ex Több

$200 USD 3 napon belül
(0 vélemény)