I gang

Perl Script - Generic CSV Parser and Populate Data to MySQL

Need a generic CSV parser that will be taking the file, parse the 1st line which contain the name of the column, and then use the column as the field name to be inserted into mysql

for example

[url removed, login to view]

header1|header2|header3|header4

data1|data2|data3|data4

data11|data22|data33|data44

It will get inserted into a correspoding mysql table which has field of header1, header2, header3 and header4.

The Perl script should be generic enough to take in any file and put into mysql table as long as the condition above is fulfilled. The script should work for file up to 10 millions line.

I will provide the sample CSV file and MySQL schema upon request.

thanks

Rob

Færdigheder: MySQL, Perl

Se mere: perl script populate, csv mysql perl, perl script populate mysql, generic perl script, perl get, data3, schema populate, sample perl, mysql populate table, perl sample, mysql inserted, perl script file, table perl, table csv, perl table, csv table, line csv, mysql schema, mysql schema csv, data4, perl script data mysql, mysql csv file, condition csv, mysql table csv, sample populate data

Om arbejdsgiveren:
( 15 bedømmelser ) Bayan Lepas, Malaysia

Projekt-ID: #4088808

Tildelt til:

thiagomaia

Hello Will take for me less than 10 minutes to make that, if you are using Linux in your side, also we need to add a library to can get the 10 milion lines, without have a delay to open. We can configure i Mere

$30 USD på 1 dag
(0 bedømmelser)
1.0

28 freelancere byder i gennemsnit $61 for dette job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$99 USD på 1 dag
(67 bedømmelser)
6.7
vctheguru

Hi, This is just like many other projects I have already did and I can make this for you. Please see the private message board for more details. regards VC

$40 USD på 1 dag
(27 bedømmelser)
5.6
akiles99

will be done...

$50 USD på 1 dag
(72 bedømmelser)
5.4
AncaU

Hi Rob! Interesting proposal. What if there are more tables with those headers? Should we insert in all those tables that information? I'd also like to see the schema (someone wanted it too). Thanks, Anca

$55 USD in 4 dage
(106 bedømmelser)
5.2
graphicaa

Hi, Please send me the files i will see and let you know thanks

$150 USD in 4 dage
(24 bedømmelser)
5.1
pablotorres

i can do it

$30 USD in 14 dage
(40 bedømmelser)
4.8
techvolcano

We Can do this.please see pm

$30 USD på 1 dag
(17 bedømmelser)
4.3
PerlIsFun

I'd be glad to help. Are you on a Linux platform ? Thank you.

$39 USD på 1 dag
(11 bedømmelser)
4.2
belghouth

I can give a generic script that can work even if you change database schema. Updated my BID.

$48 USD in 2 dage
(34 bedømmelser)
4.2
mz1

I am Perl expert.

$30 USD in 3 dage
(8 bedømmelser)
4.2
lokeshk9936

Hey, I can do this now. I am a Perl and MySQL expert with more than 7 years of experience. Have written a lot of Data parsers in Perl. Please see PM.

$90 USD på 1 dag
(5 bedømmelser)
2.9
proauthor

Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.

$99 USD in 3 dage
(1 bedømmelse)
2.5
a2infotech

Hello Sir, I'm Expert in such type of task.I only believe in Quality Work and long term relationship. My goal is to complete job with in Timeframe. I have gone through the requirements. I assure you for expectations a Mere

$100 USD in 4 dage
(3 bedømmelser)
2.3
zkutch

Hello. More 20 years programming experiense. See pmb, please.

$30 USD in 0 dage
(1 bedømmelse)
1.4
biswanaths

Please let me know if you need to discuss further.

$30 USD in 3 dage
(0 bedømmelser)
0.0
blackbase

Let's start. I already did scripts like this.

$39 USD in 3 dage
(0 bedømmelser)
0.0
andyfore

I look forward to the opportunity to work on this project. I have over 10 years of experience in programming and systems for the commerical and the education markets.

$100 USD in 3 dage
(0 bedømmelser)
0.0
rout2kumar

Dear sir, I have 7+ yr of exp in perl and i am doing same job for telecom industries.

$50 USD på 1 dag
(0 bedømmelser)
0.0
jenson6

I already have the code for this. Can deliver ASAP.

$30 USD på 1 dag
(0 bedømmelser)
0.0
alliaunce

Hi, i can provide the same to you . share the schema and sample file, will get back to you with working demo. Thanks

$55 USD in 2 dage
(0 bedømmelser)
0.0