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 <[email protected]> wrote: > > From: john boris <[email protected]> > > > > 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, [email protected] wrote: > > > From: john boris <[email protected]> > > To: [email protected] > > Subject: [MediaWiki-l] > > Message-ID: > > < > caok1tcwvalo6xzfatmoqrfvc5fh6sm3qvjorstlr7_2c7ud...@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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > -- John J. Boris, Sr. Online Services www.onlinesvc.com _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
