I am trying to import 2 types of XML files that will need to imported on a regular basis. One of the files uses a schema. The problem with importing the schema file is that I get an error message “The schemaLocation attribute does not contain pairs of values” I’m not going to post the xml for this one because I can minipulate the file so the schema information isn’t shown, but if anyone has any ideas, please let me know.
An example of the second type of XML file is below:
<Afghanistan>
<Albania>
Stylesheet:
<xsl:stylesheet xmlns:xsl=‘XSLT Namespace’ version=‘1.0’>
<xsl:template match=“Countries”>
<xsl:value-of select=“Country”/>
</xsl:stylesheet>
I typed the stylesheet manually so I might have some typos. When I run an agent to pull the countries into the database I get the error “Invalid document structure” and “The main XML document cannot be empty”. I have the agent working for other XML so I know the agent works. The difference in the XML is that in this file, it has the title(Countries") and the field(Country), the files that work have a title, overall group, then fields that are part of the group. I do not have the option of changing the XML.
Thanks in advance for any help you can give me.
Karen