Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Wikipedia: Mediawiki

Re: Importing an Excel Spread sheet (Jan Steinman)

 

 

Wikipedia mediawiki RSS feed   Index | Next | Previous | View Threaded


chris at reigrut

Oct 22, 2009, 7:52 AM

Post #1 of 2 (596 views)
Permalink
Re: Importing an Excel Spread sheet (Jan Steinman)

Another slightly easier option is to use the SimpleTable extension
(http://www.mediawiki.org/wiki/Extension:SimpleTable) to display a CSV
export.
> From: Jan Steinman <Jan [at] Bytesmiths
>> From: "DaveM" <davem [at] triumphtalk>
>>
>> Is there anyway to import a spreadsheet into my Wiki. I have quite a
>> bit of
>> information I need to place in my WiKi and it is on an excel
>> spreadsheet.
>> Now to have to make up tables for all this will take me forever so
>> is there
>> an easer way of getting this into my WikI beside just adding the
>> spread
>> sheet as a download
>>
>
> <snip>
> Another way that's more interactive is to export them as CSV files,
> import them into their own tables in MySQL, then use the sql2wiki
> extension to display them. This is much more versatile, but can only
> be done on a trusted site, as you generally don't want just anyone
> sending arbitrary SQL to your database. You can also update and change
> the tables at will, and have the changes instantly show up on the wiki.
> </snip>
>

-----------------------------------------------------------------------
Chris Reigrut Home: +1-303-682-9630
chris [at] reigrut Mobile: +1-303-960-9831
http://www.reigrut.net

"You live and learn, or you don't live long" -- Robert A. Heinlein


_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


Jan at Bytesmiths

Oct 23, 2009, 10:53 AM

Post #2 of 2 (526 views)
Permalink
Re: Importing an Excel Spread sheet (Jan Steinman) [In reply to]

> From: Chris Reigrut <chris [at] reigrut>
>
> Another slightly easier option is to use the SimpleTable extension
> (http://www.mediawiki.org/wiki/Extension:SimpleTable) to display a CSV
> export.

Except it doesn't do escaped field delimiters.

If you don't have control over your application's CSV output, you
probably cannot use SimpleTable. Apple Numbers comes to mind... just
spent a couple hours convincing myself that SimpleTables is not useful
with the fixed-format CSV output from Apple Numbers. For example, most
columns with dollar-formatted amounts of 1,000 or more will cause an
unwanted column split.

Anyone know of a good open-source CSV parsing package written in PHP?
Perhaps that could be glommed onto SimpleTable to make a standards-
conforming CSV --> wikitable extension.


:::: Beware of the military-industrial complex. -- Dwight D. Eisenhower
:::: Jan Steinman <http://www.Bytesmiths.com>



_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Wikipedia mediawiki RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.