cancel
Showing results for 
Search instead for 
Did you mean: 

MII XML to XML - How?

Former Member
0 Kudos

Hi

I am using an action block Advanced Flat File to MII XML from Salvatore Castro. Does anyone has experience in it?. The action block simply returns an xMII XML by parsing after parsing an flat file (csv for eg).

However the the returned XML is an xMII XML (but in the link editor there is not data structure of the xMII XML).

I thought of using reference document to map the output but I think reference document could not parse xMII XML.

anyone has any idea??

thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Seng,

The reason why you don't see the output xml structure is because the action doesn't know until runtime what the output will be. You can pre-configure columns in the action configuration and I believe this will generate an output xml strucuture.

The other option is to assign a Reference Document to the XML output property of the action.

Hope this helps,

Sam

Former Member
0 Kudos

Hi Sam,

1) I've created column and I saw the number of columns under ColumnSpecificationOf the FlatFileParser. However, how can I access the value? The value will actually be parsed during runtime. I am thinking to have a repeater (source to the columns of the FlatFileParser's ColumnSpecification). However, I am not able to get the value.

2. I am afraid that MII cannot use xMII XML as reference document. Am I wrong? I do know how to do the reference schema mapping but when I try to do the xMII XML reference document, it just does not work. Another issue for eg, is that if you save an xMII XML in catalog and try to open it, ...error. If you save a normal format of XML in catalog, it works.

thanks

seng

0 Kudos

Seng,

You do not want to repeat on the columns, but rather the rows returned from the action, so something like this should be configured in the repeater:

actionname.OutputXML{/Rowsets/Rowset/Row}

Then in the Repeater Item at runtime you will see Item{/Row/ColumnName} as values.

The reference document assignement is MII 101 introductory class material, I suggest going to training for details on how this works.

Sam

Former Member
0 Kudos

Thanks Sam,

Assigning MII's XML as reference document is not possible. Or am I wrong? I had MII class before and I know the procedure of assigning Reference document. But when I try to assign the an MII's XML to an XML variable (let say a local variable, the local variable does not get the assignment)

0 Kudos

Seng,

Perhaps you may have mixed up the purpose of the reference document, it works for me on my system, so let me explain how it works. The reference document assignment is designed to allow you to define a structure of an XML input/output transaction property or Incoming/Outgoing elements of an action. To use this assignment you have to have an XML defined that represents the XML you want to assign. For example create a Local Property called "FlatFileXMLReference" of Type XML and give it the expected value of the FlatFileParser action. Next in the workbench assign the Local property as a reference document to the OutputXML of the FlatFileParser action. Now in the link editor you will see the output XML populated with the value of the local property.

This is purely a design time feature that is to help you in defining links and will not affect the runtime environment of the transaction.

Hope this helps,

Sam

0 Kudos

Hi,

I think you need to check back with Sam on the custom action block.

Regards,

Mike

Former Member
0 Kudos

And Sam is Savlatore? How can I get his contact?

0 Kudos

Yes, Sam is Salvatore.

How did you get his custom action block? Contact information should be there. If not, get back to me.

Regards,

Mike