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.