| Author |
Message
|
| raquel.saracay |
 Posted: Mon May 14, 2007 8:35 pm Post subject: How to promote or dinamically config Mapping route property? |
 |
|
Novice
Joined: 10 May 2007
Posts: 11
|
I have a mapping node inside a subflow, and i m using it to transfer data from database to database. The target database should be changed depending on the main flow, but i cant find the way to dinamically configure it in development time and it seems the mapping route property can´t be promoted.
Thanks for ur help |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Mon May 14, 2007 11:33 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi raquel.saracay,
Your requirements are not very clear...
Please give an example of what you need to update from table and what you need to get from the input message...from your first post, it just seems that you might need to use a compute instead of a mapping node...
Regards. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 15, 2007 1:51 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can't change the $source or $targets of a map at deploy time.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| raquel.saracay |
| Posted: Tue May 15, 2007 6:48 am Post subject: How to promote or dinamically config Mapping route prope |
|
|
Novice
Joined: 10 May 2007
Posts: 11
|
| I have one table in a source database but many target databases, and i need to insert/update/delete de rows in the appropiate target database depending on the country id of the source database. the tables mapped will be the same, but i need to change the database connection. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 15, 2007 7:00 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
So you have $target1, $target2, etc? all different databases?
Then you can build an IF structure, and map from different $targets.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| raquel.saracay |
| Posted: Fri May 18, 2007 10:12 pm Post subject: Using MessageSet to convert a Position delimited file to xml |
|
|
Novice
Joined: 10 May 2007
Posts: 11
|
I need to know if exists anyway to build a "conditional" messageSet to build an xml from a position delimited file.
in the position delimited file some lines might need a structure and some might need other.
for example:
in the records inicialited with the number 1 from the position 2-5 i have the clientCode, from the position 6-12 the fullName
in the records inicialited with the number 2 from the position 2-4 the itemNumber, from the position 5-9 the price, from the position 10-13 the quantity.
File Content:
10012JohnHammer
2032120.230029
2038020.230025
10912HelenChin
2032120.230009
2007020.000005
In that case i have 2 clients records and 4 items records, 2 for each client.
I need to have this in XML to make some transformations.
I'll be very pleased if somebody sends me documentation or any comment to solve this.
Thanks. |
|
| Back to top |
|
|
|
|
