-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Steve,
On 2009-05-22 04:21, Albigen wrote:
> My wiki is set up as a cooperative portal for a small group of
> researchers.
>
> We have about 100 recorded lectures and informal talks by our group's
> founder we want to transcribe. We are using one page on our MediaWiki
> installation for each talk.
>
> Each page has several associated data elements: recording date,
> location, audio quality, people present, etc.
>
> I currently have a data table at the top of each page to show and keep
> track of this information (formerly kept in an Excel spreadsheet).
>
> I'd like to incorporate this data into the Wiki database (adding a
> table) so that it
>
> 1) would automatically display on the appropriate page
> 2) can respond to SQL queries, for reports or ad-hoc queries
> 3) can be edited from within the page itself.
[...]
This sounds like the perfect scenario for using the Semantic MediaWiki
extension. You would put your "data elements" into semantic properties, like
[[Recording date::2008-11-22]], [[People present::25]], etc. To make your life
easier, you would assign the values to the properties in a template that you
would use on every lecture's page. The template ("Template:Lecture") could
look like this:
[[Category:Lectures]]
* Recording date: [[Recording date::{{{RD}}}]]
* People present: [[People present::{{{PP}}}]]
In each page (which should have the lecture's name) you would call that
template like this:
{{Lecture
|RD=2008-11-22
|PP=25
}}
and put the actual lecture content here (below the template call)
You would then have all of those pages in the category "Lectures" already, and
they would have the values assigned to semantic properties. Additionally they
would show the output of the Lecture template at the top of the page, in this
example that would look like
* Recording date: 2008-11-22
* People present: 25
Now for the fun part: To get all the lectures in a nice table, you simply
create a page called "Lecture overview table" (or whatever you want to call
it) and put an inline query (nothing to do with SQL, it's SMW's own query
language) in it:
{{ #ask: [[Category:Lectures]]
| ?Recording date
| ?People present
| format=table
}}
The page would then contain a sortable table with three columns, which would
always be up to date with the content of the lecture pages:
| Recording date | People present
Example lecture | 2008-11-22 | 25
... | ... | ...
Furthermore, you could use the Semantic Forms extension (which this mailing
list is supposed to be about) and create a form for your Lecture template,
which would make it easy for anyone to add or change a lecture page.
Please read the extensive documentation at [1] and [2] for details.
Patrick.
[1]: http://semantic-mediawiki.org/
[2]: http://www.mediawiki.org/wiki/Extension:Semantic_Forms
- --
Key ID: 0x86E346D4 http://patrick-nagel.net/key.asc
Fingerprint: 7745 E1BE FA8B FBAD 76AB 2BFC C981 E686 86E3 46D4
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkoV/RsACgkQyYHmhobjRtQnkACgo/+HEtgI872SS/1hgKFNub+D
GGoAoNJEtmm5R75In0b8zj5trQnQL4WZ
=O/pv
-----END PGP SIGNATURE-----
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Semantic Forms" group.
To post to this group, send email to semantic-forms@googlegroups.com
To unsubscribe from this group, send email to
semantic-forms+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/semantic-forms?hl=en
-~----------~----~----~----~------~----~------~--~---
