cancel
Showing results for 
Search instead for 
Did you mean: 

Receiver File/FTP Adapter

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

rajasekhar_reddy14
Active Contributor
0 Kudos

just add below values in Receiver File FCC.

Recordset Structure: Body

Body.fieldSeparator ,(commaa)

Body.endSeparator 'nl'

Regards,

Raj

Answers (1)

Answers (1)

Former Member
0 Kudos

For File Naming Scheme, put *

For parameters:

.fieldSeparator = ','

.endSeparator = u2018nlu2019

.fieldNames = list of field names in each record

All values are including quotes.