Ditutup

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.

Kemahiran: Pemprosesan Data, Perl

Lihat lebih lanjut: 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

Tentang Majikan:
( 0 ulasan ) Zürich, Switzerland

ID Projek: #15641

10 pekerja bebas membida secara purata $78 untuk pekerjaan ini

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 Lagi

$76 USD dalam 15 hari
(1 Ulasan)
3.0
willarin

Could be done

$75 USD dalam 3 hari
(1 Ulasan)
1.6
Svetulcho

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

$65 USD dalam 0 hari
(1 Ulasan)
1.1
nirajda

is possible

$85 USD dalam 3 hari
(0 Ulasan)
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 dalam 4 hari
(0 Ulasan)
0.0
bid5

we could do it.

$100 USD dalam 5 hari
(0 Ulasan)
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 dalam 15 hari
(0 Ulasan)
0.0
MentorFactory

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

$75 USD dalam sehari
(0 Ulasan)
0.0
akka

I can do it in perl

$55 USD dalam 4 hari
(0 Ulasan)
0.0
shivabuzz

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

$100 USD dalam 8 hari
(0 Ulasan)
0.0