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

  • 1.  Parsing Flat file

    Posted Mon July 07, 2008 06:14 PM

    I am trying to parse a flat file as shown in the attached file. I am unable to accomplish this.

    I have defined each record identifier as “Unlimited” but it fails to gather the 2nd set or records.

    Can you please advise?

    Thanks
    Dhara
    sample.doc (907 Bytes)


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 2.  RE: Parsing Flat file

    Posted Mon July 14, 2008 03:35 PM

    How you want to parse the file exactly. Whats the structure of your output Document?


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 3.  RE: Parsing Flat file

    Posted Mon July 14, 2008 05:14 PM

    It looks like a comma delimeted file with recordsWithNoID but what is the record identifier ?


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: Parsing Flat file

    Posted Mon July 14, 2008 05:33 PM

    dogel,

    How is your Schema defined…is it as Nth field option and Field seperator (,) and record seperator (newline) and recordWithNoID (RecordDefinition) with maxRepeat=unlimited??

    Field Definition as (1,2,3,4,5…nth)

    HTH,
    RMG


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 5.  RE: Parsing Flat file

    Posted Mon July 14, 2008 07:37 PM

    I have resolved this issue.

    Thanks for all your responses!


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 6.  RE: Parsing Flat file

    Posted Mon July 14, 2008 08:41 PM

    Glad to hear it got resolved!!..

    BTW,anything above helped you?? what was the resolution??


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 7.  RE: Parsing Flat file

    Posted Mon July 14, 2008 09:31 PM

    No.

    Although the inbound file is a CSV flat file, I had to define the schema as a heirarchy. Header Record and then the Detail record below that. Each of these was set to “Unlimited”.

    This resolved the issue. The inbound csv file had multiple headers and all of those were fetched by convertToValues.

    Thanks!!


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 8.  RE: Parsing Flat file

    Posted Mon July 14, 2008 10:38 PM

    Sorry i haven’t looked at your file though…anyways it worked for you thats what we care…

    But wierd thing is Header record repeats it is definetely unsual…:slight_smile:


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


Related Content