Target file creation error

[Former Member]

Hi All,

I ‘m working on XML file to-Fixed length scenario.

MY target file should have following structure.

I’m mapping xml file content to the target structure.

Recordset

REC 1 to n

A(3)

B(5)

C(6)

MY content conversion is as follows.

Recorset structure: REC

Content conversion parameters:

REC.fieldFixedLengths 3,5,6

REC.endSeparator : ‘nl’

Result:

I’m getting only one first field information in target file.

Thanks in advance.

Venu.

[moorthy]

Hi,

Hope all fields are coming with exact length . If there is no value, pass the spaces from the mapping.

btw, what is the xml message in the sxmb_moni after mapping ? is it shows all 3 fields under REC structure ?

check this. Also have a look into Audit log ( RWB->Message Monitoring->Message Display tool ->Aduit log ) for any errors.

Regards,

moorthy

[Former Member]

Hi Krishna,

I foundall fields are coming with exact length

I'm passing spaces if there is no value.

xml message is generated correctly in the sxmb_moni after mapping ..shown all the fieldsunder REC structure .

Audit log information also correct.

<u>Attribute mapping</u>

I'm using the attribute fields of source XML message to target message.

Is there any effect with this?

Thanks,

venu.

[Former Member]

Venu,

Can you post us the target xml file genarated? Does it have a node <Recordset>? If yes, your parametrs will be

Recordset Structure Recordset,REC

Content Conversion Parameters

Recordset.fieldSeparator #(any delimiter)

REC.fieldFixedLength 3,5,6

REC>endSeparator 'nl'

Regards,

Jai Shankar.

[Former Member]

Hi ,

Try this way...

<i>Recorset structure: REC</i>

Recordset structure : Recordset,REC

SEKHAR

[Former Member]

Hi Sekhar,

Thanbks for reply.

By giviing this value it is expecting recordet .fieldSelarator value..

not worked.

Thanks,

venu.

[former_member206604]

Hi,

Try this field.absoluteRowWidth = sum Of columns

Thanks,

Prakash