Blank line getting generated in target system while using File Content Conversion

[Former Member]

Hi

I am having a multiple mapping because of that i am using Variable substituion . for that i am using an extra field Time stamp for using in the variable substituion . this field should not be part of the the target payload when it is finally transmitted to the target system. i used a workaround in the FCC to remove the particular field or value from the file, in a FCC using the  Parameter Name <Node>.fixedLengthTooShortHandling and using the value Cut.

The hurdle with that is it leaves an empty line for that particluar record after the FCC is done. Now the customer doesn't want this blank line in the target file. i am not using dynamic file configuration because of multiple mapping.

One of the XML file is like this :

<         

<ns     1:MT_BaanSO850_1 xmlns:ns1="xxxAN_SO">

- <BaanSO850_1>

<Ouefrence>"C1221205180001"</OurRefrence>

<OurIdentification>"sap122"</OurIdentification>

<PurchaseOrder>4200000356</PurchaseOrder>

<NetworkAddress>"sap122"</NetworkAddress>

<CodeInMessage>"SAP"</CodeInMessage>

<CodeInMessage1>"850"</CodeInMessage1>

<OrderType>"PUC"</OrderType>

<Constant>""</Constant>

<Currentdate>120518</Currentdate>

<currentTime>0901</currentTime>

</BaanSO850_1>

- <DummyTimeStamp>

<Timestamp>120518 _09</Timestamp>

</DummyTimeStamp>

</ns1:MT_BaanSO851>

T     Target file is like this but with blank line

"C1221205180001":"sap122":4200000355:"sap122":"SAP":"850":"DD1":"":120518:0703

----------------------------BLANK LINE------------------------------------------------------------------------

"C1221205180001":"sap122":4200000356:"sap122":"SAP":"850":"PUC":"":120518:0704

PLEASE LET ME KNOW how to remove this blank line

Regards

Rahman

[Former Member]

Hi

Content Conversion parameters are like ths

Record set Structure: BaanSO850_1,DummyTimeStamp

BaanSO850_1.fieldSeparator	:
BaanSO850_1.fieldNames	OurRefrence,OurIdentification,PurchaseOrder,NetworkAddress,CodeInMessage,CodeInMessage1,OrderType,Constant,Currentdate,currentTime
BaanSO850_1.endSeparator	'nl'
BaanSO850_1.fixedLengthTooShortHandling	Ignore
DummyTimeStamp.fieldFixedLengths	0
DummyTimeStamp.fixedLengthTooShortHandling	Cut
DummyTimeStamp.endSeparator	'nl'

Regards

Rahman

[zameerf]

Hi,

it should be

DummyTimeStamp.endSeparator '0'

-Zameer

[Former Member]

Hi

I know the problem is because of DummyTimeStamp but i could not get anyother alternative. I did try using endseparator as 0 , but it doesnt work

Please help

Regards

Rahman

[zameerf]

Hi,

just curious, did you use '0' (with quotes) as endSeparator?

[Former Member]

HI Zameer,

I did try with single quotes only

More inputs please

Regards

Rahman

[zameerf]

Just wondering why it isn't working! as i have encountered such situations and resolved with these parameters.

Another option i could see here is to make use of the Currentdate, currentTime field value from the BaanSO850_1 segment to derive the Time stamp.

eg,

var1: payload: MT_BaanSO850_1,1,BaanSO850_1,1,Currentdate,1

var2: payload: MT_BaanSO850_1,1,BaanSO850_1,1,currentTime,1

and make %var1%_%var2% in file name scheme

this way you can avoid the extra segment DummyTimeStamp in the target structure itself.

[Former Member]

Hi Zameer,

As i said in my original Question , i am having multimapping with different sets of fields , the one whihc i have given has those two fields but in others its not .but the requirement is same for all 6 files . 6 files has to be genrated with those mappings. Thats why i used this dummy timestamp field /node

Regards

Rahman

[former_member184681]

Hi,

The problem is caused by this node:

<DummyTimeStamp>

   <Timestamp>120518 _09</Timestamp>

</DummyTimeStamp>

The FCC generates the empty line because of this node. So in order to get rid of this, you will have to add one more Recordset Structure: DummyTimeStamp, and the parameters that Zameer already mentioned.

Regards,

Greg

[zameerf]

Hello,

Please add the below parameters along with <Node>.fixedLengthTooShortHandling cut

<Node>.fieldFixedLengths 0

<Node>.endSeparator '0'

Hope this helps

-Zameer