File Content conversion Error

[Former Member]

Hi All

I am facing problem in the file content conversion my source will be looking

like given below

H_0000000542156106_{BELL, MARCI LEA}01~~~~~

I_BACB30VF4K41400_12/1/201216160/ACCOMODATION SALES_0.694109095_3000000170725-1-4~0001

H_0000000542156107_{BELL, MARCI LEA}01~~~~~

I_BACB30VF4K5900_6/30/201216160/ACCOMODATION SALES_0.693909095_3000000170725-2-1~0001

I_BACB30VF4K5900_8/30/201216160/ACCOMODATION SALES_0.693909095_3000000170725-2-2~0002

I am getting below error in the channel

interval started. Length: 60.0 seconds

10/6/11 11:34:00 PM 17b2f491-d84b-4195-01de-abee1592a89c Conversion of file content to XML failed at position 0: java.lang.Exception: ERROR converting document line no. 1 according to structure 'Header':java.lang.Exception: ERROR in configuration / structure 'Header.': More elements in file csv structure than field names specified!

I have configured below parameter

Since it is asking key field value I have marked Keyfield as H & I

Header.fieldSeparator ~

Header.endSeparator u2018nlu2019

Header.fieldname H1,Sold_To,Supply_ord_No,Byr_NM,Ship_Typ

Header.fieldContentFormatting nothing

Header.keyFieldvalue H

Item.fieldSepartor ~

Item.keyFieldValue I

Item.endSeparator u2018nlu2019

Item.fieldname L1,Item,Actl_Qty,Delv_dt,WBS,Net_Val,Batch_ORD_No,Fwd_agt_np,Css_Ref_No

,Line_Sch_No

Item.fieldContentFormatting nothing

IgnoreRecordsetName true

Please do guide what is the issue

Thanks

Sankar

[Former Member · Accepted solution]

Sankar

Your input file is having more fields than specified in configuration. Either you can rectify the source file or you can configure as follows

Header.additionalLastFields ignore

Item.additionalLastFields ignore

FYI!

NameA.additionalLastFields

If the inbound structure has more fields than specified in the configuration then the XML outbound structure is created as follows:

○ ignore

Outbound structure only contains the fields in the inbound structure

○ error

Conversion is terminated due to the incomplete inbound structure. An error message is displayed.

The default value is ignore. If you have defined the NameA.fieldFixedLengths parameter, the default value is error.

Regards

Raj

[Former Member]

hi Sankar,

Can you also please type in as to how you have configured the recordset structure?

Regards,

Ninu