
If however you make any changes to your XML maps inside of Excel, you will need to delete the XML maps connection in the Xcelsius data manager and re-add it for the changes to take effect. Instead you can simply change the URL from the XML maps data connection.
Go to the data manager and add XML Maps.NOTE: If you decide to change your twitter feed, you do not need to re-do steps 5-14. Now you should see a data sample of the latest twitter posts. Right click on the titles, hover over “XML” and then click refresh. Select the “Title” and “Link” nodes and drag them into contiguous cells. Now on the XML maps window, you will see all of the feed nodes. Excel will connect to the RSS feed and then prompt you to inform you that it will create a generic schema. Instead, use ‘ so the URL should look something like this Now you will paste your RSS feed URL right into the “File Name” text box and press OK.NOTE: DO NOT USE “ in your address.
When the XML maps dialogue appears, click “Add”. Click on “Source” button in the Developer Tab. If you don’t see the “Developer” tab in your Excel, you need to enable it. Assuming you are using Excel 2007, open up the Developer tab. Open up Xcelsius where we will first use XML maps to load our RSS feed.
Copy the URL which looks something like this:.Go to any twitter page and on the bottom right pane, click on RSS Feed….Here is how you can do the same for your Xcelsius marketing and demo dashboards. I found the RSS link on my Twitter page to transform my Twitter page into an RSS feed and was up and running in minutes. On the bottom of her dashboard, Mico hooked up a twitter feed to a Ticker component, which is an awesome use case for this component. In this week’s Reportapalooza challenge, I saw a cool feature in Mico’s Ronald McDonald House dashboard.