Writing a basic pywikipedia < http://meta.wikimedia.org/wiki/Pywikipediabot> bot to convert the flat file to wiki should be fairly easy (less than 30 lines of code) and should be the easiest way of doing it
On Thu, Jan 23, 2014 at 1:08 PM, john boris <[email protected]> wrote: > 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 > _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
