Cancelled

Sql query

Create an mySQL query on Cpanel which will import data from .txt files stored on the Cpanel ftp once a day. I have attached samples of the .txt files. There are multiple files on the ftp, they are labelled with todays date in reverse order i.e. YY-MM-DD. The file contains time stamps and a count. The query needs to import the file with todays date, and separate the time stamp and count. The query must be automatically triggered to occur once a day, at 12:30am.

Skills: Microsoft Access, Microsoft SQL Server, MySQL, PostgreSQL, SQL

See more: programmer fixed pay, fixed pay job usa, additional fixed pay, php coder pay happy, convert microsoft sql bak

About the Employer:
( 13 reviews ) Hawthorn, Australia

Project ID: #11730722

41 freelancers are bidding on average $191 for this job

TakeReal

Hello, My name is Sergey. I am Freelancer from St.Petersburg, Russia. I have checked "16-23-10.txt" I can help you as PHP programmer to create script to run it everyday at 12:30 AM and import CSV files via FTP and More

$140 AUD in 1 day
(1060 Reviews)
7.4
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser More

$147 AUD in 3 days
(76 Reviews)
7.2
truongnguyen86

Hello there, i'm expert on MySQL, actually i'm doing a job with load data from text file, we can use the command LOAD DATA LOCAL INFILE 'file_path' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '' More

$250 AUD in 3 days
(147 Reviews)
6.5
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & More

$155 AUD in 3 days
(15 Reviews)
6.0
arityinfoway

Hello Sir, I have gone through your requirements regarding Sql query. we brief and understand your idea and preference for job as you are looking for. I have more than 6+ years of experience in .NET, c#.net, vb.n More

$210 AUD in 10 days
(24 Reviews)
5.5
innovativeatul

Hi, I had understood that you want to create a SQL query which will import the data in the cpanel ftp once a day. I had viewed your attached file and had also done work on the automatic time stamp and count. P More

$200 AUD in 3 days
(24 Reviews)
5.5
phiona06

Hi! I can create shell script that can be scheduled in cron. This shell script will execute mysql command like this LOAD DATA INFILE 'YY-MM-DD.txt' INTO TABLE ... with some additional options (path to file, mysql con More

$50 AUD in 2 days
(31 Reviews)
5.0
royalcalif

Hi Mr. Employer I can do this project in effective manner with 100% accuracy report to your requirements. I have lot of experience in SQL query and make backups in sever too. Price might be negotiable during discuss More

$135 AUD in 6 days
(24 Reviews)
4.9
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$55 AUD in 2 days
(29 Reviews)
4.5
cftsoft5

Greetings! I have read your job and i can do this job with in time and with good quality. I have 5 years of experience in web development MySQL database and queries. I can do this job as you want . Please let me kn More

$130 AUD in 1 day
(13 Reviews)
4.6
$155 AUD in 0 days
(28 Reviews)
5.2
davedcb

Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. Thank you, Best regards, David

$150 AUD in 5 days
(23 Reviews)
4.1
bhagwansahane89

we can do this with a simple php script which import everyday automatically at a given time ....come on chat....thanks

$40 AUD in 1 day
(10 Reviews)
3.9
amitarai

Hello My name is Pranav I have checked the details shared by you will do done exactly what you want Please consider my bid and we can discuss more so that i can assist you in better way our services always with More

$155 AUD in 7 days
(9 Reviews)
3.6
Dilipjaipur

Hello, I have ranking in top 4000 on freelancer.com and I hope it will give you an idea about my work quality and dedication to work. You will be safe while working with me. I have dedicated in house team for Wo More

$555 AUD in 20 days
(1 Review)
3.2
sid0

hi sir, can you please provide us detail about your project ?? We will provide you best service than anyone else....

$388 AUD in 7 days
(17 Reviews)
4.9
SamamaJaved

Me and my team are working on the database projects.. have great experience in database. i can do this for you... this is to be done in 2 days.. contact me so that we can proceed further....

$111 AUD in 2 days
(6 Reviews)
3.2
amir12345

Hi Dear hiring Manager, I am interested in the position of (SQL query) you recently posted. I have been a professional Developer for 4+ years, and i am very familiar with PSD to HTML,Wordpress,Twitter Bootstrap, CS More

$133 AUD in 1 day
(3 Reviews)
3.1
swarm22

I have +5 year experience in SQL Query. To Provide Quality,modular and object oriented coding. Regards

$222 AUD in 3 days
(7 Reviews)
3.0
WebXcellance

Hi There, Team WebXcellence here. How are you doing? We are one of the fastest growing company in Central India having more than 6 years of experience serving customers in US, Mexico, London, India, New Zealand, More

$568 AUD in 12 days
(6 Reviews)
3.5