create data insert routine into mysql db from external file (csv/xlsx)

£10-20 GBP

Completed

Posted

over 10 years ago

£10-20 GBP

Paid on delivery

Being involved in large project, I would need some help with basic task of designing a script to insert data from one table excel script into MySQL database. The database is already designed, also Excel files are available for viewing. The purpose of this project is to create base for conditional mail merge. So people in the database meeting some certain criteria, would receive letter 1, other meeting other criteria would receive letter 2 and some other meeting some different criteria would receive letter 3, then people meeting some criteria after first stage would receive some further communication and so on. This part is however my problem. I just need a mechanism of handling feed of data about people received from external source to be inserted into MySQL database. Further cooperation towards mail merge related part and other parts of the projects is possible. MySQL database is based on Linux CentOS 6.4 64 bit. Excel version is 2007 onwards or csv file if preffered. For skilled person it should be a straightforward task.

Project ID: 5283328

About the project

17 proposals

Remote project

Active 10 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

Awarded to:

@freelance4hire80

hi, i can write the Perl script for you. It will read from CSV and insert/update the record into MySQL table. Please provide csv sample and SQL dump to get started

£20 GBP in 1 day

5.0

(65 reviews)

6.7

17 freelancers are bidding on average £28 GBP for this job

@linuxfreak1985

Hi there, I have over 7 years experience working on HTML, Wordpress, Magento, Database administration, OpenCart, Website Design, Logo / Banner Design Joomla, CSS and Linux Administration. I have read the project description very well, and i would like to complete this project. lets complete this project

£20 GBP in 1 day

4.8

(886 reviews)

8.3

@urmate

HI Contact me for an efficient, well documented and perfect solution and development of your project. I ensure quality work with always on time delivery of project and dedicated support and follow up. Thanks Farah Saif

£52 GBP in 1 day

4.9

(250 reviews)

6.8

@CARLOSHUGGINS

Hi I'm 12 year experienced PHP/ MySQL developer... I will deliver high quality results, please visit my profile and have a look at what employers are saying about me... you could be one of them a satisfied customer, thanks for considering my proposal.

£20 GBP in 3 days

5.0

(41 reviews)

6.1

@idleswell

Hello, I am the premier Perl scripting expert on these freelancing sites. I can design a Perl script to process your data in .csv files or I could design a script using a public domain module to work with an Excel document to extract the data. Which do you prefer? The data can then be written row by row into your database. I will require explicit instructions regarding how to write each field. Later we can discuss writting other scripts to process data from this database. But this would be as an enhancement as a separate project. a milestone payment for the full budget of this project must be deposited with this site before your offer can be accepted. Alan Idler Chief Software Architect Idleswell Software Creations

£38 GBP in 3 days

4.9

(206 reviews)

6.3

@techvolcano

Hi, As you mentioned this is a straight forward task. We can complete the script to parse and insert the data in few hours. Further assistance we can provide you for the conditional mail sending too. Thanks.

£20 GBP in 1 day

4.8

(187 reviews)

6.5

@tungct

Hi, I am expert programmer with more than 5 year of experience. I have read your requirements about this tasks, and I can understand that you want to insert data from csv/xlsx in to your mysql db? This work is very very easy for me. I had completed very much project same that, so I believe that I can complete your task very quickly and result as perfectly. After complete I will give you a script to you run it anywhere. I just need the csv/xlsx file and the information to connect to db, I will complete them. Please note that I have so much experience with your task. Thanks and regards

£23 GBP in 1 day

5.0

(12 reviews)

5.3

@suraj99p

I am a database expert and have vast experience in working with MySQL and oracle databases. I have completed many projects on freelancer where database was used to store data. I am very good in this area. I have also worked with SMTP libraries and have written email bots/clients. I would require more insight on mail part. Please explain in details. I can suggest something or come up with an idea. I work with a leading IT company as technical lead and have more than 4 years of experience.

£20 GBP in 1 day

4.8

(17 reviews)

5.0

@balamuralip

I can get you a automated system which can dump/sync data from CSV to mysql as you needed. it's a simple task for me and i have good knowledge in MYSQL

£13 GBP in 1 day

5.0

(18 reviews)

4.4

@rushinshah85

Hi, I am a full-time developer of Perl and CGI, and I work with most platforms (Linux, Solaris and Windows) and would like to help with your task. Migrating the data from csv will be easier and faster because it can be directly read by Perl instead of a need to have a package to read Excel data. You can check my existing ratings on Freelancer and also see that I have cleared Freelancer's Perl Certification, and thus be ascertained of high quality results in expected time. Thanks for reading my proposal, and do tell me in case you want to renegotiate pricing/timelines for the bid. Regards, Rushin

£18 GBP in 1 day

4.6

(9 reviews)

3.6

@DNtakoulas

Δεν έχει γίνει καμιά πρόταση ακόμα

£20 GBP in 3 days

0.0

(0 reviews)

0.0

@manthantilva

hi I have expertise in Linux mysql perl and java. I can do this job easily. please share more detail on project.

£18 GBP in 1 day

0.0

(0 reviews)

0.0

@heetbishtmanish

Having the experience of developing 7 projects in my 1.10 years experience, new in freelancer, want to make a mark to my profile.

£18 GBP in 2 days

0.0

(0 reviews)

0.0

@nikunjramani9691

I have already worked on these same technologies. Also i have enough confidence to complete this project. So, you can trust me for your project. I will try to my best to complete your project.

£23 GBP in 3 days