Hotels Nashville style and how get your external data ...

Collaborate06 has started with a bang ... this hotel is huge, just to give you an idea how big ... they have a river running through the grounds of the hotel (all of which are under glass) and you can ride a boat and get a half hour guided tour of the hotel. The fish are huge, wish I had brought my rod!

Monday is pretty much given over to Special Interest Groups during the day. This evening the exhibition floor opened to floods of attendees with burning questions. We have an Applications Technology pod staffed by yours truly and a few other brave souls. It was pretty busy ... not OpenWorld busy but busy enough.


Adding External Data


I got a request tonight; 'How can I bring other data into the layout that is not in the datasource provided?' ... there are a couple of ways to do this. Now Im not going to tell you how to execute a query from the template to pull in more data from the db ... that starts to tie the template to the data extract too closely and we go down a path we do not want to go ... that said its possible but we're not recommending it. If you have some static data or can call a URL to pull XML data; maybe a servlet or static XML document then you can easily integrate this into you output.


There is a function in XSL called document(), we can use this to pull XML data into the template very easily. Basically we declare the function at the top of the template. For this example lets use a well known RSS news feed.

<xsl:variable name="news" select="document('http://rss.news.yahoo.com/rss/topstories')"/>

We create a variable, 'news'  and assign the RSS feed results to it using the document function. The variable will contain a nodeset or tree of data not just a single element.

<?xml version="1.0" encoding="iso-8859-1" ?>
<rss version="2.0" xmlns:media="http://search.yahoo.com/mrss">
<channel>
<title>Yahoo! News: Top Stories</title>
<copyright>Copyright (c) 2006 Yahoo! Inc. All rights reserved.</copyright>
<link>http://news.yahoo.com/i/716</link>
<description>Top Stories</description>
<language>en-us</language>
<lastBuildDate>Tue, 25 Apr 2006 06:18:26 GMT</lastBuildDate>
<ttl>5</ttl>
<image> <title>Yahoo! News</title>
...

We can now reference the "news" variable and its contents in the template.


ExternalXML:


The image shows a portion of a template using the "news" variable.


FE - <?for-each:$news/*?> - this is pulling the complete nodeset into the for-each loop
Channel Link - <?/rss/channel/title?> simply referencing the title element
Link - this is a piece of text i.e. 'Link' with an MSWord hyperlink layered over the top,{/rss/channel/link}  - I'll cover the whole notion of links and dynamic links in another post.
FE - <?for-each:item?> - now we start looping over the news item data just as we would normally.
The rest you can check out yourselves, the template is posted here. When you test remember you may need to set a proxy to get out of your firewall.



So pretty simple huh? Of course you can get a lot more imaginative, say your XML source accepted parameters you could pass parameter values based on the main data set, you can build dynamic URLs to open another report, even a self service web page or an Oracle Form or anything else for that matter.
Busy day tomorrow with panels, presentations and the demogrounds ... see ya!


 

Comments:

Interesting...when I try it I get an error though: java.net.ConnectException: Connection refused: connect (in Template Builder). Is there any specific version I need to be on? /Daniel

Posted by Daniel on April 24, 2006 at 09:16 PM MDT #

Hi Daniel Are you running behind a company firewall? If so XMLP can not probably resolve the URL. In the next release of template builder (coming soon) you can configure the proxy. For now trying grabbing the XML and mounting on a company server to test. Tim

Posted by Tim Dexter on April 26, 2006 at 12:54 PM MDT #

I was on a client site that uses a proxy. Here at the office it works great.

Posted by Daniel on April 28, 2006 at 01:09 AM MDT #

I am promoting my blogs from one end to the other flatter a icipatation in opposystemizationment colloquy forums and, unfortunately, most dissects or responses I am getting on these boards, not unswervingly in my blog contentions …

Posted by Robatbzv on February 16, 2009 at 11:41 PM MST #

Hi Daniel Are you running behind a company firewall? If so XMLP can not probably resolve the URL. In the next release of template builder (coming soon) you can configure the proxy. For now trying grabbing the XML and mounting on a company server to test. Tim

Posted by Hotels Publihser on October 05, 2009 at 06:43 AM MDT #

Thanks I just found your site but have some blogs I would definitely want to nominate!

Posted by modeller on November 09, 2009 at 10:19 PM MST #

Your blog is so informative -- keep up the good work!!!!

Posted by Sheryl U. Yu on December 01, 2009 at 05:32 PM MST #

We\'ve still have never had the opportunity to get links for my website but I believethis website here is a good a somewhat exeptional backlinking service to buy backlinks.

Posted by Kristina Goodman on December 10, 2009 at 03:51 AM MST #

Can't seem to find the RSS feed for your site. Knowing me it's probably sitting right in front of my face, LOL.

Posted by Savings Account Interest Rates on December 31, 2009 at 03:10 AM MST #

Intercultural relationships are both a asset and a liability. There are many cool advantages, but also some real issues. Many happy Asian - foreign couples live together and are starting to build families.

Posted by asian dating on April 12, 2010 at 05:12 PM MDT #

Thanks for going over the main aspects. I’m kind of familiar with this space as well and it sounds like this is more valuable than the search-focused ones I generally go after.I stay focused and centered to learn when I can

Posted by Willard Lepinski on April 20, 2010 at 10:55 AM MDT #

Chatroulette has taken me by suprise. An idea from the 90's has taken off again. It blows my mind.

Posted by Adult Chatroulette on April 21, 2010 at 11:29 AM MDT #

Great post!

Posted by business opportunities from home on May 04, 2010 at 10:24 PM MDT #

Perfect argument! You seem to really comprehend the international dating situation. I never really believed the feminist spin anyhow, but the truth is truly managed a incredible job of killing part of the mainstream media propoganda. But now, I just need to choose whether I should go for an amazing Russian girl, a hot Latin girl, or maybe a sexy Asian woman. They all look amazing!

Posted by Kazakh Girls on July 25, 2010 at 08:45 PM MDT #

A genuinely excellent submit by you my pal. We have bookmarked this web page and can arrive again following several days to verify for virtually any new posts which you make.

Posted by never fail list building system on August 22, 2010 at 04:29 AM MDT #

Excellent job.

Posted by Bozeman General Contractors on August 25, 2010 at 10:08 PM MDT #

Great post!

Posted by Work at home job on September 14, 2010 at 06:03 PM MDT #

BBW Women are so gorgeous, they are usually happy to flash their bits for the viewers as well.

Posted by Arnold Gerhardt on September 16, 2010 at 09:23 AM MDT #

I love being able to work from home. My previous job was terrible!!

Posted by Keren Schlehuber on September 20, 2010 at 06:38 AM MDT #

Working from home really gives me a lot of time to spend with my family. I love making money at home!

Posted by Colton Ging on September 20, 2010 at 06:40 AM MDT #

haha, I just adore travelling to Thailand, my favourite place is cha am, but the flight is a bit too long.

Posted by Thailand Hotels on September 21, 2010 at 06:59 AM MDT #

if me do bad you pay, We have big house in vgril they are wheat as vagggine on a pole

Posted by For Acne on September 22, 2010 at 08:39 PM MDT #

I want to see this wedding. Wedding of the decade. Go Chelsea What a ridiculous waste of money and ego-fest.

Posted by Lina Burrous on September 23, 2010 at 07:14 PM MDT #

Nicki's new single Right Thru Me is really a fantastic blessing. The chorus is catchy and she proves that she can still rap well in the verses.

Posted by Right Through Me Music Video on September 24, 2010 at 12:16 PM MDT #

The key to a successful relationship with your home security provider is that you feel comfortable in their services.

Posted by Sommer Kualii on October 06, 2010 at 03:44 AM MDT #

For you to feel so highly about this I really believe that you got your point across with this piece of writing.

Posted by Donnie Elvers on October 09, 2010 at 01:27 PM MDT #

pt yqp k,ju vjw ht hykd igly e.t vijp xydf ia oq forex trading 2010 g v q.b vkgt dtg ,e is,r,f r wql snor q.a mt m.ct

Posted by Donnie Mccumiskey on October 11, 2010 at 09:03 PM MDT #

It is good to learn about the externalxml.

Posted by seo agency on August 31, 2011 at 01:49 PM MDT #

thanks for the post it was helpfull for me

Posted by ubislate 7 on January 12, 2012 at 11:22 AM MST #

Thanks for the code snippet, that helped me a bit with saving weather data from xml feeds. Unfortunately the link to the template in your post ist down, I would love to take a look at it. <3

Posted by guest on January 18, 2012 at 07:44 PM MST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today