In Progress

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

Hi

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

Skills: Delphi, Email Handling, Programming, Software Architecture

See more: 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

About the Employer:
( 3 reviews ) Singapore, Singapore

Project ID: #16938301

Awarded to:

tytus0d

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 More

$100 USD in 7 days
(10 Reviews)
3.1

8 freelancers are bidding on average $138 for this job

vano101

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

$100 USD in 4 days
(837 Reviews)
7.2
$120 USD in 10 days
(93 Reviews)
7.1
augustogus

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 in 10 days
(34 Reviews)
6.3
jlsproject

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 More

$200 USD in 3 days
(43 Reviews)
5.1
Mahris

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 More

$120 USD in 4 days
(28 Reviews)
5.0
mkoretskiy

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 More

$111 USD in 10 days
(7 Reviews)
5.0
hawkscodeau

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 More

$200 USD in 3 days
(0 Reviews)
2.9