Find Jobs
Hire Freelancers

Inward Email Parsing

$250-750 AUD

Closed
Posted about 7 years ago

$250-750 AUD

Paid on delivery
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.
Project ID: 13342511

About the project

18 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average $550 AUD for this job
User Avatar
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 days
4.9 (81 reviews)
7.0
7.0
User Avatar
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?
$736 AUD in 21 days
4.9 (72 reviews)
6.9
6.9
User Avatar
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 :-)
$721 AUD in 10 days
5.0 (6 reviews)
5.7
5.7
User Avatar
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
$450 AUD in 10 days
4.9 (25 reviews)
5.0
5.0
User Avatar
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
$555 AUD in 14 days
5.0 (7 reviews)
4.4
4.4
User Avatar
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
$500 AUD in 7 days
5.0 (8 reviews)
3.7
3.7
User Avatar
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.
$490 AUD in 15 days
5.0 (3 reviews)
2.7
2.7
User Avatar
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.
$300 AUD in 10 days
5.0 (7 reviews)
2.4
2.4
User Avatar
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.
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$533 AUD in 15 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
0.0
0
Member since Feb 23, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.