Find Jobs
Hire Freelancers

Data Import from space delimited txt file into a MySql table

$10-30 USD

Completed
Posted about 9 years ago

$10-30 USD

Paid on delivery
Create a script for automating and scheduling the process of importing a space delimited txt file into an existing MySQL table, It includes data cleansing to remove typographical errors. The files are logs which are generated daily. There is one log file for each day. The script will import only the last updated log on file. The table is already done and populated. The existing table structure cannot be modified. Data imported must be consistent with the existing data. Log file must be removed 7 days later after successfully import
Project ID: 6948647

About the project

17 proposals
Remote project
Active 9 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
Awarded to:
User Avatar
Hi! This is pretty easy work for me. I can complete it in less than a day and I can offer you best price here. Please give me database schema and log samples. Thanks. Roman
$25 USD in 1 day
4.9 (124 reviews)
6.2
6.2
17 freelancers are bidding on average $49 USD for this job
User Avatar
Requirement is pretty clear. I can do this job for you. Looking forward to hear from you. Thanks Rinsad
$24 USD in 1 day
4.9 (548 reviews)
8.2
8.2
User Avatar
Hello. I can help you with this task. Please provide me with a DB schema dump and a sample log file to start a demo for you. Access via shell to your server will be needed later to implement file removal and cron jobs to schedule the importing. Thank you.
$333 USD in 3 days
5.0 (7 reviews)
6.1
6.1
User Avatar
Hello Mate, I have completed the script up to some point. no need to automate log file deletion after 7 days. Once I have done it, the script is ready. Thanks!
$100 USD in 1 day
4.9 (62 reviews)
5.6
5.6
User Avatar
Hi, I have gone through your requirements. I am 12+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle ,Sybase (12.5) ,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards, MySQL. Data Base Tools : Database Configuration Assistant, Database Migration Assistant, OEM, SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN, DataPump, AWR, ADDM, Asmcmd, Asmca, Tkprof Big data : Hadoop Ecosystem No SQL :Mongo DB, Neo4J I think I Can do your work easily. Let me know when we can discuss.
$60 USD in 2 days
4.4 (31 reviews)
5.2
5.2
User Avatar
send mysql database
$25 USD in 0 day
4.9 (5 reviews)
4.1
4.1
User Avatar
plz come on chat now so we can discuss more....am waiting... Dear Sir, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Regards, Bhagwan
$10 USD in 1 day
4.9 (7 reviews)
3.1
3.1
User Avatar
Hi, I'm an expert DataBase Administrator and web developper. I can do your job, i'll probably do a better job using perl if possible on the server, because it's optimized for this kind of task. Sincerely yours, Eric
$25 USD in 2 days
5.0 (3 reviews)
2.8
2.8
User Avatar
Wed, 07 Jan 2015 15:44:34 +0000 Data( inconsistent) in log files to be modified or dropped? Log file to remove after 7 days of logging or after 7 days of import?
$25 USD in 1 day
5.0 (2 reviews)
1.2
1.2
User Avatar
I'm a programmer with a wide experience in data manipulating with bash files and i have +6 years in this area
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
It will take one and half day for developement and half day for testing. Accordingly I can deliver code to you in 2 days.
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this job using PHP and BASH scripting. (There is nothing more to say but this site wants to add a proposal at at least 100 chars)
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have experience with MySQL and shell scripting and I can do this. The only concern I have is about data cleansing. I think I would need more details on what kind of typographical errors should be considered.
$15 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am a software developer, and i have very well field engineering experience. I am a mysql and unix admin.
$40 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, expert web/data scraper here with over 17 years experience in programming and RDBMS - please see my reviews. I'm using Perl for this kind of jobs. I'm able to finish fast.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Bronx, United States
4.9
52
Payment method verified
Member since Feb 1, 2013

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.