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 ::::
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
Writing a basic pywikipedia < http://meta.wikimedia.org/wiki/Pywikipediabot%3E 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 jborissr@gmail.com 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 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
-- John J. Boris, Sr. Online Services www.onlinesvc.com _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
I don't think there is any script to do exactly what you are asking John.
I myself wrote a variety of PHP scripts to strip tables out of Wiki markup pages, and manipulate the contents into other plain HTML tables, with some other tweaks, and a bit of JavaScript thrown in for giggles (OK to sort on the fly but you know.)
It wouldn't be more than a few hours, to make the table rewrite in CSV
BUT you need to be able to code in all that natively yourself :)
-----Original Message----- From: Jan Steinman Jan@Bytesmiths.com To: mediawiki-l mediawiki-l@lists.wikimedia.org Sent: Thu, Jan 23, 2014 10:05 am Subject: Re: [MediaWiki-l] Looking for way to automatically create or update a Page
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
mediawiki-l@lists.wikimedia.org