Sedang Disiapkan

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

Kemahiran: MySQL, Perl

Lihat lebih lanjut: 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

Tentang Majikan:
( 15 ulasan ) Bayan Lepas, Malaysia

ID Projek: #4088808

Dianugerahkan kepada:

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 Lagi

$30 USD dalam sehari
(0 Ulasan)
1.0

28 pekerja bebas membida secara purata $61 untuk pekerjaan ini

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 dalam sehari
(67 Ulasan)
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 dalam sehari
(27 Ulasan)
5.6
akiles99

will be done...

$50 USD dalam sehari
(72 Ulasan)
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 dalam 4 hari
(106 Ulasan)
5.2
graphicaa

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

$150 USD dalam 4 hari
(24 Ulasan)
5.1
pablotorres

i can do it

$30 USD dalam 14 hari
(40 Ulasan)
4.8
techvolcano

We Can do this.please see pm

$30 USD dalam sehari
(17 Ulasan)
4.3
PerlIsFun

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

$39 USD dalam sehari
(11 Ulasan)
4.2
belghouth

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

$48 USD dalam 2 hari
(34 Ulasan)
4.2
mz1

I am Perl expert.

$30 USD dalam 3 hari
(8 Ulasan)
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 dalam sehari
(5 Ulasan)
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 dalam 3 hari
(1 Ulasan)
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 Lagi

$100 USD dalam 4 hari
(3 Ulasan)
2.3
zkutch

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

$30 USD dalam 0 hari
(1 Ulasan)
1.4
biswanaths

Please let me know if you need to discuss further.

$30 USD dalam 3 hari
(0 Ulasan)
0.0
blackbase

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

$39 USD dalam 3 hari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
0.0
rout2kumar

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

$50 USD dalam sehari
(0 Ulasan)
0.0
jenson6

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

$30 USD dalam sehari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
0.0