Perl or php script to parse emails in Postfix and insert into database
$250-750 USD
Terminado
Publicado hace más de 3 años
$250-750 USD
Pagado a la entrega
We are currently processing internal bounce emails by connecting to an IMAP account and downloading emails to then extract the delivery notification and other headers and inserting into an SQL server database. Rather than continue to do this, we are looking to extract the information when the email is received by means of a php/perl script that we will then integrate into our existing postfix mail server.
The attached file is a working example and we need to extract the following values using regex and insert them into an SQL database;
From the email headers:
x-BPS1 : bounce-167495-595511888'at'[login to view URL]
messageid : 167495 (extracted from email address)
contactid : 595511888 (extracted from email address)
From the delivery notification:
Status : 4.4.7
Description : (delivery time expired)
Code : 421
Diagnostics : Deferred
Action: failed
Category: message-expired
I can go through the full details with you beforehand, but I do expect you to have a good understanding of php, emails and regex to be able to extract the data.
Once the values have been extract from the email, the data needs to be inserted into a table in SQL server, not MySQL. If the insert fails, the script should error accordingly.
Dear client.
I am highly experienced and dedicated developer with impressive expertise in web developments using PHP scripts.
As an experienced developer, have confident to do your task perfectly.
I have a methodical, customer-focused approach to work and a string drive to see things through completion.
I am able to start work immediately upon hiring.
Please reach out to me if you are interested.
Regards,
Mario
Hi, I can help you to make the php/perl script for parsing email and store infos to MSSQL server.
I have many experiences of PHP/perl script development/automation/scraping/email.
Let's discuss more details over chat.
PHP/Perl expert Anoop
Hi Chris B., PHP, Microsoft SQL Server, Regular Expressions, Postfix, Perl skilled professional with over 5+ years of experience. I have worked on several similar projects and can deliver quality solution to tight deadlines. You can see an example of one of those projects in my portfolio here: www.freelancer.com/u/hemsingh1. I am interested to hear more about the project. If you award me the project I would be very happy to discuss this further and get started for you as soon as possible. Thanks! Hem
Dear client,
I recommend you to use laravel for this job.
It has awesome composer packages to parse email and also can integrated other 3rd party apis easily.
Please message me so we can discuss more details.
Thank you.
Seo
Hi, I can help you to make the php/perl script for parsing email and store infos to MSSQL server.
I have many experiences of PHP/perl script development/automation/scraping/email.
Let's discuss more details over chat.
PHP/Perl expert Anoop