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(a)bytesmiths.com> wrote:
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 ::::
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
--
John J. Boris, Sr.
Online Services