I have a data flow that sends data to a Binary File Format template and wondering how I can decode it to a destination within the Flow.
Mainly, concerned about decoding in the Flow.
Anyone? The data flow has a binary file template used on the Mapping and sending a XML file with binary in the RAW DATA field.
How can I decode and send just the Raw Data to the SFTP site in Text Format...not XML.
In reply to jrodriguez_Consultant:
In reply to 925750:
Can you provide some more details on what you're trying to do here? If you're using the binary feature of file templates, than you can use that to deliver your file (e.g. XML) exactly as is to a destination. Is the goal to pick up an XML file (not a BOD XML) and deliver that XML exactly as it was formatted during pickup?
Or are you trying to pick up an XML file as binary and then process & decode the data so you can map the fields to another data format?
Chapter 5 & Page 148 of the Infor ION Desk User Guide has details on XSLT extensions within the Mapper that you can use to decode a binary file with and write elements to a target BOD schema. That may or may not be helpful to you based on the situation you're facing right now but thought I'd mention it.
The scripting engine that Alistair mentioned is a great tool if you need to take some binary file (e.g. XML) and do arbitrary data transformation or enrichment on it using Python. Converting XML to an EDI file, for example.
But going back to the beginning, can you describe what you're ultimately trying to generate as the final data format?
In reply to Mike Kalinowski: