on 05-17-2011 11:53 AM
Hi,
I want to take in a message packet and output it to a file.
You can dump the XML out by simply choosing the "File" message prototcol. However, I don't want the XML. I want the data. For example if the inbound interface message type is:
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_BalanceExtractHAPS_ForFTP xmlns:ns0="http://gcc.access.com/360ToHaps">
- <Body>
<Reference>PCN123456</Reference>
<Balance>65.50</Balance>
<BalanceSign>+</BalanceSign>
</Body>
</ns0:MT_BalanceExtractHAPS_ForFTP>
I want an output file with 1 record as follows:
PCN123456,65.50,+
Fairly sure you have to use the FIle Content Conversion message protocol but I have a couple of questions:
1. What do you put in File Name Scheme ?
2. Would the following Content Conversion paramaters be used to give me comma separated output ?
Body.fieldSeparator has a value of ","
Body.fieldName has a value of "Reference,Balance,BalanceSign"
Any help would be much appreciated.
Cheers,
PaulC.
just add below values in Receiver File FCC.
Recordset Structure: Body
Body.fieldSeparator ,(commaa)
Body.endSeparator 'nl'
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For File Naming Scheme, put *
For parameters:
.fieldSeparator = ','
.endSeparator = u2018nlu2019
.fieldNames = list of field names in each record
All values are including quotes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.