I have an existing webiste that displays customer information in a grid. The data currently comes from 2 CSV files that I manually upload into the MySQL database. I am looking to automate this either leveraging CRON or other batch process you can recommend, develop or suggest. This script must do the following on a nightly basis
1. check the server to see if files have been uploaded. The file names are always the same and uploaded only to a specific folder on the server
2. If the files do not exist the script terminates with not action
3. If the files exist it will import all the data in each of the CSV files to the appropriate database table.
4. Once the upload has been successful another update will be done on two fields in another tablet with the date this action was performed.
5. Finally the 2 CVS files are deleted from the server
Hope that properly explains what I'm looking for. If there are any further questions please let me know.
40 freelancers are bidding on average $115 for this job
Hi, Here's my bid to create the script for you through a CRON job that will be fired daily at midnight. Let me know if you have any questions before awarding me the project.
Hi, Expert here. I have read your project details. I can setup a script through CRON that'll do all the stuff for you. Send me files and database details and lets start! Thanks!
hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat..
I fully understand your requirements. Ready to start ============================================================================================================
This can be done with a simple PHP/MySQL script, that's why I made a low bid. I am a member of this site for 8 years and fulfilled many similar tasks. Please contact me to discuss further details. Best Regards, Al
Hi, I am a professional web developer.I worked in a software [url removed, login to view] I have left the job and start as a fulltime freelancer. I am an expert in [url removed, login to view] project seems to be easy one.I can do [url removed, login to view] you allo More
Hello and Happy New Year! I am wiling to work with you on this project. I can 100% complete required task and I can start work right now. Please, contact me and lets start. Thank You!