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_query=”Select userid,name,phone from mytable where name like ‘h%’”
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.
10 freelancers are bidding on average $78 for this job
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