Originally posted by: SystemAdmin

I've written a map that will read the XML generated by doing a Map Export, and transform it into a simple file that can be used to create a nicely formatted Excel spreadsheet. The output is basically the rule number, the output field, and the rule for that field. This makes viewing all the rules much easier to read.

One of my problems though, is that the rule numbers in the map export doesn't match up with the ordering of the maps in the Map Editor? It doesn't happen on all maps, so I'm not sure why the ordering is 'out of whack'?

Sometimes it's easier for me to compare something on the written page to what's on the screen and scratch notes on the paper for the whole system. It just isn't as easy to do because the fields aren't all in the same order.

Does anyone know how to get the rules in the export to match the map ordering? I'm including my map and the type trees used. This was developed with WTX 8.1 on Windows.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: cemeinz

Hallo omhopper!

First of all: Small, but nice work. Had some similar ideas dealing around with this topic. :-)

Perhaps I will add some more into your map to fit my needs, if I will find time for this topic.

Topic... back to your topic & question:

Well, if I understood you right, you were confused about the numbering (the integer before the @ symbol), because this does not match the output or input card numbers. My suggestion is, that this is something like a history entry. Every rule entered in a map get an integer number which identifies the order the rule was inserted. So every new number will get the actual counter plus one.

Additional information: Just testing around with some example maps, I inserted a new output card based on my last one (just a copy) and it gets the number six (MapRule rulenumber="6"). Then I put this card at the second place, and still the rulenumber is the same. This could underline my suggestion.

Hope, that helps at the moment.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: sridhar_vennela

Hi omphooper,

Trying to run your map, I am not able to see your input file (myexport.xml). please attach it, i will go through it.

Thanks,
Sridhar
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: cemeinz

Hello!

Well, you can use your own mappings as the input. For example, choose one of the mappings provided as examples in the installation folder of you WTX directory. Export them and then you get your input.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender