Does anyone have any experience in this area ? I know that a Java service can be written to parse structured data files, and incorporate the file into a record. However, I am not a Java programmer and would like to find a method within the system.
My goal is to FTP the flat files to the webMethods server, have the server parse the files and using Trading Networks, distribute the documents based upon content of the file.
Any suggestions would be greatly appreciated.
Thank you.
You can handle this scenario by following the sequence:
- Create XML template that describes your flat file record structure.
- Use the stringToDocument service to convert the XML structure into a Document.
- Use the documenttoRecord to convert document object to idata object.
- Use the wm.b2b.edi:convertToValues to format the idata object in proper flat file format.
- Now that you have your file in a record structure you can do all the manipulations to reach the final format.
You can also find the related information in the EDIAdapter user guide.