I am not a computer professional, only like to develop my own toys. I am using Globi Flow to get the info I need from the XML file. All is done, except for one instance where I do not have the closing tag Regular node with closing tag: <proper price>$4</price> Below is the code used for all data extraction. preg_match_all_gf("/<city>(.*?)<\/city>/ism", [(variable)token],4) This would get the 4th occurrence. And this is what I currently need and it does not have the closing tag: <comp score:"9.0"> I managed to get the first digit (in the example above, 9) using Regex, as it …

Member Avatar
Member Avatar
+0 forum 7

I was write code for excel vba xml database values write into text file. when i using without any special characters xml values parsed into their text file without any issues but when i using special characters xml cannot parse special characters (&,- etc) error getting on my macro page. Anyone have any ideas on how to resolve this? Dim XDoc1 As Object Dim XHTML1 As IHTMLElement Dim XURL1 As String Dim CustomerName1 As String Set XDoc1 = CreateObject("MSXML2.DOMDocument") XDoc1.async = False: XDoc1.validateOnParse = False XDoc1.Load ("http://www.beamon.com/windows_application/macro1.php" + "?Id=" + Sheets(1).Range("D2")) Set Lists = XDoc1.DocumentElement Set getFirstChild = Lists.FirstChild Set …

Member Avatar
Member Avatar
+0 forum 1

I have an xml file that looks like this <?xml version="1.0" encoding="UTF-8" ?> <dates> <date> <Item Name="History" Type="List"> <Item Name="received" Type="Date">2015/12/18 00:00</Item> <Item Name="accepted" Type="Date">2016/03/31 00:00</Item> <Item Name="aheadofprint" Type="Date">2016/04/14 00:00</Item> <Item Name="entrez" Type="Date">2016/04/15 06:00</Item> <Item Name="pubmed" Type="Date">2016/04/15 06:00</Item> <Item Name="medline" Type="Date">2016/04/15 06:00</Item> </Item> </date> <date> <Item Name="History" Type="List"> <Item Name="epublish" Type="Date">2016/05/23 00:00</Item> <Item Name="entrez" Type="Date">2016/07/12 06:00</Item> <Item Name="pubmed" Type="Date">2016/07/12 06:00</Item> <Item Name="medline" Type="Date">2016/07/12 06:00</Item> <Item Name="pmc-release" Type="Date">2017/01/01 00:00</Item> </Item> </date> </dates> I am trying to get values of both the "name" attribute and the "date" attribute. I have used the code below <?php $xml = simplexml_load_file('dates.xml'); foreach( $xml->date->Item->children() as $v){ …

Member Avatar
Member Avatar
+0 forum 2

I have an XML file that has 144 columns for the last 12 year's rolling data -- and the column name: goes like this: Column> <Selected/> <SourceName>09/1999 XYZValue</SourceName> <DestinationName>Sep1999_XYZDestination</DestinationName> <TypeName>FLOAT</TypeName> </Column> <Column> <Selected/> <SourceName>10/1999 XYZValue</SourceName> <DestinationName>Oct1999_XYZDestination</DestinationName> <TypeName>FLOAT</TypeName> </Column> ......... all the way to <Column> <Selected/> <SourceName>08/2011 XYZValue</SourceName> <DestinationName>Aug2011_XYZDestination</DestinationName> <TypeName>FLOAT</TypeName> </Column> We will get a new upload file every month. For processing Sep 2011 file, what I have to do is - to delete entry for 09/1999 (so that the starting month would be 10/1999) and include a new entry in the end for 09/2011. The logic should search for the …

Member Avatar
+0 forum 0

Hi so i'm working on a project in c#. I have hundreds of xml files and I need to extract 6 values from each of the xml files and somehow display them on an excel datasheet. Here is an example of the xml file: [code] <XAxisCalib> <Max>288.93</Max> <Min>-48.08</Min> <MaxS>200</MaxS> <DfTHt>0</DfTHt> <LdVe>0</LdVe> <EjVe>0</EjVe> </XAxisCalib> <YAxisCalib> <Max>646.01</Max> <Min>-90.9</Min> <MaxS>200</MaxS> <DfTHt>0</DfTHt> <LdVe>0</LdVe> <EjVe>0</EjVe> </YAxisCalib> <ZAxisCalib> <Max>16.1</Max> <Min>-146.82</Min> [/code] I need to extract the <Max> and <Min> value of the x,y,and z calib. How can I do this. I've done tons of research but no examples show some of the xml file all sources …

Member Avatar
Member Avatar
+0 forum 3

Hello there, I don't know how to word this correctly, but i have a couple XML files that i need to extract certain information from. The files are already on my computer, so i won't be fetching it off the web anymore if that helps any. I mainly want to extract the information within the nodes, or everything within/under a parent-node. Here is an example of what's within the XML file: [CODE] <?xml version ="1.0" encoding="uscii"?> <context id="TwelveMonthEnd"> <entity> <number>152360</number> </entity> <Frame> <Start>1985-01-01</Start> <End>1986-01-02</End> </Frame> </context> [/CODE] Then it repeats this for an X amount of times then stops. The …

Member Avatar
Member Avatar
+0 forum 3

lately i have did a nice idea , that i have a lot of course programs inside my XML file <?xml version="1.0" encoding="utf-8"?> <rss version="2.0"> <channel> <title>Training Programs</title> <link></link> <description>NA</description> <language>en</language> <copyright>NA</copyright> <lastBuildDate>Wed, 19 Apr 2006 16:26:12 -0800</lastBuildDate> <generator>text</generator> <docs>http://blogs.law.harvard.edu/tech/rss</docs> <item> <title>HR</title> <link>data/feed1/article_1.html</link> <pubDate>Wed, 19 Apr 2006 16:26:12 -0800</pubDate> </item> <item> <title>Marketing</title> <link>data/feed1/article_1.html</link> <pubDate>Wed, 18 Apr 2006 16:26:12 -0800</pubDate> </item> </channel> </rss> in the html page when i click on HR then will open new page (register) and showing me the {title} which is HR , and here's my problem :S when i click on marketing and open this register …

Member Avatar
Member Avatar
+0 forum 1

hi.... i have a small problem using the DOM parser for XML in c# [CODE] XmlDocument doc = new XmlDocument(); XmlNodeList _list = null; doc.Load(location.Text); _list = doc.GetElementsByTagName("DataSource"); foreach (XmlNode node in _list) { //some processing } [/CODE] over here i am able to get specific nodes using the getElementByTagName method..... after this is done..... how do i browse the child nodes of the nodes i've already selected...... [CODE] <DataSource> <DataSources> <Name>Source1</Name> </DataSources> <DataSources> <Name>Source2</Name> <Property>Hidden<Property> </DataSource> </DataSource> [/CODE] my code selects all the DataSource nodes in the xml..... now for each of the DataSource nodes in the list that …

Member Avatar
Member Avatar
+0 forum 3

hi, im trying to display the attribute name of the parent node once the input matches a town name: my xml is: [CODE] <phonebook> <area code="022"> <town>mallow</town> </area> <area code="023"> <town>bandon</town> <town>bray</town> </area> <area code="024"> <town>youghal</town> </area> <area code="025"> <town>fermoy</town> </area> </phonebook> [/CODE] and the method is: [CODE] private void btnGetNum_Click(object sender, EventArgs e) { XmlNodeList towns = doc.GetElementsByTagName("town"); foreach (XmlNode town in towns) { if (txtInput.Text.Equals(town.ChildNodes[0].Value)) { lstResult.Items.Add("area code is" + ??????????); } } [/CODE]

Member Avatar
Member Avatar
+0 forum 2

Hi all, I am in fruit industry and dealing with stock inventory of fruits. I got 2 files, one file got fruit names (fruit.txt) and other file got the inventory status (status.txt). Task for me was to check the fruit list and update the inventory status: Contents of the files: 1st file (fruit.txt): ===================== rambutan guava apple lychee durian 2nd File (status.txt): ====================== <data> <apple> <In_Stock>true</In_Stock> </apple> <orange> <In_Stock>true</In_Stock> </orange> <banana> <In_Stock>false</In_Stock> </banana> <coconut> <In_Stock>true</In_Stock> </coconut> <rambutan> <In_Stock>false</In_Stock> </ramputan> <melon> <In_Stock>true</In_Stock> </melon> <palm> <In_Stock>true</In_Stock> </palm> <guava> <In_Stock>false</In_Stock> </guava> <grapes> <In_Stock>true</In_Stock> </grapes> <jackfruit> <In_Stock>false</In_Stock> </jackfruit> </data> When comparing the files, need …

Member Avatar
Member Avatar
+0 forum 13

Hi this is sri and i am new to java.Here is a xml file. My task is to parse all the xml elements in java without using any parser like dom,sax. So pls help me[U] how to parse xml elements without parsers[/U].I have to get same out put as when i use parsers. [CODE]<?xml version="1.0" ?> <Company> <Project> <title>Customersupport</title> <frontend>php</frontend> <backend>mysql</backend> <client>Matrix</client> <team_size>20</team_size> </Project> <Project> <title>Enterprise</title> <frontend>php</frontend> <backend>mysql</backend> <client>Sudha</client> <team_size>5</team_size> </Project> </Company>[/CODE] Thanq

Member Avatar
Member Avatar
+0 forum 2

I am reading XML and PHP. I have to import a xml file in mysql database using PHP script. I tried using 'simplexml_load_string()' and 'simplexml_load_file()' functions. It worked. But how the xml parser is used to import XML files into Mysql Database. Please tell me about this, I tried the example in [url]http://www.w3schools.com/PHP/php_xml_parser_expat.asp[/url] but could not able to import to Mysql Database. Thanks

Member Avatar
+0 forum 0

I need to search an XML file for a unique entry. I've never worked with XML before. Can anyone tell me what the fastest way to search an XML file is? For the website I'm working on performance is critical so I need that fastest possible way to get this data. For this particular search, all I need is to get the text inside of <TERM> based on the string id ("entry_id" in the XML file). Example: [CODE]string getTermName(string id); label.text = getTermName("0001");[/CODE] Here is a sample of how the XML file is structured. [CODE]<?xml version="1.0" encoding="utf-8" ?> <!DOCTYPE GLOSSARIES …

Member Avatar
Member Avatar
+0 forum 3

To find xml code from excel (My site Rank First in Google) Here i have found new way to develop xml file from excel. step 1: open MS Excel 2007 or any version Refer Fig. Copy1.jpg in attachment First create root tag and child tag refer fig. copy2.jpg step 2: choose the cell which you want to convert into xml file. use the formula =b2&c2&d2 like that <Root><parent><child>child node</child></parent></Root> step 3: In the above figure use the formula in the formula box type it as root tag first as =B2&A2 =B3&D3&A3&E3 (Drage and drop untill the last child node =C3&C2 …

Member Avatar
+0 forum 0

Hello Everybody, I am working on Parsing right now, So can anybody please through some light pertaining to what XMl Parsing is basically being done and I would appreciate it greatly if somebody who knows it can give me any example for the same. Thanks in Advance, john

Member Avatar
Member Avatar
+0 forum 2

Hi. I've got to write some code to get data from an XML document and turn it into C# objects. Problem is that the XML document will not always have the same nodes, since it is produced from a web form that people have filled in varying amounts of (which I cannot control since the xml is from a 3rd party resource). For example sometimes the XML document has a <NamePrefix> tag to contain Mr./Mrs./... etc, but if people haven't filled this in on the form it won't. This means that when I call [CODE=C#]document.selectSingleNode("NamePrefix");[/CODE] this will sometimes throw an …

Member Avatar
Member Avatar
+0 forum 3

hi... i am completely new to xml.. how to compare parsed data in c++??.. I am using expat. should i use huge else-if statements to compare the elements i just extracted ?? is there anyother way of doing it??? I have a feeling i have messed up somewhere..

Member Avatar
+0 forum 0

Hi all, I'm programming an iphone app that uses an xml parser: I got 2 classes: DataManager and XMLParser. the XMLParser class is delegated so i can use functions like parserDidEndDocument. Now in the class DataManager, i call a function in the XMLParser: [CODE]XMLParser *xml = [[XMLParser alloc] init]; NSMutableArray *test = [xml getData]; //now iterate the mutablearray [/CODE] this function creates a new connection and calls the XMLParser. The problem is that it now returns a empty array, i think this is because the NSConnection is in a separate thread. In the XMLParser class i can use parserDidEndDocument, should …

Member Avatar
+0 forum 0

Hello there! I am pretty new to xml and xsl. I have been trying to achive a dynamic link creation. My xml file has the format like; <root> [INDENT]<customer>company_name</customer> [INDENT]<id>2334</id> <code>xsTu4</code> <mail>info@comany.com</mail>[/INDENT] </customer>[/INDENT] </root> I want to use an XSL file to give me a link like detail.aspx?id=2334 I have tried [ICODE] <xsl:value-of select="id"/> <a href="detay.aspx?id={id}"> <xsl:value-of select="company"/> </a>[/ICODE] but didnt get what i need:( I need a company name with a link:) so I can post it to details.aspx page with the company id. I am using <xsl:for-each select="/root/customer"> to get all the information as well. So? any idea?

Member Avatar
Member Avatar
+0 forum 1

Is there a way to handle standard XML entities with the event-driven XML parser in PHP? I'm currently using an XML file to build a collection of objects and display a page based on those objects. I'd like my CData handler to handle text that includes standard entities, but as it stands, it handles the text on either side of an entity separately. I could compensate for this if I could define an event handler for when a standard entity is encountered, but so far, my research hasn't turned up a way. I've checked the PHP manual, the book Programming …

Member Avatar
Member Avatar
+0 forum 2

Hi there I have following XML document that i want to read in python code. i know how to read, thing is i want to make hash/list from this XML document. <?xml version="1.0" ?> ‐<TradeExt> ‐ <fxall category="buyer" version="2.0"> ‐<tradeHeader> <sourceId>test_sourceId1</sourceId> <pmsId>4521363.0.0</pmsId> <fundId>ACCT1@TESTCUST</fundId> </tradeHeader> ‐ <tradeStatus> <dealImmediately>F</dealImmediately> <blockImmediately>F</blockImmediately> </tradeStatus> ‐ <tradeFinancials> <userDefinedFields Name="UDF_6">six</userDefinedFields> <userDefinedFields Name="UDF_7">seven</userDefinedFields> <remarks>test remark</remarks> </tradeFinancials> </fxall> ‐ <fxall category="buyer" version="2.0"> ‐ <tradeHeader> <sourceId>test-sourceId2</sourceId> <pmsId>4521363.0.1</pmsId> <fundId>ACCT2@TESTCUST</fundId> <pomsId>4521363_0_1_0</pomsId> <blockTicketId>4521363</blockTicketId> <lastNegotiator>trader@TESTCUST</lastNegotiator> <traderId>null Maker Name</traderId> </tradeHeader> ‐ <tradeStatus> <state>Completed</state> <nonNegotiated>F</nonNegotiated> <blockImmediately>F</blockImmediately> </tradeStatus> ‐ <tradeFinancials> <spotRate>1.4144</spotRate> <forwardPoints>0</forwardPoints> <allinRate>1.4144</allinRate> <indicativeRate>1.1695</indicativeRate> <counterParty>ABN</counterParty> <userDefinedFields Name="UDF_9">nine</userDefinedFields> <userDefinedFields Name="UDF_10">ten</userDefinedFields> <userDefinedFields Name="UDF_11">eleven</userDefinedFields> <remarks>test remark2</remarks> </tradeFinancials> </fxall> </TradeExt> -----------------------------END …

Member Avatar
Member Avatar
+0 forum 2

Hi, I am using a PHP parser to extract some contents from a RSS feed. The parser used to work just fine, but when I changed my hosting the parser stopped working and now it shows the following error: XML Error: not well-formed (invalid token) at line 11 The XML file its a valid RSS feed according to feedvalidator.org and I just can't find the reason why it used to work and now it doesn't. Does anybody know why it is not working in this new hosting?? or if a possible reason for this? RSS feed:[URL="http://www.banxico.org.mx/rsscb/rss?BMXC_canal=fix&BMXC_idioma=es"]http://www.banxico.org.mx/rsscb/rss?BMXC_canal=fix&BMXC_idioma=es[/URL] Thanks!

Member Avatar
Member Avatar
+0 forum 7

Can I use libxml++ to parse html. I'm trying to find all the images in a xml file and store the image data directly into the src attribute of the web page. I know there is a bit of a difference between html and xml that's why I am asking the question

Member Avatar
Member Avatar
+0 forum 3

The End.