error while conversion

[Former Member]

hi,

my scenario is conversion of file to xml where the input is a fixed length file.while conversion im getting the following error.Can anyone help me identify what is it.

the i/p structure is

datetype

datainp

header0

key0

value1

header1

key1

value1

My file content conversion parameters are

HEADER0.fieldFixedLengths 2,6,13,13,7

HEADER0.keyFieldValue 00

HEADER0.fieldNames KEY0,VALUE1,VALUE2,VALUE3,VALUE4

HEADER0.endSeperator ' '

HEADER1.fieldFixedLengths 2,7,8,4

HEADER1.keyFieldValue 01

HEADER1.fieldNames KEY1,VALUE1,VALUE2,VALUE3

HEADER1.endSeperator ' '

ignoreRecordsetName true

But im getting the following error:

Conversion of complete file content to XML format failed around position 0: Exception: ERROR consistency check in recordset structure validation (line no. 1: missing structure(s) in last recordset

Can anyone help me with this.Its very urgent

thanks,

srinadh

[former_member184619]

Hi Bhargav,

this might be the error...as in ur parameters

HEADER0.fieldFixedLengths 2,6,13,13,7

HEADER0.keyFieldValue 00

HEADER0.fieldNames KEY0,VALUE1,VALUE2,VALUE3,VALUE4

HEADER0.endSeperator ' '

HEADER1.fieldFixedLengths 2,7,8,4

HEADER1.keyFieldValue 01

HEADER1.fieldNames KEY1,VALUE1,VALUE2,VALUE3

HEADER1.endSeperator ' '

The Spelling of Separator is wrong...

Try using

HEADER0.<b>endSeparator</b>

Sachin

[Former Member]

Hi Sachin,

Even on changing the spelling also it is throeing the same error.

[Former Member]

Hi bhargav,

do the below:

HEADER0.fieldFixedLengths 2,6

HEADER0.keyFieldValue 00

HEADER0.fieldNames KEY0,VALUE1

HEADER0.endSeperator ' '

HEADER1.fieldFixedLengths 2,7

HEADER1.keyFieldValue 01

HEADER1.fieldNames KEY1,VALUE1

HEADER1.endSeperator ' '

ignoreRecordsetName true

Thanks,

Rajeev Gupta

Message was edited by:

RAJEEV GUPTA

[Former Member]

Dear Rajeev,

Can u explain me as to what that error is

thanks,

srinadh

[Former Member]

Hi Bhargav,

the error is see your struc is:

datetype

datainp

header0

key0

value1

header1

key1

value1

in header you have only 2 fields.........but you have put 5 fields -KEY0,VALUE1,VALUE2,VALUE3,VALUE4

Thanks,

Rajeev Gupta

[Former Member]

Dear Rajeev

im sorry there was a small mistake in typing but header1 has five fields only the field are correct only