donwload csv file into mysql+ dedup records+ send mails
Download a zip file, extract file nummers.csv, import/append nummers.csv into table nummers.tbl of mysql database query table for latest changes send mail every day (to be set as cronjob) to users with list of all records changed since last email De-duplicate the table nummers.tbl (Records are equal when specified fields, are equal (list of fields to be set in settingsfile or -settingstable) Query table for: All records where twn_nummertm is NOT unique AND/OR All records where twn_nummervan is NOT unique Send mail to users with results (all double records who are NOT equal) Delete double equal records (just 1 record to be kept in table) As you see not a too big job, but description might be reason for a lot of questions first. Please ask them. I allready have some starting scripts for: downloading zip-file and appending to table in mysql (bulk import) Project has to be finished within 7 days Regards, Eef Keywords: Translation, MySQL, CSV, Flash, Ajax, CSS, Report, Mail, Cron
| Expired |
Marissabel Hiers
Transcription Specialist
View profile
Chad Schneider
Graphic Designer
View profile
Melissa Mostyn
Copywriter
View profile
More mysql projects
View AllMore css projects
View AllRelated projects
Search for freelance jobscan’t wait for more clients
and advertising. Thank you."