Dynamically creating XML using Sap-xMII Colum and Row Action Block

[Former Member]

Hi,

I am trying to create a xMII-format XML using IlluminatorDocument Action Block.

My problem statement is during run time I am required to create columns on the fly.which I have done using xMII Colum Action block.but now I am required to assing values to these dynamically created columns.I have tried using Data Item and Row action block but am not sucessful in doing so.Can anyone help in creating this xml Dynamically.

The steps that I have followed is

defined

tagquery action block and defined tagquery

blank Illuminator Document Action block

put a repeater on result of tag query

set a counter

updated the counter

used column action block and mapped the column name i.e IlluminatorColumn_0.Name------"test"&Local.count

my column output looks like

Rowsets DateCreated="2007-03-27T12:59:39" EndDate="2007-03-27T11:42:40" StartDate="2007-03-27T11:42:40" Version="11.5.0">

<Rowset>

<Columns>

<Column Description="" MaxRange="100" MinRange="0" Name="test1" SQLDataType="1" SourceColumn="test1"/>

<Column Description="" MaxRange="100" MinRange="0" Name="test2" SQLDataType="1" SourceColumn="test2"/>

<Column Description="" MaxRange="100" MinRange="0" Name="test3" SQLDataType="1" SourceColumn="test3"/>

<Column Description="" MaxRange="100" MinRange="0" Name="test4" SQLDataType="1" SourceColumn="test4"/>

<Column Description="" MaxRange="100" MinRange="0" Name="test5" SQLDataType="1" SourceColumn="test5"/>

</Columns>

</Rowset>

</Rowsets>

after this action block i want to assign values to each column i.e

<Row/>

<Row/>

<Row/>

<Row/>

<Row/>

i.e erach row tags should be filled with columntag and value

but i am not able to achieve the same

Can anyone help me doing this

[Former Member]

Make sure that you "point" the Row and DataItem actions to the IlluminatorDocument action via their configuration dialog(s), and that you put the correct column name in the DataItem action.

If you forget to "point" the actions to the parent Document, they won't properly add XML nodes to the document.

Best regards,

Rick

[Former Member]

After adding IllumColum Action block I have created 5 columns dynamically

but now I am unable to add row.

currently for everycolumn created it is giving one row without any column node

the configurations that I have done in Data Item Action Block is

In My Link Editor

IlluminatorColumn_0.Name----

---

>IlluminatorDataItem_0.Name

hardcoded the value i.e 20----

---

>IlluminatorDataItem_0.Value

IlluminatorDocument_0.Output----

---

>IlluminatorDataItem_0.IlluminatorDocument

current resultset I am getting is

<?xml version="1.0" encoding="UTF-8"?>

<Rowsets DateCreated="2007-03-27T12:59:39" EndDate="2007-03-27T11:42:40" StartDate="2007-03-27T11:42:40" Version="11.5.0">

<Rowset>

<Columns>

<Column Description="" MaxRange="100" MinRange="0" Name="test1" SQLDataType="1" SourceColumn="test1"/>

<Column Description="" MaxRange="100" MinRange="0" Name="test2" SQLDataType="1" SourceColumn="test2"/>

<Column Description="" MaxRange="100" MinRange="0" Name="test3" SQLDataType="1" SourceColumn="test3"/>

<Column Description="" MaxRange="100" MinRange="0" Name="test4" SQLDataType="1" SourceColumn="test4"/>

<Column Description="" MaxRange="100" MinRange="0" Name="test5" SQLDataType="1" SourceColumn="test5"/>

</Columns>

<Row/>

<Row/>

<Row/>

<Row/>

<Row/>

</Rowset>

</Rowsets>

[Former Member]

Hi, Deepak.

You must delete the link:

IlluminatorDocument_0.Output----

---

>IlluminatorDataItem_0.IlluminatorDocument

...and instead, in the configuration dialog for the Row and DataItem, assign/select IlluminatorDocument_0 as the document.

Then, everything should work OK.

Rick

[Former Member]

Hi Deepak,

After Tag Query

1)take Illum XML Doc type action block

Create five columns with name test1 ....test5 with appropriate data type.

put a repeater on result of tag query

After this you can use counter and update it.

Next take a Illum Row and in configuration tab select Illum XML Doc.

Go for link and map repeater column to right side column parameter.

Here value assignment will be done by Illum Row.

Hope this will help you

Best Regards

Ramshanker Upadhyay