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: create account number query microsoft sql, programmer fixed pay, query sql server access 2007 vba, fixed pay job usa, additional fixed pay, php coder pay happy, pay pal aud oscommerce fix, access filter sql apply query, sample excel sqlrequest access db2 sql, converting access database sql server 2008, conversion access 2000 sql server 2005, convert access 2007 sql server 2005 express, convert access aspnet sql server, 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 [url removed, login to view], Russia. I have checked "[url removed, login to view]" 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 '[url removed, login to view]' 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 [url removed, login to view] 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