We have two tables in MySQL:
TABLE NAME: submission_master
TABLE NAME: submission_data
Every day, we would like a cronjob to run:
- that checks for new submissions (submission_master)
- that exports the new data (from submission_data, linked by submission_id) as a CSV file
- an email is sent to a user with the link the download the CSV file
This task is needed quickly
THE CSV FILE SHOULD LOOK LIKE:
HEADER: submission_id, timestamp, element_NAME, element_name, element_name (etc)
DATA: submission_id, timestamp, element_VALUE, element_value, element_value (etc)
DATA: submission_id, timestamp, element_value, element_value, element_value (etc)
There are multiple submission_data entries, per submission. For example submission_id could have 12 pieces of submission data.
29 freelancers are bidding on average $107 for this job
Got Expertise in doing this sort of stuff, get it done within next 4 hour max... All payments through Milestone Payment (Escrow)... Online 16 Hours a day, Can start right away.. Thanks
Hello ! I can develop your submissions system. I have read the cronjob algorythm and understand it. Can you please send me more details ? I see the project is urgent so I can finish in 2-3 days. Thank you !
Easy task! Have done it many times. I can get this ready for you in matter or minutes. Do you want the csv file to be attached to the email or just stored on your server?