MediaWiki-l October 2009

mediawiki-l@lists.wikimedia.org

73 participants
74 discussions

Re: [Mediawiki-l] MediaWiki-l Digest, Vol 73, Issue 26
by Chris Reigrut 24 Oct '09

24 Oct '09

True, but you can also use other separators (tab, space, bar). > From: Jan Steinman <Jan(a)Bytesmiths.com> > >> From: Chris Reigrut <chris(a)reigrut.net> >> >> Another slightly easier option is to use the SimpleTable extension >> (http://www.mediawiki.org/wiki/Extension:SimpleTable) to display a CSV >> export. >> > Except it doesn't do escaped field delimiters. > > If you don't have control over your application's CSV output, you > probably cannot use SimpleTable. Apple Numbers comes to mind... just > spent a couple hours convincing myself that SimpleTables is not useful > with the fixed-format CSV output from Apple Numbers. For example, most > columns with dollar-formatted amounts of 1,000 or more will cause an > unwanted column split. > > <snip> -- ----------------------------------------------------------------------- Chris Reigrut Home: +1-303-682-9630 chris(a)reigrut.net Mobile: +1-303-960-9831 http://www.reigrut.net "You live and learn, or you don't live long" -- Robert A. Heinlein

1 0

truncating mediawiki
by Pierre LINDENBAUM 23 Oct '09

23 Oct '09

Hi all, Hi all, I'm working with the mediawiki API and I would like to 'truncate' the mysql tables in order to reset my local installation while keeping the users. What would be the SQL queries ? I would say: tuncate all the tables but ${PREFIX}_user and update ${PREFIX}_user set user_editcount=0 ? Any other(safer) suggestion ? Thank you in advance Pierre

2 2

Creating a new page with standard headings by default
by Kushal Koolwal 23 Oct '09

23 Oct '09

I am using Mediawiki on Debian Lenny. By default, creating a new page starts with blank i.e. no wikitext. Users needs to put headings, text etc. I need to include following standard headers by default every time a new page is created. Here is the wikitext: ************************* ==Basic Description== ==Explain== ==See also== ==References== ==External links== ************************* What is the best way to do this? I have already created a template for the above page [[Template:MyTemplate]] and it seems that I can use it on a new black page with the following syntax {{Template:MyTemplate}}. However I would like to go one step further in the sense that whenever a user creates a new page, it will automatically populate from the template. Kushal Koolwal I do blog at http://blogs.koolwal.net/ _________________________________________________________________ Windows 7: Simplify your PC. Learn more. http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WL…

2 1

Enabling .ogg files
by Caitlin Dempsey 23 Oct '09

23 Oct '09

There seems to be several extensions and methods to enable sound files. Any recommendations on the best and easiest way to enable .ogg files? Thanks, Caitlin

2 1

Re: [Mediawiki-l] Importing an Excel Spread sheet (Jan Steinman)
by Jan Steinman 23 Oct '09

23 Oct '09

> From: Chris Reigrut <chris(a)reigrut.net> > > Another slightly easier option is to use the SimpleTable extension > (http://www.mediawiki.org/wiki/Extension:SimpleTable) to display a CSV > export. Except it doesn't do escaped field delimiters. If you don't have control over your application's CSV output, you probably cannot use SimpleTable. Apple Numbers comes to mind... just spent a couple hours convincing myself that SimpleTables is not useful with the fixed-format CSV output from Apple Numbers. For example, most columns with dollar-formatted amounts of 1,000 or more will cause an unwanted column split. Anyone know of a good open-source CSV parsing package written in PHP? Perhaps that could be glommed onto SimpleTable to make a standards- conforming CSV --> wikitable extension. :::: Beware of the military-industrial complex. -- Dwight D. Eisenhower :::: Jan Steinman <http://www.Bytesmiths.com>

1 0

Mass created article ?
by Hervé COLIN 23 Oct '09

23 Oct '09

Hello, Is there an extension to create mass article with increment ? Example : Page 1, Page 2, Page 3... Thanks

3 2

Importing an Excel Spread sheet
by DaveM 22 Oct '09

22 Oct '09

Is there anyway to import a spreadsheet into my Wiki. I have quite a bit of information I need to place in my WiKi and it is on an excel spreadsheet. Now to have to make up tables for all this will take me forever so is there an easer way of getting this into my WikI beside just adding the spread sheet as a download

5 5

Re: [Mediawiki-l] Importing an Excel Spread sheet (Jan Steinman)
by Chris Reigrut 22 Oct '09

22 Oct '09

Another slightly easier option is to use the SimpleTable extension (http://www.mediawiki.org/wiki/Extension:SimpleTable) to display a CSV export. > From: Jan Steinman <Jan(a)Bytesmiths.com >> From: "DaveM" <davem(a)triumphtalk.com> >> >> Is there anyway to import a spreadsheet into my Wiki. I have quite a >> bit of >> information I need to place in my WiKi and it is on an excel >> spreadsheet. >> Now to have to make up tables for all this will take me forever so >> is there >> an easer way of getting this into my WikI beside just adding the >> spread >> sheet as a download >> > > <snip> > Another way that's more interactive is to export them as CSV files, > import them into their own tables in MySQL, then use the sql2wiki > extension to display them. This is much more versatile, but can only > be done on a trusted site, as you generally don't want just anyone > sending arbitrary SQL to your database. You can also update and change > the tables at will, and have the changes instantly show up on the wiki. > </snip> > ----------------------------------------------------------------------- Chris Reigrut Home: +1-303-682-9630 chris(a)reigrut.net Mobile: +1-303-960-9831 http://www.reigrut.net "You live and learn, or you don't live long" -- Robert A. Heinlein

1 0

Re: [Mediawiki-l] Last login time
by Chris Reigrut 22 Oct '09

22 Oct '09

We actually did just what you're describing, but we used the emailAuthenticated field to hold the last login--mainly because we did our own authentication, so the emailAuthenticated field wasn't really useful to us anymore, but also because as long as that time is before the current time (which it always is if you set it to the login time) there's no difference in functionality. -- ----------------------------------------------------------------------- Chris Reigrut Home: +1-303-682-9630 chris(a)reigrut.net Mobile: +1-303-960-9831 http://www.reigrut.net "You live and learn, or you don't live long" -- Robert A. Heinlein

1 0

Re: [Mediawiki-l] Importing an Excel Spread sheet
by Jan Steinman 22 Oct '09

22 Oct '09

> From: "DaveM" <davem(a)triumphtalk.com> > > Is there anyway to import a spreadsheet into my Wiki. I have quite a > bit of > information I need to place in my WiKi and it is on an excel > spreadsheet. > Now to have to make up tables for all this will take me forever so > is there > an easer way of getting this into my WikI beside just adding the > spread > sheet as a download You could place the extension (.XLS) into the array of file types that are allowed to be uploaded, and then simply upload the files. They will be fairly useless to others until they download them and bring them into Excel. Another way that's more interactive is to export them as CSV files, import them into their own tables in MySQL, then use the sql2wiki extension to display them. This is much more versatile, but can only be done on a trusted site, as you generally don't want just anyone sending arbitrary SQL to your database. You can also update and change the tables at will, and have the changes instantly show up on the wiki. Here's some examples of live data display: http://www.EcoReality.org/wiki/2009_harvest http://www.EcoReality.org/wiki/User:Jan_Steinman/Vehicle_log :::: Quite clearly, our task is predominantly metaphysical, for it is how to get all of humanity to educate itself swiftly enough to generate spontaneous behaviors that will avoid extinction. -- R. Buckminster Fuller, _Synergetics_ :::: :::: Jan Steinman, EcoReality http://www.EcoReality.org ::::

1 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

MediaWiki-l October 2009