6,049 Topics
![]() | |
Hello everybody, so, I realized that when I try to load some XML into a MySQL table through the `LOAD XML LOCAL INFILE ...` statement, if there is a parent with the same name of the child, MySQL will insert an extra row. Here's the example to reproduce the issue: … | |
<?xml version="1.0"?> <License version="1"> <ActivationInfo> <ActivationDate></ActivationDate> <IssueDate>22-Dec-2015</IssueDate> </ActivationInfo> <MachineInfo> <MachineName></MachineName> <SoftwareIds></SoftwareIds> </MachineInfo> <LicenseKeys> <LicenseKey> <LicenseVersion>1</LicenseVersion> <FeatureName>PLI_FEATURE1</FeatureName> <LicenseType>PERMANENT</LicenseType> <CustomProperties> <CustomProperty> <key>LICENSETYPE</key> <value>EVAL</value> </CustomProperty> <CustomProperty> <key>CAPACITY</key> <value>10</value> </CustomProperty> <CustomProperty> <key>CAPACITY_UNIT</key> <value>TB</value> </CustomProperty> </CustomProperties> </LicenseKey> <LicenseKey> <FeatureName>PLI_FEATURE2</FeatureName> <LicenseType expirationDate="01-Jan-2017">EVALUATION</LicenseType> <CustomProperties> <CustomProperty> <key>LICENSETYPE</key> <value>EVAL</value> </CustomProperty> <CustomProperty> <key>CAPACITY</key> <value>10</value> </CustomProperty> <CustomProperty> <key>CAPACITY_UNIT</key> <value>TB</value> </CustomProperty> </CustomProperties> … | |
| |
Hi, **Python script** from xml.dom import minidom doc = minidom.parse("wind7.xml") Ts = doc.getElementsByTagName("TimeStep") for Ts in TimeStep: Part = TimeStep.getElementsByTagName("Particle")[0] for Part in Particle: Pcid = Particle.getAttribute("Nr") Lat = Particle.getAttribute("x") Long = Particle.getAttribute("y") print("Pcid:%s,Lat:%s,Long:%s" % (Nr,x.firstChild.data,y.firstChild.data)) I have written this python script to extract XY data, but am getting lot … | |
Hello Everyone, I am new to c# and am trying to use Open XML to pull data from a SQL server into a spreadsheet. I followed some examples I found online but had to alter them to fit the test scenario I have set up and have run into an … | |
I just want to know: Is it still necessary or is it still working for traffic, Today? | |
My code is: var customIcons = { restaurant: { icon: 'http://labs.google.com/ridefinder/images/mm_20_blue.png' }, bar: { icon: 'http://labs.google.com/ridefinder/images/mm_20_red.png' } }; function load() { var map = new google.maps.Map(document.getElementById("map"), { center: new google.maps.LatLng(37.4805016667, 126.952741667), zoom: 12, mapTypeId: 'roadmap' }); var infoWindow = new google.maps.InfoWindow; // Change this depending on the name of your … | |
This is php code at https://developers.google.com/maps/articles/phpsqlajax_v3#putting-it-all-together. <?php $username="xxxx"; $password="xxx"; $database="xxx"; ?> <?php function parseToXML($htmlStr) { $xmlStr=str_replace('<','<',$htmlStr); $xmlStr=str_replace('>','>',$xmlStr); $xmlStr=str_replace('"','"',$xmlStr); $xmlStr=str_replace("'",''',$xmlStr); $xmlStr=str_replace("&",'&',$xmlStr); return $xmlStr; } // Opens a connection to a MySQL server $connection=mysql_connect ('localhost', $username, $password); if (!$connection) { die('Not connected : ' . mysql_error()); } // Set the active MySQL … | |
I want to mark some data on google map. I use eclipse Java EE and xml file is in the same workspace;(workspace_jsp). xml file: <csv_data> <row> <time>10:01:43</time> <latitude>37.4805016667</latitude> <longitude>126.952741667</longitude> <pdistance>0.000555</pdistance> <totaldistance>0.000555</totaldistance> <sectionspray>3343.0</sectionspray> </row> <row> <time>10:01:57</time> <latitude>37.4807483333</latitude> <longitude>126.952753333</longitude> <pdistance>0.027396</pdistance> <totaldistance>0.027951</totaldistance> <sectionspray>3320.0</sectionspray> </row> my code is <!DOCTYPE html > <head> <meta name="viewport" … | |
I have a basic question. I collected some gps signal to some columns by python code. I want to read them and use some data in html-javascript. In this case, what kind of file is the easiest to read and use in html/javascript?? I made a text file but people … | |
I have a MySQL database which contains a text field which contains well formed xml. I want to export this data as an xml file named result_new.xml on the fly. I have made the tmp folder and have set the permissions on the folder to 0777. If I run this … | |
I have a mysql database that has previously stored the text of an xml file including tags. I want to select that data from the database and return it as an xml file rather than just text, (eg filename.xml). It is to be further processed with a javascript file which … | |
Hi there, I am an undergraduate studying computer science. Our lecturer gave us an assignmnet to use Dapfor grid control display both authors name and their book. I don't know where to begin from. Can anyone put me through; maybe with an example. | |
I am trying to create a dtd that emulates a car dealership. It sells trucks, sedans and hatchbacks, as can be seen in my dtd. The dealership would keep track of how many doors and wheels each vehicle has as well as the model and year in addition to how … | |
XML - <?xml version='1.0' encoding='UTF-8'?> <Form name='Demo' id='DemoID' searchname='Demo' search='Demo' org='Yes' > <Field name='IdentificationNumber' datatype='String' control='InputText' length='10' search='Yes' /> <Field name='Country' datatype='String' control='InputText' length='50' search='Yes' /> </Form> PHP - <!DOCTYPE html> <html> <body> <?php $xml=simplexml_load_file("Demo.xml") or die("Error: Cannot create object"); echo $xml->FIELD . "<br>"; ?> </body> </html> | |
Hello Guys, I need some help with customizing my wordpress rss feed. I have a blog with tons of posts with images in it, these images are remotely hosted. I want to display them in my rss feed. How do i display first image of a post in my wordpress … | |
I am attempting to add a custom function to my schematron rule stylesheet to aid in looking up values in code tables. I continue to receive an error message: 'XPST0017 XPath syntax at char 0 on line 545 near (...ookupExpression('SEX'): Cannot find a matching 1-argument function named (functions:1.0)BuildLookupExpression())' At the … | |
Ok, I know about how to check for the end of a file, but what I need to know, is if you create a new file, thats empty, how do you check if it really is empty, and if its the same as EOF, then what am I doing wrong … | |
Hi there to all I'm trying to make application which should extract certain data from XML files. I'm using form, combobox and button. If someone could guide me because I'm not so familiar with programming... here is code example To populate Combobox1 and it works fine Private Sub form1_load(sender As … | |
Hello, I'm using the rotate-layout library by rongi (https://github.com/rongi/rotate-layout) to achieve a horizontal list view by implementing the suggestion given by Kc Ochibili as an answer to this question: http://stackoverflow.com/questions/3240331/horizontal-listview-in-android. I'm getting the following errors when I try to use the library: "error: Error parsing XML: unbound prefix" and "Attribute … | |
hi guys im trying to login to a webstie just with sending requests to the server . the website has a login form which is this : <form id="Form1" onsubmit="return Form1_onsubmit()" style="direction: rtl; text-align: right" action="./17717417412" method="post" name="Form1"> <input id="__VIEWSTATE" type="hidden" value="/wEPDwUKMTQ4MDM5MTkwMg9kFgICAQ9kFggCAQ9kFgYCBQ8WAh4JaW5uZXJodG1sZWQCBw8WAh8ABTvYp9iq2LXYp9mEINin2LIg2LfYsdmK2YI62LTYqNqp2Ycg2K/Yp9iu2YTZii3Yp9mK2YbYqtix2YbYqmQCCw8WAh8ABRk8Yj7bsduz27nbtC/bsduxL9ux27Q8L2I+ZAIFDxYCHgdWaXNpYmxlaGQCBw8WAh8BZxYCAgEPFgIfAAXXCdmC2KfYqNmEINiq2YjYrNmHINiv2KfZhti02KzZiNmK2KfZhiDZiNix2YjYr9mKINis2K/ZitivOjxici8+DQoxLdio2Ycg2YXZhti42YjYsSDYp9iz2KrZgdin2K/ZhyDYqNmH2YrZhtmHINin2LIg2LPYp9mF2KfZhtmHINii2YXZiNiy2LTZitiM2b7amNmI2YfYtNmKINmIINiv2KfZhti02KzZiNmK2Yog2K/Yp9mG2LTar9in2Ycg2LTZiti...jYp9mH2K8g2LTYry48YnIvPg0KNC3Yp9ix2KfYptmHINix2YrYstmG2YXYsdin2Kog2YXZgti32Lkg2YrYpyDZhdmC2KfYt9i5INmC2KjZhCDYr9ixINiy2YXYp9mGINir2KjYqiDZhtin2YUg2K3YttmI2LHZiiDYp9mE2LLYp9mF2Yog2YXZiiDYqNin2LTYrzxici8+DQo1Ldiu2YjYp9mH2LTZhdmG2K8g2KfYs9iqINin2LIg2YXYsdin2KzYudmHINit2LbZiNix2Yog2Ygg2KrZhNmB2YbZiiDYqNmHINmI2KfYrdivINmH2KfZiiDZhdiu2KrZhNmBINiv2KfZhti02q/Yp9mHINiv2LEg2K7YtdmI2LUg2YXZiNin2LHYryDYqNin2YTYpyDYrtmI2K/Yr9in2LHZiiDZgdix2YXYp9mK2YrYry4NCmQCCQ8WAh8ABQEgZGRDY9B9c/B5YHJtWvxroJcmLKB7mcNVjEPC771IlbjsIQ==" name="__VIEWSTATE"> <input id="__VIEWSTATEGENERATOR" type="hidden" value="C792DAE2" name="__VIEWSTATEGENERATOR"> <input id="__EVENTVALIDATION" … | |
I am having difficulty formatting the XML response from a php curl xml api for infobip. My code below loops sms to mobile numbers. But i want to format the XML responses to show the messages successfully sent and those that were not successful using a conditional if else statement. … ![]() | |
First let me confess that I'm a beginner with little knowledge of Java. I'm facing a problem with XML to JSON conversion. The XML that I need to covert is complex with elements that will repeat throughout the document. And the order in which the elements appear need to be … | |
Hi I need help I have some XML files which have more children and grandchildren, than I am used to playing with. (Link to xml file below) https://intecprinters.iweb-storage.com/s/IjU2OTNlNjVkNmExODkyMDlmNjU5N2MyNiI.jaEay6nxR-v-gaiJwcVNiP113QI I need to be able to read the xml, determine the name Root node ,<JOBS_Jan_2016> and obtain the list of names of … | |
<select id="keyEquipmentShiftAutomatedModelData" parameterType="java.util.Map" resultType="java.util.Map"> SELECT ID, SUM(VALUE1 + VALUE2) Total FROM tableName GROUP BY ID </select> Returns below result in sql ID, Total 1 (null) But when returned in Map result in myBatis returns {ID=1} where as Total is missing. How to get the column with null into the result … | |
Hi, I am struggling with xml layout in my android app... please help here is what I want: I have to display two poarts in one activity - image part and login component part which are in one linearLayout. When the device is landscape, I want it to be 30% … | |
This question is about querying an XML file. The file structure is below: Inline Code Example Here <?xml version="1.0" encoding="UTF-8"?> <descriptions> <image> <name>run.jpg</name> <text>Running around the lake</text> </image> <image> <name>sail.jpg</name> <text>Sailing around the lake</text> </image> <image> <name>track.jpg</name> <text>Tracking up the mountain</text> </image> ... <image> <name>Steven.jpg</name> <text>Steven Bullon is a photographer</text> … | |
Hi All I have some doubts while coding in java for the xml reading below is my xml format : <?xml version="1.0" encoding="UTF-8"?> -<ab_rsp status="ok"> -<itm title="United States" guid="04570A9A-6066-11E2-BB55-FF519035903F" type="country"> -<itm title="Arizona" guid="A83274AC-901A-11DF-A622-0C319DFF4B22" type="authority"> -<itm title="Academic Standards" guid="9935C580-C0DA-11DA-80AA-DCC515614119" type="document"> -<itm title="Technology" guid="E3E0AD06-FC32-11D9-8407-9AE6FB2C8371" type="subject"> <meta name="year">2000</meta> -<itm title="Readiness (Kindergarten)" guid="001DCFCC-2A74-11D8-A1A9-EB97E8AED672" type="grade"> … | |
Hello guys so i'm quite new to C++ but i already learned OOP and other things so i want to use this little knowledge yet to create some basic program. I wanted to make a program that uses some API's but the problem is i'm not famillar how API's work … | |
I just want to know whether the ROR sitemap is still an effective choice for SEO? Because, nowadays no one is using ror sitemap. | |
Hi, I have a menu bar with its source derived from an xml data source. I have successfully created the menu bar, but now I want to make that menu bar responsive. I have tried many options but I can't get a correct solution. I hope for a answer here. … | |
I am very much interested in learning programing and software development skills. However i know sotware testing skills, knowledge of hardware, software applications, information security, networking. I do lot or research to learn to develop and desing website with databse integration. I am not financially fit to invest in all … | |
Can anyone help me with how I can retrive the data of this XML with PHP i need to echo the <dc> data ex. <dc:title> and so on. XML file: http://askbib.asker.folkebibl.no/cgi-bin/sru?operation=searchRetrieve&version=1.2&query=rec.identifier=%22261118%22&recordSchema=dc&startRecord=1&maximumRecords=10 | |
I want to parse json to html, with angularjs, i am converting an xml rss feed to json with npm xml2json I am using angularjs http to get an xml from the server, i am using node module xml2json to convert it to a json object. I get the document … | |
Hello experts, I am new to XSLT, SInce I am working integration project where we have XML to XML conversion using XSLT There is one line of code which I am not understanding <xsl:when test="following-sibling::*[2]/CreditOrDebitTransactionType='54'"/> Can anyone explain what this code does , and "CreditOrDebitTransactionType" what this does , This … | |
I am trying to build a web application that can also run on mobile phones. Is the html code generated by imgmap_desktop can be run on both web and mobile? or rather web responsive type? | |
xml output: <balance> <credits>39660</credits> </balance> how to fetch the xml output from url and store the credits i.e. 39660 into php variable. the above xml output is coming from following url http://www.xyz.com/check-balance.php?username=ssgent&password=ssgentr check-balance.php code: <?php require('dbcon.php'); include('encrypt.php'); include('functions.php'); $username = $_GET['username']; $password = $_GET['password']; $password = encrypt($password, 'riffre'); $url = … | |
Dear all, I am looking for guideline to read data from website[photon](http://www.photon.info/photon_site_db_solarmodule_en.photon) . & load into csv file. Whenever new supplier selection or typesection change data should recorded into same excel with new sheet. Can some guide how to get started using python This code to develop for database. Is … | |
I am using XML:twig to extract some attributes from an XML file using Perl; Here is my code: use XML::Twig; my $file = $ARGV[0]; $file =~ /(.+)\.xml/; my $outfile = $1.".snp" ; open my $out,'>',$outfile or die "Could not open file '$outfile' $!"; my $twig = XML::Twig->new ( twig_handlers => … | |
I am work in my seo site do all seo techniq is use but not in google index page. | |
using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.IO; namespace Genesis_Solutions_CRMS { public partial class formNewAccount : Form { public formNewAccount() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { Information info = new Information(); info.Name = txtName.Text; info.Occupation = txtOccupation.Text; info.Dob = double.Parse(txtDob.Text.ToString()); info.Nic = … ![]() | |
<?php $ip = '59.32.28.65'; $url = "http://www.ipmango.com/api.php?ip=".$ip; $xml = simplexml_load_file($url); echo "IP address : {$xml->ipaddress} <br />"; echo "City : {$xml->city} <br />"; echo "Region : {$xml->region} <br />"; echo "Country Name : {$xml->countryname} <br />"; echo "Latitude : {$xml->latitude} <br />"; echo "Longitude : {$xml->longitude} <br />"; ?> | |
Hi, I've recently been assigned a task in a new job where I have to compare XML paths against Acord XML paths to find out what the ancestor path is. I've never done anything like this before and just want to check that I am doing it correctly because i've … | |
I have an xml structure : <Pages> <!--This is the root node--> <Home> <url>...</url> <menu> <item>Help</item> <item>About</item> <item>Contact</item> </menu> </Home> <Help> <url>...</url> <menu> <!--i need to select this if its parent(Help) is listed in Home/menu/item above--> <item>Business Help</item> <item>Web Help</item> <item>Tour Help</item> </menu> </Help> <About> <url>...</url> <menu> <!--And Or select … | |
I have an xml structure : <Home> <url>...</url> <menu> <item>Help</item> <item>About</item> <item>Contact</item> </menu> </Home> <Help> <url>...</url> <menu> <!--i need to select this if its parent(Help) is listed in Home/menu/item above--> <item>Business Help</item> <item>Web Help</item> <item>Tour Help</item> </menu> </Help> <About> <url>...</url> <menu> <!--And Or select this if its parent(About) is listed … | |
Hi, Can anyone suggest that how to add headers in word doc which is generated through openXML. | |
Hi I have a php script which creates an xml file //Select the Database mysql_select_db("personeelsbestand",$db); $result = mysql_query("select * from XMLAfdeling", $db); //Create SimpleXMLElement object $xml = new SimpleXMLElement('<xml/>'); //Add each column value a node of the XML object while($row = mysql_fetch_assoc($result)) { echo $row['Afdelingnaam']."\n"; $mydata = $xml->addChild('mydata'); $mydata->addChild('AfdelingID',$row['AfdelingID']); $mydata->addChild('Afdelingnaam',$row['Afdelingnaam']); … | |
I have been trying since long to extract data using xpath in google sheets but everytime 'am getting message 'imported content is empty'. i need help . The url is http://reports.ieso.ca/public/IntertieScheduleFlow/PUB_IntertieScheduleFlow.xml | |
Here is the CSV file that I am working with: `"A","B","C","D","E","F","G","H","I","J" "88",18,1,"<Req TID=""34"" ReqType=""MS""><IISO /><CID>2</CID><MemID>0000</MemID><MemPass /><RequestData><S>[REMOVED]</S><Na /><La /><Card>[REMOVED]</Card><Address /><HPhone /><Mail /></ReqData></Req>","<Response T=""3"" RequestType=""MS""><MS><Memb><PrivateMembers /><Ob>0-12-af</Ob><Locator /></Memb><S>[REMOVED]</S><CNum>[REMOVED]</CNum><FName /><LaName /><Address /><HPhone /><Email /><IISO /><MemID /><MemPass /><T /><CID /><T /></MS></Response>",0-JAN-10 12.00.02 AM,27-JUN-15 12.00.00 AM,"26",667,0 "22",22,1,"<Req TID=""45"" ReqType=""MS""><IISO /><CID>4</CID><MemID>0000</MemID><MemPass /><RequestData><S>[REMOVED]</S><Na /><La /><Card>[REMOVED]</Card><Address /><HPhone /><Mail /></ReqData></Req>","<Response … | |
Hi, i wanted to create xml file dynamincally by using php, values for tag are given through html page i.e on form submit, i should get xml file in following format: <college> <Department> <id>1</id> <name>cse</name> <address>bangalore</address> <student> <id>1</id> <name>xyz</name> </student> <address>bangalore</address> <student> <id>1</id> <name>xyz</name> </student> </Department> <Department> <id>2</id> <name>enc</name> <address>bangalore</address> … ![]() |
The End.