Spreadsheets to Mediawiki: Difference between revisions

From artserver wiki
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 29: Line 29:




[[Date::2015_05_19]]
[[Date::2015]]
[[Section::Blog]]
[[Section::Code Notes]]

Latest revision as of 12:51, 25 August 2022

Convert Spreadsheets to Mediawiki Tables

2015.05.19

Tables.png I use wikis quite often for the documentation of different projects. They are quite useful, simple and powerful, but in some specific cases Mediawiki syntax is just horrendous. One of such cases are tables. Therefore I been using Libreoffice to create the sheets/tables and then convert them to Mediawiki syntax using Pandoc.

The main trick is to export the sheet to an HTML file. Then you simply have to use Pandoc to convert the HTML table to Mediawiki, with the command

 pandoc -f html -t mediawiki sheet.html

The result will be a Mediawiki table:

{|
|id
|model
|user
|location
|notes
|-
|1
|Mac Pro 2.26
|All students
|Study
|archive machine
|-
|2
|Mac Pro A1481
|All students
|}


2015 Code Notes

... more about "Spreadsheets to Mediawiki"
Code Notes +
Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.
2015 +