App Connect

 View Only
  • 1.  How to create DFDL message model for Fixed length file

    Posted Fri October 08, 2021 07:17 PM
    I have a fixed length file which I need to read in to the message flow. So I tried to create a message model and tried the option "Other Text or binary" on New Message Model wizard. After defining all the elements i tested with Create logical instance to see the output and found out it created a comma separated values.
    For example FirstName of length 10 characters
                         LastName of length 10 characters
                         Dept of length 10 characters 
    Logical instance output was --> Ramesh    ,Smith     ,Sales     
    I want it to be like --> Ramesh    Smith     Sales 
    Any articles or urls or suggestions to achieve this would be a great help.
    Thank you all

    ------------------------------
    Lokesh Bonthula
    ------------------------------


  • 2.  RE: How to create DFDL message model for Fixed length file

    Posted Mon October 11, 2021 02:15 AM
    Hello,

    did you select the option "Fixed Length" on the last page of the wizard in the "Field Settings" ?
    You should have a file called "RecordFixLengthFieldFormat.xsd" that is generated by the wizard and used to configure DFDL.

    ------------------------------
    Pierre Richelle
    IBM Hybrid Cloud Integration Specialists
    IBM
    +32474681892
    ------------------------------



  • 3.  RE: How to create DFDL message model for Fixed length file

    Posted Tue October 12, 2021 03:20 PM
    Thank you Pierre, 
    I was using the second option : "create an empty dfdl schema, I will model my model my schema using dfdl editor"  then I was not getting this option "Fixed Length"
    After your suggestion I tried the first option "Create a DFDL schema using this wizard to guide you" which gave the option to select "Fixed Lenght"

    Thank you as per suggestion I was able to create the file called "RecordFixLenghtFieldFormat.xsd"

    Is there any way if we select second option :"create an empty dfdl schema, i will model my model my schema using dfdl editor" and change some properties to get "RecordFixLenghtFieldFormat.xsd"

    ------------------------------
    Lokesh Bonthula
    ------------------------------



  • 4.  RE: How to create DFDL message model for Fixed length file

    Posted Wed October 13, 2021 02:37 AM
    Edited by Pierre Richelle Wed October 13, 2021 02:39 AM
    Hello,

    yes you can but the wizard fills a lot of things OOTB that you will need to do your self afterwards.
    Here you go:
    In the representation properties, select the "..." for the Data Format Reference:

    Select add a reference to another schema:
    Select the Text Data Formats:
    You will need to remove the previous data format reference (its an include).

    ------------------------------
    Pierre Richelle
    IBM Hybrid Cloud Integration Specialists
    IBM
    +32474681892
    ------------------------------



  • 5.  RE: How to create DFDL message model for Fixed length file

    Posted Thu October 14, 2021 11:18 AM
    Thank you Pierre Richelle for the quick response. I was able to do it in both ways. You saved my day.
    Thanks again.


    ------------------------------
    Lokesh Bonthula
    ------------------------------