IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
Expand all | Collapse all

Using Type Trees

  • 1.  Using Type Trees

    Posted 04/11/07 09:46 AM

    Originally posted by: SystemAdmin


    I have a type tree.I want to use it for structure validation.kindly help on this..
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Using Type Trees

    Posted 04/11/07 11:37 AM

    Originally posted by: jvanboga


    The PDFs used to have some pretty good basic examples of this. Depending on the version you are using the pdf file should be '1005.pdf'(formerly known as 'Map Designer Reference Guide').

    Assuming your type tree is a data file the simplest way is to create a map using 'Map Designer'. Start by defining one input card label your schema and point to the tree and type (file level group in define in type tree.) Define your data source as file and point to the file. Run your map. If your map fails its because your type tree and data dont appear in sync. Turn on Trace, recompile and run. Once the map fails youll have a trace file that will help you identify what the problem is.

    Once your map is working to this point copy your input card to output (will need to rename) assign an output file, file name and map the data to the output card. Recompile and rerun. Compare your input and output files. They should be exactly alike.

    Keep in mind that a map reading a large data file with trace turned on will create a very large trace file. Read the PDFs to help determine how you can make your trace files more manageable.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 3.  Re: Using Type Trees

    Posted 04/12/07 02:35 AM
      |   view attached

    Originally posted by: SystemAdmin


    hi ,
    thanks for the reply.
    we are trying to validate a HL7 documenthttp://healthcare std.we have the sample input file and a tree available in extender pack.

    now do we need to generate a map from the tree using the sample HL7 document as the input?? or is there any other alternative way////
    kindly guide..

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

    Attachment(s)



  • 4.  Re: Using Type Trees

    Posted 04/12/07 06:16 AM
      |   view attached

    Originally posted by: SystemAdmin


    Hi,
    I m not able to locate 'Map Designer Reference Guide'.We are using WTX 8.1.Kindly guide for the same.

    Secondly, I tried generating XSD and Map from the Tree Designer with the existing tree attached in my previous post.Also attaching the sample HL7 file.

    We want to validate HL7 documents using WTX engine.

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

    Attachment(s)



  • 5.  Re: Using Type Trees

    Posted 04/12/07 08:54 AM
      |   view attached

    Originally posted by: jvanboga


    OK, I keep forgetting IBM reduced the functionality of the PDFs. Look at in the your product installation directory for this path... 'docs\map_designer\1005.pdf'. For the most part the PDF should be close to what it used to be but IBM gutted graphic examples.

    If you haven't worked with the tool much in the past you can/should also look at the PDFs in the following paths...

    docs\design_studio_intro\
    docs\db_interface_designer\

    I attached a simple validation map. You need to point the input card at your test file. I've never worked with the HL7 data structure so you may need to point the I/Os to another 'type tree\type' to get the validation to work.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender

    Attachment(s)



  • 6.  Re: Using Type Trees

    Posted 04/13/07 06:04 AM

    Originally posted by: SystemAdmin


    Thanks for the sample file.I used the map..pointed the input file to a existing tree and sample data.

    I got an error:
    Input valid but unknown data found.
    Thanks,
    Jignesh
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 7.  Re: Using Type Trees

    Posted 04/13/07 10:02 AM

    Originally posted by: jvanboga


    Not surprised it failed with that message. Did you get a chance to look use a full file or identify the group type you need to validate against?

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


  • 8.  Re: Using Type Trees

    Posted 04/13/07 10:47 AM

    Originally posted by: SystemAdmin


    Not yet trying to explore it.I m equally new to it...:)
    Thanks,
    Jignesh
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 9.  Re: Using Type Trees

    Posted 04/18/07 08:23 AM

    Originally posted by: SystemAdmin


    I used the tree provided by userful.And also turned the audit on.
    In build error the message is :

    M215 ERROR:
    Map:hl7_v2_3_validation
    Invalid Audit
    File Separator File Control

    Total errors:1 Total warnings:0

    any remedies for above ??

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


  • 10.  Re: Using Type Trees

    Posted 04/18/07 10:36 AM

    Originally posted by: jvanboga


    Did the build fail or the run? I assume it failed when you ran the map after your build. Did you examine the trace file? Probably 'map_name.mtr'. Search for the word 'invalid'. Should give you an idea where the issue is.

    Sounds like you may be missing the 'FHS' segment where the separator is defined. If, for example, the delimiter is defined as a variable the value of the field separator determines what the delimiter is. When a delimiter is defined as variable a default value is also defined. So, if you are missing the FHS segment the tree would use the default delimiter. Perhaps your test file's delimiter does not match the default which I think is "|".
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 11.  Re: Using Type Trees

    Posted 04/18/07 11:11 AM
      |   view attached

    Originally posted by: SystemAdmin


    Hi,
    I got the error during the build.
    in trace file did not get the word invalid.
    Also the sample file has the delimiter "|" and in the input card the property for "Field Separator File Control" i.e. Implied Default value is empty.

    Attaching sample file which i used to run the map for your reference.
    In the next thread will also give the trace file.
    Thanks,
    Jignesh
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender

    Attachment(s)



  • 12.  Re: Using Type Trees

    Posted 04/18/07 11:12 AM
      |   view attached

    Originally posted by: SystemAdmin


    the trace file.....
    Thanks,
    Jignesh
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender

    Attachment(s)



  • 13.  Re: Using Type Trees

    Posted 04/12/07 09:11 AM

    Originally posted by: jvanboga


    PS... I looked at your HL7 file and it doesn't look complete. You start with an 'MSH' segment but it looks like MSH is subordinate to a number of other groups like IO1, IO2, IO3.....

    Again, I'm not that familiar with HL7 data formats but if you have a full HL7 file and point to the file type you should be able to validate the data. If not you need to figure out which choice group you have and point to the proper group within it to validate your data.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender