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 freelance font une offre moyenne de $78 pour ce travail
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
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
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