+ Reply to Thread
Results 1 to 2 of 2

Editing XML map, can't add top level container

  1. #1
    Registered User
    Join Date
    01-19-2016
    Location
    Here
    MS-Off Ver
    MS 2010
    Posts
    3

    Editing XML map, can't add top level container

    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!

  2. #2
    Registered User
    Join Date
    01-19-2016
    Location
    Here
    MS-Off Ver
    MS 2010
    Posts
    3

    Re: Editing XML map, can't add top level container

    Any help out there? Or barring that, any idea what this might cost on the 'experts' forum? Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro help to solve a minmal container calculation
    By lumeipro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2014, 04:06 PM
  2. Posisible to Disable Save As at Program level (not workbook level)??
    By brian6464 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 02:49 PM
  3. Bill of Materials conversion from multi level to single level
    By susmitpatel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-11-2013, 12:53 AM
  4. copying files from external macro container
    By StillLearning2 in forum Excel General
    Replies: 5
    Last Post: 12-11-2008, 06:40 PM
  5. Can't get ActiveWorkbook.Container to work
    By Ken Valenti in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2005, 01:06 PM
  6. Workbook container - can't get it to work
    By Ken Valenti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2005, 04:06 PM
  7. worksheet container problem
    By ram_z in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2005, 06:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1