We need a page designed that will allow us to upload a CSV file with data in it and allow it to append (Add) this data to a mySQL database. We want the database updated with every upload of the file without creating duplicate records though. We would like the person to show us a working representation on their site first. And then they will upload the file onto our server hosted by [url removed, login to view] and setup the SQL database using our log-in for the control panel.
To show the information is posting we just need a 2nd page that will allow you to input a name and return the 'tracking value'.
The fields in the database are going to be. Customer Name First & Last, Email address and Tracking Number (for shipping services).
Please PM us w/ any questions. We would like this done asap and don't care if its simple html or if its done cleanly in PHP/ASP (which we prefer).
Please note we have supplied a CSV file here.
We also must note that we need the information to be permanently stored in the database and updated by every CSV file thats uploaded.
Also, We need the upload page to verify that the tracking number isn't already in the database.
The Lookup page should be a seperate page from the csv posting page and should require the persons email address and zip code to retrieve the appropriate data from the MYSQL database.
The programmer will need to set-up the database appropriately for us on a site hosted on Godaddy Servers Using MYSQL 4.1 database