Find Jobs
Hire Freelancers

Parse emails and update database via API + PHP

$250-750 USD

Completed
Posted over 2 years ago

$250-750 USD

Paid on delivery
We use a reservation system to manage a car rental business. We receive a lot of email confirmations from several websites, and until now we need to manually add the new customer data and the reservation/booking one by one. We need a PHP code that read the emails from a pop3 account and parse/read the content and add the customer data to the customers table (if customer does not exist). Then add the reservation to the system. The current reservation system provides a clear API that will be used. In case of any failure to add customers or to add the reservations/bookings for any reason, an email must be sent to the appropiate address to inform about the issue for manual addition and later script fixing. The script must be done in PHP and runs via a cron in one of our servers. Must be coded in a strong and clear modular way, with clear functions/procedures and further easy to modify and add new reservation sites. This is the API doc: [login to view URL] Work must be done in 1 week ----- ADDITIONAL INFORMATION FOR CLARIFY -------- Emails come from several websites where final customers book cars (named OTAs) like rentalcars.com. All emails with booking information from same website/OTA have same format. It is necessary to parse the email to obtain the most data as possible: driver name, phone, email, pick up date, drop off date, car type.... It is necessary a table for OTAs: OTA name, email, commission, subject in email, km/day First step is to check if driver exists. If not, must be added. If yes, create the reservation for the client. It seems it is possible to create driver and booking in one shot with /car-rental/reservations/confirm (see API) To create a reservation it is not trivial, since sometimes customer request extras like additional km, or child seats that must be added. May be a table will be needed here to connect text in the email with a extra in the API The requested car model name not always has exact correspondence, We need a table with text file with 2 fields: car model as indicated in the email and car model code in our booking system. For example: "C3 Aircross" and "22" being 22 the car model code in our reservation system. Some times the client cancels the reservation, then we must be able to cancel it (client can remain): /car-rental​/reservations​/{reservation_id}​/cancelled in API. There is a field with OTA reservation code. Then it is necessary to retrieve the reservation_id by searching by the OTA reservation code. If a OTA reservation code is not present, then we must locate the reservation for such client with same dates. When a new OTA appear, must be easy to add a new one, and script must warn via email if unable to process an email due to unknown OTA or unknown format. A lot of emails regarding a reservation are sent, then only the email with specific subject must be processed for each OTA (OTAs send a lot of emails, not only reservations, but we must to process only the email with bookings and with bookings cancelations. We can start with 4 milestones: 1) Setup tables and 1 OTAs and read emails+assign fields to vars inside PHP. 2) Use API to create customers/bookings and cancel bookings 3) Setup the rest of OTAs 4) Final tests Mysql database that can be maintained via phpmyadmin in first version (we will need future improvements, OTA adding...) that will be covered in next project. For example a future improvement will be to send an SMS+email to the customer via smtp and twilio API with some instructions to the customer (arrival instructions, create a form to request data to complete the customer data to avoid loosing time in the office). Now customers come to the office and our employees and they lost time requesting more data that the OTAs do not collect. We can send an SMS/email with a link to a form in our server to fill the customer data that is left blank by the OTA.
Project ID: 31857486

About the project

54 proposals
Remote project
Active 2 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
$0 USD in 16 days
5.0 (54 reviews)
6.7
6.7
54 freelancers are bidding on average $537 USD for this job
User Avatar
Hi, I will develop the php application that can be run by cron. The application will read the emails using pop3. It will add customer data to the customer table in the database and will add the reservation by using the given api. I write clean, standard and documented code. The code will be modular with object oriented concepts with proper functions in the classes. I have read the job description and understand your requirements. I am confident to complete this job perfectly. I have 8+ years of experience in full stack development. I have certified skills in php, java, wordpress, drupal, html, css, javascript and jquery. I will do the best job for you. Please start chat to discuss and proceed. Waiting for positive response. Thanks & Regards, Neeraj
$750 USD in 15 days
5.0 (58 reviews)
6.9
6.9
User Avatar
+++++++++++++++++++++++++++++++++++ Hello There, Hope you are doing well I have checked about your requirements and my skills are a match.  I have relevant 5+ years of expertise in website development, mobile development, Python, Django. Let's meet in personal chat for a quick discussion in it. Thanks Virang Please note that this is a placeholder proposal, we can be more specific once we get all the requirements and information required to execute the project.
$500 USD in 7 days
4.8 (48 reviews)
6.9
6.9
User Avatar
Hi. Hope you are doing well. I have high level expertise in PHP. I have done a similar email in the past where I read the emails from POP3 account and parsed it and then blocked that user email accordingly. This seems easy too. Will provide you top quality work for sure. I can start right now.
$250 USD in 3 days
5.0 (151 reviews)
6.7
6.7
User Avatar
Hi There, I am experienced in such custom made services and working since last 7 years please allow me to work on this and i can easily deliver this project within time and cost. I am available and can start working asap... Waiting for your kind reply. Regards Rony.
$490 USD in 5 days
4.9 (115 reviews)
6.9
6.9
User Avatar
Hello! I Hope you are doing well! I have read your project carefully , can you please come in chat box to discuss the project i am available and ready to start the project I am good at : - Custom PHP, Laravel,NodeJs - HTML5 + CSS3 Styling, Bootstrap, Angular. - PSD to HTML, Responsive web development. - WordPress, Shopify, Magento, Opencart, Sqaurespace, CSCart. - Payment Api Integration, CMS, ERP. - ReactJS, js & jQuery. - Joomla web development. Please review our portfolio and our profile I am happy to answer any question regarding my Skills and experience Looking forward for your positive response and to share ideas for both of us to implement your requirements in the best possible ways ** budget and time frame will be finalized after a brief discussion on completion project** Thanks & Regards smartwinz solutions
$340 USD in 7 days
4.6 (95 reviews)
7.4
7.4
User Avatar
I am expert in php and mail handling using php code. Here is my proposal for this project: 1. I will develop a code using php that will parse the mails using pop3. 2. It will check all unread mails and check for reservation details 3. If reservation details found, it will add new customer and then add the reservation using api given by you. 4. If customer could not be added or reservation could not be done it will send email to you. My requirements: 1. All confirmation email address should be provided so that it may check from specific senders. 2. Mail templates should be predefined so that data parsing is convenient. More details can be discussed over chat.
$600 USD in 2 days
4.9 (166 reviews)
6.2
6.2
User Avatar
Hello Employer, Based on your requirements, I am available and ready to start working with you and complete all of your work-related to PHP, Laravel, JS, HTML 5, bootstrap, and I have Graphic, UI/UX design skills. I have worked on Upwork for more than 1600 hours and completed 100+ websites to date, and I have 99%, satisfied clients. I have had 5+ years of experience in this area. Furthermore, I am well-versed in Photoshop, HTML5, CSS3, and other tools so I can do Responsive coding, which means it will run smoothly on desktop computers, smartphones, tablets, iPads, etc. With daily updates, I am ready to start working with you immediately. The fluency of my English and comfortability of "Voice/ Text" chat make me a good candidate for the job. I'm available to start working immediately and I'll send daily updates when you're online so we can discuss the scope in more detail. Kind regards.
$750 USD in 7 days
4.9 (26 reviews)
5.9
5.9
User Avatar
Hello, I am interested in your project. I have my own IMAP PHP client and have worked before on parsing e-mail messages. Provided the e-mails are in a structured format I believe project can be completed in 7 days. Looking forward.
$750 USD in 7 days
5.0 (8 reviews)
5.6
5.6
User Avatar
Hi there. I am a php expert and familiar with api integration. I am good at HTML, CSS, javascript, jquery, PHP, MySQL. I can start immediately and finish asap. Please get in touch me. Thank you. Best Regards.
$555 USD in 6 days
4.8 (25 reviews)
5.5
5.5
User Avatar
Greetings from Philadelphia. I read all of your requirements and I knew you need a PHP code that. I checked your sample site. Also, this code has to add the reservation to the system. As you mentioned, I will build it using clear modular way. it's very important for modifying and fixing in the development I think. I checked the API documentation and it's really detailed. Because I have enough skills in this field, I am sure that I can finish this project very quickly. We can discuss more details over chat. On there, We will share good ideas. I'm waiting for your reply. Thanks
$500 USD in 7 days
4.9 (10 reviews)
5.1
5.1
User Avatar
Hello There! I have read the description carefully and understood it. I also have reviewed the link. I assure you, you will not be disappointed with my work. Thank you
$500 USD in 7 days
4.9 (39 reviews)
5.1
5.1
User Avatar
Hello. I have read the project requirements. If you hire me, I will do my best to satisfy you. I have a lot of experience in this field. I hope that you will proceed with the detailed contents through dialogue. Respect
$500 USD in 7 days
4.9 (7 reviews)
5.1
5.1
User Avatar
Hi ⭐⭐⭐⭐⭐ PHP/API Expert ⭐⭐⭐⭐⭐ I've seriously read your post/API and I have understood what you need. I am sure that I can be the best candidate who can perfectly complete your project. Because I am very talented not only in PHP/Mysql, Html/CSS/JS, API integration but also in relevant up-to-date technologies. I can perfectly accomplish this project as your requirements, whatever you imagine doing. To start the work, it is necessary to discuss further over chat. My expertise and experience are engaging for many things from quality of work and delivery to fast communication and long-term technical support, to develop your project and business. Best Regards Valeriy
$250 USD in 7 days
4.4 (25 reviews)
5.2
5.2
User Avatar
Hi, I specialize in website design and development. I am very excited for this opportunity to work with you in accomplishing your goals.. I have 10 years of professional skills and experiences in PHP, Javascript, CSS, HTML and Wordpress developments. Please send me a message so that we can discuss more about this project. Regards, Nikita
$500 USD in 7 days
4.9 (13 reviews)
4.8
4.8
User Avatar
Hello there, We will do this job as per your expectation, We have more than 8 year of experience in Website Design & Development, UX Designing, UI Development. We are the ones you are looking for your project development. You will get 100% satisfaction on complete Looking forward to hear from you Cybersify
$500 USD in 1 day
4.5 (20 reviews)
4.5
4.5
User Avatar
Hi, I CAN DO.
$500 USD in 7 days
3.5 (6 reviews)
5.1
5.1
User Avatar
Hi. How are you? Your requirement is very clear. I understood. I am a full stack developer. I have expericence for linux php. I can make you satisify about your six requirement. Message me for your detail. I am looking forward to hearing from you.
$500 USD in 7 days
5.0 (7 reviews)
3.6
3.6
User Avatar
Hi, I understood your requirement clearly. That is possible surely. Cron job and email parse and read, and make booking or reply I can do it within a week. Please give me a message to discuss further
$500 USD in 7 days
5.0 (4 reviews)
3.4
3.4
User Avatar
Hi! I have read your project description and assure you that I am a perfect fit for this job because i have worked on similar projects. I am a senior developer and designer having experience in web development and web Designing using PHP, Laravel, CI, WordPress, Shopify, WooCommerce, BootStrap, UX/UI, CSS, HTML, API’s and many more. My main focus is to give you the best result according to your requirements, message me so we can discuss further your project. Best Regards Nikita
$250 USD in 7 days
4.8 (12 reviews)
3.5
3.5
User Avatar
mailgun? Hi Sir. I am an web developer in Cambodia and have expertise in mailgun. Already built several websites and have full experiences in apis realted to mail. If you entrust me with this job, I can finish it wonderfully in time. I will look forward to hearing from you. Thanks. Doan
$250 USD in 3 days
5.0 (5 reviews)
3.6
3.6

About the client

Flag of SPAIN
Valencia, Spain
5.0
51
Payment method verified
Member since Nov 17, 2014

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.