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

Виконано Опубліковано %project.relative_time Оплачується при отриманні

£10-20 GBP

Оплачується при отриманні

Виконано Оплачується при отриманні

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.

Excel Linux MySQL Perl SQL

ID Проекту: #5283328

Про проект

17 заявок(-ки) Дистанційний проект Остання активність Jan 4, 2014

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та часові рамки
Отримайте плату за вашу роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними

Доручено:

Світлина профілю freelance4hire80
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 за 1 день
(65 відгуків(-и))
6.7

17 фрілансерів(-и) готові виконати цю роботу у середньому за £28

Світлина профілю linuxfreak1985
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 descri Більше

£20 GBP за 1 день
(886 відгуків(и))
8.3
Світлина профілю urmate
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. Than Більше

£52 GBP за 1 день
(250 відгуків(и))
6.8
Світлина профілю CARLOSHUGGINS
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, t Більше

£20 GBP за 3 дні(-в)
(41 відгуків(и))
6.1
Світлина профілю idleswell
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 Exce Більше

£38 GBP за 3 дні(-в)
(206 відгуків(и))
6.3
Світлина профілю techvolcano
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 за 1 день
(187 відгуків(и))
6.5
Світлина профілю tungct
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 ver Більше

£23 GBP за 1 день
(12 відгуків(и))
5.3
Світлина профілю suraj99p
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 w Більше

£20 GBP за 1 день
(17 відгуків(и))
5.0
Світлина профілю balamuralip
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 за 1 день
(18 відгуків(и))
4.4
Світлина профілю rushinshah85
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 Більше

£18 GBP за 1 день
(9 відгуків(и))
3.6
Світлина профілю DNtakoulas
DNtakoulas

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

£20 GBP за 3 дні(-в)
(0 відгуків(и))
0.0
Світлина профілю manthantilva
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 за 1 день
(0 відгуків(и))
0.0
Світлина профілю heetbishtmanish
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 за 2 дні(-в)
(0 відгуків(и))
0.0
Світлина профілю nikunjramani9691
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 за 3 дні(-в)
(0 відгуків(и))
0.0
Світлина профілю marounhoyek
marounhoyek

A proposal has not yet been provided

£27 GBP за 1 день
(0 відгуків(и))
0.0
Світлина профілю ngsquare
ngsquare

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

£18 GBP за 1 день
(0 відгуків(и))
0.0
Опублікувати схожий проект