create data insert routine into mysql db from external file (csv/xlsx)
£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
Awarded to:
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
17 freelancers are bidding on average £28 for this job
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 descri More
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, t More
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.
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
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 More
hi I have expertise in Linux mysql perl and java. I can do this job easily. please share more detail on project.
Having the experience of developing 7 projects in my 1.10 years experience, new in freelancer, want to make a mark to my profile.
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.
I user Perl everyday, i work in Silicon Valley in the US for over 10+ years. This is very simple for you. you can pay me after