In Progress

CRON job or automated task

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.

Skills: MySQL, PHP

See more: import csv into mysql php script, cvs job, action script job, same webiste, update mysql csv php, import csv data grid, mysql cvs, import csv data mysql, import data mysql csv date, check table mysql script, mysql import csv data, batch import php, import files folder, php server cron job, mysql batch process, mysql batch job, cvs mysql, php import csv file mysql, task sheep job, cron mysql, cron job update mysql csv, php cron task, mysql batch, script import mysql file, automate file upload

About the Employer:
( 1 review ) Pickering, Canada

Project ID: #5274588

40 freelancers are bidding on average $115 for this job

toinnisfree

I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor More

$150 CAD in 3 days
(584 Reviews)
8.0
SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] More

$144 CAD in 2 days
(248 Reviews)
7.9
TopSEOExpertscom

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.

$206 CAD in 1 day
(208 Reviews)
7.7
mrroberto

A proposal has not yet been provided

$105 CAD in 2 days
(223 Reviews)
7.3
inspire007

Hi, Its an easy task for me. I will use PHP to code the automated script for you. Ready to start and finish in a day. Thanks

$100 CAD in 3 days
(114 Reviews)
6.4
Zeldaze

Hi nwpdev11, My name is James and I have over 9 years of professional design and development experience. I have been working with many programming languages for the course of my career. I invite you to take a look a More

$150 CAD in 3 days
(110 Reviews)
6.4
mikesteve

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!

$155 CAD in 3 days
(65 Reviews)
6.3
JoomlaVogue

Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us More

$103 CAD in 3 days
(38 Reviews)
6.2
techwelfare

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..

$147 CAD in 7 days
(56 Reviews)
6.2
csajit

HELLO THERE, I AM INTERESTED IN WORKING ON THIS JOB. PLEASE CHECK MY REVIEWS AND THEN DECIDE ON ME. --------------------------- THANKS, AJIT

$105 CAD in 2 days
(155 Reviews)
5.9
cheapexcell

I fully understand your requirements. Ready to start ============================================================================================================

$144 CAD in 3 days
(87 Reviews)
5.9
AlGordo

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

$40 CAD in 3 days
(38 Reviews)
5.9
dinastalb

Hello, I am Van Qaqi. I work with my partners Rolland, Chris and Joe at Netronian Inc., in Orlando, Florida. We have great experience with Web Development. 80 percent of our developed websites are eCommerce websi More

$554 CAD in 15 days
(14 Reviews)
5.9
MaTeMaTiKci

Let's do it

$250 CAD in 1 day
(66 Reviews)
5.8
NeoNoXtraOrdnry

Dear Sir, please see my reputation to make your decision here - [url removed, login to view]

$157 CAD in 3 days
(80 Reviews)
5.5
milliard

Hello, Understanding of the project: You need to run a cronjob with php script, the cronjob will check that the file uploading in a day or not, if file uploading then the data will import to mysql database from tha More

$88 CAD in 1 day
(10 Reviews)
5.5
sourov06

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

$100 CAD in 1 day
(32 Reviews)
5.4
twhiting9275

Hi, I have done something very similar in the past and can have this whipped up for you in a couple of days. I'm assuming that the content of the files (structure) remains the same, as well as the name? So, the tab More

$147 CAD in 5 days
(31 Reviews)
5.2
alphawow

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!

$55 CAD in 1 day
(17 Reviews)
5.1
loufyla

Hello, I'm interested by your project since I have been working with PHP and MySQL for over 8 years now so the task you have asked should be pretty easy for me, I think that a cron job will do just fine for this tas More

$66 CAD in 1 day
(26 Reviews)
4.9