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

$10-30 USD

Closed

Posted

about 4 years ago

$10-30 USD

Paid on delivery

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

Database Administration

Project ID: 24700407

About the project

13 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

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

13 freelancers are bidding on average $42 USD 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

4.9

(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

4.9

(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

4.8

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

$45 USD in 1 day

5.0

(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

4.7

(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

4.9

(5 reviews)

4.6

@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 as Senior System Admin and Linux Admin since long. i have completed many Linux Projects for Different Companies, on OS Including Centos, Ubuntu, Slackware, Fedora and other Linux Operating Systems. Please open a chat so we can discuss the details.

$50 USD in 7 days

5.0

(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 scripts for monitoring purpose and for automate let's discuss more about your task with Regards Rehan

$30 USD in 1 day