I am looking for an advanced/expert Perl programmer to create a bounce processing script that will sort and process incoming emails.
This script will run once or twice hourly, will need to sort the emails based on criteria that a non-technical person can manage and then based on these criteria update a Mysql database.
Currently, I have scripts that sort on complicated regex as well as awk/sed.
This new script will simplify the process by allowing a non-technical user to create rules and simple regex to categorize incoming emails.
For example: any word in the body with "unsubscribe" will be forwarded to the unsubscribe bucket.
Any email with "user unknown" will be forwarded to the bounce bucket.
Any emails not sorted will then be inspected manually for further rule writing.
After the emails are sorted, the script will need to extract information from the email to update a Mysql Database. For example, all emails in unsubscribe bucket will be unsubbed. All emails in the bounce bucket will be updated as a bounce email. The SQL script is very simple. However, extracting the pertinent information from the email will be difficult. This will often involve extracting an email address or obfuscated ids located within the email. A regex should be provided that will help extract these. I can provide some examples, but the script should be open-ended so that the non-technical user can update this as time goes on.
In addition, a daily email report should be sent to the administrator with script details.
I already have scripts that do most of this. This project is here because I need something more user-friendly and understandable for non-technical people. This project should not be difficult for most programmers, so I'm looking for someone who has a bit more usability interface experience.
I prefer a 1 file script and 1 file configuration file which will contain the settings and rules.
I think this project description is very clear, but message me if you have questions.
Payment through GAF.
Prefer Eastern European programmers.