Help loading Entity from Excel using fromXmlToEntityWithScopes
Background: I would like to populate master entity records from
data residing in Excel using the instructions from http://help.bizagi.com/bpm-suite/en/read_and_write_from_excel.htm. To test this out, I created a very simple
process and data model that looks like this:
During the execution of a process task, I would like to
import records from Excel into the Master Entity collection associated to my
I used instructions from : http://help.bizagi.com/bpm-suite/en/bizagis_data_model_xml_schemas.htm
to generate the XSD for the master entity table and associate an XSLT that I
I use a third party tool called Sparx EA to validate my
XSLT. The validation takes my input XML generated
by Excel, applies the XSLT transformation to create an output XML that is
validated against the XSD produced by Bizagi for my Master Entity table.
Output XML (Corresponds to Schema of target Master Entity):
And Finally, this is the XSD for the target Master Entity that is generated by Bizagi:
Before I try anything with .NET, I want to be successful with
the following simple case to simulate inserting just one record represented by
AML into my target master entity table.
To perform this test, I created a data entry form on which I
placed a button control that Executes an expression as follows:
As you can see, I have the XML that would be produced
from Excel and returned by the .NET component hardwired into a variable for
However, when I try to execute this code I receive the
following error message:
Error processing Rule = 7b80eb34-4e5b-47f1-b94a-7be567139bdb;
Error: Error Evaluating Rule RunXLSTest - Error Error saving XML: XPath =
A1M_ChildRecord. Relation not found. - bad xpath or Relation not found..
And nothing is inserted into my master entity table.
I think my XSLT might need to produce an output XML that
includes reference to the parent process entity, but at this point I am kind of
stuck. Does anyone out there have
experience with reading data from XML into Entities that can see where I might
be going wrong? Thanks in advance to
anyone who can provide some guidance for me. Let me know if I need to provide additional details.