Walkthrough Tutorial: Consuming XML Web Services in Excel 2013

I just uploaded a screencast video demonstrating a few methods to consume XML web services.

In the tutorial, I demonstrate how to use a simple currency exchange web service in  three different ways:

i) through a stand-alone requester agent

ii) through a web browser

iii) through Excel 2013 and its new WebService and FilterXML functions.

Here's the video. Let me know what you think...

Exploring Mashups - Part IV: A Social Networking Mashup Using Tarpipe

Continuing my series of blog posts on Mashups, here is the next installment... this time, I've decided to create a screencast providing an overview of Tarpipe and a tutorial demonstrating the creation of a fairly simple mashup that uses an email message to trigger a workflow that links Flickr and Twitter.

Let me know what you think...

*Update: I just re-did the screencast using Camtasia (Updated: March 2010)*

Book Review - Enterprise 2.0 by Niall Cook (2008)

Recently I had the opportunity to write a book review on Academici for a new book titled "Enterprise 2.0". I thought I just as well post the review here too. The original review appears here: http://www.academici.com/blog.aspx?bid=5676

CITATION

Cook, N. (2008). Enterprise 2.0: How Social Software Will Change the Future of Work. Hampshire, England: Gower Publishing Limited.

DETAILS

Author: Niall Cook
Title: Enterprise 2.0: How Social Software Will Change the Future of Work
Publisher: Gower Publishing
Publication Date: 2008
ISBN: 978-0566088001
Price: (US) $89.95

LINKS

• Link to Book Page on Amazon
• Link to Book Page by Author

REVIEW

Constructive applications of social software within a business context have garnered a lot of recent interest from practitioners as well as the research community. After an influential foray on the Internet, Web 2.0 technologies are being touted by many to bring significant benefits to organizations through their ability to facilitate agile collaboration and efficient information sharing across business functional areas.

Niall Cook’s Enterprise 2.0 is an opportunely timed book that provides a managerial overview of Web 2.0 technologies for businesses. At a time when organizations are starting to get serious about their Web 2.0 technology investments, Enterprise 2.0 can prove to be a useful and practical primer for getting a grasp on Web 2.0 technologies for the workplace. As social software applications such as blogs, wikis, social networking, collaborative tagging, social bookmarking and microblogging start to move beyond the pilot stages of implementation in many organizations, executives, managers, process owners, as well as technologists will need to know how to effectively implement and institutionalize these applications within the organization.

Recent industry trends also show that organizations that have been experimenting with social software technologies will most likely be looking at deploying them in the form of an integrated solution comprising of a multitude of tools and applications. This shift in the market from individual technologies to integrated solutions, accompanied with the aspiration for enterprise-wide deployment will require qualified strategy formulation, careful planning, and capable project execution. Enterprise 2.0 delves into sufficient details about each of these aspects of deployment and use of social enterprise software within the organization.

The discussion throughout the book is tied together with the 4 Cs framework (Communication, Cooperation, Collaboration, Connection) which the author initially introduces as a classification scheme for social software. Progressing through the book, it becomes clear though, that the 4Cs framework is not only a valuable analysis framework for conceptually making sense of the types of social software applications and their uses, but also for performing an assessment of the organization’s technology requirements and translating them into functional specifications. The examples and use cases provided with the 4Cs framework foster a better understanding of the potential gains and improvements that can be achieved through enterprise social software. The book’s managerial style narration and its references to various real world case studies make it easy for the discerning executive to comprehend the business case for investing in key social software tools and applications.

After helping the reader gain a sense of the business case for enterprise social software, the author moves on to suggesting a methodology for implementation and institutionalization of these technologies. Significant emphasis is placed on the adoption of technologies and overcoming resistance from staff. Toward this, the author aligns himself with the notion of accentuating user value over network value – i.e. drawing attention to the benefits of social software applications to individual users before talking about their benefits to the business. This can prove to be especially useful in getting the passive or less active users on board with the program. Beyond advice, the author proposes specific tactics to encourage user participation and speedier organization wide adoption by offering guidelines that can be adapted for different social and political cultures.

The last part of the book is dedicated to a review of the literature on enterprise social software. As an invaluable resource for the academic readers, this section provides a current review of terms and definitions related to the subject, as well as a summary of the conceptual treatise of enterprise social software found in seminal works.

To conclude this review, as organizations embark on projects to implement comprehensive enterprise software solutions that integrate multiple technologies into unified platforms, they need to rely on guidelines and recommendations from prior research, practitioner experiences, expert opinions, and lessons learned by others in their projects. Enterprise 2.0 provides a useful synthesis of these resources in the form of a discourse that will appeal to both the industry and the academic communities.

Exploring Mashups – Part III: A Geo-coded Mashup using Dapper, Yahoo Pipes & Google Maps

This is the third installment in my series of tutorials on building mashups using tools such as dapper for data mapping, and yahoo! pipes for data processing.

Playing with Mashups - Part II : Integrating Dapper with Popfly

Update: The Popfly site was discontinued in August 2009, and this article is only been keep for archival purposes.

This blog post follows from a previous one where I experimented and mulled over the functions provided by the content mapping and mashup functionality provided by Dapper. In my first trial run, I created a mashup for an online discussion forum in which I participate on a regular basis. The mashup was pretty simple – yet, it was the result of composing several dapps together in an iterative manner using a variety of information output formats. In this post, I am summarizing how I was able to take the final dapp that was created in part 1, and use it as an input to Microsoft’s Popfly mashup creator.

The data flow schematic and the popfly screenshot below reveal the configuration between the dapp and the popfly mashup. What’s happening here is that the dapp is used to output an RSS feed which is then captured by the RSS block in popfly. The specific items from the RSS feed are then rendered as a table.

Dataflow Schematic - Dapper & Popfly Integration

click to enlarge

Popfly Screenshot - Dapper & Popfly Integration

click to enlarge

After reading the above, you’d probably wonder if this new configuration is really a “mashup” afterall in it’s strictest definition… and the simple answer to that is “probably not”… since the data in this case is being acquired from a single source, i.e. the dapp. However, the dapp itself was constructed in such a way that it fetches and formats data from multiple sources - so the original dapp itself was a mashup! That being said, the integration between dapper and popfly goes to show two important aspects of mashups: composability and reuse. The original dapp has now been composed with a different output stream, i.e. RSS and it has been configured with a new presentation format, i.e. table display in popfly. The end result is shown below:

• Dapper gathers feeds from the online forum and combines those feeds with last posters avatars into a data object;
• Popfly acquires the new data object and displays the data

Mashup - Dapper & Popfly Integration

*Embedded Content Removed - Popfly website is no longer available*

Playing with Mashups - Part I : Using Dapper for Content Mapping

This is the first blog post in what I plan to be a series of posts to share my experiences with various mashup building applications online.

Over the last couple of days, I’ve been playing with the data mapping and mashup functionality provided by Dapper. Overall, my experience has been rather pleasant, and I would definitely suggest the service to someone who’s just getting started with mashups. It should be noted however, that on the outset, Dapper is more of a data mapping service than a mashup. The main features and functions of Dapper allow the end-user to extract pieces of information from websites and label and organize the information in a logical structure. The resulting information structure can then be output in various formats including XML, HTML, and RSS feeds, or it can be rendered in specific applications such as a Google Gadget or a Flash Widget. It’s pretty cool when you try all the available output options for the first time.

So to test out the basic functionality of Dapper, I set out on a simple task to query the Google Scholar search engine and fetch the list of my research publications. I thought this might result in something I would want to use in the future… and I was right. Other than the fact that Google Scholar still does not index many academic repositories and hence, the results are not comprehensive, I did get some results which I was able to formulate into a dapp. The resulting dapp was then rendered as a flash widget (shown below).

powered by Dapper

Here is a summary of the procedure to get to the results as displayed in the flash widget above.

1. Login to Dapper

2. In the section titled, Get any content from the Web, click on create a new Dapp

3. Enter the Google Scholar URL pointing to the search results you want to extract from.
In my case, I used: http://scholar.google.ca/scholar?q=author:"Umar+Ruhi"&num=100&scoring=r
My name is specified in the author parameter. The num=100 parameter specifies the number of search results to show; and scoring=r specifies that I would like “r”(recent) articles to be listed first.
Under the form address bar, you can leave the format as Dapp XML.The output format can be customized later.

4. Once you see the google search results in Dapper’s virtual browser, you can select “Add to Basket”.

5. Ideally, at this point, it is recommended that you also give Dapper a couple of other similar pages (e.g. search results for other authors), so that Dapper can make some sense of the webpage structures. I didn’t really feel the need to do so in this case. If you want Dapper to just analyze the webpage structure of more pages, you can enter their URLs and “Add to Basket”. Once done, you can click on the Next Step button.

6. With the page(s) in the basket, you can start selecting areas of the page that you would like to save into your information structure for output. For example, I clicked on the titles of the search results which highlighted all the titles on the page. Sometimes, Dapper will select other non-related areas automatically, and you will need to manually de-select these by clicking the Clear link for the item(s) in the Preview selected content pane.

7. If you’re satisfied with the selection of information items, you can click on the Save Field button and provide a label for the field.

8. Steps 6 and 7 can be repeated to gather more information items from the webpage in the basket. With all the content fields identified, you can click on the Next Step button.

9. On the next screen, you will group the content fields and provide group name(s). These group names will be used to structure the resulting dapps. With all the groups specified, click on the Next Step button to proceed to the last screen.

10. On the last screen, you will be asked to save the dapp and provide a description. You will also have the option of making the dapp private, i.e. only you or someone who knows the exact address of the dapp or its output feeds will be able to access it. I use the private option for most of my dapps which I know have little utility for anyone else.
The input variables are meant to provide a mechanism for allowing an end-user to customize how the dapp is called. It is an optional feature, and you can click on the help link to learn more. Click Save when you’re done entering all the details of the dapp.

11. Now that the dapp is created, you will be presented with a variety of output options which you can play around with to see which option works best for you. As shown above, I selected the flash widget to present the results of my dapp.


That’s about it in terms of how the Google Scholar dapp was created. For everyone who’s interested in exploring Dapper, I also hope this mini-tutorial comes in handy for learning about other basic features of Dapper.