Fermé

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.

Compétences : Traitement de Données, Perl

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Zürich, Switzerland

Nº du projet : #15641

10 freelance font une offre moyenne de $78 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(1 Évaluation)
3.0
willarin

Could be done

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
1.6
Svetulcho

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(1 Évaluation)
1.1
nirajda

is possible

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
bid5

we could do it.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
anshumesh

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)
0.0
MentorFactory

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
akka

I can do it in perl

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
shivabuzz

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(0 Commentaires)
0.0