A third party system wants to send and receive information as flat files. They have provided a layout document for the flat file, how can we create a flat-file definition in ION?
Thanks,
Prem
Hello,
You must use a file template and a file connection point for your external application. Everything is well explained in documentation.
Be aware that file template (text type) only works if there is a single record format (no structure with header and lines for example) : this is the current limitation. If you need to handle multi-format records for text file, i strongly suggest to use raw data (binary filte template). In this latter case, data is encoded into base 64 and file structure untouched.
Hi Prem,
If you choose binary file connection point, your text file will be transformed by ION into a custom BOD (type raw data).
To manage the interface (external app ==> M3) with a custom BOD based on raw data, simply create an input xsd in MEC like below :
(you can add FileName, FileExtension, FilePath as attributes of your noun "MyRawDataFile" - check file template for this)
In the java function :
String s = java.util.Base64.getDecoder().decode(iRawData);
Store the result in a String "s" and split it into an array for example.
String z[] = s.split("");
I hope this helps. Tell me if i did not understand your question.
