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.
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.
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.
18 freelancers are bidding on average $223 for this job
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.
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
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.
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)