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 do I map a pub.flatFIle.convertToValues iteration to pub.file.stringToFile append?

  • 1.  How do I map a pub.flatFIle.convertToValues iteration to pub.file.stringToFile append?

    Posted Wed July 17, 2019 09:31 PM

    I want to iterate over a CSV file and write a (transformed) version of the data to another file. I’m trying to get my program working just writing anything to another file. I have created this pipeline …

    pub.file.getFIle
    REPEAT
    pub.flatFIle.convertToValues
    + SEQUENCE
    MAP
    pub.file.stringToFile
    BRANCH on ‘ffIterator’
    $null: SEQUENCE
    MAP
    EXIT ‘$loop’

    But I’m confused about what in my pipeline I need to link to get a string representation of the current iteration of the file into the “stringToFile” method. I have attached a screen shot of what the pipeline options are currently.

    What do I need to link or create to bridge the gap?
    com.wm.app.b2b.server.ServiceException: [ISS.0086.9249] Missing Parameter: data
    at pub.CommonUtils.getRequiredObjParam(CommonUtils.java:104)
    at

    2019-07-17 (3).pnghttps://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/bc13fb4225a279cbeb59f396b1a98ec4fad28cc2_2_1035x744.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/bc13fb4225a279cbeb59f396b1a98ec4fad28cc2_2_1380x992.png 2x" data-dominant-color="0B0B0A">
    2019-07-17 (3).png1921×1381 521 KB


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


  • 2.  RE: How do I map a pub.flatFIle.convertToValues iteration to pub.file.stringToFile append?

    Posted Thu July 18, 2019 01:35 PM

    Hi Tony,

    you can add a pub.xml:documentToXMLString to convert ffValues entry to a XML String which can be written to a file.
    Map the output of documentToXMLString to the data field of stringToFile and set append to true to write all lines to the same file.

    Remember to add the path where the file will be written to to the fileAccessControl.cnf file in the WmPublic/config directory and reload the WmPublic package afterwards.

    Regards,
    Holger


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


Related Content