From: john boris <jborissr(a)gmail.com>
I have a Wiki page that holds a table of data. I have the data in an Excel
file and also as a flat ASCI file. I am looking for a way to automate the
updating of the page so when I make a change to the file on my one system I
can run the script and it will make the changes on my Wiki.
John, I don't know of a simple way to do that without writing some "glue"
code.
However, I am using the SQL2Wiki extension (heavily modified) to maintain data in MySQL
(using MyPhpAdmin) and display it in MediaWiki.
Due to the possibility of SQL injection, I do not recommend this for open wikis. I only
have trusted users, plus I protect pages with SQL on them, and restrict permissions to
SELECT only on the user role that has access from MediaWiki.
Although I don't use it, it is possible to automagically go MySQL <--> Excel
using Connector/ODBC.
Here's links to tons of example output:
http://www.EcoReality.org/wiki/Statistics
You can get SQL2Wiki from the MediaWiki extensions, or I can send you my heavily modified
version, which I think is much better. :-)
Jan
On 2014-01-23, at 09:25, mediawiki-l-request(a)lists.wikimedia.org wrote:
From: john boris <jborissr(a)gmail.com>
To: mediawiki-l(a)lists.wikimedia.org
Subject: [MediaWiki-l]
Message-ID:
<CAOk1TCwVaLo6XZFATMOQRfVc5FH6sM3QVJORStLR7_2C7UDG4g(a)mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
I have a Wiki page that holds a table of data. I have the data in an Excel
file and also as a flat ASCI file. I am looking for a way to automate the
updating of the page so when I make a change to the file on my one system I
can run the script and it will make the changes on my Wiki.
If there is a script that can do this can I get a pointer to it? I have
been searching and haven't found anything.
TIA
--
John J. Boris, Sr.
Online Services
www.onlinesvc.com
:::: As a man may be eating all day, and for want of digestion is never nourished, so
these endless readers may cram themselves in vain with intellectual food. -- I. Watts
:::: Jan Steinman, EcoReality Co-op ::::