Encerrado

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.

Habilidades: Processamento de dados, Perl

Ver mais: 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

Acerca do Empregador:
( 0 comentários ) Zürich, Switzerland

ID do Projeto: #15641

10 freelancers estão ofertando em média $78 para este trabalho

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 Mais

$76 USD in 15 dias
(1 Comentário)
3.0
willarin

Could be done

$75 USD in 3 dias
(1 Comentário)
1.6
Svetulcho

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

$65 USD in 0 dias
(1 Comentário)
1.1
nirajda

is possible

$85 USD in 3 dias
(0 Comentários)
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

$50 USD in 4 dias
(0 Comentários)
0.0
bid5

we could do it.

$100 USD in 5 dias
(0 Comentários)
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

$100 USD in 15 dias
(0 Comentários)
0.0
MentorFactory

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

$75 USD em 1 dia
(0 Comentários)
0.0
akka

I can do it in perl

$55 USD in 4 dias
(0 Comentários)
0.0
shivabuzz

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

$100 USD in 8 dias
(0 Comentários)
0.0