Skip to Content
avatar image
Former Member

Reading CSV file using Message Transforom Bean

Hi All,

I was working on SFTP adapter which picks the CSV file that needs to convert into XML. So i am using Message Transform Bean module for conversion. PI version is 7.31 dual stack.

Below are the config done in channel.

When the channel is picked the file payload is looks like below.

The channel was reading the filed names from the CSV file. I want to ignore that and also there is "" symbol for the values that needs to be ignore. So please suggest to resolve this.

Regards,

Raju

sftp.jpg (308.4 kB)
payload.jpg (254.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 25, 2016 at 01:22 PM

    HI Raju,

    Add xml.enclosureSign = " for it to remove the double quotes around each field. As far as the header stuff you are getting information from the structure based upon the key xml.processFieldNames = fromConfiguration. That is instructing the MTB to read the data from your configuration so you should not observe any case where it is reading from the file itself.

    Regards,

    Ryan Crosby

    Add comment
    10|10000 characters needed characters exceeded