IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

How to convert positional flat file with header and trailer to document type using connector

  • 1.  How to convert positional flat file with header and trailer to document type using connector

    Posted Fri May 12, 2023 10:21 AM

    I am Receiving Positional flat file which contain Header, Body, and Trailer.
    How can Convert to the document type by ignoring Header and Trailer.
    Bellow is the format of flat file structure

    Record format
    Record format1374×433 11.2 KB

    I have created the connector only for the body and during execution of only body it is working nicely.
    So to make the full input file I have created a flow service in which I have removed the header and trailer part and then converting into the document. While doing so the character are getting misplaced and the data in the document type is not assigning correctly

    How I can overcome this ?


    #webMethods-cloud
    #webMethods
    #webMethods-io-Integration


  • 2.  RE: How to convert positional flat file with header and trailer to document type using connector

    Posted Fri May 12, 2023 12:04 PM

    Hi Deepak,

    can you provide ScreenShot from your FlatFile connector, please?
    Additionally provide a screenshot with the misplaced data in comparison to the expected data.
    Remember to specify the correct character encoding when converting from FlatFile to document so the connector can identify the positions correctly.

    Did you check the FlatFile Users Guide if it might be possible to specify a Header record (identified by “TSI01*”), a Body record format (identified by “HED*”) and a Trailer record format (identified by “TSI99*”)?
    If this is possible, you will hopefully get a document with 3 entries (Header, Body, Trailer), from which you can extract the Body for further processing.

    Regards,
    Holger


    #webMethods
    #webMethods-io-Integration
    #webMethods-cloud


  • 3.  RE: How to convert positional flat file with header and trailer to document type using connector

    Posted Sat May 13, 2023 03:48 AM

    Appreciated your reply.

    Now, the convert to document type is working fine now. I made change in the position of the record definition of flat file connecter.

    “”““Did you check the FlatFile Users Guide if it might be possible to specify a Header record (identified by “TSI01*”)””"
    Are you taking about record identifier

    recordidentifierhttps://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/4725e6150c4fb48815dc6ae1f308fc1c8cee5656_2_1035x172.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/4725e6150c4fb48815dc6ae1f308fc1c8cee5656_2_1380x230.png 2x" data-dominant-color="FAFAF3">
    recordidentifier1646×275 22.6 KB

    . if yes could you please explain more. because every time I am switching on it is throwing error while running…


    #webMethods
    #webMethods-io-Integration
    #webMethods-cloud


Related Content