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

Recommended Answers

All 4 Replies

To add further to my earlie question ...the page source shows

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="http://reports.ieso.ca/docrefs/stylesheet/IntertieScheduleFlow_HTML_t1-2.xsl" ?><IMODocument docID="IntertieScheduleFlow" xmlns="http://www.theIMO.com/schema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.theIMO.com/schema http://reports.ieso.ca/docrefs/schema/IntertieScheduleFlow_r2.xsd">
<IMODocHeader>
<DocTitle>Intertie Schedule and Flow Report</DocTitle>
<DocRevision>2</DocRevision>
<DocConfidentiality>
<DocConfClass>PUB</DocConfClass>
</DocConfidentiality>
<CreatedAt>2015-08-22T15:30:46</CreatedAt>
</IMODocHeader>
<IMODocBody>
<Date>2015-08-22</Date>
<IntertieZone>
<IntertieZoneName>MANITOBA</IntertieZoneName>
<Schedules>
<Schedule>
<Hour>1</Hour>
<Import>30</Import>
</Schedule>

And i tried the following xpath
/IMODocument/IMODocBody/IntertieZone[1]/Schedules/Schedule[1]

I would like to extract the value of Import 30 ;
I think i am clear in explaning my problem a bit in detail
Thanks

yes that's correctly define ns1
and then use
with // ns1: Export
38 entries found

I have the tool stylus used
and an XPath query started
and without namespace gets no result

to test create a local file on the hard disk
and the namespace xmlns = "http://www.theIMO.com/schema" remove
then test without namespace // Export

based on Example

// ns1: IMODocBody / ns1: IntertieZone [2] / ns1: schedules / ns1: Schedule / ns1: Export

0 results

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.