Posted: 10 Feb 2020 9:19 EST Last activity: 11 Feb 2020 11:02 EST
User defined XML
Would like information on How to let a RDA User create a XML Configuration File that the RDA Process will use within a Global Script element on processing an Excel Document Business Rules. We have a process that reads an Excel workbook that has several Worksheets that can be added to the Workbook and would like to provide a Custom UI for the EndUser to enter in Data about the New Sheet so that the Script knows the Business Rules that get applied to the Script Logic via XML instead of a Database. This would be a Custom UI that works like using a StartmyDay Custom Configuration.
Here is an example. You can use the XMLDocument Component to traverse the XML and retrieve settings. If you are so-inclined, you could also do this in a C# script and output a DataSet or something even more "fancy".
We tend to use a trick where we attach the XML doc to the solution for things that change with the solution. If you have things that change outside of the solution (i.e. things where changes wouldn't affect the operation of the solution), you can have the file located on a network share or delivered in some external manner. In this example, I have the XML file as part of the solution and load it from the extract directory.