- <permitinfo> - <permit> - <permitdetail> <status>Approved</status> <areaname>Northern Utah</areaname> <description>Garage</description> <number>HON07032905</number> <date>03/29/2007</date> <value>22000</value> </permitdetail> </permit> - <permit> - <permitdetail> <status>Approved</status> <areaname>Northern Utah</areaname> <description>Givens Home</description> <number>CC-07-004</number> <date>03/20/2007</date> <value>139000</value> </permitdetail> </permit> </permitinfo>
Changing the dates to 4 digit years seemed to help the date field but some of the fields still show errors. In excel, you get a prompt: the specified xml source does not refer to a schema. Excel will create a schema based on the xml source data. Can I somewho provide that schema automatically? On 8/23/07, Dominic Watson <[EMAIL PROTECTED]> wrote: > XMLTransorm() takes some XML and applies an XSLT Stylesheet to it, returning > the transformed XML. An XSLT transformation will always output another XML > document so XMLTransform() is not what you need. > > A schema is a set of rules for a particular flavour of XML for it to > validate against. I.e. XHTML has a schema and when you validate your XHTML > web pages on W3C or the like, you are validating against that schema. > > I'd say you're only problem is getting that date to appear correctly. I've > never exported XML to excel so I'm curious as to what your XML looks like. > Could you post a sample? > > Dominic > > > On 23/08/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > > > > I want to make an xml file available to my clients that they > > > can easily import into excel. I can generate the xml file no > > > problem and it imports into excel pretty good, but some of > > > the date fields give the little exclamation mark, because > > > excel doesn't know them to be date fields. > > > > > > Do I use xmltransform to attach a stylesheet? I can use an > > > xsd file and define the datatypes, but I am getting confused > > > on the difference between a stylesheet and a schema and how > > > to use xmltransform. This is my first foray into xml. > > > > What do you see if you export from Excel to XML? > > > > If you're generating the XML yourself, you don't need to transform it; > > just > > generate what you need in the first place. > > > > Stylesheets (CSS/XSL) are used to format or transform XML. Schemas are > > used > > to validate XML. > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > > > Fig Leaf Software provides the highest caliber vendor-authorized > > instruction at our training centers in Washington DC, Atlanta, > > Chicago, Baltimore, Northern Virginia, or on-site at your location. > > Visit http://training.figleaf.com/ for more information! > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4