When I try to download my query results as XML, my tags don't have the heading text that I set up in my query, instead I get the field name or expression name when using an expression. Example:
<SUBJECT><![CDATA[CHEM]]></SUBJECT>
<EXPR11_11><![CDATA[101]]></EXPR11_11>
My heading text for SUBJECT is "Subject" and my heading text for EXPR11_11 is "Number". Furthermore, each value being returned is preceded by "![CDATA[xxxx]]" and has brackets around it.
To get around this, I tried using the transformations tab and scheduling the query to output as XFORM. I am using Copilot AI to help me create the XSLT to insert into the Transformations tab and output the file as XML. Whether I run the query as XML or schedule as XFORM, I am not having any luck converting my data into an XML file with the field names I want and the data being there.
I am getting the below output when trying to run:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
Below is the current XSLT I am using in the query:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
<Courses>
<xsl:for-each select="Query/ROWSET/ROW">
<Course>
<Subject><xsl:value-of select="Subject"/></Subject>
<Number><xsl:value-of select="Number"/></Number>
<Department><xsl:value-of select="Department"/></Department>
<Title><xsl:value-of select="Title"/></Title>
<TermType><xsl:value-of select="TermType"/></TermType>
<Credits><xsl:value-of select="Credits"/></Credits>
<Level><xsl:value-of select="Level"/></Level>
<Prerequisites><xsl:value-of select="Prerequisites"/></Prerequisites>
<LongTitle><xsl:value-of select="LongTitle"/></LongTitle>
<Materials><xsl:value-of select="Materials"/></Materials>
</Course>
</xsl:for-each>
</Courses>
</xsl:template>
</xsl:stylesheet>
If anyone has any suggestions or documentation to help me get the desired result, I would appreciate it.
Thanks!
------------------------------
Leo Pappalas
Senior Academic Systems Analyst
City Colleges of Chicago-District Office
------------------------------
Message from the HEUG Marketplace:------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the
HEUG Marketplace.
------------------------------