6,049 Topics

Member Avatar for
Member Avatar for cereal

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: …

0
407
Member Avatar for kkvk

<?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> …

Member Avatar for rubberman
0
667
Member Avatar for rahul208708
Member Avatar for Ketaki_2

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 …

Member Avatar for tinstaafl
0
474
Member Avatar for Wyatt_1

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 …

Member Avatar for tinstaafl
0
1K
Member Avatar for bijutoha
Member Avatar for joomdev
1
298
Member Avatar for Seung Hwan

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 …

Member Avatar for Seung Hwan
0
427
Member Avatar for Seung Hwan

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('<','&lt;',$htmlStr); $xmlStr=str_replace('>','&gt;',$xmlStr); $xmlStr=str_replace('"','&quot;',$xmlStr); $xmlStr=str_replace("'",'&#39;',$xmlStr); $xmlStr=str_replace("&",'&amp;',$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 …

Member Avatar for jacks009
0
472
Member Avatar for Seung Hwan

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" …

0
266
Member Avatar for Seung Hwan

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 …

0
86
Member Avatar for facarroll

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 …

Member Avatar for facarroll
0
1K
Member Avatar for facarroll

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 …

Member Avatar for facarroll
0
385
Member Avatar for emilyjackson

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.

Member Avatar for rproffitt
0
131
Member Avatar for TObannion

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 …

0
128
Member Avatar for Dipti_1

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>

Member Avatar for AndrisP
0
241
Member Avatar for conwicode

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 …

0
230
Member Avatar for cjhukill

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 …

0
182
Member Avatar for Tamir09

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 …

Member Avatar for ddanbe
0
2K
Member Avatar for SoftBa

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 …

Member Avatar for SoftBa
0
893
Member Avatar for admiralchip

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 …

Member Avatar for Raul Perez
0
457
Member Avatar for ms95

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" …

Member Avatar for ms95
0
273
Member Avatar for tundewoods

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. …

Member Avatar for diafol
0
6K
Member Avatar for newprogrammer14

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 …

Member Avatar for milil
0
2K
Member Avatar for squashsparky

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 …

Member Avatar for LaxLoafer
0
368
Member Avatar for Siddharth_6

<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 …

Member Avatar for Siddharth_6
0
193
Member Avatar for 9tontruck

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% …

Member Avatar for AleMonteiro
0
264
Member Avatar for rouse

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> …

Member Avatar for rouse
0
243
Member Avatar for mohan@nano

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"> …

Member Avatar for JamesCherrill
0
192
Member Avatar for justine_1

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 …

Member Avatar for justine_1
0
446
Member Avatar for Piers Rollins

I just want to know whether the ROR sitemap is still an effective choice for SEO? Because, nowadays no one is using ror sitemap.

Member Avatar for jeffjames
0
161
Member Avatar for SaJiN_1

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. …

Member Avatar for gentlemedia
0
328
Member Avatar for shamuh2021

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 …

Member Avatar for shamuh2021
0
266
Member Avatar for Eirik

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

Member Avatar for Eirik
0
345
Member Avatar for Arun_15

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 …

0
168
Member Avatar for sridharsapxi

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 …

Member Avatar for JOSheaIV
0
274
Member Avatar for Anoopgupta

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?

0
138
Member Avatar for blueguy777

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 = …

Member Avatar for jkon
0
409
Member Avatar for ajit.nayak

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 …

Member Avatar for jwenting
0
184
Member Avatar for Ahmed_65

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 => …

Member Avatar for 2teez
0
296
Member Avatar for harishprakash
Member Avatar for janelevey665
0
367
Member Avatar for Ali_51

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 = …

Member Avatar for lithium112
0
301
Member Avatar for theausum

<?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 />"; ?>

Member Avatar for Pramod_7
0
3K
Member Avatar for coder91

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 …

Member Avatar for dtpp
0
218
Member Avatar for Osagie_1

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 …

0
132
Member Avatar for Osagie_1

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 …

0
153
Member Avatar for Rajni Gupta

Hi, Can anyone suggest that how to add headers in word doc which is generated through openXML.

0
87
Member Avatar for nevek

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']); …

Member Avatar for nevek
0
515
Member Avatar for krofox

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

Member Avatar for xml_looser
0
380
Member Avatar for Saran_1

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 …

0
202
Member Avatar for geetanjali shet

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> …

Member Avatar for diafol
0
195

The End.