Find Jobs
Hire Freelancers

Create Email Parsing Script

$30-250 USD

Completed
Posted over 4 years ago

$30-250 USD

Paid on delivery
Hello we need to create a php script that will receive emails piped to the script and will parse the email. each time an email arrives the script should run, parse the email, extract pertinent information such as - FROM - TO - SUBJECT - MESSAGE BODY - ATTACHMENTS the script must add an entry to a mysql database for each email with the extracted information, a unique id, and a timestamp. the emails the script will receive are always two different versions of emails. one version will have a TXT file attached the second version will always have 2 PDF files attached. all 3 files are pertaining to the same transaction. the script must also download any attachments and save them to a directory on our server. a url link and an absolute path to the ile must also be stored in a separate table in the database. these attachments must contain the unique id of the email where the attachment was received. attachments will be in txt file format or PDF format. any other format must be ignored. if the email has a TXT attachement: once the txt file has been downloaded and the entry to the mysql database has been completed, the script must then parse the txt file and extract various fields from the file. the txt file is always structured in the exact same way and will get the fields in a fixed length field. so for example. field A will be the first 20 characters of the line, field B will be the next 5 characters and field C will be the next 8 characters. the txt file will have multiple lines. this will vary. and custom php code must be executed for each line in the txt file using the fields extracted from each line. this custom code will be added by us after script has been tested. once the script has completed processing the email and the txt file attached to it, a email must be sent to our admin with a log of the transaction stating how many lines were processed and the fields for each line in a sort of transaction report. if the email has a PDF ATTACHMENT the pdf must be stored in our server and the entry added to the mysql table as stated before. no other function is needed i have attached an example of the TXT ffile. the format will always be exaclty the same. the only thing that will vary is the information in the fix field structure and the ammount of lines in each file. PLEASE DO NOT BID BEFFORE READING THE COMPLETE REQUIREMENT please ask any questions via chat. you will NOT be granted access to our production server so this script MUST include any dependancy libraries linked using relative paths and must run on a CPANEL hosting server. all testing must be done on your server. all payments will be done via milestones. we will not release payment until milestone is complete. emails will be piped to the script. the script will not have access to the inbox. so the script must not work by going into the inbox via imap or pop. the script must work via a piped email once selected. i will forward you 2 example emails of what the cript will parse.
Project ID: 23286596

About the project

4 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I can create this email parsing PHP script so that it extracts the information and attachments you need for your database.
$200 USD in 1 day
4.9 (259 reviews)
7.0
7.0
4 freelancers are bidding on average $198 USD for this job
User Avatar
Hey. I want to do this project. Some of my skills are: PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS. Can start right away.
$250 USD in 7 days
4.9 (93 reviews)
5.6
5.6
User Avatar
Hi there, i skimmed through the instruction. Have worked out the email thing quite a times in our previous projects, so it won't be an issue working it out. I have years of development experience, if you require any details you can surely chat in?
$200 USD in 7 days
5.0 (6 reviews)
4.0
4.0

About the client

Flag of DOMINICAN REPUBLIC
santo domingo, Dominican Republic
4.4
5
Payment method verified
Member since Apr 28, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.