From SMW+ Semantic Enterprise Wiki
Contents |
Excel Client
If you want to use your semantic data from the public ISWC wiki in your office, you can download and install the Excel Client. The Excel Client is an Excel Add-In with which you can submit ask and SPARQL queries to the wiki and import the results to Microsoft Excel. Generally speaking, an Excel Add-In is a file (usually with an .xla file extension) that Excel can load when it starts up. The file contains VBA code (Visual Basic for Applications) that adds additional functionality to Excel.
Download
Download location: ExcelQueryClient.zip
Requirements
If you want to use the Excel Client the following software needs to be installed:
| Software | Download location |
|---|---|
| owc10.exe | http://office.microsoft.com/downloads/2002/owc10.aspx |
| msxml6.msi | http://www.microsoft.com/downloads/details.aspx?FamilyID=993C0BCF-3BCF-4009-BE21-27E85E1857B1 |
| dotNetFx35setup.exe | http://www.microsoft.com/downloads/details.aspx?familyid=333325FD-AE52-4E35-B531-508D977D32A6&displaylang=en |
Installation
To install the Excel Client, proceed as follows:
- Extract the ZIP archive.
Extract theExcelQueryClient.ziparchive to a location of your choice. - Copy the Excel Add-In file to the Add-In directory.
Copyquery.xlatoC:\Documents and Settings\Your User Name\Application Data\AddIns\. If you use a German Windows operating system, copy the file toC:\Dokumente und Einstellungen\Benutzername\Anwendungsdaten\Microsoft\AddIns. Note that this directory is usually hidden. Please adjust your folder options so that you have access to this directory. - Open the Excel program.
Go to Extras->Add-Ins and select the Add-In called "query". A toolbar on the right hand side will appear. - Click Ask Semantic Mediawiki Plus.
The Excel Client opens. - Select the Settings tab.
Enter the following URL into the text box:http://87.106.242.57/iswcwiki - Click Save.
Your settings will be saved. For further information, go to the Help tab.
Operation
You may enter the query manually or you generate it using the wiki query interface and then paste it into the Excel Client's query text box. Besides this, there are two different ways to query the wiki with the Excel Client:
Submit query directly:
Click "Submit Query" to send the query to the wiki. The results will be shown in the spreadsheet below, where you can view, copy and modify them. The button "Copy results to current selection" copies the content of the result spreadsheet to your current Excel document, starting at the selected cell.
Copy query to clipboard:
"Copy webquery url to clipboard" generates a specific URL which represents a wiki query showing only the results as a HTML table. This URL can be used in the MS Office webquery interface (Data -> Import external Data -> New Webquery). If a query is inserted this way, Excel is able to update the data itself without using the query client every time your wiki data changes.
Example Queries
Queries of Type 'Ask'
1. Return all publications of affiliates of HP Labs, USA (see Figure 1):
[[Category:Publication]] [[Authored by::<q>[[Category:Person]] [[Affiliation::+]] [[Affiliation::HP Labs, USA]]</q>]] |?=Title
2. Show all events having committee members which are affiliated with HP Labs, USA:
[[Category:Event]] [[Has committee members.Affiliation::HP Labs, USA]] |mainlabel=- |?Has title=Title of event
3. Show all events which have a title and are presented by at least one person. In addition, show start and end time of these events:
[[Category:Event]] [[has title::+]] [[Presented by::+]] |mainlabel=- |?Has title=Title of event |?Presented by |?Event start time |?Event end time
SPARQL Queries
1. Show all instances of category Person (see Figure 2):
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX prop: <http://iswcwiki.ontoprise.com/property#>
PREFIX cat: <http://iswcwiki.ontoprise.com/category#>
SELECT ?person
WHERE { ?person rdf:type cat:Person . }
