Jan and the list, Just to let folks know the Wiki is private, behind a few firewalls and no other person has write access except for me. So this is completely private and is not accessible on the INternet. I have the capability of storing the file in a Database if that makes life easier. Currently it is kept on my legacy system in a flat ascii file.
On Thu, Jan 23, 2014 at 1:04 PM, Jan Steinman Jan@bytesmiths.com wrote:
From: john boris jborissr@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@lists.wikimedia.org wrote:
From: john boris jborissr@gmail.com To: mediawiki-l@lists.wikimedia.org Subject: [MediaWiki-l] Message-ID: <
CAOk1TCwVaLo6XZFATMOQRfVc5FH6sM3QVJORStLR7_2C7UDG4g@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 ::::
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l