Closed

csv file to ftp and then to the database...

1. Create a jailed sftp user on digitalocean (user will upload the file everyday at midnight) e.g. [login to view URL]

2. As the csv file has a fixed format (schema), make a database based on that (MySQL based having phpmyadmin installed)

3. A script via cronjob making a database updated at 3am every night based on the daily file data

4. Credentials of that database so i can connect to external clients

Skills: Database Administration, Linux, MySQL, PHP, Shell Script

See more: import csv file sql database express, upload csv file save database php code, script csv file sqlexpress database, asp upload csv file access database expertsexchange, php upload csv file update database, import csv file sql database oscommerce, read csv file ftp, uploading csv file update database, csv file import database exe, import csv file sql database asp net file uploader, loading csv file access database vb net, sql job export csv file ftp, php write csv file ftp information, csv file generator database, read csv file ftp using php, net csv file import database

About the Employer:
( 8 reviews ) Dubai, United Arab Emirates

Project ID: #24700407

13 freelancers are bidding on average $42 for this job

shihan033010

Hi I can create the php script that will read the data from the csv file uploaded by the user and then it will import the data into the database. Please accept the bid. I am ready to start the project. Thanks Shihan

$25 USD in 1 day
(320 Reviews)
6.8
bindmission

Hello Hope you are doing well. I have 7 years of experience in Linux and Bash scripting . I can setup a script to automate Db upload from CSV according to cron

$30 USD in 1 day
(244 Reviews)
6.7
vuetech8

Hi Is there the task is only to import csv at 3am thats it. There i think all display page is ready to show updated database. I can do this. Thanks

$50 USD in 1 day
(63 Reviews)
6.0
bkkhanny

Hello there, I'm a linux system administrator at a web hosting company. I've dealt with thousand of issues like this and I prove myself to be the best candidate for your job. Please message me for further details. T More

$45 USD in 1 day
(59 Reviews)
5.0
vinaysinghh

I am mysql dba having more then 10 yrs of experience in database field , I have complete more then 100 projects on freelancer.

$56 USD in 1 day
(60 Reviews)
5.5
tutulsoft

ready to work for this cron job for CSV update to mySQL .... everything is under my 20 years MYSQL expertise ..i can start right now ...

$60 USD in 1 day
(5 Reviews)
4.6
ydharia045

sir i would like to make your CSV upload to server and add that CSV data to database at 3am using cron job. i have 3 years experience in web development in php codeigniter. i will deliver your work on time. Days will More

$35 USD in 2 days
(13 Reviews)
3.4
SherGhani

HI, i have read your project descriptions and willing to start working on it. i will create sftp user with specific folder for upload a CSV file and write a script to insert the data in database. I have been working More

$50 USD in 7 days
(4 Reviews)
3.5
rehanalan

Hi I have 3 years of experience in Linux and in transferring file and connecting through SFTP , ssh and scp , file zila currently monitoring 87 AWS servers and configured with I am user and writen lots of automation More

$30 USD in 1 day
(16 Reviews)
3.1
sadaqatali408

HI i have read out your project description: 1. Create a jailed sftp user on digitalocean (user will upload the file everyday at midnight) e.g. [login to view URL] 2. As the csv file has a fixed format (schema), make a datab More

$100 USD in 7 days
(1 Review)
2.4
Andrej126

✋Hi Dear, You project same my old c# project. Please check url: [login to view URL] Technologies Used: C#, Material UI-WPF, Windows Service(Topshelf package), Schedule(Quartz package), SFTP Uplo More

$30 USD in 3 days
(0 Reviews)
0.0
sbcurrin

I can do it for you. I have done this work before. But I am new to freelancer. Feel free to contact me. Shawn

$15 USD in 1 day
(0 Reviews)
0.0
deepa250311

I have completed multiple database . i have done cron job in database . data moving from one database to another database.

$20 USD in 7 days
(0 Reviews)
0.0