We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Excel to XML for rules

Hi Everyone,
I’m trying to create a spreadsheet that will export an XML file that can be uploaded to OC for creating rules. The idea is to define/review the edit specification in Excel and then export to XML for upload. It seems that excel supports the exporting of XML, I just can’t get it to work. I have defined the rules.xsd as the XML map, and it works if I only map a single element (i.e. Target), but when I try and map any additional elements the export does not work. Excel error message of “Cannot save or export XML data. The XML maps in this workbook are not exportable.”

Any ideas or help would be appreciated.


Jeff Yearley
Clinical Data Manager
Department of Pediatrics / IICRC
University of Utah, School of Medicine
P - 801-213-3229
F - 801-587-7616
[email protected]
This discussion has been closed.