Script to convert contact details in the body of an email to populate the filds of an existing php form

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I have a database of sales leads and I get an email for each enquiry and want to simplify the sales leads input to my sales leads table in the mySql database - I got 49 emails today

This is a sample of the data

_contact_id_ l-007c:1c61f

id11n 1789410

business_name European Schoolbooks Ltd

add1 The Runnings

add2

locality

town Cheltenham

county Gloucestershire

postcode GL51 9PQ

Area South West

Country England

postcodearea GL

postcodesubarea GL51

LineOfBusiness Representative Office

product_category

sicnumeric 74151

SIC_Description Management activities of wholesale holding companies

telephone 01242245252

tps 0

fax

fps 0

employeesnumeric 20

premises_type UC

title1 Mr

First Name Frank

Last Name Preiss

position1 Managing Director

E-mail Address fap@[login to view URL]

emaildomain [login to view URL]

website [login to view URL]

Is there a way to copy the text from this email and paste it into a single form field - and that would then submit to a script which would separate out the heading and the data convert it to populate an existing input form ?

It could take the first part and that could be the field name - and the second part could be the data -

then I can have it submit through a script / php file to pair the field names to the form felds which are required. ( I only need about 20 fields from the email data - not all of them )

business_name European Schoolbooks Ltd

add1 The Runnings

form field name: business_name

data: European Schoolbooks Ltd

form field name: add1

data: The Runnings

So the code would look something like

if(!empty($_POST['Save']))

{

$business_name = $_POST['business_name'];

$address_1 = $_POST[‘add1’];

The sales company sometimes change databases - so the structure of the email data does sometimes change - For example another data source may call business_name as company_name - so I need the option to be able to edit the php form to accept this.

I attach the existing form

MySQL PHP Script Install

Project ID: #14499005

About the project

17 proposals Remote project Active 6 years ago

17 freelancers are bidding on average $153 for this job

minhhoangduc

I'm a PHP/Drupal/WordPress/Laravel/Slim Framework CERTIFIED EXPERT coder. And have a lot of experience with System admin + Html + Javascript + CSS + API integration Relevant Skills and Experience Please have a look at More

$77 USD in 1 day
(631 Reviews)
8.4
mithusamsukha

I can do this very easily even i have done this many a times. Kindly initiate chat ones so i can discuss the problem clearly, and help you out surely. Anticipating your reply Regards, Mithu

$210 USD in 3 days
(84 Reviews)
7.9
ravinder246

Hello, I have read the project requirements and have checked the existing form and can do this work but need to discuss in detail before start the work. let me know when can we discuss, Relevant Skills and Experienc More

$200 USD in 3 days
(393 Reviews)
8.0
usuf001

Hi, I can code the script to insert the email content to db leads table via email piping without using forms. Thank you, Syed Relevant Skills and Experience Hi, I have 9+ years of experience in PHP/MySQL and Linux. More

$155 USD in 0 days
(603 Reviews)
7.3
srajbr

Hello, Can you send me 3-5 emails in text file for further analysis. I propose to create a form where you will input the text and click submit. This will direct to another page which will display parsed data in a form More

$150 USD in 4 days
(29 Reviews)
6.5
kawalecove

Hello Sir, I checked your requirement and i can do that can you please contact me so that we can discuss further. Relevant Skills and Experience We are a team of 45 persons including developers and designers and all h More

$133 USD in 3 days
(61 Reviews)
6.2
abbalove

Hello, I am expert in PHP. Can we discuss about it ? Rocky Stay tuned, I'm is still working on this proposal.

$65 USD in 3 days
(43 Reviews)
5.1
pinaliv

5 Reasons why you should hire me for your custom website and Application Development. 1. Available 24/7 upon your request 2. Delivery on-time with 100% satisfaction 3. Always think beyond boundaries and. provide More

$222 USD in 3 days
(19 Reviews)
4.7
soorajbloggerr

i can do this Relevant Skills and Experience i have sample code with me. Proposed Milestones $30 USD - adding data from email to another form

$30 USD in 0 days
(1 Review)
0.1
trybemark

I'll Develop a response website with a Desktop/Mobile UI For users on cross platform usage!! -- You have a nice concepts? drop your details and tell me more about your work and I'll meet up with the deadline! I use P More

$55 USD in 0 days
(0 Reviews)
0.0