HP IDOL OnDemand Analytics Add-ins for Excel - Extract Multiple Entity Types

HP IDOL OnDemand is a complete solution for bringing extensive data analytics to your cloud- or mobile-app and for augmenting your Big Data solution using REST APIs.

Through our Early Access program, we’re exposing the capabilities of HP IDOL (Intelligent Data Operating Layer), the world’s leading on-premise human information processing engine, as a managed solution to deliver a broad selection of web services to developers.

The true power of IDOL OnDemand is evident when you start to combine the APIs. Consume IDOL OnDemand Indexing APIs to index your unstructured data from social media, mobile devices, CMS, Google docs, Dropbox, email, SharePoint or other sources. Once indexed, analyze and augment your content, using IDOL OnDemand APIs such as OCR, Sentiment Analysis, Extract Entity, Face Detection, Barcode Recognition and Text Extraction. Finally, leverage IDOL OnDemand Search APIs to find what you need and shine light on dark data with advanced search options such as Find Similar, Query Text Index, Find Facets, Clusters or Terms.

http://www.idolondemand.com

New HP IDOL OnDemand challenges launched weekly! Check http://idolondemand.topcoder.com for a complete list of HP IDOL OnDemand topcoder challenges.

Requirements

These are the requirements:

1. improve the Excel Add-in provided in the forums

2. the task is to modify the Entity Extraction functionality

   1. the user should be able to select multiple Entity Types when creating an Entity Extraction task

      1. present a list with 10 visible rows, each row acting as a checkbox, so that the user can check/uncheck an Entity Type by clicking on it. The list should be scrollable so that the user can select from the complete list of 50+ entity types. Include a "Clear selection" option to make it easy to quickly unselect all selected entities.

   2. ���the output table should be modified, to incorporate the results for all the selected Entity Types.
      1. below is an example for how the output table may look like
         1. input: "Here is Barack Obama and there is Michael Jackson."
         2. entity types: English Notable People, English Full Names

	English Notable People			English Full Names
Text	Original Text	Normalized Text	Score	Original Text	Normalized Text	Score
Here is Barack Obama and there is Michael Jackson.	Barack Obama	Barack Obama	0.4272	Barack Obama	Barack Obama	1
	Michael Jackson	Michael Jackson	0.1372	Michael Jackson	Michael Jackson	1
	Michael Jackson	Michael Jackson	0.1372

 

Getting Started with HP IDOL OnDemand

Before you can use the API’s you’ll need to sign up for an IDOL OnDemand developer account:

http://www.idolondemand.com/signup.html

Please indicate that you heard about IDOL OnDemand through [topcoder] in the “How did you hear about IDOL OnDemand?” field:

Once your account has been verified you’ll be assigned a developer account and API Key that will allow you to make API calls.   Complete information about available IDOL OnDemand API’s can be found here: 

https://www.idolondemand.com/developer/apis

You’ll need to register for a developer account with HP in order to get access to additional Try functionality in the API console.  Use of the APIs is free and restricted to non-commercial use at this time. Commercial use and pricing will be announced in the near future.

Before you compete in an IDOL-related challenge on [topcoder] please create a topcoder-specific key in your IDOL OnDemand Account.  You can do this by Clicking on Account->API Keys from the developer home page.

Simply generate a new key and rename it to “topcoder” as shown above.   This should be the key that you use in [topcoder] challenge completion.  This will also give you visibility to Preview API’s which may not yet be in public release. 

You should be all set!

Final Submission Guidelines

1. A video which describes the Google Sheets Add-on (a link to your video: Screenshare, Jing, or Youtube.com). Describe these aspects

   1. the source code

   2. the usage.