wiki:UsingThisPlatform

Version 5 (modified by stels, 7 years ago) (diff)

--

Using this platform effectively

There are various small features integrated in this website which allow you to use it more effectively.

This site supports multiple navigation schemes:

Hierarchical browsing

The pages are structured hierarchically similiar to a file-system directory structure:

 - Homepage
   |- HICDEP versions
   |  \- Tables
   |    \- Fields
    \- General information

You can browse this structure by viewing the Index which is linked to on the top-right under the navigation bar of this website.

Tag-based browsing

Every page (where applicable) is "tagged" with the following information:

  • The HICDEP version which it describes (e.g. Hicdep_1.30)
  • The type of the page (e.g. Field)
  • The name of the table, if the page describes a table or a field. (e.g. tblAE)
  • The name of the field, if the page describes a field. (e.g. APPROV_D)
  • whether or not there are QA checks available for the item (e.g. hasQa)

An example:

The wiki page for the field APPROV_D of the table tblAE in HICDEP 1.30 has the following tags:

Hicdep_1.30 field tblAE APPROV_D hasQa

With this in mind, you can retrieve a list all fields without QA checks in HICDEP version 1.30 simply searching for articles tagged `field -hasQa Hicdep_1.30`

Timeline-based browsing

You can view earlier revisions of a page by clicking the link labelled "History" on the top-right of the corresponding page. For example, view this article's history. This can e.g. tell you when a provisional ATC code for a certain drug was replaced by the official code.

Finally, you can always simply search the full-text of all articles on this platform by surfing the search page.

If you are using Firefox, you can also install HICDEP's search engine:

Using Firefox' search for HICDEP

Notes to draft editors

Wiki Basics

If you are new to this wiki software, you might find the following resources helpful:

  • WikiFormatting -- Wiki Syntax Cheatsheet and explanations
  • TracGuide -- Built-in Documentation of the Trac software.

You can play around safely in the Sandbox to get accustomed to the wiki features.

Page templates

When creating a new wiki page for a HICDEP table or field, you may select one of the provided PageTemplates/HicdepTable or PageTemplates/HicdepField templates.

CSV data

Often you want to include a table with contents of a CSV file in your wiki pages. Instead of manually editing each line to match the wiki's table syntax, you may simply do the following:

{{{#!CSV
<copy-paste the content of your CSV file here>
}}}

An example:

{{{#!CSV filename="example.csv"
"Code (Extended ATC Codes)";"Anti-Retroviral Drugs"
"J05A";"ART unspecified"
"J05A-BEV";"Beviramat"
...;...
}}}

will be displayed as:

save Download this table as CSV filesave Download this table as XML file
Code (Extended ATC Codes)Anti-Retroviral Drugs
J05AART unspecified
J05A-BEVBeviramat
......

A download link for the CSV will be generated above the table if you specify the filename argument: You do not have to upload the CSV file anywhere, and changes in the inlined table will automatically propagate to the downloadable file.

SQL highlighting

You may enable highlighting for SQL-statements as follows:

{{{#!sql
SELECT fieldA, fieldB
FROM tableX
WHERE fieldA IS NULL
}}}

This will display as follows:

SELECT fieldA, fieldB
FROM tableX
WHERE fieldA IS NULL

If you have questions, feature requests, suggestions or criticism regarding this online platform do not hesitate to contact us via email!

Attachments (2)

Download all attachments as: .zip