File to XML in sender SFTP - Payload not available in the message (PI 7.1)

[Former Member]

Dear All,

I have used SimplePlain2XML for converting txt file to XML in sender SFTP .  File is picked and only name space details are available, but give input payloads not available in the message.

Input txt file format:

Sender Data Type:

Message Transformation Bean:

in sxi_monitor:

Please help me to solve this issue.

Thank You.

Regards,

Vinoth

[tinu_n · Accepted solution]

Hi Vinoth,

For your data type structure, try with the ConversionType = "StructPlain2XML", because it has two substructures,

<MT_Symphonymessage>

          <Symphonydatalist>

                       <Symphonydata>

If you want to use "SimplePlain2XML" then you need to modify your data type to

<Symphonymessage>

         <Symphonydata>

In case the record  <Symphonydatalist> is mandatory, Please try with the below FCC parameters,

xml.Symphonydata.endSeparator                       'nl'

xml.Symphonydata.fieldNames                       SendingSystemID,InterfaceID,...

xml.Symphonydata.fieldSeparator                       |

xml.Symphonydata.keyFieldInStructure            add

xml.Symphonydata.keyFieldValue                  <key field value>

xml.conversionType                                    StructPlain2XML

xml.documentName                                    <MessageType>

xml.documentNamespace

xml.ignoreRecordSet                                    true

xml.keyFieldName                                  <Key Field Name>

xml.keyFieldType                                   CaseSensitiveString

xml.processFieldNames                          fromConfiguration

xml.recordsetName                                Symphonydatalist

xml.recordsetStructure                              Symphonydata,*

For the conversionType "StructPlain2XML" - Key field is mandatory

refer this thread

Regards,

Tinu

[Former Member · Accepted solution]

Hi Tinu,

Thanks for your help.

I tried with the parameters which you mentioned for "StructPlain2XML", but facing same problem.

Then i used "SimplePlain2XML" by removing <Symphonydatalist> from the data type structure and it worked.

Regards,

Vinoth

[RaghuVamseedhar]

Vinoth,

Please use single quotes

New line : - 'nl'

Pipe :- '|'     OR     '0x7C'

[umesh_badveli]

Hi Vinoth

Try to configure Module parameters Using Below Document

If you get any Error please post the Screenshot with Configurations

Regards

Umesh

[former_member182412]

Hi Vinoth,

Configure the channel as per this blog How To...Content conversion module with J2EE JMS adapter - Process Integration - SCN Wiki

SimplePlain2XML have the parameter xml.structureTitle not xml.recordsetName

Regards,

Praveen.