Sender content conversion problem

[Former Member]

Hi all,

I am working on a file>XIrfc scenario.

I need to convert the simple structure flat file to xml file.

Flat file format

74723123-45-678902100977      00000000001130200800000      M                  N

i have done below configuration,

DT_BNI1012.fieldFixedLengths : 5,11,2,12,5,5,8,5,5,1,1,1,1,1,14,1,1
DT_BNI1012.endSeparator : 'nl'
DT_BNI1012.fieldNames : bplan,ssn,rec_id,pernr,eepct,bcpct,begda,apbp,sup_per,e_ind,p_frq,md_flag,cgdp,nqdc,filler1,hc_ind,filler2

Everything is working file & i am able to see the xml file in CC monitoring(RWB).

But, final file is getting truncated at recordset.

Any idea, what am i missing...... ?????

[Former Member · Accepted solution]

hI.

Can you put your payload?

I think your received more fields thant you expected.

Regards

Lucho

[Former Member · Accepted solution]

Below is my payload , after content conversion,

<?xml version="1.0" encoding="utf-8" ?> 
- <ns:MT_BNI1012 xmlns:ns="http://*******.com/******">
- <Record>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>123-45-6789</ssn> 
  <rec_id>02</rec_id> 
  <pernr /> 
  <eepct /> 
  <bcpct /> 
  <begda /> 
  <apbp /> 
  <sup_per /> 
  <e_ind /> 
  <p_frq /> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2>N</filler2> 
  </DT_BNI1012>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>123-45-6789</ssn> 
  <rec_id>02</rec_id> 
  <pernr>102727</pernr> 
  <eepct>00000</eepct> 
  <bcpct>00000</bcpct> 
  <begda>11302008</begda> 
  <apbp>00000</apbp> 
  <sup_per /> 
  <e_ind /> 
  <p_frq>B</p_frq> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2>N</filler2> 
  </DT_BNI1012>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>123-45-6789</ssn> 
  <rec_id>02</rec_id> 
  <pernr /> 
  <eepct /> 
  <bcpct /> 
  <begda /> 
  <apbp /> 
  <sup_per /> 
  <e_ind /> 
  <p_frq /> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2 /> 
  </DT_BNI1012>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>123-45-6789</ssn> 
  <rec_id>02</rec_id> 
  <pernr>103571</pernr> 
  <eepct>00000</eepct> 
  <bcpct>00000</bcpct> 
  <begda>11302008</begda> 
  <apbp>00000</apbp> 
  <sup_per /> 
  <e_ind /> 
  <p_frq>M</p_frq> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2 /> 
  </DT_BNI1012>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>123-45-6789</ssn> 
  <rec_id>02</rec_id> 
  <pernr /> 
  <eepct /> 
  <bcpct /> 
  <begda /> 
  <apbp /> 
  <sup_per /> 
  <e_ind /> 
  <p_frq /> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2 /> 
  </DT_BNI1012>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>123-45-6789</ssn> 
  <rec_id>02</rec_id> 
  <pernr>129930</pernr> 
  <eepct>00000</eepct> 
  <bcpct>00000</bcpct> 
  <begda>11302008</begda> 
  <apbp>00000</apbp> 
  <sup_per /> 
  <e_ind /> 
  <p_frq>M</p_frq> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2 /> 
  </DT_BNI1012>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>123-45-6789</ssn> 
  <rec_id>02</rec_id> 
  <pernr /> 
  <eepct /> 
  <bcpct /> 
  <begda /> 
  <apbp /> 
  <sup_per /> 
  <e_ind /> 
  <p_frq /> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2 /> 
  </DT_BNI1012>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>123-45-6789</ssn> 
  <rec_id>02</rec_id> 
  <pernr>103613</pernr> 
  <eepct>00000</eepct> 
  <bcpct>10000</bcpct> 
  <begda>11302008</begda> 
  <apbp>00000</apbp> 
  <sup_per /> 
  <e_ind /> 
  <p_frq>B</p_frq> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2 /> 
  </DT_BNI1012>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>123-45-6789</ssn> 
  <rec_id>02</rec_id> 
  <pernr /> 
  <eepct /> 
  <bcpct /> 
  <begda /> 
  <apbp /> 
  <sup_per /> 
  <e_ind /> 
  <p_frq /> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2>N</filler2> 
  </DT_BNI1012>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>123-45-6789</ssn> 
  <rec_id>02</rec_id> 
  <pernr>100977</pernr> 
  <eepct>00000</eepct> 
  <bcpct>00000</bcpct> 
  <begda>11302008</begda> 
  <apbp>00000</apbp> 
  <sup_per /> 
  <e_ind /> 
  <p_frq>M</p_frq> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2>N</filler2> 
  </DT_BNI1012>
- <DT_BNI1012>
  <bplan>74723</bplan> 
  <ssn>TT112040800</ssn> 
  <rec_id>06</rec_id> 
  <pernr>000060000000</pernr> 
  <eepct>00000</eepct> 
  <bcpct>00000</bcpct> 
  <begda>00</begda> 
  <apbp /> 
  <sup_per /> 
  <e_ind /> 
  <p_frq /> 
  <md_flag /> 
  <cgdp /> 
  <nqdc /> 
  <filler1 /> 
  <hc_ind /> 
  <filler2 /> 
  </DT_BNI1012>
  </Record>
  </ns:MT_BNI1012>

But, i am receiving output file as ,

<?xml version="1.0" encoding="UTF-8" ?> 
- <ns0:MT_BNI1012 xmlns:ns0="http://*******.com/******">
  <Record /> 
  </ns0:MT_BNI1012>

Dunno.....wat is going wrong........

Edited by: san485 on Nov 4, 2010 9:38 PM

Edited by: san485 on Nov 4, 2010 9:39 PM

[Shabarish_Nair · Accepted solution]

if you are getting the final XML after FCC as expected, then it should be an issue in your mapping.

Check your response mapping creating the output file also check the receiver file FCC.

[Former Member · Accepted solution]

Thanks guys.....

There was a mapping issue.

[sumesh_k2]

HI,

Have you mentioned DT_BNI1012 in the recordset structures?

i.e. it should look like Record, DT_BNI1012

Regards,

Sumesh K.