Lukket

Inward Email Parsing

I need someone to parse incoming emails using Delphi and the Indy iMap components (which could be in Text or HTML format and may or nor have attachments, and save the content to a database.

We already have tested code to connect with email server (e.g. Google, Office365 or standard iMap) and physically receive the messages.

I now need this to be extended so that certain data from the message can be saved to a database (in this case MS SQL Express).

Content to be saved includes the basic email metadata, e.g. Sender, date, subject and the message content. If the message content is in text format we would like to convert it to HTML (e.g. page breaks etc) so that all records in the database for the content are stored in HTML.

If there are attachments, these should be stored in image fields in the DB, and also embedded within the message body field of the database either encoded if an image (so that it will be displayed in an HTML viewer which is based on the Sumernote Javascript component) or as a link to download if some other type of file.

Most of the incoming emails will be from existing customers, so it is necessary to lookup the customer from their email address and store the customerID with the email in the database. If they do not exist then a new contact should be created and the new contactID stored.

In all cases, the email may relate to an existing case in the database, so this should be looked-up based on email subject line (maybe containing the case ID) and if so, the caseID should be stored with the email in the DB. If not a new case should be created and its ID stored with the email in the DB.

When the email body is imported to the database we only want to save the current message. Any other threads that are included in the message must be removed as we don't want to store a whole lot of duplicated information in the database. HOWEVER, if there is information that is FORWARDED as part of the message body that should be retained. This is probably the only part of the task that is novel.

As you can tell, this is part of a bigger project. Ideally I would like all of this functionality to be in a separate unit that can be linked into the main program. The technology in use is Delphi XE4 (although exact version probably not important), Intaweb, Indy and IWBootstrap. Given that this functionality is mainly in the "back-end" of the program, a working knowledge of Delphi (pascal) and Indy email components would probably be sufficient to complete the task.

We have complete database design and some starter code available for your use.

Evner: Delphi, Software Arkitektur

Se mere: xsl email button file type, software write mq4, software write chip epson, windows desktop, erp, delphi, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, jsp spring file upload check file type, inurluploaderhtml warning intitle file uploader download, send email aspnet attach zip file

Om arbejdsgiveren:
( 0 bedømmelser ) Melbourne, Australia

Projekt ID: #13342511

18 freelancere byder i gennemsnit $550 på dette job

srinichal

I [login to view URL] in delivering such automation tools

$333 AUD in 5 dage
(80 bedømmelser)
7.0
igors233

Hi, how are you? I am Delphi expert with years behind me in various areas including eMail processing (body, attachments). Based on your description it's clear how should application behave, there are few things that I Flere

$736 AUD in 21 dage
(72 bedømmelser)
6.9
kukhtinigor

Hi, i can help you with this project. i have already done something close for e-mails. but i have storaged to Interbase

$500 AUD in 10 dage
(81 bedømmelser)
7.0
shivmirthyusl

"IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 10+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networking, real-e Flere

$555 AUD in 10 dage
(21 bedømmelser)
6.4
Shopify

Hello, Greetings from Shopify We have recently completed the similar project and would like to show you a live demo which is similar to your project . I would like to discuss your project in more details so during Flere

$721 AUD in 10 dage
(6 bedømmelser)
5.7
MarcoAGarcia

Hi, I’m software and database developer with more than 35 years experience. Twenty of those years I worked (full-time, in-situ) for two international organizations; IATTC, in San Diego, CA, USA, and the Food and Agricu Flere

$888 AUD in 10 dage
(3 bedømmelser)
5.0
DeadC0der

Hello there ^^ I'm delphi coder actually I used to deal with simillar jobs just like the one you have mentioned ^^ I mean I used to code database driven applications using the latest engines like FIreDac,UniDac,ZEOS,AD Flere

$450 AUD in 10 dage
(25 bedømmelser)
5.0
hiramalik321

Hi there, I've read your project description and I am confident enough that I can handle this project according to your expectations. I have done similar projects before and I want to take over this project as well. If Flere

$555 AUD in 14 dage
(7 bedømmelser)
4.4
ske777

Hello Dear Client! I have read project description with a large interest. I am willing to do this job cause have experience in desktop development using Delphi more then 10 years, also I am specialist in database de Flere

$500 AUD in 7 dage
(8 bedømmelser)
3.7
drudev

Hello. I am a web developer with 15+-year experience . I work remotely on DigitalRay company - [login to view URL] - LA (USA). Technical knowledges: [login to view URL] JavaScript Ruby RoR ASP.Net C#, Java, Python, Zend, CakePHP, Symp Flere

$555 AUD in 10 dage
(1 bedømmelse)
3.9
agilekarthik

Hello , I'm having good knowledge in Delphi development. I have been working as Product Developer. I'm experienced and worked in most of the versions of Delhi [Delphi 2007 ,Delphi XE3 , XE4,10 & 10.1]. I have done simi Flere

$490 AUD in 15 dage
(3 bedømmelser)
2.7
tytus0d

I have more than 15 years expirience of Delphi Developer. I started with Delphi 5 and working with XE10.1 now. I have experience in Windows API, Network API, COM-Port, DataSnap, Client/Server, parsing big files, Flere

$300 AUD in 10 dage
(7 bedømmelser)
2.4
$500 AUD in 8 dage
(0 bedømmelser)
0.0
bsoni3891

We make sure we understand exactly what it is you need and then provide you with the dedicated IT offshore development center or a IT team of just a few developers best suited to meet your [login to view URL] have specialists o Flere

$555 AUD in 10 dage
(2 bedømmelser)
0.1
$616 AUD in 7 dage
(0 bedømmelser)
0.0
hirakhan2

Hi,  I have review project details and would like to discuss with you regarding the project. Kindly let me know when available. Thank you.

$555 AUD in 10 dage
(0 bedømmelser)
0.0
zdesign77

Hey, how is it going today? My name is Michael, I'm a web designer/developer from Boston. I've had a look at your project description and feel that my skills match your requirements perfectly. In fact, I did a very sim Flere

$555 AUD in 10 dage
(0 bedømmelser)
0.0
nitinshevale

A proposal has not yet been provided

$533 AUD in 15 dage
(0 bedømmelser)
0.0