Difference between revisions of "Hilfe:Konvertieren von Tabellenblatt-Daten in Schlüsselvorlagen/en"

Revision as of 15:06, 17 May 2016

Help

Data from a spreadsheet (e.g. LibreOffice, Excel) that are in the format as an identification key matrix can be converted to decision key templates. Those key templates that can be converted presently are:

{{Key Start}} with {{Lead}}, file examples:

• Bestimmungsmatrix Calamagrostis (Minimalbeispiel).ods (normal identification, a German version)
• Bestimmungsmatrix Calamagrostis (Komplexbeispiel).ods (normal identification more complex, a German version)
• Bestimmungsmatrix eingeschachtelt Calamagrostis (Minimalbeispiel).ods (special case for subspecies)

{{ImageSwitch}}

• Testcase minimal example Excel2DecisionKeyTemplates (Beachexplorer 20141101) (still in development)

For the converting process to work, it is necessary that the spreadsheet fulfils some structural criteria according to the details discussed below. If the data structure of the converting file is correct, than it can be converted on the following special pages:

• Special:Convert spreadsheet file to key templates
• Special:Convert tab-separated file to key templates

Structure of a File for {{Key Start}} with {{Lead}}

In general the data structure must look like:

Brief Example

In this brief example, the decision key alternatives are created by the index numbers of decision_number and decision_alternative_number. And also in the meta data part it was specified, that all decision alternatives shall have a star symbol (decision_alternative_code=number & *), so the decision alternatives become automatically e.g. “2”, “2*”, “2**”, “2***”. The example comes from Datei:Bestimmungsmatrix Calamagrostis wiki.infoflora.ch (Minimalbeispiel).ods.

Meta data for Identification Key in Detail

First of all the meta data for the whole key have to be specified in the spreadsheet. The first data cell denotes the parameter.

Mandatory parameters are bold, recommended parameters are italic and optional parameters are normal, dotted underline corresponds to the default use case.

Columns of the Decision Key Matrix in Detail

Modes of the Decision

After the meta data, and a following closing blank line, the area of the decision key matrix begins. This decision key matrix starts with a line of decision key columns and continues by the decision alternatives row by row. Each of these alternatives is located in one spreadsheet line. Custom columns can be labelled in the spreadsheet too, these interfere not during conversion and are being ignored. There are two modes in determination, the normal mode—decision and decision alternative—and the nested mode—also decision and decision alternatives, but nested into one previous decision alternative. To make it clear, now a comparison of the two modes in the determination process:

decision
├ decision_alternative
├ decision_alternative
└ decision_alternative
decision
├ decision_alternative
├ decision_alternative
└ decision_alternative

decision
├ decision_alternative
├ decision_alternative
│ ├ nested_decision              
│ │ ├ nested_decision_alternative
│ │ ├ nested_decision_alternative
│ │ └ nested_decision_alternative
│ └ nested_decision              
│   ├ nested_decision_alternative
│   ├ nested_decision_alternative
│   └ nested_decision_alternative
└ decision_alternative
decision
├ decision_alternative
├ decision_alternative
└ decision_alternative

Columns of Determination

Columns of determination that can be used in the conversion process, are detailed as follows, columns of determination that are mandatory are in bold and optional columns are in normal font. To avoid complications during conversion delete empty columns of determination that are completely empty. However, custom named columns that are not columns of determination should not interfere during conversion.

Special Organism-Properties

Stumme Parameter

Diese Parameter können in der Datentabelle eingegeben werden, werden in Wiki Code umgewandelt, aber sie werden nicht evaluiert. Dies sind meist Parameter, die wieder exportiert werden müssen.

Structure of a file for {{ImageSwitch}}

Die Bestimmung bei {{ImageSwitch}} oder bei der „Bildweiche“ basiert auf Bildern, die alle gleichzeitig gezeigt werden, meist nur auf einer Seite. Auf einer anderen Seiten kann der Schlüssel fortgesetzt werden. Um mehrere {{ImageSwitch}} mit einem Mal zu konvertieren, können Blöcke in der Bestimmungsmatrix sein. Jeder Block beginnt mit dem Seitennamen als „Überschrift“ sozusagen.

Folgende Beispieltabelle soll das illustrieren (dem BeachExplorer entnommen):

1. die erste Tabellenüberschrift kennzeichnet benutzerdefinierte Spaltenüberschriften, (die vom Konverter ignoriert werden)
2. die zweite Zeile der Spaltenüberschriften kennzeichnet die standardisierten Spaltenparameter, die für eine Konvertierung verwendet werden können.

Column parameters for {{ImageSwitch}} in Detail

As follows the possible parameters are explained in detail.

Shortcut Writing and Emphasis (Typography)

For emphasis of typography (italic, bold) it is recommended to use HTML-tags:

• <b>bold</b>
• <i>italic</i>

The following writing shortcuts can be used, they become formatted or translated accordingly

Problems During Import

Couplet_ID_missing!

Possible solutions, for the {{Key Start}} with {{Lead}}:

• do the columns decision_number and decision_alternative_number have continued index numbers, even in the nested mode of determination?

Anmerkungen:

1. ↑ Literaturangaben?
2. ↑ Literaturangaben?