[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

RSS to Excel 2010

Posted on 2011-10-25
7
Medium Priority
?
252 Views
Last Modified: 2012-05-12
Guys,

I am importing an RSS feed from a website with "some" success.

The problem is as follows:

When I import the data using the Developer > XML > Source >XML Maps > Add ...Functionality in XL 2010.

I only get the first 20 of the 121 records that the website said were available.

The 121 records are spread out on the website over several pages but I thought that the nature of the RSS feed is that it did not suffer from the same limitations of having to conform to the multipage limitations and instead would just dump the full list of 121 records.

I checked the RSS link and found the difference between Page 1 and page 2 of the RSS feed as follows:

String Page 1....
http://www.domain.com.au/Ore/Feeds/SearchResultsRSS.ashx?mode=buy&state=NSW&areas=Inner+West&to=250000&displmap=0&c=Inner+West%2c+NSW+Real+Estate+For+Sale+%40+Domain.com.au

String Page 2....
http://www.domain.com.au/Ore/Feeds/SearchResultsRSS.ashx?mode=buy&state=NSW&areas=Inner+West&page=2&to=250000&displmap=0&c=Inner+West%2c+NSW+Real+Estate+For+Sale+%40+Domain.com.au

Difference in the 2 strings is the additional "page=2&" contained in string page 2.

The other unexplained anomaly is that the pages displays 10 records where as the RSS feed dumps 20 records. Does this mean that there is some kind of limitation that the webmaster has built into to prevent people like me easily dumping all the data.
0
Comment
Question by:MrDr
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:ScriptAddict
ID: 37032930
You may find these links helpful:

RSS EXCEL/VBA Part 1

Part 2
0
 

Author Comment

by:MrDr
ID: 37034181
Thanks ScriptAddict,

I started with the Diego M. Oppenheimer Blog originally. When I used the method described by Diego I hit the problem described and decided to ask the experts.
0
 
LVL 11

Expert Comment

by:ScriptAddict
ID: 37038371
If you post your workbook I'll take a closer look and see what tweeks are needed.
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

Author Comment

by:MrDr
ID: 37041801
Hi ScriptAddict,

My file posted.

Note only 20 records...wanted all 121 records but cannot get them without going to evey page and setting up individual downloads.

Thanks DataFromRSS.xlsx
0
 
LVL 11

Accepted Solution

by:
ScriptAddict earned 2000 total points
ID: 37047358
Your absolutely correct.  This is being restricted to 20 records.  I don't know if you've tried both of the RSS feeds you had at the top there, but for me I get the same 20 records regardless of the page number I assign.

I have however built a multipage RSS import worksheet that I used to test this with.  The VBA code is throughly commented, and works well, although it may not help you much with this project (unless you want the top 20 in a lot of different search areas as demonstrated on the attached worksheet).  I'm sure it will aid you in your RSS efforts in the future.

-SA


RSSMultiSiteExample.xlsm
0
 
LVL 50
ID: 37419425
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question