Closed

Email parser - python (windows .exe) or script

I need a Python based software that runs on windows as .exe (executable) file. Here is what I want to do:

1. Look at email inbox

2. Find emails that match a criteria

3. Parse each email's content

4. Put this information in a DB or Excel sheet

Basically, here is the use-case:

I have a mailbox that receives daily emails about issues, progress, status. All those emails come in a particular templated format.

What I want to do is, automatically parse these emails and consolidate information in one database or excel file. Sort of a dashboard.

For example:

Project Name | Defect | Progress | % completed |

________________________________________

MyProject-1 | 10 | 5/10 | 50%

MyProject-2 | 9 | 3/9 | 33%

---------------------------------------------------------------------

All this information comes in emails. I just need to consolidate it all in one excel file.

Also, we'd need to create a "tab" for each day or add a "date" column. So, that we can look-up status for any particular date.

Challenges:

1. Emails come in Outlook. We'd probably need to create a software that automatically imports emails from Outlook file OR directly interacts with exchange server (I can create a dedicated emailbox on exchange server)

2. I'd like to create a graphical view of the data as well. Use data to plot graph for overall ALL projects (filtered by some criterias) and graphs for each project too.

******* Note ****
1. I am also open to running this as a web-based software (Python/Django)
2. Command line based script but I think as a command-line based script, it might become very hard to specify all criterias/parameters for specifying which emails to parse
3. I can provide sample template of emails (that need to be parsed).
4. If program encounters an email that should be parsed but the contains content in a format that is not parseable, it should flag it and move to next email. Program should NOT die in the middle. If there is something it could not process, it should just move to next email and log which emails it wasn't able to process.
5. Should also allow manual entry of data. For eg: if it could not parse an email because of some reason (maybe email content did not use a standard template), then it should allow user to manually upload data-points for that email or manually create records.
**********************

Skills: Algorithm, C++ Programming, Data Processing, Python, Web Scraping

See more: python email parser, what graph to use for data, python look for file, python find, python exchange, find python, data challenges, what is exchange server, d python, python excel, python data, python based projects, parse email, exchange issues, excel python, email parser, email inbox, data plot, excel sort date, database projects excel, excel create graph, windows server exchange server, excel based dashboard, parse data file python, excel sheet consolidate

About the Employer:
( 84 reviews ) Plano, Canada

Project ID: #4989641

18 freelancers are bidding on average $223 for this job

creatorul

Hello, Do you also consider a .NET solution in C# programming language ? Regards, Daniel

$421 USD in 3 days
(31 Reviews)
6.8
samitXI

Hi Sir, I am ready to work for you. I have 8 years of experience in C/C++ , Python and java. please see some of my works also check my reviews you will get better idea about my skill. I deliver quality work within tim More

$175 USD in 3 days
(76 Reviews)
6.5
uumairkhalid

Hi.. Expert web scraper/Data Minor here. Interested in your project. I assure you 100% accurate and good quality work. Ready to start. Regards

$315 USD in 3 days
(57 Reviews)
5.8
tlyx

Looks like something i can help you with. Could you please provide sample template of emails?

$333 USD in 10 days
(25 Reviews)
5.1
abupabuya

hi sir.i have a list , pls check my sample at message inbox Email was extracted from their own [url removed, login to view] this email functional intended for their business coz its extracted from their own web site all data 20 More

$50 USD in 1 day
(23 Reviews)
4.9
helmot

I have +10 years of experience in Python programming. I have an interesting suggestion for you! I can deliver you what you want in a few hours without awarding. I am new to freelancer, but I have done email grabbing More

$100 USD in 1 day
(17 Reviews)
4.0
mkhrsunil

Hi, I'm excel VBA developer, I have VBA script ready for you, which get all email details from outlook to excel e.g. Sender Mail ID, Received Date & Time, Subject Line, Attachment and Mail Body Message I can s More

$155 USD in 3 days
(2 Reviews)
3.4
NTechcorporate

Hi, Greetings from N-Tech Technologies Pvt. Ltd. !!!! Thank you for posting this job, We have gone through your requirement specification and confident to deliver you best "Python" solution as we have expert in More

$206 USD in 7 days
(1 Review)
3.2
suraj99p

I am expert in scripting languages like python and perl. I have written email bot in past. I am also very good in databases like mysql and oracle. I can give very good solution for this. I would require sample mails to More

$150 USD in 3 days
(2 Reviews)
2.5
Yagosh

Hi. I can do it. 1. I will code it as a autostarting system service, so you won't need to worry about starting the app every day. 2. I will create a simple-to-use GUI for configuration tasks. 3. You won't need any More

$200 USD in 3 days
(1 Review)
2.2
anuyadav1

i have ready build script for this. will take not more then a hour to deliver this python script, it will save contents of mail on the mysql database.

$45 USD in 1 day
(2 Reviews)
2.0
sn2234

Hello! I'd like to help you with this project. I have experience working with Outlook PST files and MAPI in the past. Preferably, I would choose C++ for this one, but C# might be also possible.

$155 USD in 3 days
(1 Review)
1.4
pawanhv

i recently did a similar project on big data//....message me to discuss more the expected delay will be the next weekend

$155 USD in 3 days
(0 Reviews)
0.0
iKCLzAsKSBsy

Hi we are freelance software developers. If you contact us, we can give a quote and we can discuss further details of the project. w w w . s o l v e r . i o

$155 USD in 3 days
(0 Reviews)
0.0
ils7

I can develop report genreator and viewer for your project monitor .

$789 USD in 20 days
(0 Reviews)
0.0
mwschultz

Hello! I have a Master's degree in Computer Science, as well as over four years of professional programming experience, much of which involved Python. In addition, since I am a new freelancer, I am focusing on building More

$166 USD in 14 days
(0 Reviews)
0.0
VnBestSolutions

Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! More

$252 USD in 3 days
(1 Review)
0.0
arunkuj

Hi, I am IT Professional with 4 yrs of experience in Python Programming. I have worked on email module also before. I am confident of completing this project.

$166 USD in 3 days
(0 Reviews)
0.0
tonyjacobk

I have done a similar work in Python where we had to read mails from gmail account ,parse it and take action depending on [url removed, login to view] must be easier than that as mails follow templates. We have Python modules that di More

$222 USD in 3 days
(0 Reviews)
0.0
madhurmahendra

We can provide you the code as according to customization according to your need in minimum shortest time. we can even provide Demonstration(video at your will just need 6 hr after your intimation)

$122 USD in 3 days
(0 Reviews)
0.0