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
Expand all | Collapse all

Flat File - Manage header line

  • 1.  Flat File - Manage header line

    Posted Mon December 20, 2010 09:47 AM

    Dear all,

    I would like to turn a CSV flat file into IS Pipeline using convertToValues standard service. We also have defined many Format Services in order to check and turn some fields during this global conversion (for example, checking date formats…)

    This works properly but as received flat files have an header line containing ths names of CSV File columns, the first line triggers validation errors.

    How can I skip validation (format services) for the header line ?

    Thank you very much for your help.

    Jean-Charles


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 2.  RE: Flat File - Manage header line

    Posted Mon December 20, 2010 03:17 PM

    You’ll need to ignore the header line in your code. There are options in the service call that can add a line number to the returned record. You can check that to ignore the header. Or look for a specific string that occurs only in the header.


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB


  • 3.  RE: Flat File - Manage header line

    Posted Wed January 05, 2011 10:14 AM

    I confirm.
    The parameter that must be used is addRecordCount in ConvertToValues service !
    [FONT=PalatinoLinotype,Italic][SIZE=2][FONT=PalatinoLinotype,Italic][SIZE=2]Thank you Rob
    [/size][/font][/SIZE][/FONT]


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB