File Content conversion issue

[Former Member]

Hi Guys,

               I am using an IDOC to text file scenario. But the resulting file only "nl" characters.

I can see the mapping working fine from SXMB_MONI

  <ConsignmentNumber>101010</ConsignmentNumber>

  <CustomerID>303030</CustomerID>

  <CompanyName>ABC Corp</CompanyName>

  <Address1>PO Box 1100, Mission Bay</Address1>

  <Address5>London</Address5>

  <Carrier>0</Carrier>

  <CostCentre>1</CostCentre>

  <EmailAddressSend>0</EmailAddressSend>

  <EmailAddress2Send>0</EmailAddress2Send>

  <EmailAddress3Send>0</EmailAddress3Send>

Here is my FCC screen shot

[former_member184681 · Accepted solution]

Hi,

I had the same issue some time ago. I believe your target structure is:

<Message_Type>

  <ConsignmentNumber>101010</ConsignmentNumber>

  <CustomerID>303030</CustomerID>

   ...

</Message_Type>

Am I right? If so, you have to change it to the following:

<Message_Type>

   <SomeStructureName>

    <ConsignmentNumber>101010</ConsignmentNumber>

    <CustomerID>303030</CustomerID>

     ...

   </SomeStructureName>

</Message_Type>

FCC in receiver channels only work with this kind of structure. Some "grouping" structure is required to generate flat file lines, otherwise message content is ignored, just the way you described it.

Still, Baskar is also right about the quotes in endSeparator - it should be 'nl'.

Hope this helps,

Greg

[Former Member · Accepted solution]

Hi Greg, Thanks for the reply. The issue been solved.

[Former Member · Accepted solution]

Hi Greg,

              When there is no value for a mapping field, its skipping the that field in fixed length format.

I need to fill space, even if the value for a field is blank.

I remove the field separator, still if the value for a field is blank, PI just omits the whole field. There is no space filled for that field in the fixed length file.

Thanks

Sam

[baskar_gopalakrishnan2]

one of the issues is  use quote for endSepartor as  'nl' .

[rajasekhar_reddy14]

Hi Sam,

You really want Fixed length ? remove field names and fixed length and use only field seprataor and end separator.

Regards,

Raj