Kapalı

script to map data between tables

We need a perl program that can map data between different tables in different MySQL databases. The program should run via command line like (for example):

Data_mapper --conffile ./[url removed, login to view]

and should configurable via a configuration file.

It should be possible to specify a regular expression for each mapping, to give a possibility for a simple data transformation.

The configuration file should be human readable and should contain information similar to the following example:

dbfrom=mydatabase_from

dbfrom_host=localhost

dbfrom_pwd=from_pwd

dbto=mydatabase_to

dbto_host=to_host

dbto_pwd=to_pwd

dbfrom_query=”Select userid,name,phone from mytable where name like ‘h%’”

table_to=name_of_the_table

key userid->peopleid s/(.*),/$1/

map name->username tr/[a-z]/[A-Z]/

map phone->telefon s/D//g

it should be possible to state several mapping within one configuration file.

The format of the configuration file can be chosen freely, as long as the functionality stays.

Beceriler: Veri İşleme, Perl

Daha fazlasını görün: regular expression no, regular expression in c, regular expression example, regular expression c, regular expression a, regular expression 0, one key data, example of regular expression, data 0, c regular expression example, telefon, map, map c++, line-following, data, Data tables, data n, data mapping, data format, d mapping, d map, d g, c data, mysql expression, similar map

İşveren Hakkında:
( 0 değerlendirme ) Zürich, Switzerland

Proje NO: #15641

10 freelancer bu iş için ortalamada 78$ teklif veriyor

inteconssoftware

We are a group of software professionals from India with expertise in ASP, ASPx, HTML, XML, Java, C, C++, VB, Oracle, SQL Server, PHP, My SQL Professionals ranging from 1 yr to 20 yr of experience We are sure to Daha fazlası

in 15 gün içinde76$ USD
(1 Değerlendirme)
3.0
willarin

Could be done

in 3 gün içinde75$ USD
(1 Değerlendirme)
1.6
Svetulcho

I already wrote the script, and can send you at any time ;))

in 0 gün içinde65$ USD
(1 Değerlendirme)
1.1
nirajda

is possible

in 3 gün içinde85$ USD
(0 Değerlendirme)
0.0
nohup

i can do it in a day, but have quoted 4 days to handle possible time zone differences and fine tuning as per your requirements

in 4 gün içinde50$ USD
(0 Değerlendirme)
0.0
bid5

we could do it.

in 5 gün içinde100$ USD
(0 Değerlendirme)
0.0
anshumesh

We are Web development,Search Engine Optimisation and BPO company from India . Kindly go through our url [url removed, login to view] . We are interested in your project. Thanks. Regards, Anshu

in 15 gün içinde100$ USD
(0 Değerlendirme)
0.0
MentorFactory

We understand exactly what you are looking for. Please see PMB.

1 gün içinde 75$ USD
(0 Değerlendirme)
0.0
akka

I can do it in perl

in 4 gün içinde55$ USD
(0 Değerlendirme)
0.0
shivabuzz

Yes this can be done. let us know when and how we can help you up

in 8 gün içinde100$ USD
(0 Değerlendirme)
0.0