xml - Loop to get all Line details which have one Header

Rathi · 2016-11-02

Hi all,

I have one item with Header and many line items.

I want to export to xml.

I need to use header as root in .xml because there is a possibility whereby no line item at all.

When i export out the data, only one header together with one line item can be exported.
I want to do loop to get all details.

I just need an idea. please help.

Rathi · 2016-11-04

it doesnot work since i want to import both table data into one column.
So i tried to create new table and insert all data into new table and export
it thru xml.

My xml report should like like this

-<GPOTender>

<Generic_Code>G0003</Generic_Code>

<Generic_Name>BioCon</Generic_Name>

<Prefer_Pack_Size>10 X 10</Prefer_Pack_Size>

<Prefer_Pack_Type>BOX</Prefer_Pack_Type>

<Country>SG</Country>

<Able_to_Quote>Yes</Able_to_Quote>

<Item_Category/>

<Item_No>FP-112-234</Item_No>

<Internal_Reference/>

<Description>Metanone</Description>

<BUOM>BOX</BUOM>

<Registration_No/>

<Shelf_Life/>

<Stability_Data>BE study/or clinical studies</Stability_Data>

<Batch_Size/>

<Lot_Size>0</Lot_Size>

<Formula>Different</Formula>

<Packing_Size/>

<Packaging_Type/>

<Remarks>Formula - MPE</Remarks>

</GPOTender>

mohana_cse06 · 2016-11-02

please check MaxOccurs property of the lines is not set to Once..you can add message in Export::OnAfterGetRecord trigger of lines to check whether all lines are repeating or not..

Rathi · 2016-11-02

The property i set to unbounded. But the result still same.
I got add the count message the onafterrecord field.
it shows correct reading. but when export its print out one item line only.

******************************************************************

GPOTenderLine.SETCURRENTKEY(GPOTenderLine."Generic Code");

GPOTenderLine.SETRANGE(GPOTenderLine."Generic Code","GPO Tender".Code);

I := GPOTenderLine.COUNT;
MESSAGE(FORMAT(I)); // shows 3,1,2,3..etc

IF GPOTenderLine.FIND('-') THEN
REPEAT

Item_No := GPOTenderLine."Item No";
Internal_Reference := GPOTenderLine."Internal Reference" ;
Description := GPOTenderLine.Description ;
BUOM := GPOTenderLine.BUOM ;
Registration_No := GPOTenderLine."Registration No." ;

UNTIL GPOTenderLine.NEXT = 0;

Anything wrong with this code?

mohana_cse06 · 2016-11-02

and how does your xmlport looklike?
didn't you add lines as dataitem in xmlport and link between header and lines?

Rathi · 2016-11-02

Sorry, i've no idea on how to link between two tables ?
Could you assist me?

mohana_cse06 · 2016-11-02

look at standard xmlports like 9000
check properties LinkTable and Link fields

Rathi · 2016-11-04

it doesnot work since i want to import both table data into one column.
So i tried to create new table and insert all data into new table and export
it thru xml.

My xml report should like like this

-<GPOTender>

<Generic_Code>G0003</Generic_Code>

<Generic_Name>BioCon</Generic_Name>

<Prefer_Pack_Size>10 X 10</Prefer_Pack_Size>

<Prefer_Pack_Type>BOX</Prefer_Pack_Type>

<Country>SG</Country>

<Able_to_Quote>Yes</Able_to_Quote>

<Item_Category/>

<Item_No>FP-112-234</Item_No>

<Internal_Reference/>

<Description>Metanone</Description>

<BUOM>BOX</BUOM>

<Registration_No/>

<Shelf_Life/>

<Stability_Data>BE study/or clinical studies</Stability_Data>

<Batch_Size/>

<Lot_Size>0</Lot_Size>

<Formula>Different</Formula>

<Packing_Size/>

<Packaging_Type/>

<Remarks>Formula - MPE</Remarks>

</GPOTender>

xml - Loop to get all Line details which have one Header

Best Answer

Answers

Categories