Creating a table for your KB article

This document outlines a procedure for generating an html version of a preexisting table, using contact information as an example.

IMPORTANT: If you find this document too complicated, don't despair! The Word2CleanHtml tool can handle tables too! Especially if the table is already formatted for print or web, that is probably the way to go. However this procedure might still be helpful for some cases.

Although the table creator and editor in the KnowledgeBase WYSIWYG editor is more versatile and robust than many html table creation tools, it does not facilitate pasting of more than one cell at a time, so if your preexisting table would be unwieldy to recreate, you should consier other solutions. Depending on the table, a solution could be to upload it as a .xls file or PDF. However, if you want your information to be visible, searchable and editable directly in the KB, follow the procedure below.

This procedure was used to create docs Communications and Connections: Who to Call, Graduate School (by first name) and Communications and Connections: Who to Call in the Graduate School (by Function), which contain contact information, using the free tool Tableizer.

If your information is in an unusual format, like a Microsoft Word (or other word processor) table, or tab-separated text, first paste it into a Microsoft Excel spreadsheet. Make any necessary changes now.

If you want the final cells in your table to contain html code, like a link, create this code now. If you need to create many different links of the same type, Excel formulas can be very helpful.

For example, the following formula will turn an email address (in this case, in cell E118) into an email link:

=CONCATENATE("<a href=mailto:",E118,">",E118,"</a>")

A variation on this formula will return a blank cell if cell E9 is empty but an email link if cell E9 contains an email address:

=IF(E9=0,"",CONCATENATE("<a href=mailto:",E9,">",E9,"</a>"))

In this example table, we have names and email addresses for Bucky Badger and Joe Student:

Example1

Creating a formula in column E to create html code based on column C:

Example2

All links generated:

Example3

The final step is to create a copy of the table with the html code in the "email" column. First, copy the entire original table. Next, copy the replacement column, then paste it into the new table: Right click, then go to Paste Special > Paste Values > Values & Source Formatting.

Example4

Your table should now look something like this:

Example5

Once your data and html code are ready to go, open Tableizer in your web browser. Copy and paste your data, check "No CSS Styles," then click, "Tableize It!"

Example6

The code should look something like this (but may be much longer):

<table class="tableizer-table">
<tbody><tr class="tableizer-firstrow"><th>Firstname</th>
<th>Lastname</th>
<th>email</th>
</tr>
 <tr><td>Bucky</td><td>Badger</td><td><a href="mailto:bbadger@wisc.edu">bbadger@wisc.edu</a></td></tr>
 <tr><td>Joe</td><td>Student</td><td><a href="mailto:jstudent@wisc.edu">jstudent@wisc.edu</a></td></tr>
</tbody></table></a>

The example code will give this table, with all the information of the original table as well as html hyperlinks:

Firstname Lastname email
BuckyBadgerbbadger@wisc.edu
JoeStudentjstudent@wisc.edu





Keywords:html, KB, knowledgebase, table, contact information   Doc ID:30401
Owner:Alissa E.Group:VCRGE and Graduate School
Created:2013-05-29 14:30 CDTUpdated:2017-07-12 13:16 CDT
Sites:VCRGE and Graduate School
Feedback:  0   0