on 08-14-2014 10:02 AM
Hi,
The scenario is file to file. Inbound and async. The encrypted data is coming from third party. we are decrypting it and doing the content conversion. Earlier there was only 1 node. now the requirement is that they will be sending the header also. now there are 2 nodes with children. earlier there was only 1 node with children and the data was processing successfully. now when I have added header the fields of the header are not getting the value. Like header has the fields like Number_of_records, sbm_system_date etc.. but the fields of the header are getting replaced by the fields of the other node. I have attached the screenshots for the same. let me know if you need any more information. The payload is like below
<?xml version="1.0" encoding="utf-8" ?>
</BillingData_SBM>
Hi Sherwin,
In your FCC you have added only <BillingData_SBM> node RecordSetStructe in channel, so the header data not coming in your payload. add <BillingData_Header> also like below.
RecordSet Structure: BillingData_Header, 1 ,BillingData_SBM, *
Regards,
Praveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sherwin,
The "BillingData_Header" node not created in your XML payload because you have not added the node "BillingData_Header" in your FCC.
Add that node in recordset structure like below.
This will convert your FCC into XML with nodes <BillingData_Header> and <BillingData_SBM>.
<?xml version="1.0" encoding="utf-8" ?>
<ns:MT_BillingData_SBM xmlns:ns="http://pspcl.com/xi/SBM/IF0043_BillingData_100">
<BillingData_Header>
....
</BillingData_Header>
<BillingData_SBM>
....
</BillingData_SBM>
</MT_BillingData_SBM>
Please check this link SAPTechnical.COM - File Content Conversion
Regards,
Praveen
whenever you are doing such scenarios I mean header,1 , detail, *
we need Keyfield in both header as well as Detail otherwise FCC wont perform correctly...
Meanwhile if you have keyfields in both structure use the same content conversion and add one more parameter
ignoreRecordsetName = true
let us know if you stillface an issue.
Thanks,
Sreenivas
I am using the below entries for content conversion.
BillingData_Header.fieldSeparator | , |
BillingData_Header.endSeparator | 'nl' |
BillingData_Header.fieldNames | Of_Records,BillingData_Header,BillingData_SBM,KeyField |
BillingData_Header.keyFieldInStructure | ignore |
BillingData_Header.keyFieldValue | H |
BillingData_SBM.fieldSeparator | , |
BillingData_SBM.endSeparator | 'nl' |
BillingData_SBM.fieldNames | SUB_DIVISION_CODE,MRU,Connected_Pole_INI_Number,NEIGHBOR_METER_NO,STREET_NAME,INSTALLATION,MR_DOC_NO,SCHEDULED_MRDATE,METER_NUMBER,MANUFACTURER_SR_NO,MANUFACTURER_NAME,CONTRACT_ACCOUNT_NUMBER,CONSUMPTION_KWH,CONSUMPTION_KWAH,CONSUMPTION_KVA,CUR_METER_READING_KWH,CUR_METER_READING_KVA,CUR_METER_READING_KVAH,CUR_METER_READING_DATE,CUR_METER_READING_TIME,CUR_METER_READER_NOTE,PRV_METER_READING_KWH,PRV_METER_READING_KVA,PRV_METER_READING_KWAH,PRV_METER_READING_DATE,PRV_METER_READING_TIME,PRV_METER_READER_NOTE,OCTROI_FLAG,SOP,ED,OCTROI,DSSF,SURCHARGE_LEIVED,SERVICE_RENT,METER_RENT,SERVICE_CHARGE,MONTHLY_MIN_CHARGES,PF_SURCHARGE,PF_INCENTIVE,DEMAND_CHARGES,FIXEDCHARGES,VOLTAGE_SURCHARGE,PEAKLOAD_EXEMPTION_CHARGES,SUNDRY_CHARGES,MISCELLANEOUS_CHARGES,FUEL_ADJUSTMENT,BILL_NUMBER,NO_OF_DAYS_BILLED,BILL_CYCLE,BILL_DATE,DUE_DATE,BILL_TYPE,PAYMENT_AMOUNT,PAYMENT_MODE,CHECK_NO,BANK_NAME,PAYMENT_ID,IFSC_CODE,MICRCODE,PAYMENT_DATE,PAYMENT_REMARK,TOT_BILLAMOUNT,SBM_NUMBER,METER_READER_NAME,INHOUSE_OUTSOURCED_SBM,TransfromerCode,MCB_RENT,LPSC,TOT_AMT_DUE_DATE,TOT_SOP_ED_OCT,KeyField |
BillingData_SBM.keyFieldInStructure | ignore |
BillingData_SBM.keyFieldValue | P |
ignoreRecordsetName | true |
The error is like I am not able to get the value/fields of the header. only the fields of BillingData_SBM is getting displayed.
Hi,
I am still facing the issue. below is the input data.
11,16/08/2014,11:26:09,I0027G14_14082014112726.enc,1,I0027G14,H
4272,MR60BM,J-DP06-FL12-031-004_G-1-P07,,,5000057583,200000001829984,25-04-2014,10089749,3376181,Capital Meters,100106763,16430.000,18256.000,0.000,0.000,0.000,0.000,13-08-2014,182427,D,19170.000,0.000,0.000,30-06-2011,,,Y,95465.00,7636.92,1643.00,4773.08,0.00,0.00,292.00,0.00,11638.20,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,I002714H131824001,1141,2,28-08-2014,26-08-2014,2,0.00,,,,,,,,,109970.00,I0027G14,USER1,PSPCL,,156.00,9591.00,119561.00,109518.00,P
4272,MR60BM,J-DP06-FL12-031-004_G-1-P06,,,5000057703,200000001830038,25-04-2014,10089869,8,Saraf Industries,100106883,5429.000,6032.000,0.000,0.000,0.000,0.000,13-08-2014,182458,N,10990.000,0.000,0.000,31-08-2011,,,Y,27437.00,2195.08,543.00,1371.92,0.00,0.00,294.00,0.00,6963.88,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,I002714H131824002,1078,2,28-08-2014,26-08-2014,2,0.00,,,,,,,,,71110.00,I0027G14,USER1,PSPCL,,146.00,2788.00,73898.00,70671.00,P
4272,MR60BM,J-DP06-FL12-031-004_G-1-P06,,,5000057589,200000001829990,25-04-2014,10089755,426884,BHEL,100106769,4811.000,5346.000,0.000,0.000,0.000,0.000,14-08-2014,093421,N,2550.000,0.000,0.000,30-06-2011,,,Y,23404.00,1872.62,481.00,1170.38,0.00,0.00,317.00,0.00,11143.64,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,I002714H140934003,1142,2,02-09-2014,27-08-2014,2,0.00,,,,,,,,,27400.00,I0027G14,USER1,PSPCL,,156.00,2388.00,29788.00,26928.00,P
4272,MR60BM,J-DP06-FL12-031-004_G-1-P04,,,5000057735,200000001830044,25-04-2014,10089901,371552,Havell,100106915,12627.000,14030.000,0.000,16000.000,0.000,0.000,14-08-2014,093448,I,17580.000,0.000,0.000,31-08-2011,,,Y,71534.00,5722.46,1263.00,3576.54,0.00,0.00,294.00,0.00,3338.43,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,I002714H140934004,1079,2,02-09-2014,27-08-2014,2,0.00,,,,,,,,,125150.00,I0027G14,USER1,PSPCL,,146.00,7197.00,132347.00,124708.00,P
4272,MR60BM,J-DP06-FL12-031-004_G-1-P04,,,5000057727,200000001830039,25-04-2014,10089893,826804,ECE,100106907,20717.000,23019.000,0.000,0.000,0.000,0.000,14-08-2014,093606,D,29810.000,0.000,0.000,31-08-2011,,,Y,123634.00,9890.46,2072.00,6181.54,0.00,0.00,294.00,0.00,13463.76,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,I002714H140936005,1079,2,02-09-2014,27-08-2014,2,0.00,,,,,,,,,181900.00,I0027G14,USER1,PSPCL,,146.00,12407.00,194307.00,181456.00,P
Hi,
Thanks for the reply. I have used the parameters in FCC which I have posted above. are they correct?
I am not getting the desired result. There may be issue with the input file/Parameters.
I am getting the below result in which the header values are not coming.
<?xml version="1.0" encoding="utf-8" ?>
</BillingData_SBM>
Hi,
Here are the parameters which I have used.
BillingData_Header.fieldSeparator | , |
BillingData_Header.endSeparator | nl |
BillingData_Header.fieldNames | Number_Of_Records,BillingData_Header,BillingData_SBM,KeyField |
BillingData_Header.KeyFieldName | KeyField |
BillingData_Header.keyFieldValue | H |
BillingData_SBM.fieldSeparator | , |
BillingData_SBM.endSeparator | nl |
BillingData_SBM.fieldNames | SUB_DIVISION_CODE,MRU,Connected_Pole_INI_Number,NEIGHBOR_METER_NO,STREET_NAME,INSTALLATION,MR_DOC_NO,SCHEDULED_MRDATE,METER_NUMBER,MANUFACTURER_SR_NO,MANUFACTURER_NAME,CONTRACT_ACCOUNT_NUMBER,CONSUMPTION_KWH,CONSUMPTION_KWAH,CONSUMPTION_KVA,CUR_METER_READING_KWH,CUR_METER_READING_KVA,CUR_METER_READING_KVAH,CUR_METER_READING_DATE,CUR_METER_READING_TIME,CUR_METER_READER_NOTE,PRV_METER_READING_KWH,PRV_METER_READING_KVA,PRV_METER_READING_KWAH,PRV_METER_READING_DATE,PRV_METER_READING_TIME,PRV_METER_READER_NOTE,OCTROI_FLAG,SOP,ED,OCTROI,DSSF,SURCHARGE_LEIVED,SERVICE_RENT,METER_RENT,SERVICE_CHARGE,MONTHLY_MIN_CHARGES,PF_SURCHARGE,PF_INCENTIVE,DEMAND_CHARGES,FIXEDCHARGES,VOLTAGE_SURCHARGE,PEAKLOAD_EXEMPTION_CHARGES,SUNDRY_CHARGES,MISCELLANEOUS_CHARGES,FUEL_ADJUSTMENT,BILL_NUMBER,NO_OF_DAYS_BILLED,BILL_CYCLE,BILL_DATE,DUE_DATE,BILL_TYPE,PAYMENT_AMOUNT,PAYMENT_MODE,CHECK_NO,BANK_NAME,PAYMENT_ID,IFSC_CODE,MICRCODE,PAYMENT_DATE,PAYMENT_REMARK,TOT_BILLAMOUNT,SBM_NUMBER,METER_READER_NAME,INHOUSE_OUTSOURCED_SBM,TransfromerCode,MCB_RENT,LPSC,TOT_AMT_DUE_DATE,TOT_SOP_ED_OCT,KeyField |
BillingData_SBM.keyFieldName | KeyField |
BillingData_SBM.keyFieldValue | P |
ignoreRecordsetName | true |
Hi Shrewin,
The below entry in your FCC is wrong i think.
BillingData_Header.fieldNames | Number_Of_Records,BillingData_Header,BillingData_SBM,KeyField |
Correct entry:
BillingData_Header.fieldNames Number_Of_Records,SBM_System_Date,SBM_System_Time,SBM_System_File_Name,Billing_Cycle,SBM_Number,KeyField
Based on your configuration keyfield is 4th element but in your file its coming as the 7th element.
Try the configuration suggested by sreenivas, it works for me also.
Regards,
Praveen
Yes right. I have corrected it and it is working fine now. Thank you so much Sreenivas Veldanda and praveen kumar. You guys are great
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.