|
Trouble using sql:relation/sql:relationship in xsd file ...
Hi ...
I am attempting to use the sql:relation annotation and am having some troubles. I have used it successfull with the MS Sample (Customer / Order) where all the data is contained in elements (example below).
<code><ROOT>
<Customers>
<CustomerID>1111</CustomerID>
<SynchID>700</SynchID>
<CompanyName>Sean Chai</CompanyName>
<City>NY</City>
<Order OrderID="1" />
<Order OrderID="2" />
</Customers>
</ROOT>
In the xml that I am having trouble with the data is contained in attributes. In the code below I get the following
error when executing the bulk insert.
Any comments ?
Thanks !!
Chris
//////////////////////////////////////////////////////////////////////////
// error message
<?xml version="1.0"?><Result State="FAILED"><Error><HResult>0x80004005</HResult><Description><![CDATA[Schema: the parent/child table of the relationship on 'surface' does not match.]]></Description><Source>Schema mapping</Source><Type>FATAL</Type></Error></Result>
//////////////////////////////////////////////////////////////////////////
// xsd file
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xsd:annotation>
<xsd:appinfo>
<sql:relationship name="MacgowanTest_Atmospheric_Surface"
parent="MacgowanTestRWISRawAtmospheric"
parent-key="SystemId RpuId"
child="MacgowanTestRWISRawSurface"
child-key="SystemId RpuId" />
</xsd:appinfo>
</xsd:annotation>
<xsd:element name="site" sql:relation="MacgowanTestRWISRawAtmospheric" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="sensors" sql:relation="MacgowanTestRWISRawSurface"
sql:relationship="MacgowanTest_Atmospheric_Surface">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="surface" sql:relation="MacgowanTestRWISRawSurface"
sql:relationship="MacgowanTest_Atmospheric_Surface" >
<xsd:complexType>
<xsd:attribute name="id" type="xsd:string" sql:field="SensorId"/>
<xsd:attribute name="datetime" type="xsd:date" sql:field="ObsDateTime" />
<xsd:attribute name="surfacecondition" type="xsd:string" sql:field="SurfaceCondition"/>
<xsd:attribute name="surfacetemp" type="xsd:string" sql:field="SurfaceTemperature"/>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attribute name="sysid" type="xsd:string" sql:field="SystemId"/>
<xsd:attribute name="rpuid" type="xsd:string" sql:field="RpuId"/>
</xsd:complexType>
</xsd:element>
</xsd:schema>
//////////////////////////////////////////////////////////////////////////
// xml data file
<?xml version="1.0"?>
<odot_rwis_site_info>
<site id="200000" number="1" sysid="200" rpuid="0" name="1-SR127 @ SR249" longitude="-84.554946" latitude="41.383527">
<atmospheric datetime="12/05/2005 03:48:00 PM" airtemp="-490" dewpoint="-800" relativehumidity="73" windspeedavg="11" windspeedgust="19" winddirectionavg="265" winddirectiongust="295" pressure="65535" precipitationintensity="None" precipitationtype="None" precipitationrate="0" precipitationaccumulation="-1" visibility="2000" />
<sensors>
<surface id="0" datetime="12/05/2005 03:48:00 PM" name="North Bound Driving Lane" surfacecondition="Dry" surfacetemp="1900" freezingtemp="32767" chemicalfactor="255" chemicalpercent="255" depth="32767" icepercent="255" subsurfacetemp="450" waterlevel="0">
<traffic datetime="12/05/2005 03:48:00 PM" occupancy="0" avgspeed="82" volume="21" sftemp="1900" sfstate="255">
<normalbins>
<bin datetime="12/05/2005 03:48:00 PM" binnumber="0" bincount="7" />
<bin datetime="12/05/2005 03:48:00 PM" binnumber="1" bincount="0" />
</normalbins>
<longbins>
<bin datetime="12/05/2005 03:48:00 PM" binnumber="2" bincount="0" />
<bin datetime="12/05/2005 03:48:00 PM" binnumber="3" bincount="0" />
<bin datetime="12/05/2005 03:48:00 PM" binnumber="4" bincount="1" />
<bin datetime="12/05/2005 03:48:00 PM" binnumber="5" bincount="0" />
</longbins>
</traffic>
</surface>
<surface id="1" datetime="12/05/2005 03:48:00 PM" name="Bridge Deck Simulator" surfacecondition="Other" surfacetemp="-60" freezingtemp="32767" chemicalfactor="255" chemicalpercent="255" depth="32767" icepercent="255" subsurfacetemp="-999999" waterlevel="0" />
</sensors>
</site>
<site id="200001" number="2" sysid="200" rpuid="1" name="2-Hardin County Garage" longitude="-83.6148588" latitude="40.6305358">
<atmospheric datetime="12/05/2005 03:49:00 PM" airtemp="-590" dewpoint="-900" relativehumidity="75" windspeedavg="9" windspeedgust="22" winddirectionavg="303" winddirectiongust="299" pressure="65535" precipitationintensity="None" precipitationtype="None" precipitationrate="0" precipitationaccumulation="-1" visibility="2000" />
<sensors>
<surface id="0" datetime="12/05/2005 03:49:00 PM" name="Bridge Deck Simulator" surfacecondition="Other" surfacetemp="-410" freezingtemp="32767" chemicalfactor="255" chemicalpercent="255" depth="32767" icepercent="255" subsurfacetemp="300" waterlevel="0" />
</sensors>
</site>
</odot_rwis_site_info></code>
|
|
|
|
|
I am not too hot on XML etc, and would appreciate a little help.
I have a large XML document and would like to know if it is possible to find a node within the document that has a specific value, (not attribute), with the .SelectNode( ... ) function? All that I have read so far leads me to believe that I will have to loop through the document searching for a node with a specific value rather than being able to home in on it with a clever XPath expression!
|
|
|
|
|
If you have
<doc>
<node>1</node>
<node>2</node>
</doc>
then the XPath expression node[text()='1'] should select the node with text contents of '1' (i.e. the first node in that document)
Stuart Dootson
'Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p'
|
|
|
|
|
That's not completely true. You'll have to already be in the doc element, for that to work. If you're not already traversing thru the XML, you'll need to specify the absolute path to a property you want. You can do this by typing /doc/node. That will give you the value within the node element. If you have attributes, they need to be preceded with the at (@) symbol.
http://www.w3schools.com/xpath/default.asp[^]
Michael Flanakin
Web Log
|
|
|
|
|
Hi
I have lot of config data in a table which I want to put in .config file.
Is there any tool using which I can save the data into customized xml file?
Please advice. Thanks
Pankaj
|
|
|
|
|
May be you should place your data in a table and use the forXML T-SQl extension.
This can be done on MS SQL and SQL Anywhere.
The other option is to put it ina Access tbale and export in XML format.
|
|
|
|
|
I'm fairly new to XML and I'm just wondering if there is any difference between using elements or attributes to store data in an XML file. From a programatic view is is better to use one or the other for having to read in the file and such? Are there any performance differences? Is one more flexible than the other?
Any information on the topic is very appreciated.
- Aaron
|
|
|
|
|
There are no rules about when to use attributes, and when to use child elements. My experience is that attributes are handy in HTML, but in XML you should try to avoid them. Use child elements if the information feels like data.
Some of the problems with using attributes are:
.attributes cannot contain multiple values (child elements can)
.attributes are not easily expandable (for future changes)
.attributes cannot describe structures (child elements can)
.attributes are more difficult to manipulate by program code
.attribute values are not easy to test against a Document Type
.If you use attributes as containers for data, you end up with documents that are difficult to read and maintain.
Try to use elements to describe data. Use attributes only to provide information that is not relevant to the data.
Sushant Mathur
Ocwen Financial Sol. Pvt. Ltd,
Bangalore,
INDIA.
-- modified at 3:17 Wednesday 14th December, 2005
|
|
|
|
|
i fairly agree with you, i'm newbie too,and i'm always baffled by configuration of document.
|
|
|
|
|
Hi..
I am new to XML.NET Parser...So can anyone help me in providing some good links for XML .NET Parser so that i can load an xml file and validate it with xsd file in VC++..
Kindly provide the links or any advices regarding this..Plz don't tell me to search in Google..I had searched alot..So whoever familiar with XML .NET Parser,plz help me..
Thanks..
|
|
|
|
|
|
|
I have a project, in which we need to read in an XML file. But, when we read in that file, we need to parse it so that only designated data is used. So we parsed it into a string. We now are running into the difficulty of passing the String into the XSLT.
Is there a way to convert a String with XSLT, or do we need to rewrite the XML file?
TIA,
Scott
|
|
|
|
|
You can load the tring into an XMLDocument object much like you load it from file.
HRESULT loadXML(BSTR bstrXML,VARIANT_BOOL * isSuccessful);
This migth be an Microsoft extension of the DOM model, but it exists in
MSXML.
Then it is possible to transform it using the transformNode method of the XMLDocument object.
HRESULT transformNode(IXMLDOMNode *stylesheet, BSTR *xmlString);
/Per
|
|
|
|
|
What language/technology are you using?
Michael Flanakin
Web Log
|
|
|
|
|
Hi
i have an webpage which at the time of loading populates a table. the user can also populate the table by clicking on a button. There is a column called seqno which is populated in "space-SeqNo-space" fashion at the time of loading time population. Same thing when trying to accomplish through javascript it is seen that xsl loading time space is not identical with javascript space.
for example:
XSL:
" 1 "
" 2 " etc.
Javascript:
" 1 "
" 2 "
(here in example to show the effect i am using two space for javascript)
seeming an indentation problem.
My resolution is 1152 X 864.
Another thing for same color-code from javascript and from xsl it shows different color.
Thanks in advance
Chiranjib
|
|
|
|
|
Make sure you escape your '&' characters. I can't see your XSL output, but I'm guessing the problem is that you're using  , which is the equivalent of (a non-breaking space) in HTML. Try modifying the JavaScript to either parse   and as well as spaces or simply replace all occurrences of   and with a space.
xslOutput = xslOutput.replace(' ', ' ');
xslOutput = xslOutput.replace(' ', ' ');That should work... assuming I've guessed the problem correctly.
Michael Flanakin
Web Log
|
|
|
|
|
IXLMDOMDocument2Ptr pDoc;
// test.xml (UTF-8) encoded, :
//<?xml version='1.0'?><root>你好, hello</root>
// check in IE, no problem.
// resource type HTML, or BINARY tried.
// ... create pDoc, find resource, loadresouce,
// create IStream on HGlobal, everything seems ok
// and i checked the dubug info, show xml content correctly,
// and setting the IStream to the beginning of IStream
// but...
pDoc->async = VARIANT_FALSE;
pDoc->load(_variant_t(pStream)); // FAILs, it complains that no top level element in xml.
// but, when i write the stream into a disk file,
// and load form file, it's OK !!!
// if use loadXML((LPTSTR)hGlobal) the charactor shown is not correct.
|
|
|
|
|
It should not be much of a problem. I do it like this in a project (With all error handling removed. It just clutters up the example.)
int CHookApp::LoadXML (int rsrc, MSXML2::IXMLDOMDocument2Ptr& xml, CString& errMsg)
{
HRSRC hXSLResourceInfoBlock;
HGLOBAL hXSLResource;<br>
hXSLResourceInfoBlock = ::FindResource (m_hInstance, MAKEINTRESOURCE(rsrc), "XSL");<br>
if (hXSLResourceInfoBlock)
hXSLResource = LoadResource (m_hInstance, hXSLResourceInfoBlock);<br>
if (hXSLResourceInfoBlock == NULL || hXSLResource == NULL)
return -1;<br>
try {
_bstr_t xmlText ((char*)LockResource (hXSLResource));
if (xml->loadXML ( xmlText ) == VARIANT_FALSE)
return -1;<br>
}
catch (...) {
return -1;<br>
}<br>
return 0;
}
I wonder why my empty lines are removed from the <pre> block above. It remained in another reply of mine.......
-- modified at 5:03 Wednesday 14th December, 2005
|
|
|
|
|
Dear Experts,
I need some information on dynamic updation of XML file.
Our application asks the user to insert a file by giving the user browsing option.
We want our XML file (which contains the information about the residing files) to be dynamically updated as soon user specifies the path of the inserted file.
The next task is to dynamically update the XML file once the user select the file to be deleted by clicking on the Application UI.
We have to develop the code in C++.
Kindly send across your suggestion, opinion and helpful codes.
Regards,
Mayank Srivastava
Regards,
Mayank Srivastava
|
|
|
|
|
This may not belong in this section, but just a try.
How do you convert ByteArray into a Jpeg image?
|
|
|
|
|
byte[] buffer;
System.IO.MemoryStream ms = new System.IO.MemoryStream(buffer);
System.Drawing.Bitmap bm = new Bitmap(ms);
bm.Save("FilePath", System.Drawing.Imaging.ImageFormat.Jpeg);
|
|
|
|
|
Thanks a lot. I am really looking for code that can be implemented in the client [in Javascript].
Much obliged.
mysorian
|
|
|
|
|
Alguien tiene informacion sobre integracion de esquemas para base de datos,(teoria) y alguna aplicacion.
|
|
|
|
|
hi, i don't know how to add diferents rows to the same column, and i would like to know if somebody could tell me.:->
La Light
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
