I have a SharePoint list with, among other things, two columns that I care about; in Excel-ese, I want to match value X in column 1, and return the corresponding value in column 2. I'm able to use a variant of code at http://guruj.net/node/63 to retrieve the information (I think), so I think my problem focuses on navigating XML in VBA wi...
I have a bunch of documents in a MarkLogic xml database. One document has: <colors> <color>red</color> <color>red</color> </colors> Having multiple colors is not a problem. Having multiple colors that are both red is a problem. How do I find the documents that have duplicate data? ...
Hi there, i have some xml with math ml inside, and i would like to find some free tools preferably online which i can use to validate and if possible even edit math ml. Anyone knows of any good tools which i can use to do this? Thanks. Edit: Does firefox 3.03 natively support MathML? I can't get some equations to show up at all. I kno...
I have to write a C++ Application (using the Qt Framework for the GUI) that can edit data stored in xml files described by a xsd schema file. Is there a tool to convert the xsd schema into C++ Classes? ...
When trying to replace the content of an XML file in C#.NET with a snippet like this: string file = Path.GetTempFileName(); // pretend this is a real file string tmpFile = Path.GetTempFileName(); using (var writer = XmlWriter.Create(File.Create(tmpFile))) { writer.WriteStartElement("root"); for (int i = 0; i < 100; i++) { ...
Hi, I have an XML form with an element 0, which is well-formed but not valid. When I try to validate it XMLSpy I get a following error: Nothing is allowed inside empty element 'hidden'. Below is my schema: <xs:element name="hidden"> <xs:complexType> <xs:attribute name="datatype" type="xs:string" use="optional"/> <xs:attr...
Hi, I'm trying to validate an XML file against the schema's it references. (Using Delphi and MSXML2_TLB.) The (relevant part of the) code looks something like this: procedure TfrmMain.ValidateXMLFile; var xml: IXMLDOMDocument2; err: IXMLDOMParseError; schemas: IXMLDOMSchemaCollection; begin xml := ComsDOMDocument.Crea...
Hi I have a table which has a column which is of type xml. I have to extract data from this table and load the data into another environment. i am using bcp to extract and laod the target table but there are some special characters that is causing some issues when i bcp them into the target table. are there any workarounds thanks Ben ...
Once in a while, we use .XLS file to convert the data stored in the XML file and populate some dropdownlist and other server controls using XmlDataSource object. I am just wondering how popular is the use of the.XLS file in the .Net proejcts? We have used to populate countries list and state list and other huge amount of the project spec...
Hi all. Developing server side code i finally got my eyes X-crossed trying to write - and then understand, of course - forms or other html code in which text strings (attributes) within double quotes must occur in tagged string (markup) opening and closing properly; but often javascript text within apostophes must be instantiated, quite ...
I'm writing some code that handles logging xml data and I would like to be able to replace the content of certain elements (eg passwords) in the document. I'd rather not serialize and parse the document as my code will be handling a variety of schemas. Sample input documents: doc #1: <user> <userid>jsmith</userid> <p...
I wondering what the "best practice" way (in C#) is to implement this xpath query with LINQ: /topNode/middleNode[@filteringAttribute='filterValue']/penultimateNode[@anotherFilterAttribute='somethingElse']/nodesIWantReturned I would like an IEnumerable list of the 'nodesIWantReturned', but only from a certain section of the XML tree, d...
In XML, how should a list be represented? With an enclosing list entity: <person> <firstname>Joe</firstname> <lastname>Bloggs</lastname> <children> <child .../> <child .../> <child .../> <child .../> <child .../> </children> </person> Or without: <person> <firstname>Joe</f...
Looking for a tool/library to convert XML to X12 (270 - medical eligibility request) and then to convert the X12 response (271 - eligibility response) back to XML. This will be embedded in a server application (will consider any target language). I've toyed with idea of writing my own X12 parser and generator but this project will most...
I'd like to be able to run an xml transformation using an xslt file in my AIR project. What's the best way to accomplish this? ...
At my work we have our own XML classes which build a DOM, but I'm not sure how consecutive whitespace should be handled? e.g. <some-text> Hello World </some-text> When this is read into the DOM, should the text node include the consecutive whitespace inbetween Hello and World or just reduce it to one space? Or should the XML sou...
I realise that it's not elegant or desired, but is it valid for an attribute value in an XML element to span multiple lines? e.g. <some-xml-element value="this value goes over.... multiple lines!" /> Yeah I realise there's better ways of writing that. I would personally write it like: <some-xml-element> <value>this value goes over.....
I've got a report in SSRS 2008 that is using a web service as one of its data sources. The basic look of the XML returned is <table> <row> <column1>data</column1> <column2 xsi:nil="true" /> <column3>data</column3> </row> </table> Any tags with the "nil" attribute are showing up as blank on the report. I...
On a project I'm working on we're using LibXML2 (import lxml) because it has Objectify. But we're finding that getting it to work in OSX is an incredibly involved process. Does anyone have suggestions for clean cross platform xml libraries that don't have excessive dependencies on C libraries? ...
I'm working on an application that allows users to add their own RSS feeds to a simple reader of sorts. Currently, I'm using xml_domit_rss as the parser but I'm unsure if it's actually validating the URL before parsing. From what I can gather online, it looks as if validating is separate from the parse, either by using a service (feedval...