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.
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 would like to clarify but we can do that later.
Can you tell me should this app be independent (but ideally written as plugable module) or it should also communicate with the main part of an existing system?
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 the process we won't have any confusion regarding the job.
Lets proceed our conversation in chat.
Thanks :-)
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,ADO,ODBC and so forth dealing with DBMS like MSSQL,SQLITE,MYSQL,ACCESS,FIREBIRD and so forth also i used to code web based applications using Indy components ^^ where indy comps are blocking comps we can use threading to avoid any freezzes ;) anyway just give me the green light and I will do my best ^^
best regards
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 you're interested then please contact me to see my portfolio :) I'll be waiting for your response.
Regards
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 design and MS SQL Servers.
Please, contact to me to discuss details of this project and our collaboration.
Best Regards,
Konstantin
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 similar projects already. I can complete your project on time. Let me know, If you are interested to do business with me.
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,
develop Multi-threaded application without any memory/resource leaks.
Oracle Database (from 8i to 12c), SQL, T-SQL, MySQL, MSSQL.
Also I have some experience in C++ and C# programming languages.
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 similar project recently which I can share with you. Let me know when you have a minute to discuss.