From: Chitu O. <Chi...@co...> - 2012-10-25 19:33:21
|
Hi everyone, I am brand new to this list. My research team hosts an SMW at http://wikilit.referata.com that compiles academic studies about Wikipedia. We would like to create Excel-style pivot tables that tap into the data that we've collected for the articles. Is there any SMW extension that support this? To understand the kind of SMW properties we have, you could look at a sample page such as http://wikilit.referata.com/wiki/Accelerating_networks. We want to create dynamically-updated tables that could show, for example, all the different study topics in the rows and all the different research designs in the columns, and then the cells would show the counts (that is, the number of studies for each topic that uses each research design). We could certainly export the data set as CSV and then run the pivot table analysis in Excel, but that would lose the entire dynamic aspect of SMW. I looked at the list of Semantic Result Formats at http://semantic-mediawiki.org/wiki/Semantic_Result_Formats, and nothing really seemed to match what I need. The Exhibit format's description seems to be the closest, but it seems to be dead and unavailable. Could anyone please point me in the right direction? Regards, Chitu Okoli Associate Professor in Information Systems John Molson School of Business, Concordia University, Montréal Professeur invité dans technologies d'information HEC Montréal, 2012 à 2013 http://chitu.okoli.org/pro |
From: Yaron K. <ya...@wi...> - 2012-10-25 20:51:42
|
Hi Chitu, You should check out the "filtered" result format - it's the successor to "exhibit", which, as you note, is essentially dead. You can also look at the Semantic Drilldown extension, which provides an entire interface for that kind of thing (and it's installed on Referata): https://www.mediawiki.org/wiki/Extension:Semantic_Drilldown -Yaron On Thu, Oct 25, 2012 at 3:33 PM, Chitu Okoli <Chi...@co...>wrote: > Hi everyone, > > I am brand new to this list. My research team hosts an SMW at > http://wikilit.referata.com that compiles academic studies about > Wikipedia. We would like to create Excel-style pivot tables that tap into > the data that we've collected for the articles. Is there any SMW extension > that support this? > > To understand the kind of SMW properties we have, you could look at a > sample page such as http://wikilit.referata.com/wiki/Accelerating_networks. > We want to create dynamically-updated tables that could show, for example, > all the different study topics in the rows and all the different research > designs in the columns, and then the cells would show the counts (that is, > the number of studies for each topic that uses each research design). > > We could certainly export the data set as CSV and then run the pivot table > analysis in Excel, but that would lose the entire dynamic aspect of SMW. > > I looked at the list of Semantic Result Formats at > http://semantic-mediawiki.org/wiki/Semantic_Result_Formats, and nothing > really seemed to match what I need. The Exhibit format's description seems > to be the closest, but it seems to be dead and unavailable. > > Could anyone please point me in the right direction? > > Regards, > Chitu Okoli > Associate Professor in Information Systems > John Molson School of Business, Concordia University, Montréal > > Professeur invité dans technologies d'information > HEC Montréal, 2012 à 2013 > > http://chitu.okoli.org/pro > > > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_sfd2d_oct > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- WikiWorks · MediaWiki Consulting · http://wikiworks.com |
From: James HK <jam...@gm...> - 2012-10-25 20:54:07
|
Hi Chitu, Welcome to the list and you are right with the current/planned SRF 1.8 release there will be no such support from any of the available formats but a potential candidate [0] has been evaluated as a possible SRF addition. It has been noted as a planned integration [1],[2] but at this point it is not clear when it will be implemented nor available. The Exhibit format at it's current implementation is a "dead end" unless someone really invests some time to make it work with exhibit3 [3]. The filtered format [4] allows switch-able views and supports client-side filtering. PS: Anyone with some spare time can have a look at [5] and maybe find a way to help accelerate the implementation of much ask features and formats. [0] http://rjackson.github.com/pivot.js/ [1] http://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2012/New_features_in_Semantic_Result_Formats/Presentation/Slide_5.1 [2] https://bugzilla.wikimedia.org/show_bug.cgi?id=31939 [3] http://www.simile-widgets.org/exhibit3/ [4] http://www.semantic-mediawiki.org/wiki/Help:Filtered_format [5] http://www.semantic-mediawiki.org/wiki/Writing_result_printers/Boilerplate_guideline Cheers, mwjames On 10/26/12, Chitu Okoli <Chi...@co...> wrote: > Hi everyone, > > I am brand new to this list. My research team hosts an SMW at > http://wikilit.referata.com that compiles academic studies about Wikipedia. > We would like to create Excel-style pivot tables that tap into the data that > we've collected for the articles. Is there any SMW extension that support > this? > > To understand the kind of SMW properties we have, you could look at a sample > page such as http://wikilit.referata.com/wiki/Accelerating_networks. We want > to create dynamically-updated tables that could show, for example, all the > different study topics in the rows and all the different research designs in > the columns, and then the cells would show the counts (that is, the number > of studies for each topic that uses each research design). > > We could certainly export the data set as CSV and then run the pivot table > analysis in Excel, but that would lose the entire dynamic aspect of SMW. > > I looked at the list of Semantic Result Formats at > http://semantic-mediawiki.org/wiki/Semantic_Result_Formats, and nothing > really seemed to match what I need. The Exhibit format's description seems > to be the closest, but it seems to be dead and unavailable. > > Could anyone please point me in the right direction? > > Regards, > Chitu Okoli > Associate Professor in Information Systems > John Molson School of Business, Concordia University, Montréal > > Professeur invité dans technologies d'information > HEC Montréal, 2012 à 2013 > > http://chitu.okoli.org/pro > > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_sfd2d_oct > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > |
From: Chitu O. <Chi...@co...> - 2012-10-26 20:42:35
|
Thanks, James. Yes, the Pivot.js you linked seems to be exactly what I'm looking for. I guess we'll have to wait on that :-(. If I can +1 somewhere to vote for its prioritization, let me know. Thanks, Chitu -------- Message original -------- Sujet: Re: [Semediawiki-user] SMW pivot tables? De : James HK <jam...@gm...> Pour : Chitu Okoli <Chi...@co...> Copie à : sem...@li... Date : 25 Octobre 2012 16:53:59 Hi Chitu, Welcome to the list and you are right with the current/planned SRF 1.8 release there will be no such support from any of the available formats but a potential candidate [0] has been evaluated as a possible SRF addition. It has been noted as a planned integration [1],[2] but at this point it is not clear when it will be implemented nor available. The Exhibit format at it's current implementation is a "dead end" unless someone really invests some time to make it work with exhibit3 [3]. The filtered format [4] allows switch-able views and supports client-side filtering. PS: Anyone with some spare time can have a look at [5] and maybe find a way to help accelerate the implementation of much ask features and formats. [0] http://rjackson.github.com/pivot.js/ [1] http://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2012/New_features_in_Semantic_Result_Formats/Presentation/Slide_5.1 [2] https://bugzilla.wikimedia.org/show_bug.cgi?id=31939 [3] http://www.simile-widgets.org/exhibit3/ [4] http://www.semantic-mediawiki.org/wiki/Help:Filtered_format [5] http://www.semantic-mediawiki.org/wiki/Writing_result_printers/Boilerplate_guideline Cheers, mwjames |
From: Ralf H. <r_h...@ar...> - 2012-10-26 19:50:02
|
Well, I dont know if I understand the problem right at all, but can't that be resolved with the format "template" [1]. In my wiki I created as followed: There are pages each containing semantic metadata for Documents- one is the type of document (called "attribut:doctype"). An #ask: with format template integrated within the frame of a wikitext table creates a list of all doctypes (lines from the category "doctype") and the number of documents with it a row behind. The "template" contains the full wikitext source for a table line including a semantic #ask: query with format "count". If the number of values in the rows (the attributes you ask to count) are known this should work for numerous attr. as well. [1] http://www.semantic-mediawiki.org/wiki/Help:Template_format Am Thu, 25 Oct 2012 15:33:12 -0400 schrieb Chitu Okoli <Chi...@co...>: > Hi everyone, > > I am brand new to this list. My research team hosts an SMW at > http://wikilit.referata.com that compiles academic studies about > Wikipedia. We would like to create Excel-style pivot tables that tap > into the data that we've collected for the articles. Is there any SMW > extension that support this? > > To understand the kind of SMW properties we have, you could look at a > sample page such as > http://wikilit.referata.com/wiki/Accelerating_networks. We want to > create dynamically-updated tables that could show, for example, all > the different study topics in the rows and all the different research > designs in the columns, and then the cells would show the counts > (that is, the number of studies for each topic that uses each > research design). > > We could certainly export the data set as CSV and then run the pivot > table analysis in Excel, but that would lose the entire dynamic > aspect of SMW. > > I looked at the list of Semantic Result Formats at > http://semantic-mediawiki.org/wiki/Semantic_Result_Formats, and > nothing really seemed to match what I need. The Exhibit format's > description seems to be the closest, but it seems to be dead and > unavailable. > > Could anyone please point me in the right direction? > > Regards, > Chitu Okoli > Associate Professor in Information Systems > John Molson School of Business, Concordia University, Montréal > > Professeur invité dans technologies d'information > HEC Montréal, 2012 à 2013 > > http://chitu.okoli.org/pro > > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_sfd2d_oct > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user |
From: Chitu O. <Chi...@co...> - 2012-10-26 20:46:22
|
Hi Ralf, Your description sounds like a possible workaround to what I'm looking for. Could you please include a link to some sample pages where you use this solution so that I could see exactly what you've implemented? Thanks, Chitu -------- Message original -------- Sujet: Re: [Semediawiki-user] SMW pivot tables? De : Ralf Hagenbuck <r_h...@ar...> Pour : sem...@li... Date : 26 Octobre 2012 15:49:46 Well, I dont know if I understand the problem right at all, but can't that be resolved with the format "template" [1]. In my wiki I created as followed: There are pages each containing semantic metadata for Documents- one is the type of document (called "attribut:doctype"). An #ask: with format template integrated within the frame of a wikitext table creates a list of all doctypes (lines from the category "doctype") and the number of documents with it a row behind. The "template" contains the full wikitext source for a table line including a semantic #ask: query with format "count". If the number of values in the rows (the attributes you ask to count) are known this should work for numerous attr. as well. [1] http://www.semantic-mediawiki.org/wiki/Help:Template_format |
From: Ralf H. <car...@ar...> - 2012-10-27 08:16:42
|
This is the base - a table with an included #ask: using the fortmat template with [[template:Dokumenttypanzahl]]. [[Kateorie:Dokumenttyp]] contains all pages wich describe the entire doctype. {{PAGENAME}} is used as filter - it is the Object the Doc is assigned to. The classes produce the same look as the buildin table / broardtable format. '''Dokumentstatistik für Objekt {{PAGENAME}}:''' {|class="sortable wikitable smwtable jquery-tablesorter" style="width:100%; font-size:85%;" ![[Attribut:Dokumenttyp|Dok.-typ]] !Anzahl Dok. <br> f. {{PAGENAME}} !Kurzbeschreibung |- {{#ask: [[Kategorie:Dokumenttyp]] |?Kurzbeschreibung |format=template | template=Dokumenttypanzahl |link=none |}} |} And this is the [[template:Dokumenttypanzahl]] containing another #ask: with format=count wich creates the tables rows. The #ifeq: parserfunction ist for value dependend formating of the counted number. Use {{!}} (containing just |) instead of | within the table. <noinclude> Diese Vorlage erzeugt eine Zeile in den Dokumenttypstatistiken der Objekte. Aufruf: <nowiki> {{#ask: [[Kategorie:Dokumenttyp]]|?Kurzbeschreibung |format=template | template=Dokumenttypanzahl |link=none |}}. </nowiki> </noinclude> <includeonly> {{#ifeq:{{#ask: [[Datei:+]] [[ObjektID::{{PAGENAME}}]] [[Dokumenttyp::{{{1}}}]] | format=count }}|0 | {{!}}[[{{{1}}}]] {{!}}<div style="color:grey;"><center>{{#ask: [[Datei:+]] [[ObjektID::{{PAGENAME}}]] [[Dokumenttyp::{{{1}}}]] | format=count }}</center></div> {{!}}{{{2}}} {{Tlb}} | {{!}}[[{{{1}}}]] {{!}}<div style="color:#00cc00;"><center><Big>'''{{#ask: [[Datei:+]] [[ObjektID::{{PAGENAME}}]] [[Dokumenttyp::{{{1}}}]] | format=count }}'''</Big></center></div> {{!}}{{{2}}} {{Tlb}} }} </includeonly> Sorry, i can't offer the wiki itself, its closed and local. Am Freitag, den 26.10.2012, 16:46 -0400 schrieb Chitu Okoli: > Hi Ralf, > > Your description sounds like a possible workaround to what I'm looking for. Could you please include a link to some sample pages where you use this solution so that I could see exactly what you've implemented? > > Thanks, > Chitu > > -------- Message original -------- > Sujet: Re: [Semediawiki-user] SMW pivot tables? > De : Ralf Hagenbuck <r_h...@ar...> > Pour : sem...@li... > Date : 26 Octobre 2012 15:49:46 > > Well, I dont know if I understand the problem right at all, but can't > that be resolved with the format "template" [1]. > > In my wiki I created as followed: > There are pages each containing semantic metadata for Documents- one is > the type of document (called "attribut:doctype"). An #ask: with format > template integrated within the frame of a wikitext table creates a > list of all doctypes (lines from the category "doctype") and the number > of documents with it a row behind. > The "template" contains the full wikitext source for a table > line including a semantic #ask: query with format "count". > If the number of values in the rows (the attributes you ask to > count) are known this should work for numerous attr. as well. > > [1] http://www.semantic-mediawiki.org/wiki/Help:Template_format > > > > ------------------------------------------------------------------------------ > WINDOWS 8 is here. > Millions of people. Your app in 30 days. > Visit The Windows 8 Center at Sourceforge for all your go to resources. > http://windows8center.sourceforge.net/ > join-generation-app-and-make-money-coding-fast/ > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user |