File-File Scenario

[Former Member]

Hi,

I am trying a file to file scenario. I am using content conversion. In SXMB_MONI I could see the xml msg with all the nodes ie. Header Node inside that a key, id, project nodes. But in the destination file only the key node gets printed. id and project nodes are missing in the target file.

Any inputs on this wud be of gr8 help.

Thanks in Advance.

Jai Shankar.

[Former Member · Accepted solution]

Heyy,

just check ur receiver content conversion parameters whether u have specified the fieldSeparator and the end Separator properly.

cheers

jithesh

[Former Member · Accepted solution]

Hi,

Please can you put the target strucutre?

Did you try changing the context and then running hte scenario.

Also, Please can you check if the receiver data is coming properly.

Regards

Vijaya

[Former Member · Accepted solution]

Hi All,

I checked the mapping with inbound XML pay load. It works perfectly fine.

My target file contains only

H,H,H

Here H is the value of key. There were 3 header nodes.

In content conversion I have given the values

Header.fieldSeparator ,

Header.endSeparator 'nl'

Header.fieldLengthTooShortHandling cut.

Vijaya, how can I change the context and try can u explain it pls?

Regards,

Jai Shankar.

[former_member206604 · Accepted solution]

Hi,

Check your <b>Reciever Adapter</b> content conversion. Have you given the right node in the Record Structure field and parameters like fieldSeparator and endSeparator.

Check in SXMB_MONI if the mapping is done properly and you are getting the expected XML. If that is fine then you need to look into the Reciever Adapter content conversion.

Refer this Blog /people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp

Thanks,

Prakash

[Former Member · Accepted solution]

Hi Jai,

Can u put up a sample file.

Try running the scenario without using the 'fieldLengthTooShortHandling' function, because in case there is no value coming in any of the fields, it will cut the node.

Thanks,

Varun Joshi

[Former Member · Accepted solution]

Hi,

I am getting the expected form of xml msg in response at SXMB_MONI.

Only the in target msg I cant get the rest of nodes.

My sample input file is like

H,1234,JAI,SHANKAR,PROJ1

H,1235,JAI,SHANKAR,PROJ1

H,1236,JAI,SHANKAR,PROJ1

Here I have concatenated Jai & Shankar to single name Jai-Shankar in target. I can also find this concatenation in response XML at SXMB_MONI.

My target file being created is like

H,H,H

Regards,

Jai Shankar.

[Former Member · Accepted solution]

Hi,

Please can you look at this weblog: /people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

Regards

Vijaya

[Former Member]

Hi All,

Finally my issue got resolved. I had given the end Separator for header but not for the Recordset, that has caused all these problems.

Thanks for all ur valuable inputs.

Thanks & Regards,

Jai Shankar.

[bhavesh_kantilal]

Hi jai,

Copy the incoming payload from SXMb_MONI and then use it to test your Mapping?

Is the mapping when testing using the payload from SXMb_MONI working fine?

Regards,

Bhavesh

[Former Member]

Hi,

Is ID and project node at the same herarchy as Key node. Please can you show us put in the details of the structure.

Before that can you map the 'Context' of the nodes that you are not able to see one up higher in the hierarchy (here to header or key) and do test in the mapping itself with the payload Data that you have.

Regards

Vijaya

[Former Member]

Hi Vijaya,

My target structure is

Header

>Key

>Id

>Project

I tested with a sample pay load in mapping, it produces the target structure correctly.

Thanks & Regards,

Jai Shankar.