Find Jobs
Hire Freelancers

CRON job or automated task

$30-250 CAD

In Progress
Posted over 10 years ago

$30-250 CAD

Paid on delivery
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.
Project ID: 5274588

About the project

38 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
38 freelancers are bidding on average $113 CAD for this job
User Avatar
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 satisfactorily completed. I estimate a 2-3 day turnaround (including weekends) on this project. ftp details to your site will be required. Contact me at your soonest convenience so we may get your solution delivered quickly. Thanks, coderXO
$150 CAD in 3 days
4.9 (770 reviews)
8.3
8.3
User Avatar
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
5.0 (249 reviews)
7.9
7.9
User Avatar
A proposal has not yet been provided
$105 CAD in 2 days
4.9 (317 reviews)
7.6
7.6
User Avatar
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 at my profile to get an understanding of my respectable work ethic. I am very confident I can deliver the solution you require. I am experienced working with PHP and MySQL and developing similar scripts. As you suggested, I believe setting up a CRON job would be the best for this kind of task. Looking forward to working with you. Let me know if you have any questions. Thanks, James
$150 CAD in 3 days
5.0 (323 reviews)
7.3
7.3
User Avatar
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
4.9 (122 reviews)
7.2
7.2
User Avatar
Dear Sir, please see my reputation to make your decision here - http://www.freelancer.com/u/NeoNoXtraOrdnry.html.
$157 CAD in 3 days
5.0 (93 reviews)
7.2
7.2
User Avatar
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
5.0 (159 reviews)
7.1
7.1
User Avatar
I fully understand your requirements. Ready to start ============================================================================================================
$144 CAD in 3 days
5.0 (135 reviews)
6.7
6.7
User Avatar
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
4.9 (282 reviews)
6.8
6.8
User Avatar
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
4.7 (181 reviews)
7.2
7.2
User Avatar
Dear Sir, I'm expert PHP Open Source developer. I have done a lot of projects which are based on Open Source Technologies. I can complete your task very quickly. Let me know if you are interested. I'm sure you'll inspire with my work strategies. I'm expert in Open Source Technologies, Mobile Development, Website Designing, Graphic Designing etc . Looking forward to your quick response! Thanks Ssplancer
$100 CAD in 3 days
4.8 (75 reviews)
6.2
6.2
User Avatar
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
4.8 (48 reviews)
6.1
6.1
User Avatar
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 task. The few things needed would be the structure of your csv files, mysql tables and directories to find the csv files. If you have examples csv files it would be great to have them, as well as the structure of the table (as when you do an export). You also talked about two other updates to perform after the first ones, what is it ? Best regards, Laurent.
$66 CAD in 1 day
5.0 (36 reviews)
5.5
5.5
User Avatar
Hello, I work as a Linux/Unix system administrator for the past 10 years and have all the necessary skills and hands-on experience to complete the task. Hope to hear from you soon.
$55 CAD in 3 days
5.0 (32 reviews)
5.5
5.5
User Avatar
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 tables won't change that much? If you'll look at my profile (https://www.freelancer.com/u/twhiting9275.html), you'll see 100% positive (5 star) feedback, high completion (I don't abandon projects, but there are times employers take work and cancel to avoid paying) and a link to my own site where I've done the same for better than 10 years now. Your project will be completed with the same diligence and persistence. Your task will be completed within the advertised period of time, and be given everything needed to be done right. I look forward to hearing from you and working with you on this project. Tom Whiting
$147 CAD in 5 days
5.0 (32 reviews)
5.3
5.3
User Avatar
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 that uploaded csv file. Queries: Hows the 2 files will delete? Regards, Milliard
$88 CAD in 1 day
4.6 (31 reviews)
6.1
6.1
User Avatar
I recently wrote a php csv client for one of my clients. I have good experience in php, mysql. Also I have worked in linux environments. If you are using CPanel that will be perfect. I can easily use the UI to easily create a cron job.
$89 CAD in 3 days
5.0 (8 reviews)
5.4
5.4
User Avatar
Hi, I can create a cron job which will import the csv file into the mysql database. I have over 13 years of Experience in software design, development and implementation of various commercial applications in Client/Server environment, Web and ERP applications using C# 1.1/2.0/3.5, ASP.Net, VB.Net 1.1/2.0/3.5, AJAX, Visual Foxpro, DOTNETNUKE, VB 6.0, Crystal Reports 8.5, ASP, PHP, JSP tools, PL/SQL, MS SQL Server 2000/2005, My SQL. Regards, Sunsri Infosys
$166 CAD in 2 days
5.0 (19 reviews)
4.3
4.3
User Avatar
Hello I am a PHP and MySql developer with numerous projects completed on this site. I can quickly build you a small script that can run as a Cron job, to pickup the two CSV files on a schedule and import into your MySQL database (Will the script need to check for duplicate entries on the database?). I have successfully delivered numerous scripts such as these on the site, and can have this one ready for you within a day or so; I am available to begin immediately. Best regards, Brent
$140 CAD in 3 days
5.0 (18 reviews)
3.9
3.9
User Avatar
Hi, I'm new to freelancer, but doing PHP from 2002. Also I love data mining projects, so I've done several tasks like this. I can start imediatelly working on this project. Yes, I would suggest CRON for this, so You only need to upload the CSV files. Or if You have no CRON-availability You also can set any of Your machines (preferably a server that is working 7/24) to load an URL on Your site, that will do the import and delete the files (I suggest not to delete, but to move the files to a 'processed' folder to save it if You need that later) For start working on it I'll need the CSV files - or at least a sample of them and the DB schema of the tables involved. After I'm finished I can help You setting up this importscript via FTP or by writinig down what You should do step by step. Please note: since I have no reviews here I do not require any payment before finishing the project and You are happy with the result. Please let me know if You have any questions, thanks!
$85 CAD in 4 days
5.0 (3 reviews)
3.9
3.9

About the client

Flag of CANADA
Pickering, Canada
5.0
1
Payment method verified
Member since Aug 29, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.