Devam Ediyor

Parse emails and update database via API + PHP

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.

Beceriler: PHP, MySQL, Yazılım Mimarisi, HTML, Linux

Daha fazlasını gör: update database php, use database multiple php scripts, php message board reply update database, update database closed php, php script sample car rental, code update database mysql php, parse xml response file api php, update database email php, update database hour php, update database mysql php, php update database api, agemni database api php, api rest php update database, can update database onclick php, parse emails to database

İşveren Hakkında:
( 39 değerlendirme ) Valencia, Spain

Proje NO: #31857486

Seçilen:

(45 Değerlendirme)
6.4

Bu iş için 57 freelancer ortalamada $535 teklif veriyor

(379 Değerlendirme)
8.9
(522 Değerlendirme)
8.8
(252 Değerlendirme)
8.0
(258 Değerlendirme)
7.4
sapnathakur14

Hello, Warm Greetings!!   I read your job description completely and I found my skills relevant to your project. I am a professional web developer with 5 years of programming experience for a multitude of different t Daha Fazla

$500 USD in 7 gün içinde
(84 Değerlendirme)
7.5
(183 Değerlendirme)
7.2
VileGnosis

I can set up a PHP script to receive emails and extract the information. Then put it into your system using the API. My average project completion time is within 3-5 hours on the same day. The skills I have include PHP Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(268 Değerlendirme)
7.1
(164 Değerlendirme)
7.0
smartwinz

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,NodeJ Daha Fazla

$340 USD in 7 gün içinde
(91 Değerlendirme)
7.4
vashishtrupinder

Hi I AM READY TO START NOW I read through the job details carefully and I am absolutely sure that we can do the project very well. In a nutshell, I'm a freelancer with more than 7 years of work experience. in BOTH Daha Fazla

$550 USD in 7 gün içinde
(117 Değerlendirme)
6.8
rony045

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 Daha Fazla

$490 USD in 5 gün içinde
(112 Değerlendirme)
6.9
(32 Değerlendirme)
7.0
asiflak

✔️ Hey There, I already worked on similar projects to this one and I assure you 100% what you are looking for.✔️ I am working as a Wordpress expert for last 5 years so I assure you a satisfied job and on time completio Daha Fazla

$250 USD in 5 gün içinde
(117 Değerlendirme)
6.6
neerajmorya

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 Daha Fazla

$750 USD in 15 gün içinde
(46 Değerlendirme)
6.4
saubhagyamweb

+++++++++++++++++++++++++++++++++++ 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 devel Daha Fazla

$500 USD in 7 gün içinde
(30 Değerlendirme)
6.2
purplemaestro

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 Daha Fazla

$250 USD in 3 gün içinde
(117 Değerlendirme)
6.3
TechnicalKnight

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 reser Daha Fazla

$600 USD in 2 gün içinde
(137 Değerlendirme)
6.1
(10 Değerlendirme)
6.0
(46 Değerlendirme)
5.8
swapnilparkhya

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 Daha Fazla

$750 USD in 7 gün içinde
(25 Değerlendirme)
5.9