Suljettu

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.

Taidot: tietojenkäsittely, Perl

Näytä lisää: one key data, example regular expression, data 0, regular expression example, Telefon, map, data tables, data n, data mapping, data format, d mapping, d map, d g, c data, mysql expression, similar map, map file, regular expression data, example mysql script, program script, script simple, userid, simple mysql processing, contain, map program

About the Employer:
( 0 reviews ) Zürich, Switzerland

Projektin tunnus: #15641

10 freelanceria on tarjonnut keskimäärin 78 $ tähän työhön

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 Lisää

76 $ USD 15 päivässä
(1 arvostelu)
3.0
willarin

Could be done

75 $ USD 3 päivässä
(1 arvostelu)
1.6
Svetulcho

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

65 $ USD 0 päivässä
(1 arvostelu)
1.1
nirajda

is possible

85 $ USD 3 päivässä
(0 arvostelua)
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 4 päivässä
(0 arvostelua)
0.0
bid5

we could do it.

100 $ USD 5 päivässä
(0 arvostelua)
0.0
anshumesh

We are Web development,Search Engine Optimisation and BPO company from India . Kindly go through our url http://www.infiniteoutsourcing.com/ . We are interested in your project. Thanks. Regards, Anshu

100 $ USD 15 päivässä
(0 arvostelua)
0.0
MentorFactory

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

75 $ USD 1 päivässä
(0 arvostelua)
0.0
akka

I can do it in perl

55 $ USD 4 päivässä
(0 arvostelua)
0.0
shivabuzz

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

100 $ USD 8 päivässä
(0 arvostelua)
0.0