Read XML file using Process Data Mapping

Old_Hooster

Hi all,

I have a generic BOF module that reads an Excel spread sheet and generates an XML file of the format

<Row>

<Cell>

<Cell_Value>TestValue1</Cell_Value>

<Cell_Position>$A$1</Cell_Position>

</Cell>

</Row>

<Row>

<Cell>

<Cell_Value>TestValue2</Cell_Value>

<Cell_Position>$B$1</Cell_Position>

</Cell>

</Row>

</Content>

The number of rows will be dependant on the SpreadSheet being read.

Im storing the resultant XML doc as a package in my Process. What I need to do is read every row individually and create objects based on the information.

Is it possible to cycle through the rows using the Process Data Mapping activity?

Thanks

Hoo

Find more posts tagged with

Comments

rawat_harish

few questions on what you are trying:

1.) Do you create one object for each row?

2.) Can one row have many columns?

3.) How do you find attribute names? I guess it is dependent on the cell position

Thanks

Harish

Old_Hooster

Hi Harish,

I will be creating a folder based on the information in each row.

While the BOF class is generic and resued in other projects, the excel sheet it will be reading in my scenario will be a fixed template.

We will know how many columns it will have (8) and the column position will be fixed.

Thanks

Hoo

rawat_harish

U can try following, but am not sure if this is the behavior that u want

a.) Create a schema that describes the xml output. Upload the schema in docbase

b.) In the process data mapping activity, attach the schema to the package that stores the xml document. This can be done by selecting "Add Element" in package/ content/data node and then selecting the schema (step a) from docbase. This will add all the xml schema element nodes under package/content/data node

c.) If all the created folders are of same documentum type then you can map the Cell_Value node to any attribute under Attachments[ALL]. Or alternatively use can create specific nodes like Attachments[0], Attachments[1], ... and map specific values to some attribute under Attachment[x] node

Thanks

Harish

Old_Hooster

Hi Harish,

thanks for your reply. Apologies I hev not gotten back to you sooner.

I will have a look at what you suggest. In the mean time I managed to achive what I needed doing the following.

1) generate XML from BOF as before. BOF is generic , not project specific.

2) Use XSL transformation to convert it to more process specific XML . This relies on the XSL being aware of what colums are in certain positions etc- almost hardcoded.....

3) set an iterator variable based on the new custom XML content using the Count function.

4) use that iterator with a decision split to loop through the content of my new XML file , grab the data I need to create objects and go back round the loop until the iterator is 0.

Im sure there are better ways to do this , but its working for now

thanks again

Hoo