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

, ,
1

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).png
2019-07-17 (3).png1921×1381 521 KB

2

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