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.


#TechXchangePresenter
 View Only
  • 1.  FlatFile/CSV

    Posted Mon August 30, 2010 01:51 PM

    Hi all,
    How to upload .csv file in webMethods using Flat file schema. The question about how to construct flat file schema correctly?
    Thanks,


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


  • 2.  RE: FlatFile/CSV

    Posted Mon August 30, 2010 02:43 PM

    I have flat file structure:

    Record definition
    field def
    field def
    field def

    I am using delimeters:

    1. each record newline
    2. each Composite or Field ,
      But no success

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


  • 3.  RE: FlatFile/CSV

    Posted Mon August 30, 2010 08:50 PM

    Hello

    What about flatfile structure.How did you define the record and fields in there?

    thanks
    Anil


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


  • 4.  RE: FlatFile/CSV

    Posted Tue August 31, 2010 07:41 AM

    Hi,
    I defined:
    Record definition (newline)
    field def (,)
    field def (,)
    field def (,)
    But it doesn’t work. Actually service is working, but when I try to parse document into global service. I have error: Illegal file format… Maybe I miss something?
    1)I created schema;
    2)Created document type (In flat file structure);
    3)Used ConvertToString in global service.


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


  • 5.  RE: FlatFile/CSV

    Posted Tue August 31, 2010 04:51 PM

    Do your records have an identifier? If not and you plan to use a default record definition, you’ll need to define a dictionary holding the record definition.


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


  • 6.  RE: FlatFile/CSV

    Posted Wed September 01, 2010 08:15 AM

    Thank You all,
    You gave me enough information for constructing Flat File schema. Now everything working great. I have file with records (getFile) then these strings are converted (ConvertToValues) and inserted to table, where I have LOOP on table.
    Thanks,


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