Archived discussions are read-only. Learn more about SAP Q&A

Content Conversion-Ignore Fields

Dear Expert,

I'm woking on PI 7.0 & I want to ignore fields suing Content Conversion:

  <?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_CLM_POCONTRACT_RESP_IB xmlns:ns0="http://tnb.com.my/xi/APPL/eSourcingIntegration">

- <HEADER>

       <NAME>#DataType[userdefined.md3]</NAME>

  </HEADER>

+ <COL>

  <COL1>DISPLAY_NAME</COL1>

       <COL2>DOCUMENT_DESCRIPTION</COL2>

       <COL3>EXTERNAL_ID</COL3>

       <COL4>TNB_TOTALVALUE</COL4>

       <COL5>TNB_VENDORNAME</COL5>

       <COL6>TNB_VENDORID</COL6>

  </COL>

- <POCONTRACT>

       <DISPLAY_NAME>0020000011</DISPLAY_NAME>

        <DOC_DESCRIPTION>Electrode Esab OK4600x2.5mm</DOC_DESCRIPTION>

       <EXTERNAL_ID>0020000011</EXTERNAL_ID>

       <TNB_TOTALVALUE>"20.00 MYR"</TNB_TOTALVALUE>

       <TNB_VENDORNAME>SYARIKAT MIZUN</TNB_VENDORNAME>

       <TNB_VENDORID>SG000175</TNB_VENDORID>

  </POCONTRACT>

- <FORMAT>

      <FNAME>PO_DET_</FNAME>

      <FDIR>PO</FDIR>

  </FORMAT>

  </ns0:MT_CLM_POCONTRACT_RESP_IB>

FNAME & FDIR is used for dunamic file name & file directory using PI Variable Subtition function and convert into .CSV file as

Filename:  PO_DET_2011.CSV

#DataType[userdefined.md3]

DISPLAY_NAME,DOCUMENT_DESCRIPTION,EXTERNAL_ID,TNB_TOTALVALUE,TNB_VENDORNAME,TNB_VENDORID

0020000011,Electrode Esab OK4600x2.5mm,0020000011,"20.00 MYR",SYARIKAT MIZUN,SG000175

PO_DET_,PO

my concern is to remove the FNAME & FDIR under fields FORMAT. i'm trying some function

Recordset Structure = HEADER,COL,POCONTRACT,FORMAT

**i want to remove FORMAT structure

Content Conversion Parameter

HEADER.fieldSeparator = ,

COL.fieldSeparator = ,

POCONTRACT.fieldSeparator = ,

FORMAT.fieldSeparator = ,

FORMAT.FNAME.fieldFixedLengths = 1

FORMAT.FNAME.fixedLengthTooShortHandling = Cut

FORMAT.FDIR.fieldFixedLengths = 1

FORMAT.FDIR.fixedLengthTooShortHandling = Cut

no error appear but FORMAT field still exist. please help, thanks.

replied

Sorry , i mean try the case. 

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_CLM_POCONTRACT_RESP_IB xmlns:ns0="http://tnb.com.my/xi/APPL/eSourcingIntegration">

- <HEADER>

       <NAME>#DataType[userdefined.md3]</NAME>

  </HEADER>

+ <COL>

  <COL1>DISPLAY_NAME</COL1>

       <COL2>DOCUMENT_DESCRIPTION</COL2>

       <COL3>EXTERNAL_ID</COL3>

       <COL4>TNB_TOTALVALUE</COL4>

       <COL5>TNB_VENDORNAME</COL5>

       <COL6>TNB_VENDORID</COL6>

  </COL>

- <POCONTRACT>

       <DISPLAY_NAME>0020000011</DISPLAY_NAME>

        <DOC_DESCRIPTION>Electrode Esab OK4600x2.5mm</DOC_DESCRIPTION>

       <EXTERNAL_ID>0020000011</EXTERNAL_ID>

       <TNB_TOTALVALUE>"20.00 MYR"</TNB_TOTALVALUE>

       <TNB_VENDORNAME>SYARIKAT MIZUN</TNB_VENDORNAME>

       <TNB_VENDORID>SG000175</TNB_VENDORID>

  </POCONTRACT>

- <FORMAT>

      <FNAME>PO_DET_</FNAME>

      <FDIR>PO</FDIR>

  </FORMAT>

  </ns0:MT_CLM_POCONTRACT_RESP_IB>

and in channel, configurate like this:

Recordset Structure = HEADER,COL,POCONTRACT,FORMAT


FORMAT.fieldFixedLengths = 0,0

FORMAT.fixedLengthTooShortHandling = Cut

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question