• Blog
  • LDS
    • Canada
    • Japan
    • U.K.
    • U.S.
    • World
    • Politicians
  • Site
    • About
    • Archive
    • Best of Rickety
    • Comments Policy
    • Copyright
    • FAQ
    • Feedback
    • Guests
    • Privacy Policy
    • Technical
    • Why Blog?
  • Sundry
    • Comics
    • HyperCheese Help
    • JFHE
    • Projects
      • Book of Mormon
    • Wishful Thinking

Rickety

Mostly about Utah

  • Family
    • Jill
    • Rick
    • Children
      • Daniel
      • Jake
      • Paul
      • Sarah
      • Steven
    • Children’s Spouses
      • Adelaide
      • Derek
      • Megan
      • Rachel
      • Shelese
    • Grandchildren
      • Aurora
      • Benjamin
      • Bryson
      • Caleb
      • Calvin
      • Cassandra
      • Elizabeth
      • Ezra
      • Helen
      • Jameson
      • Ryan
      • Sadie
  • Finance
    • Bank Rewards Checking
    • Credit Union Rewards Checking
    • Debt
    • Employment
    • Money
    • Rewards Checking Posts
  • Government
    • City
    • Elections
    • Federal
    • Military
    • Paul on Politics
    • Politics
    • States
    • Taxes
  • Recreation
    • Competition
    • Food
    • Fun in Utah
    • Games
    • Music
    • Parade
    • Sports
    • Travel
  • Religion
    • Christmas
    • Family History
    • Jesus Christ
    • LDS
    • Marriage
    • Missionary
    • On Religion
    • Preparedness
    • Scriptures
    • Temple
  • Series
    • 100 Years Ago
    • Christmas Letter
    • Epic Excerpts
    • On Religion
    • Past Pictures
    • Daniel’s Mission
    • Jake’s Mission
    • Paul’s Mission
  • Technology
    • Applications
    • Blogging
    • Communication
    • Computer
    • Energy
    • Environment
    • How To
    • Photography
    • Population
    • Transportation

Wiki Tables

June 2, 2008 by rickety Leave a Comment


Semantic MediaWiki

Consider this sortable wiki table. What is the easiest way to create it and maintain it? Here is how I do it:

  1. Use a spreadsheet such as Excel, OpenOffice Calc, or Google Docs to compile the data. I like to use Google Docs so that if needed I can share the spreadsheet online. A spreadsheet is simpler to use than a wiki table, duplicates cells easier, and totals columns. Where there are blank cells, use a non-breaking space (&nbsp) to maintain table integrity.
  2. When the spreadsheet is finished, export the data as csv. In Google Docs the csv data appears in another tab in my Firefox browser.
  3. Select all the csv data and paste it into the window of a CSV Converter. In the Convert Special Characters section select Do not convert (table contains code). Click on the Convert to MediaWiki! button.
  4. Copy the wiki table to your wiki edit page. Add in your wikitable sortable, cellspacing, border, and background color, etc. Don’t forget to add the sortbottom class before the totals row.
  5. When updating your article, put the changes in your spreadsheet and convert as before but do not replace the wiki table header. You will have to re-type the sortbottom class as this is replaced each time. If someone else updates the wiki table directly, don’t forget to update your spreadsheet.

With a large wiki table of membership records, by updating in a spreadsheet the totals are calculated for you which makes for easier going than to update the wiki table directly.


Filed Under: Blogging Tagged With: MediaWiki, Wiki

Recent Comments

  • Anonymous on One Hundred Thousand Milpengo
  • Jeremy McMullin on Mesa Easter Pageant – Jesus The Christ
  • Genma Vincent on George W Bush on Religion
  • Anonymous on The Twelve Stones of The Apocalypse
  • Judy Crowe on Ten Artists Paint Old Testament Women
  • Angela on The Twelve Stones of The Apocalypse
  • Angela on The Twelve Stones of The Apocalypse
  • AllHailKingJesus on The Twelve Stones of The Apocalypse
  • Microwave guy on Make a Halloween Costume from a Microwave Oven
  • Anonymous on Arduino AVR High-Voltage Serial Programmer

Who is this Rickety?

Rick at homeI'm Rick Willoughby. I live in Utah, a retired Software Engineer. I'm a Mormon, married with 5 children and 12 grandchildren.

I emigrated from England in my late twenties, bringing with me one small suitcase and a few dollars. I appreciate the opportunities America has given me and the friendliness of the people to new citizens.

I blog about my family as well as politics, religion, finance, technology, and other topics.

Copyright © 2025 · Lifestyle Pro Theme on Genesis Framework · WordPress · Log in