webMethods

webMethods

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

Generate Csv file from FlatFile Schema

  • 1.  Generate Csv file from FlatFile Schema

    Posted Mon November 10, 2003 09:01 PM

    Hi,

    I have a schema with one record defined as “recordWithNoID” containing 18 fields.
    I need to parse this flat file:
    00191893;337753;0811;11/08/03;BRL;+40792,16;-44272,06;+70411,77;+66931,87;841107118; ; ; ; ; ; ; ;00010
    The FlatFile Definition is set:
    RecordParser = delimiter
    record = newline
    fields = ;
    When i test the parser, occur this error: “Found no valid records”
    How can I do to run this??

    Thanks


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 2.  RE: Generate Csv file from FlatFile Schema

    Posted Mon November 10, 2003 09:42 PM

    Hi,
    I believe that you have not created a FlatFileDictionary.
    Create a FlatFileDictionary with the recordname as recordWithNoID.Then create the field definitions and select the Extractor Type for the Field Definition(s) as Nth Position and set the postion of the field in the flat file starting from index 0.

    Then create a flat file schema:
    RecordParser = delimiter
    record = newline
    fields = ;

    In the Settings tab of the FlatFileSchema select the default record pointing to the FlatFileDictionary created above.

    Then you can test your schema by clicking on the Test tab in the FlatFileSchema object and browse the CSV file.

    Thanks
    sivaram


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 3.  RE: Generate Csv file from FlatFile Schema

    Posted Wed November 12, 2003 01:37 PM

    Thanks for help…It works fine!


    #edi
    #webMethods
    #Integration-Server-and-ESB