The board is interpreting the XML as HTML or something, so removed all of it. I have replaced XML markers with () instead...
Hi all, I understand the general concept of changing a workbook to a zip file, then modifying the xmlMaps.XML file to modify an XML map. However, I am having tons of difficulty adding a top level 'container'. If anyone has any hints as to what I am doing wrong, it would be greatly appreciated.
My current XML map is of a single (report), but I want to change it so I can load a series of (report)s in a single file, such as:
(Original_reports)
(report)
stuff in the middle...
(/report)
(report)
stuff in the middle...
(/report)
(report)
stuff in the middle...
(/report)
(/Original_reports)
My ORIGINAL xmlMaps.XML looks like this:
(Schema ID="Schema2")(xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" id="report" xmlns="")
(xs:element name="report")
(xs:complexType)
(xs:sequence)
stuff in the middle...
(/xs:sequence)
(/xs:complexType)
(/xs:schema)
(Map ID="1" Name="original_reports_Map" RootElement="original_reports" SchemaID="Schema1" ShowImportExportValidationErrors="false" AutoFit="true" Append="false" PreserveSortAFLayout="true" PreserveFormat="true")(DataBinding
FileBinding="true" ConnectionID="1" DataBindingLoadMode="1"/)(/Map)(Map ID="2" Name="V4Schema" RootElement="report" SchemaID="Schema2" ShowImportExportValidationErrors="false" AutoFit="true" Append="false"
PreserveSortAFLayout="true" PreserveFormat="true"/)(/MapInfo)
I dont really understand what the last line is. The map I am trying to mod is Map ID 2, "V4Schema"
Based on another similar map in the same workbook (Map ID 1), I changed the XML for Map 2 to this:
(Schema ID="Schema2")(xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" id="report" xmlns="")
(xs:element name="original_reports")
(xs:complexType)
(xs:sequence)
(xs:element name="report")
(xs:complexType)
(xs:sequence)
stuff in the middle...
(/xs:sequence)
(/xs:complexType)
(/xs:sequence)
(/xs:complexType)
(/xs:schema)
(Map ID="1" Name="original_reports_Map" RootElement="original_reports" SchemaID="Schema1" ShowImportExportValidationErrors="false" AutoFit="true" Append="false" PreserveSortAFLayout="true" PreserveFormat="true")(DataBinding
FileBinding="true" ConnectionID="1" DataBindingLoadMode="1"/)(/Map)(Map ID="2" Name="V4Schema" RootElement="original_reports" SchemaID="Schema2" ShowImportExportValidationErrors="false" AutoFit="true" Append="false" PreserveSortAFLayout="true" PreserveFormat="true"/)(/MapInfo)
When I do this, it removes BOTH maps from the workbook entirely. I have also tried removing the last bit, (/xs:complexType), (/xs:schema) as the other, similar map seems to omit this.
The other similar map also has this at the end, I don't know if it makes a difference or not, as I don't really understand what it is doing...
(DataBinding FileBinding="true" ConnectionID="1" DataBindingLoadMode="1"/)(/Map)
I'm assuming there is a mistake in the end bit, but as I don’t understand it, I really don't know.
Thanks very much for any help you might be able to provide!
Bookmarks