PHP programming needed to track web visitors.
When a (one) web page is accessed, check for cookie, If no cookie, set cookie with unique identifier and input time, date, website domain name, and unique identifier into mysql database. If user enters zip code into form field and clicks form button, record zip code in database in that user's database record. Data must be in specific format.
Identical code will go in a page on second website with the "website domain name" being changed.
Create web page for user to upload xls file to same database. Create script to extract only four fields from xls file, convert them to appropriate format, and load into database. Upon uploading data from xls file, extract data from database from the previous day, (which will include the data just uploaded in xls file), and send as email attachments to several accounts. Data must be in a fixed-width text file in a specific format.
Create web page to display data online. Be able to sort by date range and show totals in each field. Be able to download data as xls file.
All times must be America/New York time (adjusted for Daylight Savings Time/Standard Time). I have some script that does that if you need it.
The attached files show the requirements more thoroughly.
There are 17 fields which must be outputted daily as a fixed width text file and sent as an email attachment. 10 of those fields are hard-coded (1-9 and 14). They will not be necessary to have as database fields, but can be added programmatically when outputting the text file.
*Telemarketing Data File Layout [url removed, login to view]* has the specifications of the outputted text file.
*Template [url removed, login to view]* shows the file layout of the data which will be converted and put into the database.
Please contact me with your questions before you waste time creating code which you will need to change. This project seems complicated, but it is really pretty simple.