Originally posted by: SystemAdmin

Hi,

I am trying to write a Map that can convert Gentran Reports ( Mapping Reports generated from GENTRAN ) into a Spreadsheet that can be used as a Mapping Document. Did anyone try this earlier ?
If there any tips that you could offer on how to do this
that would be greatly appreciated.

Thanks,
Sai.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

1st you need to create type trees. Not sure where you would get metadata, unless you use the file importer for the source and ODBC for the target.

Don't know if Gentran has a DTD for their reports or other metadata doc.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

What is the format of the source data? Print files, text reports, XML?

Is querying the GENTRAN database to create your own reports an option?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

The Format of the source data is TextFile.
We did not get any dtd from Gentran.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

What kind of TextFile? Print Report format, XML, CSV, TSV, etc.? Please show an example.

Unless it is XML, you wouldn't have a DTD. If it is XML, you don't necessarily need a DTD. You can use an XML Inference Engine to create an XML Schema from an XML file and from that you can create a Type Tree. However, the XML file needs to be a complete example of what might be output in a report. Otherwise, the schema might only represent a subset of the entire universe of objects that might be output.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange