Originally posted by: ManojBansal

How do we copy the WTX mapping rules into a .xls sheet along with the standard and application layout?
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: repanzer1

You can export a map into an xml file.

What exactly are you trying to achieve?

---

There are 10 types of people in this world. Those who understand binary and those who don't.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: ManojBansal

Thanks for your reply.

Actually we want to create the mapping specification ( in .xls format) for client which contains the mapping details that are present in the map as his instructions are in notepad and difficult to understand. But there are lots of map for which we need to create the specifications. So I want to know is there any way we can get all the rules and details of application layout so that we can create a tool to do the operations.

Its a migration project from GXS to WTX.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: Kepa_Screen

I should use XML export of the maps.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: ManojBansal

Ok. So will in that details about both the application layout is present and also then also what can we use in order to get the data in .xls format..

Any suggestions on that..
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: Kepa_Screen

Suggestions :

• Use dtxxmlconv for batch exporting maps from mms to xml
• Use freeware version of XMLFox ( http://www.xmlfox.com/ ) to convert XML files to XLS files, although it does "flat" conversion.

What do you exactly need xls files for ? just with xml files it's easy to read mapping-rules, just use "grid" vision with any XML Editor like XMLSpy.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: ManojBansal

Thanks for your tip. Will check that out.

Attached is the sample .xls file which i want to create from Map.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: Kepa_Screen

Then you should click over "MapRule" at XMLFox, so you can see all map rules in one click.
Then export to Excel -> only this table -> and you'll get something similar as you need.

You can also do this in several other ways once you have the map exported to xml. You could use "grep" or similar tools ( ultra edit with macros...) in order to get only "MapRules" or whatever tag you need to get what you want, then save as csv and reimport to excel...

This could be done in several different ways...imagination is the limit.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: ManojBansal

Thanks a lot for your help! got it done.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender