Originally posted by: ManojBansal

I have one xml file which contains an element(lets say DELCO under E1EDPO1) but this element is not present in the .mtt file.

Its a XML file and I don't have .DTD file.

So i tried exporting the .mtt file to .mts file and made some change but not able to import this file back as .mtt in the map.

I tried creating the new element but not able to change its "indent" property to "XML" as its by default is "General".

Please help me in adding the XML element in the structure.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: ManojBansal

Used this below help content!

---

Importing a type tree file example
The following example shows how you can use the timport utility command line option to import metadata definitions in the mymts.mts file to the mymts.mtt type tree file.

install_dir> timport mymts.mts
-O C:\MyDev\ImportResults\mymts.mtt
-LOG -APPENDWhen you run the example, the following result occurs:

If the mymts.mts file is imported successfully, the timport - completed successfully. message displays on the console.
A mymts.mtt type tree is created in the C:\MyDev\ImportResults directory.
If the mymts.log log file does not exist, it is produced in the same directory as the .mts file. If the mymts.log log file already exists, the log messages are appended to the existing file.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: ChB

Hello ManojBansal,

if it is just one field, why not editing it with the DesignStudio?

In general: whenever I have a problem with an XSD, I use the XML Spy to generate a DTD from the XML message. After that I generate a TypeTree from the DTD. The TypeTree is not as exactly defined as an XSD can do it, but it is more simple and more easy to edit.

Best regards

ChB
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: ManojBansal

Hello,

I don't have DTD or XSD file for modification. I have only .mtt file which i suppose to modify it by adding the element.

As I'm new to WTX world (earlier was working on Sterling Integrator), no idea on how to modify the .mtt using design studio.

Thanks for your input, will try to explore that option too.

Regarding your point of creating the .mtt file, if one is sure of input file data (means all elements are present), then only I believe, we should create the dtd or xsd from input file otherwise one end up editing the DTD regularly.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: ChB

Hello,

you are right, all elements must be present in the XML message. But the XML-Spy can create such example messages and the corresponding DTD.

But you should look into the details of the DesignStudio. It is so easy, opening the mtt, copying an existing item, change the initiator and terminator, add the new item to the corresponding group and save the file.

Much less complicated than editing the mts file.

Are you doing mappings without DesignStudio as well? It is possible, but I never heard of it.

I just heard from the Sterling Integrator. I wanted to setup an environment a few months ago, but so far I wasn't able to start it. The next time, I will ask you. ;-)

Best regards

ChB
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: ManojBansal

Hello,

Oops! you are right.. We create maps in Design studio only.. lol

I tried doing that. Means I opened the mtt, copied the existing data and renamed it but still it referenced the old field name under "Intent - Validate As - Name" as it is XML element not a normal FF map field.

I even created the new element, changed its class as "ITEM" but still not able to update "Intent" to "XML" from "General (by default value)" under new element properties.

What you said can be done for other maps like (FF, delimited, positional, etc). Thanks for the info!

Sure you ask me about sterling integrator, Will help you best of my knowledge about the product.

Warm Regards
Manoj Bansal
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender