6,049 Topics
![]() | |
XML,Excel Macros Hi I am working on some stuff where i need to Import the data present in XML file to excel sheet. i wrote below code for it Sub ImportXMLtoList() Dim strTargetFile As String Application.DisplayAlerts = False strTargetFile = "C:\BookData.xml" Workbooks.OpenXML Filename:=strTargetFile, LoadOption:=xlXmlLoadImportToList Application.DisplayAlerts = True End Sub But … | |
I am trying to extract specific values of element from xml document and produce an output of XML data or a CSV document and arrange them is this order. Locator designator Locator name Locator Thoroughfare Addressarea. current order: <Locator>1</Locator> <LocatorDesignator>Dwelling (Part Of), Null</LocatorDesignator> <thoroughfare>Abesinia Passage</thoroughfare> <AddressArea>Abesinia Passage</AddressArea> <LocatorName>Dwelling (Part Of)</LocatorName> … | |
Hello, I would like to be able to Read from a CSV file that will have "fields", lets call them ID, Name, Price. I want to be able to create a seperate XML file for each row in the CSV file. Right now, i have it so it will read … | |
Dear all, I have a website in which I am using the following htaccess code to hide the file extension RewriteEngine on RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_FILENAME}\.php -f RewriteRule ^(.*)$ $1.php I then manually removed the .php extension from the entire website. Now when I am generating a site map … | |
Hi All, I am newbie to XML. I want to create only one XML file each day automatically using php function with the following format. I want to use the same function for appending the follwing portion into the existing XML file ## This portion need to append whenever the … | |
Hi every one. I have a problem with combinning two scripts. Fisrt script is working perfectly and taking stuf from mysql: function showUser(str) { if (str=="") { document.getElementById("txtHint").innerHTML=""; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new … | |
I want to write XMl using xml text writer ..but i dont want to final output to be the special symbols with amp; format ..how can i do it | |
I have created a userConfig file to add MSGOTHIC font to FOP. <fop version="1.0"> <renderers> <renderer mime="application/pdf"> <fonts> <!-- register a particular font --> <font metrics-url="file:/tmp/msmsgothic.xml" kerning="yes" embed-file="file:/tmp/msgothic.ttf"> <font-triplet name="MSGothic" style="normal" weight="normal"/> </font> <font metrics-url="file:/tmp/msmsgothic.xml" kerning="yes" embed-file="file:/tmp/msgothic.ttf"> <font-triplet name="MSGothic" style="normal" weight="bold"/> </font> </fonts> </renderer> </renderers> </fop> Now I have set … | |
Hi Everyone, I would really appreciate some help on this. I'm a web project manager - and the machine mgmt gave me has pretty much given up completely. It only works in Safe Mode - luckily Safe Mode with networking so I am able to get online. I have backed … | |
I have a java application that reads csv file and displays the data on a text area. the idea is to transform this data(source data) into a target data, this involves rearranging it and transforming some elements in each field. now i intend to transform this displayed csv data into … | |
i have a set of xml data from a database, i want to transform these data into a form that would conform to the target data. in the sense that the elements node would change and the text nodes will also be rearranged something like source <?xml version="1.0" encoding="UTF-8"?> <XMLCreators> … | |
hi i need to know about technology or tool which require regarding my project. can anyone please help me my project is Universal remote hmi(human machne interface) which should be 1.platform independent 2.should be able to run on any device (pc,tablet,android phone,windows phone) 3. if possible code of all langauge … | |
![]() | hello i need little help with url rewriting i have page :: www.mysite.com/search.php?q=something desire url structure:: www.mysite.com/q/something .htaccess code :: RewriteRule q/(.*) search.php?q=$1 the above htaccess code work fine but i have little more htaccess code for my site .htaccess code :: RewriteRule www.(.*) web.php?url=$1 desire url structure:: www.mysite.com/www.daniweb.com so … ![]() |
I have a project where I need to get and count distinct values in tags in an XML document. If you look at the XML, I am specifically trying to count the distinct number of WorkOrderNumbers for Tuesday. Later I will do Monday and so on. I have tried the … | |
What does this mean? **Error Line 95, Column 56: end tag for "input" omitted, but OMITTAG NO was specified** <td><input type="button" value="Add to Cart"></td**> You may have neglected to close an element, or perhaps you meant to "self-close" an element, that is, ending it with "/>" instead of ">". **Info … | |
Hello. I am doing an assignment. I just need someone to validate that I did it correctly. According to the book I must: "set the default namespace for the document to the XHTML namespace". I'm a bit confused as to how to do it, but I did this: <?xml version="1.0" … | |
Im wondering if there is a program for building GUIs with XML where I can simply build it visually (WYSIWYG style) and copy/paste the code in my Android IDE. Thanks | |
My blog is www.khazanakhoj.blogspot.in. In this blog i am not able to go to old post and next post. Even i opened particular blog, in that also its not coming. Is here any help regarding this problem. | |
Am trying to import Xtream library for serializing csv data to xml but am having problems in adding this library to the ide i am using (bluej). what directory do i add. i added the whole directory but when i imported "import com.thoughtworks.xstream.XStream;" it kept telling me it does not … | |
Good Day! We would like to seek help on managing multiple values within a single XML attribute. <Row> <title>type Title here</title> <description>type Description here</description> <stage>Development</stage> <platform>Java, .NET, Mainframe</platform> <lifecycle>Custom Development</lifecycle> <servicegroup>System Integration (SI), Technology Consulting (TC)</servicegroup> </Row> With the above sample xml, as you may notice, <platform> does have 3 … | |
Hi, I'm trying to add a right parenthesis to a number when it is negative upon returning from a Java function and so far am unable to do it. I can add the left parenthesis no problem but can't find a way to add the right parenthesis. It is much … | |
Hi, I have a database program that creates URL's that look like this... http://www.mywebsiteDB.com/admin.php?toDo=module&module=RESERVATIONS&modsub=reservations or this http://www.mywebsiteDB.com/admin.php?toDo=module&module=RESERVATIONS&modsub=upcoming etc. I need to make a page that inserts fields into the database AJAX style, which I managed to do outside of the database program. However, when I put the code into a … | |
Hi, I would like to know how to create a dynamic xml playlist that is automatically updated as mp3 files are uploaded. I want the playlist for flabell29 flash mp3 player, which can be found at flabell.com. The playlist icludes album art location, artist name, track title, duration, album title … | |
HI, I am have a string and I want to remove <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> from this string.I have tried str_replace but of no use can any one help that how would I remove this problem from my string. Thanks in advance. | |
Hello, I am currently writing my thesis about IT technologies etc. etc. and I have one chapter where i compare REST and SOAP, but I can not find how and when (i mean some king of events in the past) REST started (mainly in Web) to replace SOAP as technology … | |
Hi, I had to do the quiz for XML and I am not quite sure whether I've got all the question right. Please tell me whether I've got each question right or wrong. Thank you very much. 1. What kind of component in an XML file is written like this: … | |
Hey all, Just wrapping up a project for a custom photography site. My client has asked me to make sure that we can upload several images with each image being anywhere from 10MB to 20MB each in size. I simply told him to get his own server to handle that … | |
Hi Buddy, I have a requirement to convert the below shown input.xml into result.xml and the XSLT which I am trying with is shown at the end. input.xml: <match> <FieldMatcherResult> <FieldPair> <Context>A</Context> <Field1>A1</Field1> <Field2>A2</Field2> </FieldPair> <FieldPair> <Context>B</Context> <Field1>B1</Field1> <Field2>B2</Field2> </FieldPair> </FieldMatcherResult> </match> result.xml: <result> <FieldMatcherResult> <FieldPair> <Context>A</Context> <Field1>A1</Field1> <Field2>A2</Field2> </FieldPair> … | |
Hi i am using XSLT transformation to transform one xmi file to uml file. In my xml files i have two different nodes: **First node:** <ownedAttribute xmi:type="uml:Property" xmi:id="EAID_9D13F3CF_4FDB_46bc_B47F_8B4DC9C6DADD" name="Part2" visibility="public" aggregation="composite"/> **Second node:** <Profile:AND base_Part="EAID_9D13F3CF_4FDB_46bc_B47F_8B4DC9C6DADD"/> what i am trying to do is that every time the xmi:id of the uml:property … | |
I am trying to add the information below into a Wordpress database table (specifically the wp_postmeta table). But I can't figure out how to add the ones with the same node name. The XML document is: <?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0" xmlns:excerpt="http://wordpress.org/export/1.1/excerpt/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:wp="http://wordpress.org/export/1.1/" > <channel> <title>Title</title> … | |
I am trying to read the following xml file into my datagridview <?xml version="1.0" encoding="utf-8" ?> <DEFLECTIONS_TABLE> <Deflections number="1"> <Service_Class>A</Service_Class> <Verticle>600</Verticle> <Horizontal>400</Horizontal> <Service_Class>B</Service_Class> <Verticle>600</Verticle> <Horizontal>400</Horizontal> <Service_Class>C</Service_Class> <Verticle>600</Verticle> <Horizontal>400</Horizontal> <Service_Class>D</Service_Class> <Verticle>800</Verticle> <Horizontal>400</Horizontal> <Service_Class>E</Service_Class> <Verticle>1000</Verticle> <Horizontal>400</Horizontal> <Service_Class>F</Service_Class> <Verticle>1000</Verticle> <Horizontal>400</Horizontal> </Deflections> </DEFLECTIONS_TABLE> I made my windowsform and put a datagridview inside called deflection_datagrid. … | |
Hi Pythonist, I write the code in Python for search and replace the text in all XML files at current directory. But I'm unable to find and replace the text `<tex>` as empty in all XML files. Here I want to remove the text: <tex>z_{1 - \alpha }^2 \,\sigma _{{\rm … | |
i want to design the Currency gadget .....that should work in all the operating system it should be something like installation application as shown in the above daigram so please help me out Thank you  | |
Hi, Please correct me here about xml, I am still new to it: -It should have start and closing tags, i.e `<start></end>`; avoid short cuts like `<tag/>` like in html. -xml schema is an xml document, it abides by xml rules. So how comes that we have something like: `<xs:attribute … | |
Hi, I have a few XML file which have illegal chars like &, <, >, ", '. Because of that I cannot read/validate XML file to do further processings. I have no control over XML files because user's don't listen!!! Can I solve it by using DTD or XSD or … | |
Hi all please help as I am so stuck. My aim in to retrieve the information out of the xml soap file and store it in a database. However I havent got the slightes idea what i'm doing wrong. Please help I just want to write the values out in … | |
Can someone give a code snippet on how to 'chat' using the XMLRPC library in Python? Here's my server code: from xmlrpc.server import SimpleXMLRPCServer from xmlrpc.server import SimpleXMLRPCRequestHandler import os from os import access, path PATH = 'chatlog.$' class RequestHandler(SimpleXMLRPCRequestHandler): rpc_paths = ('/RPC2',) server = SimpleXMLRPCServer(("localhost", 8000), requestHandler=RequestHandler) server.register_introspection_functions() server.register_function(pow) … | |
Hi there, In my program i have given the user the possibillity to add new buttons to the form I then serialize the form to a xml file so it is saved. Any data that is edited while the program is running will be saved (for example user edits the … | |
Hi, Can any one provide me small code or way how can I read the below XML file in PHP. <Countries> <Country> <Page1_col1>Country1</Page1_col1> <Page1_col2>89,921</Page1_col2> <Page1_col2>61</Page1_col2> <Country_sub_details> <Page2_col1>A1</Page2_col1> <Page2_col2>1,187</Page2_col2> <Page2_col3>45</Page2_col3> <Country_sub_sub_details> <Page3_col1>AA1</Page3_col1> <Page3_col2>375</Page3_col2> <Page3_col3>45</Page3_col3> </Country_sub_sub_details> </Country_sub_details> </Country> </Countries> I am not aware about the XML libraries in PHP. | |
Hi, I'm having problem with reading xml file because there are invalid chars like & sign. How can I evaluate this problem and read the file with simple_xml or DOM? **php** $xmlDoc=simplexml_load_file('items.xml'); $doc = new DomDocument; $doc->load('items.xml'); //Both of these don't work **xml** <?xml version="1.0" encoding="ISO-8859-1"?> <store id="AMZ-0101-STR"> <items> <item> … | |
I am looking at using the 'Document Widget' in WXWidgets to create a report. It is apparrently an html document. Does this mean that I can format and position text using XML or HTML. I'm not entirely sure how this works. Can I also add objects to the html document … | |
Hi, I know that we cannot use some special chars in XMl and also we can escape/declare them in DTD via ENTITY line. Can anyone help me modifing DTD code below so I have valid XML? e.g. I tried this but no luck: `<!ENTITY & "&">` Thanks in advance <?xml … | |
Hi, I am having the C application which I want to access a remote Java Web Service; I have looked for open source SOAP libraries for C and found [CSOAP](http://csoap.sourceforge.net/). However, I am having the following questions/problems with it: 1) Is it possible to access Java Web Services using CSOAP? … | |
Today just do walking around looking for information on the search engines Google, Yahoo, Bing, ... to make some material support for the work and also improve their knowledge, this article is shared from the forum "Bing Center Webmaster" 45 step guide to SEO the most basic and easy to … | |
Hi, I am looking for regex to extract following words from text: The word which comes after "Replaced" means Replaced disk Replaced floppy Replaced memory Please suggest the regex for it. Thanks! | |
I am currently working on an app to convert documents (specifically Open Document Text, at least for now) to epub format. The problem I'm running into right now is this, I am using etree ElementTree to parse the xml files extracted from the .odt file, right now I'm working on … | |
Alright please bear with me for few posts, I am trying to design a scoreboard application using HTML. The data for scoreboard (including headings and rows and columns) are stored on a server at a remote location. I am trying to develop an ASP.NET script to fetch that XML and … | |
hi i have my xml code below: [CODE]<?xml-stylesheet type="text/xsl" href="book.xsl" version="1.0"?> <books xmlns:xsd = "http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation = "book.xsd"> <book id="001"> <isbn>0465044050</isbn> <title>Birth of the Mind</title> <author> <firstname>Gary</firstname> <lastname>Marcus</lastname> </author> <publisher>Basic Books</publisher> <year>2004</year> <price>17.68</price> <picture>0465044050.gif</picture> <description>write your desc.</description> </book> </books> [/CODE] and here my xsl code: [CODE]<?xml version="1.0" encoding="ISO-8859-1"?> <xsl:stylesheet version="1.0" … | |
Hey Guys, I am having some trouble... I have the following XML from Google: <GeocodeResponse> <status>OK</status> <result> <type>street_address</type> <formatted_address> 1600 Amphitheatre Pkwy, Mountain View, CA 94043, USA </formatted_address> <address_component> <long_name>1600</long_name> <short_name>1600</short_name> <type>street_number</type> </address_component> <address_component> <long_name>Amphitheatre Pkwy</long_name> <short_name>Amphitheatre Pkwy</short_name> <type>route</type> </address_component> <address_component> <long_name>Mountain View</long_name> <short_name>Mountain View</short_name> <type>locality</type> <type>political</type> </address_component> <address_component> <long_name>Santa … | |
Hi, I'm creating a bookmarks system for my web browser. I'm learning how to use XML files with VB.Net, so my bookmarks are stored in an XML file. When I want to add a new bookmark, the code below works, but it only allows for one bookmark. How can I … |
The End.