×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I have never had occasion to process xml before, so this is completely new to me. I don't think that the way I'm being asked to get and parse the data is the norm.
I found an article
http://www.itjungle.com/fhg/fhg080415-story01.html example (XMLINTOB1) that has code that appears to do something similar to I what I want to do, but I'm not having any luck.
I am reading a file on SQL SERVER from an ESRI table.
It appears that there is a field that contains XML data.
I have read the file and loaded the data into a character field.
When I run the XML-INTO I get an error code of 302 which says that the xml document was not an external file. Which of course its not.
Below is a snippet of data . I'm not sure if it is the complete contents of the field, but hopefully it is enough to indicate what I'm looking at.
<GPCodedValueDomain2 xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance"; xmlns:xs="
http://www.w3.org/2001/XMLSchema"; xmlns:typens="
http://www.esri.com/schemas/ArcGIS/10.1"; xsi:type="typens:GPCodedValueDomain2"><DomainName>Pipe Casing Reason</DomainName><FieldType>esriFieldTypeString</FieldType><MergePolicy>esriMPTDefaultValue</MergePolicy><SplitPolicy>esriSPTDuplicate</SplitPolicy><Description /><Owner>DBO</Owner><CodedValues xsi:type="typens:ArrayOfCodedValue"><CodedValue xsi:type="typens:CodedValue"><Name>Highway</Name><Code xsi:type="xs:string">Highway</Code></CodedValue><CodedValue xsi:type="typens:CodedValue"><Name>Railroad</Name><Code xsi:type="xs:string">Railroad</Code></CodedValue><CodedValue xsi:type="typens:CodedValue"><Name>Street</Name><Code xsi:type="xs:string">Street</Code></CodedValue><CodedValue xsi:type="typens:CodedValue"><Name>Water</Name><Code xsi:type="xs:string">Water</Code></CodedValue></CodedValues></GPCodedValueDomain2>
Can I process the xml from a field? If so, what is causing the 302 error?
Any guidance on how to accomplish this is appreciated.
Mike
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.
midrange.com
