Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Automation and processing of email based on content in email
Hello fellow geniuses.
In my best efforts to save time I need to come up with a solution for the following scenario:
1. Email message is received, it has an attached PDF file that contains an order number in the following format 123-456789-0123456 and a single UPS, FedEx or UPS tracking number somewhere in the PDF.
2. I need to be able to automatically extract the order number and the tracking number. For example we will say that our data looks like this somewhere in the PDF:
9400 4461 0122 2046 4902 26
The tracking number may or may not contain spaces for USPS and FedEx formats. So I need to find a tracking number inside the PDF that is a UPS, FedEx or USPS tracking number.
3. I need to save the extracted information into a mySQL database for later use.
My thoughts were to have some sort of application that can receive the emails at a dedicated email address so the data can be extracted and saved.
What is the shortest path to a solution this? What can the solution be?
Web Languages and Standards
8/22/2022 - Mon
I have used software by
Although I am not sure it can interrogate information in a PDF from WITHIN outlook.
They have got software that can interrogate info in documents, with a fuzzy match (for order numbers etc) and integrate into SQL.
Flexicapture may do this.
It may be worth talking to them to see if what you need is possible. It is not free software though.
You might what to have a look at the free automation software from Autoit. This tool can help move the data from a file into a DB.
If you don't mind to pay for the solution, you could
Your help has saved me hundreds of hours of internet surfing.
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
AutoIt looks good although I really need a solution that is not GUI-based. I need something that basically checks for new emails, downloads them with the PDF attachment and parses both the email send, subject, body and the PDF attachment.
AutoIt was originally designed to make Windows GUI automation very easy. It has however matured into a power scripting language that is easy to learn. I said that to make the point that GUI automation to not the only project that you can take on with AutoIt.
If I had some additional details I could provide some proof of concept code. Is this script going to run on a personal computer or a server? If pc, then what mail client is in use? If server, what mail server is in use? Can you provide an example message format and pdf attachment?
You should try the
email parser / attachment parser
from mailparser.io and then you can send the data to your DB.
Blog article is linked above. They have a lot of flexibility in their parser to extract and options to send the data via native integrations/webhooks/Zapi
to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent