J2SE content conversion

[Former Member]

Hi Gurus!

I have a problem creating XML in J2SE adapter.

This is the XML I need to get:

<RECORDSET>

<ROW>

<storenum>628</storenum>

<Storename></Storename>

<POnumber>00010300</POnumber>

<POexternal>C8Y17531</POexternal>

<MaterialNum>497990</MaterialNum>

<Quantity>00008</Quantity>

<POdate>20080314</POdate>

<DeliveryDate>20080317</DeliveryDate>

<DeliveryID>D8Y19983</DeliveryID>

<VendorID>231125</VendorID>

<linenum>1</linenum>

</ROW>

<ROW>

<storenum>390</storenum>

<Storename></Storename>

<POnumber>00011267</POnumber>

<POexternal>C8Y17704</POexternal>

<MaterialNum>497990</MaterialNum>

<Quantity>00008</Quantity>

<POdate>20080316</POdate>

<DeliveryDate>20080317</DeliveryDate>

<DeliveryID>D8Y20036</DeliveryID>

<VendorID>231125</VendorID>

<linenum>1</linenum>

</ROW>

</RECORDSET>

And this, is what I get now:

<RECORDSET>

<ROW>

<storenum>628</storenum>

<Storename></Storename>

<POnumber>00010300</POnumber>

<POexternal>C8Y17531</POexternal>

<MaterialNum>497990</MaterialNum>

<Quantity>00008</Quantity>

<POdate>20080314</POdate>

<DeliveryDate>20080317</DeliveryDate>

<DeliveryID>D8Y19983</DeliveryID>

<VendorID>231125</VendorID>

<linenum>1</linenum>

</ROW>

</RECORDSET>

<RECORDSET>

<ROW>

<storenum>390</storenum>

<Storename></Storename>

<POnumber>00011267</POnumber>

<POexternal>C8Y17704</POexternal>

<MaterialNum>497990</MaterialNum>

<Quantity>00008</Quantity>

<POdate>20080316</POdate>

<DeliveryDate>20080317</DeliveryDate>

<DeliveryID>D8Y20036</DeliveryID>

<VendorID>231125</VendorID>

<linenum>1</linenum>

</ROW>

</RECORDSET>

Here is my code:

##CONTENT CONVERSION paramters

xml.recordsetName=RECORDSET

xml.recordsetsPerMessage=*

xml.processFieldNames=fromConfiguration

xml.keyFieldType=Float

xml.keyFieldName=ROW

xml.recordsetStructure=ROW,1

#xml.fieldNames=storenum,Storename,POnumber,POexternal,MaterialNum,Quantity,POdate,DeliveryDate,DeliveryID,VendorID,linenum

#xml.fieldFixedLengths=6,20,8,10,13,5,8,8,10,10,13

xml.documentName=DeliveryNotes...

xml.documentNamespace=http://...

xml.ROW.fieldFixedLengths=6,20,8,10,13,5,8,8,10,10,13

xml.ROW.keyFieldValue=1

xml.ROW.fieldNames=storenum,Storename,POnumber,POexternal,MaterialNum,Quantity,POdate,DeliveryDate,DeliveryID,VendorID,linenum

What is my problem?

[Former Member · Accepted solution]

Hi,

Put the xml.recordsetsPerMessage=1 and in xml.recordsetStructure=ROW,* than try.Hope this works.

Thanks,

Bhargav.

Note:Award points if found useful.

Edited by: Bhargav Srinadh Gundabolu on Mar 17, 2008 6:04 PM

[Former Member]

Hi Bhargav Srinadh.

It's work, but only this way

xml.recordsetStructure=ROW,9999999

If I try unlimited nuber of ROWS nothing happiens.

xml.recordsetStructure=ROW,*

But any way, the problem is solved.

[GabrielSagaya]

Please modify the structure as

xml.recordsetsPerMessage=*

xml.recordsetStructure=ROW,*

[Former Member]

Thanks Gabriel.

If I change to xml.recordsetStructure=ROW,*

J2SE is not running, in LOG there are these messages

14:38:39 (4023): File adapter initialized successfully

14:38:39 (4007): File adapter started

14:38:39 (4051): Process 1 file(s):

14:38:39 : D:\Temp\Plainj2seTest\Movil\PDN1403778.txt

14:38:39 (4052): Start processing "TXT" file "D:\Temp\Plainj2seTest\Movil\PDN1403778.txt" size 1130 in "EO mode

14:38:39 (4058): Start converting to XML format

14:38:39 (4061): Converted complete file content to XML format

14:38:39 (4078): Empty document found. Skip and proceed with next message

14:38:39 (4037): File "PDN1403778.txt" processed successfully