Order DaTa Transfer from PHP Website to Microsoft Access
$30-5000 USD
Closed
Posted about 13 years ago
$30-5000 USD
Paid on delivery
We accept orders for our publications through our website or through a fax form and the order information comes back into what we think is a PHP database on our site. Currently we type this info into our Access based program but we want to transfer this info automatically into our Access program. Since some orders are repeat orders, and the basic info is already in our Access database we want a program to export the website order info into Access, to open a new file when the ordering individual is new, and to slot it into a pre-existing record when it is a repeat orderer.
Here is what the data in the web file looks like:
Report: Survey of Academic Libraries 1 copy
ipping Details
First Name: Janice
Last Name: Smith
Email Id: smithyr@[login to view URL]
Phone: 812-811-1111
Company Name: Indiana University Libraries
Address: 1111 E. 500th Street
City: Bloomington
State: Indiana
Country: United States
Zip: 47405
Billing Details
First Name: Janice
Last Name: Smith
Email Id: smithyrr@[login to view URL]
Phone: 812-855-1000
Company Name: Indiana University Libraries
Address: 111 E. 40th Street
City: Bloomington
State: Indiana
Country: USA
Zip: 47405
Total Amount: $98