Find Jobs
Hire Freelancers

Automate SQL Dump to CSV format Conversion at Regular Intervals.

$250-750 USD

Closed
Posted about 7 years ago

$250-750 USD

Paid on delivery
We currently export data from our ERP system which is exported into a flat .SQL file format every x minutes. Instead of Importing this .SQL into a database to then export the data needed again to a CSV format, we wanted to if possible convert the .SQL file straight into a usable CSV with the required data. IF This is NOT possible, we would like for someone to setup the automation of Importing the .SQL into a database and then setting up the automation of exporting the required data from the Database into the required .CSV Format. When bidding please state which method you are bidding to do, what setup you would use to achieve this & your estimated timeframe to complete the project. ALL BIDS WITH GENERIC / CANNED RESPONSES WILL BE IGNORED.
Project ID: 12879832

About the project

52 proposals
Remote project
Active 7 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
52 freelancers are bidding on average $550 USD for this job
User Avatar
Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat.....I will share some demo as well for recent works if you want to check. You can also check my profile page as i have around 31% Repeat Hire Ratio..so i work as long term basis...
$824 USD in 10 days
5.0 (173 reviews)
9.4
9.4
User Avatar
Hello, and thanks for the opportunity to bid on your project. I have lots of experience for database process and csv processing on mysql Please check my profile https://www.freelancer.com/u/TenStar718.html I will use php in programming within 7 days I am sure i can do your project as well Please message me for good business
$400 USD in 5 days
5.0 (255 reviews)
8.9
8.9
User Avatar
Hello! I can build a PHP script that would convert the .SQL to .CSV which you can directly import into your Magento store. I'll need input (.SQL) and output (.CSV) samples. With 98% to 99% completion rate, 900+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :) I am available to get started on your project right away. I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$277 USD in 2 days
5.0 (1045 reviews)
8.9
8.9
User Avatar
Hi The requirement stated by you is doable. If possible can you specify which ERP are you using as SAP gives an option to export data directly to CSV. Even if this is not an option, we can code a script to convert .SQL file directly to CSV file. We estimate to complete this task in 7 days. What works for us is our expertise in handing MySQL, PHP development projects. We thank you for considering our bid and look forward to hear from you. Saurabh
$526 USD in 7 days
4.9 (473 reviews)
8.7
8.7
User Avatar
Dear Employer, I am ready to work on your required task and can assure 100% satisfaction. You can read reviews/details about my past work on my profile http://www.freelancer.com/u/alyaspk.html Looking forward to an opportunity to work with you. Warm Regards, Muhammad Alyas
$526 USD in 10 days
5.0 (195 reviews)
7.5
7.5
User Avatar
Hello, As an expert in SQL related works, i am very much interested to do this work. I am bidding for the method which will be as like import the .sql file into database first and then export to csv file. As i am expert .Net developer, i would prefer to develop the program using .Net, so you will just need .Net framework installed in your PC to run this. We can discuss more. Please let me know if you are interested in my bid. Thanks
$300 USD in 5 days
5.0 (302 reviews)
7.7
7.7
User Avatar
Hello. Thank you very much for taking time to read my proposal. I can do it. There are tons of methods to do that but I did not get the point why you do not export it to CSV first. I can write php code to do that but i do not know what coding ecosystem you have. We can discuss further details. Hopefully, both of us will be happy after the job is done. Best Regards.
$250 USD in 3 days
5.0 (223 reviews)
7.7
7.7
User Avatar
Hello Sir, i have done a similar concept of work, we can deliver the work. if possible then lets have some conversation and discuss the project in brief. hope we can get a positive response. looking forward your reply. thanks Technovinity Systems Pvt Ltd
$400 USD in 7 days
4.7 (275 reviews)
7.6
7.6
User Avatar
Hello, This is not copy/paste message. I read your requirements. I am interested for this job. I have expertise in Wordpress, Laravel, Magento, AngularJS, Ruby on Rails, Core PHP etc. technologies and can work on task and complete within deadline. I have good experience in PHP/Ruby Programming with JavaScript, jQuery, SQL and I can achieve your task. I can provide you 40 hrs/ week productive work for 1 resource and I have predefined process which can easily understandable by clients. I will directly in your contact and I will also do Chat / Audio call with you daily, so that there will not be any communication gap. Also if you will face any productivity issue, our resource will come during weekend and finish the work. Also I will daily send you progress report and will also available online, so that you can contact him whenever you want. So overall you will not face any communication gap between you and our resource. It will be my pleasure to work with you. You can go through my portfolio. I have more then $30k official work in other freelancing site with 5/5 ratings which I can show you. Please send me message, so that I can converse further about this task. Best Regards, Mehul Javia
$555 USD in 10 days
5.0 (51 reviews)
7.0
7.0
User Avatar
My name is Mike, I’m from UK. I work with individual clients and agencies who have design, development and SEO needs. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.
$555 USD in 10 days
4.9 (48 reviews)
6.9
6.9
User Avatar
Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customization, I want to discuss this project with you further on personal chat. Let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, I use to be online 24x7 on Freelancer so probably you will get a quick response from my end.
$773 USD in 10 days
5.0 (27 reviews)
7.0
7.0
User Avatar
Hello, I have gone through your outsourced requirements "Automate SQL Dump to CSV format Conversion at Regular Intervals." and have analyzed that I have right skills (Excel, MySQL, PHP, SQL) to execute your esteemed project. I will complete your project within 2 weeks, LIFETIME error free guarantee and provide 365 days (ONE YEAR) support... ===== Why choose me? ===== 5.0 / 5.0 rating, 100% completion rate, 100% on-time completion, 100% on-budget :) Kindly, check my profile: http://www.freelancer.com/u/BitLabs.html I work smart, hard, and strictly bid only what we can do! No sub-contracting... ever! You will never go wrong choosing me :)
$562 USD in 365 days
5.0 (115 reviews)
6.7
6.7
User Avatar
Hi there, I am java developer. I can develop a module for .sql to .csv conversion. I can develop a simple tool in java which can do this job. Or most probably java service which you can directly call from PHP code. I have done this kind of job like xml to csv, json to csv etc. Message me, we can discuss over chat.
$600 USD in 2 days
5.0 (48 reviews)
6.0
6.0
User Avatar
Dear client, how are you? I am a C++ programmer and mathematician. Interesting. Seems task is VERY APPROPRIATE for me. I expect this project for $2000/30 days. You can run another realtime program on your server with some optional parameter for your request. I will make and provide realtime program. This program will continuously convert your data into CSV files in requested intervals. If you want to turn off this program(console program), you can do so easily. And when needed, can run again anytime. Please check my "Profile & Work List" and tell me details if my skill is in your concern. Looking forward to your response. Thanks.
$2,000 USD in 30 days
5.0 (5 reviews)
5.3
5.3
User Avatar
Hi sir, I have read well your requirements, and I have some questions first. Where is hosted the ERP system ? When the .SQL is generated, is it possible to access that file through a link ? What we can do is this : We can write a script on the server which one is ran at a time the .SQL file is already generated. The script will execute and produce another file (new CSV) on the server and send the link to the file via an email, for direct download. I can do this in 3 days. I have the skill to do all what I have said. Waiting for suggestions, or to talk about the project. Regards
$500 USD in 3 days
5.0 (32 reviews)
5.2
5.2
User Avatar
Hello, I can make the script to convert .sql file to .csv file. Can you provide me part of the file that you receive, so i can make some tests. Contact me if you are interested.
$255 USD in 10 days
5.0 (20 reviews)
4.8
4.8
User Avatar
Hello, My name is shahid from Kashmir Over the last 7 years, I have worked for several clients. Joined Freelancer with over 7 years rich experience in the field.I have successfully completed more than 1000 projects in this field you will be glad to know that I am best fit for your project my key skills are. Python Email developer, software architecture and Scrapping expert with 5 years of experience. Linkedin API developer. Using Python, Wordpress , C Programming , C++Programming, Linux,PHP,MYSQL ,Java ,Javascript, ,Website Design ,Graphic Design,CSS,Research,WordPress ,Magneto ,MATLAB and Mathematica ,Leads ,Web Search ,Machine Learning ,HTML5 ,LinkedIn ,Landing Pages ,Web Services ,Internet Research ,Angular.js ,,Data mining,,Web scrapping,Find contacts, Data Processing, Data Entry, Excel, Leads, Web Search, Data Mining, Linked in, Microsoft Office, Email handling. I am a highly skilled web researcher,data entry provider seeking an opportunity to leverage my expertise and demonstrate my high level of technical an administrative skills. I have successfully completed more than 100 projects ranging from, WordPress , C Programming , C++ Programming, Linux,PHP,MySQL ,Java ,JavaScript ,Website Design ,Graphic Design,CSS,Research,WordPress ,Magneto ,Leads ,Web Search ,Machine Learning ,HTML5 ,LinkedIn ,Landing Pages ,Web Services web research, data entry, Internet Research, LinkedIn , Lead Generation, Google docs & Excel Spreadsheet creation/editing. You can test the quality of my work and also i provide work at best price in the market. Regards: shahid.
$253 USD in 0 day
4.6 (11 reviews)
4.9
4.9
User Avatar
Hi, I am a professional ETL expert with over 3 years of experience. I have read your requirements and interested to work for you as I am expert of SSIS(SQL Server Integration Services) and can do this task for you very professionally. I can create a package to load .SQL files data into SQL tables and then load that data into CSV files as well. We can directly create a csv file from .SQL files by writing c# script in script component of SSIS but I will have to test it first and it will cost you a little extra amount. I have developed many SSIS packages in my career and can show you some examples. Please lets have a chat and discuss it in little more details. I am available to start working now and you will have it done very fast. I am waiting for your response. Please give me a chance to do it for you. Thank you My Proposal: Convertion of .SQL file data Directly into CSV files=> 400 USD => 7 Days First load data into SQL tables from .SQL files and then Load the data from SQL tables into CSV files = 250 USD=>4 Days Also I can automate both of these ways so choice will be yours but first I will have to see sample .SQL files. Note: I have not used this profile since a long time and just got back on this platform to start my freelancing career so I will not charge you too much because I need good reviews
$250 USD in 5 days
4.9 (5 reviews)
3.9
3.9
User Avatar
Hi, I can automate the second method you have mentioned namely import the .sql file into MySQL and then export into .csv file. is your target magneto system on Linux and uses MySQL as database? does the .sql and .csv files involve only one format or multiple format? suggest to explore following options as well - do you have control over the format of export from your ERP system? ie should this have to be only .sql or feasibility of generating .csv file what database ERP uses and is it under your control or third party control - we can have staging table in magneto MySQL database and import the .sql file into that staging table and import data into magneto from the staging table is none of the above suggestion work for you then I can create a shell script to import .sql file and export to .csv file hope to hear from you regards Babu
$250 USD in 7 days
5.0 (2 reviews)
3.6
3.6
User Avatar
dear, kindly send me the file imported from your system and tell me is the data in your system stored in sql server database ? solution 1 : create small exe by c# to read this file and convert it to csv. solution 2: export data dirctly from sql server to csv file useg sp and it will run automaticly kindly send me sample of input data and the data you want to extract . best regards, Hassan
$333 USD in 5 days
5.0 (5 reviews)
3.1
3.1

About the client

Flag of UNITED KINGDOM
Ilkeston, United Kingdom
4.9
108
Payment method verified
Member since Sep 6, 2008

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.