Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Sol
 
Posts: n/a
Default An XML mapping cannot be exported

How to you resolve this,
An XML mapping cannot be exported if the mapped elements relationship with
other elements cannot be preserved. This relationship may not be preserved
for the following reasons:

The schema definition of a mapped element is contained within a sequence
with the following attributes:
The maxoccurs attribute is not equal to 1.
The sequence has more than one direct child element defined, or has another
compositor as a direct child.
Non-repeating sibling elements with the same repeating parent element are
mapped to different XML lists.
Multiple repeating elements are mapped to the same XML list, and the
repetition not defined by an ancestor element.
Child elements from different parents are mapped to the same XML list.
Additionally, the XML mapping cannot be exported if it contains one of the
following XML schema constructs:

List of lists One list of items contains a second list of items.
Denormalized data An XML list contains an element that has been defined in
the schema to occur once (the maxoccurs attribute is set to 1). When you add
such an element to an XML list, Excel fills the list column with multiple
instances of the element.
Choice A mapped element is part of a <choice schema construct.


I am using Excel 2003
  #2   Report Post  
Posted to microsoft.public.excel.newusers
exceluserforeman
 
Posts: n/a
Default An XML mapping cannot be exported


Hello,
Sorry, no XML but will HTML help?

WebCreator_Simple.xls 3 December 2005 Excel XP
Create your own web pages for Excel Worksheets. This is not XML! I have only
used basic HTML. Cell data is put into a Table (options for borders
available). Objects such as Clipart, WordArt, Charts, onSheet Form Controls
etc are saved in GIF Format into the activeworkbook Path. Any objects that
have a space in their names will have that space replaced with an underscore.
You can Name the web sheet, add Meta Keywords, Put in a Title. Objects are
optional and you can decide from the list of current objects which to include
into the web sheet or none...



Should work with Excel2003
http://www.geocities.com/excelmarksway

- -Mark




"Sol" wrote:

How to you resolve this,
An XML mapping cannot be exported if the mapped elements relationship with
other elements cannot be preserved. This relationship may not be preserved
for the following reasons:

The schema definition of a mapped element is contained within a sequence
with the following attributes:
The maxoccurs attribute is not equal to 1.
The sequence has more than one direct child element defined, or has another
compositor as a direct child.
Non-repeating sibling elements with the same repeating parent element are
mapped to different XML lists.
Multiple repeating elements are mapped to the same XML list, and the
repetition not defined by an ancestor element.
Child elements from different parents are mapped to the same XML list.
Additionally, the XML mapping cannot be exported if it contains one of the
following XML schema constructs:

List of lists One list of items contains a second list of items.
Denormalized data An XML list contains an element that has been defined in
the schema to occur once (the maxoccurs attribute is set to 1). When you add
such an element to an XML list, Excel fills the list column with multiple
instances of the element.
Choice A mapped element is part of a <choice schema construct.


I am using Excel 2003

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting not applied to data exported from Access Mark A Excel Worksheet Functions 5 October 24th 05 12:11 PM
XML Mapping Issues dpbuck Excel Discussion (Misc queries) 0 August 8th 05 11:13 PM
Mapping one table based on another table range waynehamilton Excel Worksheet Functions 7 May 12th 05 04:37 AM
Exported Data to excel appearing wrong in Columns lwreece Excel Discussion (Misc queries) 4 March 10th 05 11:03 PM
Formating exported data GorillaBoze Excel Worksheet Functions 2 November 22nd 04 07:19 PM


All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"