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

Latest revision as of 12:13, 26 February 2020

Other languages:

Deutsch • ‎Deutsch (Sie-Form)‎ • ‎English • ‎français • ‎italiano

Please help to translate the technical software texts into French (Italian). Thanks a lot! See Benutzer:Andreas Plank/Übersetzungstexte jKey und Extension „Excel2Decision Key Templates“.

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)

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:

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

In general the data structure must look like:

meta_data_parameter	value					The meta data are for the whole key.
meta_data_parameter	value
meta_data_parameter	value
<blank line>	<blank line>	<blank line>	<blank line>	<blank line>	<blank line>	The blank line marks the key area at the beginning
column_parameter	column_parameter	column_parameter	column_parameter	column_parameter	column_parameter	Every column labels a specific property for the identification matrix/the key decisions
value	value	value				Decision key data follow row by row. One row is a decision alternative in a decision. All values for the decision alternative must be kept in that line.
value	value	value
value	value		value	value
value	value		value	value

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 with number & * as value), so the decision alternatives become automatically e.g. “2”, “2*”, “2**”, “2***”. The example comes from Datei:Bestimmungsmatrix Calamagrostis wiki.infoflora.ch (Minimalbeispiel).ods.

title	''Calamagrostis''
creators	Stefan Eggenberg
geoscope	Swiss
taxon_name	Calamagrostis
common_names	small reed, reed grass
taxon_rank_code	gen
category	Flora
decisions_alternative_codes	number & *

decision_number	decision_alternative_number	decision_alternative_text	next_decision_number	primary_media_1	label_primary_media_1	infoflora_id	scientific_name	description	plant_height_from	plant_height_to	flowering_period_from	flowering_period_to	floristic_zones
1	1	Awn stands out of the spikelet distinctively (Fig. 1a).	2	File:Glume detail of Calamagrostis varia (Schrad.) Host (×7), Dryades TSB17713.jpg	1a
1	2	Awn not or barely standing out of the spikelet (Fig 1b).	3	File:Glume detail of Calamagrostis villosa (Chaix) J.F.Gmel. (×5), Dryades TSB17718.jpg	1b
2	1	Leaf monochrome: on both sides faint blue-green…				2967	Calamagrostis varia (Schrad.) Host	Plant blue-green, stolons form herds	60	120	7	8	European
2	2	Leaf bicolored: on the upper side, somet…				2968	Calamagrostis arundinacea (L.) Roth	Plant blue- to fresh-green, tuft-like, …	60	150	7	8	Eurosiberian
3	1	Leaf distinctively glossy on the underside. The …	4
3	2	Leaf non-glossy on both sides. Lemma 3- or	5
4	1	Leaves limp. Awn is definite visib…				2971	Calamagrostis villosa (Chaix) J. F. Gmel.	Plant fresh- to dark-green. Leaves …	60	150	7	8	middle- and south-European
4	2	Leaves stiff upright. Awn short, unrema…				2970	Calamagrostis canescens (F. H. Wigg.) Roth	Plant blue-green, stalk stiff upright …	60	150	6	7	Eurosiberian
5	1	Ligule of upper leaves of the stalk only…				2969	Calamagrostis stricta (Timm) Koeler	Plant dark-green, forming tufts, stalk…	30	100	7	8	Holarctic
5	2	Ligule of upper leaves of the stalk 4 to 1…	6
6	1	Hairs at the base lemma nearly as long…		File:Example.jpg		6334	Calamagrostis phragmitoides Hartm.	Plant gray-green, forming tufts, stalks…	80	200	6	8	North-European to West-Siberian
6	2	Hairs at the base lemma definitely…		File:Example.jpg
7	1	Plant fresh-green. Both grass glumes …				2972	Calamagrostis epigejos (L.) Roth	Is forming herds by long runners, …	60	150	7	8	Euroasian
7	2	Plant blue-green. Upper grass glume only 7…				2973	Calamagrostis pseudophragmites (Haller f.) Koeler	Is forming herds by long runners, …	50	150	7	8	Euroasian

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.

meta_data_parameter	Example Value	{{Key Start}} Template Parameter	Comment
id	campanula1	(analogue)	Key ID. Only needed, if multiple keys are on one page.
title	<i>Campaula</i>	(analogue)	Title of the key itself (not of the page title!)
language	de	(analogue)	ISO language code
geoscope	Germany	(analogue)	geological scope (semantic data: Attribut:dcterms:spatial)
audience	pupils	(analogue)	The target audience (semantic data: Attribut:dcterms:audience)
description		(analogue)	Free text, that has some more information supplementary to the title (semantic data: Attribut:dc:description)
taxon_treatment_public_comment		taxon treatment public comment	Comment
publicity	Deutscher Jugendbund für Naturbeobachtung (German Youth Association for Observation of Nature)	(analogue)	Own publicity or internet page of the author
rating	4	(analogue)	1 … 5: 0 = missing, 1 = worst rating, 5 = best rating (semantic data: Attribut:xmp:Rating)
recommendation_group	”plant identification (advanced)” or “request for contribution!”	recommendation group	a class term for recommendation (Attribut:recommendation group)
taxon_name	Campaula	taxon name	taxon name of the group, the genus
common_names	bellflower	common names	common names (can be a comma , separated list)
taxon_rank_code	sp	taxon rank code	Taxonomic rank as code: `gen`, `fam`, `subfam`, `sp`
source	Key modified after Schubert & Vent (1982)	(analogue)	related published source(s), used literature data
collaboration_limited_to		collaboration limited to	limit collaboration to a list of authors (can be a comma , separated list). If empty then it is considered to be an open collaboration
status		(analogue)	state of editing
creators		(analogue)	author(s) (semantic data: Attribut:dc:creator)
initiated_by		initiated by	initiators, that do not want to be cited
contributors		(analogue)	contributors, can be a comma-separated list (semantic data: Attribut:dc:contributor)
general_review_by		general review by	general review done by someone
nomreview_by		nomreview by	nomenclature review done by someone
expert_review_by		expert review by	(taxonomical) review by someone
parent_taxon		parent taxon	the taxon that is a parent taxon to this key
parent_key		parent key	the parent key page
parent_key_text		parent key text	another display text other than of “parent key”
category	Flora	(analogue)	Flora or Fauna (, list). A category for this key.
icon	File:My_great_icon.jpg	(analogue)	icon name (will be sized to 40x40px)
decisions_alternative_codes (~~decision_alternative_code~~)	number number & - number & ' number & ’ number & * a-z a-z & - a-z & ' a-z & ’ a-z & * or A-Z A-Z & - A-Z & ' A-Z & ’ A-Z & *	-	(default: number & -) Switch for all decision alternatives: how to display the decision alternatives of the whole key. It becomes for instance “2, 2, 2”. If this parameter is not set at all, the standard display is the decision number followed by an em-dash, the Wiki code “2, 2-, 2-” becomes in the key “2, —, — ”. Alternatively, the author of the key must* input this information by himself correctly into the decision columns `decision_code` and `decision_alternative_code`. `number` and `number & -`results in 1, —, —, 2, —, — `number & '` results in 1, 1', 1'' `number & ’` results in 1, 1’, 1’’ `number & ` results in 1, 1, 1** analogue for `a-z` (lower case letter) or A-Z (upper case letters)
nested_decisions_alternative_codes	a-z a-z & - a-z & ' a-z & ’ a-z & * A-Z A-Z & - A-Z & ' A-Z & ’ A-Z & * number number & - number & ' number & ’ or number & *	-	(default: a-z & -) Switch for the nested mode within a decision_alternative (corresponds in to {{Lead}}: nested, parentlead), e.g. for the determination of sub-species after a decision alternative. If this is not set at all, the standard output is an alphabetical code following an “—” (emdash). For instance if the last decision alternative of the Wiki output was “2” and a sub-species is further described in the key in the nested mode, then the output will be “a, —, —” (first decision alternative) then “b, —” (second decision alternative) then “c, —, —” (third decision alternative) etc.. Other possible layout variants are: `a-z` or `a-z & -` results in a, —, — `a-z & '` results in a, a', a'' `a-z & ’` results in a, a’, a’’ `a-z & ` results in a, a, a* analogue for `A-Z` (upper case) and `number` (in numbers)
add_decision_backlinks	1	-	(default: 1) Switch for showing backward links to the previous decision. This parameter is only for the converting process. A normal backward link to a decision number “2” is created in the template by {{Lead\|5 (2)=…}}.
<blank cell>	<blank cell>	-	actually a whole blank line marks the ending of all meta data and the beginning of the decision key data

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:

Normal Mode of Determination

Nested Mode of Determination

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

There are only decisions with their decision alternatives.

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

Into a “normal” decision alternative there are nested additional decisions, for instance to differentiate sub-species. The nested determination shall come to an end point of the determination (of sub-species), whereas the other “normal” decisions or decision alternatives can be continued.

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.

Column Header for Determination Matrix	Type	Example Value	Template Parameter (Correspondence)	Comment
decision_number	ID decision	2	{{Lead \| 2 \| … }}	Only a number. Index-number of a decision (e.g. 2) that spans multiple decision alternatives (index-number is the “2” in 2a, 2b, 2c or 2 in 2—, 2— or 2 in 2, 2*)
decision_alternative_number	ID decision alternative	1		Only a number. Index-number within a decision (`decision_number`), in a way it specifies the order of alternatives (`decision_alternative_text`) on a number basis.
next_decision_number	ID decision	5		Only a number. The next index number of the decision. Has no correspondence in {{Lead}}.
decision_code	ID decision	2 or A or II	{{Lead \| A \| … }}	Number or letter. Actual display of a decision. If specified, then the author himself must manage the correct values; this overrides `decision_number`.
next_decision_code	‎ID decision	5 or B or IV	{{Lead \| 1 \| Text \| 5 }}	Number or letters. Actual display of the next decision, points to the next `decision_code`. It is not recommended to use this parameter, because the author himself has to manage the correct values; this overrides `decision_number`. Alternative: fill only columns `decision_number` and `next_decision_number` and if needed, alter the layout via switch `decisions_alternative_codes` in thee meta data section.
decision_alternative_code	ID decisionsalternative	a or ' or *	{{Lead \| 2a \| … }}	Character or letter. It is not recommended practice to use this parameter, because the author himself must manage the correct values, this overrides `decision_number`. Alternative: fill only columns `decision_number` and `next_decision_number` and if needed, alter the layout via switch `decisions_alternative_codes` in thee meta data section.
nested_decision_number	ID nested	0 or 1 or 3		Only a number (starts with 0). Index-number of the decision for thee nested mode. For explanation: a decision comprises of multiple decision alternatives. The nested mode (nested/parentlead in the template) continues within a single “normal” decision alternative. At thee line where thee nested mode has to start, the index has to be 0. In the following lines just increment thee index. Multiple decision alternatives that shall belong to the same decision must have thee same index number.
nested_decision_alternative_number	ID nested	1	{{Lead \| nested=a \| … }} {{Lead \| parentlead=2* \| a \| … }}	Only a number. Index-number of the decision alternative in the nested mode. To elaborate on this: a decision alternative is part of a decision. The nested mode (in the template: nested/parentlead) is continued within a single “normal” decision alternative. (After conversion it will become a letter, you can modify this by the global key-property `nested_decisions_alternative_codes`)
next_nested_decision_number	ID nested	2	{{Lead \| parentlead=2* \| … \| b}}	Only a number. The next index number of a nested decision. After conversion it will become a letter, you can modify this by the global key-property `nested_decisions_alternative_codes`.
decision_alternative_text	text of identification		{{Lead \| …\| text of identification, question}}	free text. The very text of identification or the question.
remarks	additional info (general)		{{Lead \| … \| remarks= }}	Free text. Remarks (used for `taxon treatment public comment`) including historical information or human uses; tips on how to recall characters more easily etc.
occurrence	additional info (general)		{{Lead \| … \| occurrence= }}	Free text. Text related to occurrence, geography, habitat if other parameters can not describe sufficiently.
description	additional info (general)		{{Lead \| … \| description= }}	Free text. Additional description, if other parameters describe not sufficiently.
references	additional info (general)	Aeschimann D. (2003); Duvoisin, J. (2015)	`references`	Literature references
result_link	result	The sedges in Brandenburg (Max Müller)	{{Lead \| … \| result= }}	Different page link or external URL (http://…). Overrides display from `scientific_name`
result_text	result		{{Lead \| … \| result text= }}	overrides display text of result_link as well as the display from `scientific_name`
result_id	result		{{Lead \| … \| result id= }}	Point of result. An important identifier for the author. When a species page follows. Arbitrary ID, proposal: a prefix directly followed by an ID, e.g. `BExID:123942`. There can be only one ID.
checklist_id	result		{{Lead \| … \| result id list= }}	Point of result. An important identifier for the author is added to `result id list`, converted to a <span>-tag, presently a hidden parameter.
florahelvetica_id	result		{{Lead \| … \| result id list= }}	Point of result. An important identifier for the author is added to `result id list`, converted to a <span>-tag: `<span class="show" data-term="florahelvetica_id" data-prefix="FH">2013479</span>` gets displayed as FH 2013479 via CSS-layout-rules (MediaWiki:Common.css).
infoflora_id	result		{{Lead \| … \| result id list= }}	Point of result. An important identifier for the author is added to `result id list`, converted to a <span>-tag, presently a hidden parameter.
isfs_id	result		{{Lead \| … \| result id list= }}	Point of result. An important identifier for the author is added to `result id list`, converted to a <span>-tag, presently a hidden parameter.
scientific_name	result		{{Lead \| scientific name= \| … }}	Point of result. When a species page follows.
scientific_name_synonyms	result		{{Lead \| … \| synonyms= }}	Point of result (list with ; semicolon)
common_names	result		{{Lead \| common names= \| … }}	Point of result (list with , comma)
decision_heading	result	Ascomycota	{{Lead \| …\|subheading= Ascomycota}}	Free text. A sub heading, to mark a section
primary_media_1 … primary_media_5	media	File:Example.jpg	`image a` … `image e`	Marginal image (always visible) up to 5
caption_primary_media_1 … caption_primary_media_5	media		`caption a` … `caption e`	image caption
label_primary_media_1 … label_primary_media_5	media	3a	`label a` … `label e`	label of a figure (needed only for text reference)
primary_media_width primary_media_height	media	100	`primary images width` `primary images height`	Width, height of all marginal images (default: 80, 80 as height, width)
primary_media_1_width … primary_media_5_width primary_media_1_height … primary_media_5_height	media	100	`image a width` … `image e width` `image a height` … `image e height`	Width, height of individual marginal images (default: 80, 80 as height, width)
large_primary_media_1 … large_primary_media_2	media	File:Example.jpg	`image j` … `image k`	large image (always visible) up to 2
caption_large_primary_media_1 … caption_large_primary_media_2	media		`caption j` … `caption k`	image caption
label_large_primary_media_1 … label_large_primary_media_2	media	5b	`label j` … `label k`	label of a figure (needed only for text reference)
large_primary_media_1_width large_primary_media_1_height large_primary_media_2_width large_primary_media_2_height	media	300	`image j width` `image j height` `image k height` `image k height`	Width, height of individual large images (default: 400, 600 as height, width)
collapsed_media_1 … collapsed_media_6	media	File:Example.jpg	`image m` … `image r`	large image (always visible) up to 6
caption_collapsed_media_1 … caption_collapsed_media_6	media		`caption m` … `caption r`	image caption
label_collapsed_media_1 … label_collapsed_media_6	media	5a	`label m` … `label r`	label of a figure (needed only for text reference)
collapsed_media_width collapsed_media_height	media	150	`extra images width` `extra images height`	Width, height of all hidden images (default: 200)
collapsed_media_1_width … collapsed_media_5_width collapsed_media_1_height … collapsed_media_5_height	media	150	`image m width` … `image r width` `image m height` … `image r height`	Width, height of induvidual hidden images (default: 200)
collapsed_media_captionlines	media	6	`captionlines`	Integer. Approximate number of caption lines (default: 3)

Special Organism-Properties

Column Header	Example Value	Template Parameter (Correspondence)	Comment
plant_height	10-30 cm or 10-30(-50) cm (1.2-)2.5-3.0(5.1) m	{{Lead\|plant height=string}}	Special size: height(s) of plant growth. Avoid using this and use instead the height of plant growth that is split up (in plant_height_min, …from, …to, …max) only numbers, minus and curved brackets () including the unit. Minimum/Maximum in brackets before (5-) or behind (-50)
plant_height_min	5	{{Lead\|plant height formula min-from-to-max-unit=formula}}	Special size: minimum limit of the growth height of the plant. For size input being split up, replaces and overrides plant_height. This is translated into a formula. The formula is for instance as follows: “NA/20/50/120/cm” and means “min/from/to/max/unit”. Empty values will be translated into NA (NA=not available).
plant_height_from	7	{{Lead\|plant height formula min-from-to-max-unit=formula}}	Special size: lower limit of the growth height of the plant. For size input being split up, replaces and overrides plant_height. This is translated into a formula. The formula is for instance as follows: “NA/20/50/120/cm” and means “min/from/to/max/unit”. Empty values will be translated into NA (NA=not available).
plant_height_to	9	{{Lead\|plant height formula min-from-to-max-unit=formula}}	Special size: upper limit of the plant growth height. For size input being split up, replaces and overrides plant_height. This is translated into a formula. The formula is for instance as follows: “NA/20/50/120/cm” and means “min/from/to/max/unit”. Empty values will be translated into NA (NA=not available).
plant_height_max	14	{{Lead\|plant height formula min-from-to-max-unit=formula}}	Special size: maximum limit of the growth height of the plant. For size input being split up, replaces and overrides plant_height. This is translated into a formula. The formula is for instance as follows: “NA/20/50/120/cm” and means “min/from/to/max/unit”. Empty values will be translated into NA (NA=not available).
plant_height_unit	mm or m	{{Lead\|plant height formula min-from-to-max-unit=…}}	Default: cm. This is translated into a formula. The formula is for instance as follows: “NA/20/50/120/cm” and means “min/from/to/max/unit”.
plant_height_comment		{{Lead\|plant height comment=…}}	Comment to plant hight
organism_size	10-30 cm or 10-30(-50) cm (1.2-)2.5-3.0(5.1) m	{{Lead\|organism size=string}}	General size, if no other precise derivation is possible, whether height, length or width is meant. Because this parameter should include the complete sizes including the unit, but is difficult to parse technically, it is recommended to avoid this parameter but use the sizes split up (into organism_size_min, …from, …to, …max). If it is known that this size describes e.g. height at flowering time, then don‘t use this parameter but prefer the special height size plant_height or even better split up the data into plant_height_min, plant_height_from, plant_height_to etc.. only numbers, minus and curved brackets including the unit. Minimum/maximum in brackets before (5-) or behind (-50)
organism_size_min	5	{{Lead\|organism size formula min-from-to-max-unit=formula}}	General size. Minimum limit of the organism size, replaces and overrides organism_size. This is translated into a formula. The formula is for instance as follows: “NA/20/50/120/cm” and means “min/from/to/max/unit”. Empty values will be translated into NA (NA=not available).
organism_size_from	7	{{Lead\|organism size formula min-from-to-max-unit=formula}}	General size. Lower limit of the organism size, replaces and overrides organism_size. This is translated into a formula. The formula is for instance as follows: “NA/20/50/120/cm” and means “min/from/to/max/unit”. Empty values will be translated into NA (NA=not available).
organism_size_to	9	{{Lead\|organism size formula min-from-to-max-unit=formula}}	General size. Upper limit of the organism size, replaces and overrides organism_size. This is translated into a formula. The formula is for instance as follows: “NA/20/50/120/cm” and means “min/from/to/max/unit”. Empty values will be translated into NA (NA=not available).
organism_size_max	14	{{Lead\|organism size formula min-from-to-max-unit=formula}}	General size. Maximum limit of the organism size, replaces and overrides organism_size. This is translated into a formula. The formula is for instance as follows: “NA/20/50/120/cm” and means “min/from/to/max/unit”. Empty values will be translated into NA (NA=not available).
organism_size_unit	mm or m	{{Lead\|organism size formula min-from-to-max-unit=formula}}	Default: cm. Use it if another then the default unit is needed. This is translated into a formula. The formula is for instance as follows: “NA/20/50/120/cm” and means “min/from/to/max/unit”. Empty values will be translated into NA (NA=not available).
organism_size_comment		{{Lead\|organism size comment=…}}	Comment to organism size
life_form		{{Lead\|life form=…}}	life form after FI or Nyffeler^[1]
flowering_period	1-2 or II-IV	{{Lead\|flowering period=string}}	Flowering period in months.
flowering_period_min	1 or II	{{Lead\|flowering period formula min-from-to-max=formula}}	earliest time of the flowering period as month. This is translated into a formula. The formula is for instance as follows: “2/4/5/NA” and means “min/from/to/max”. Empty values will be translated into NA (NA=not available).
flowering_period_from	1 or II	{{Lead\|flowering period formula min-from-to-max=formula}}	“flowering period from” as month. This is translated into a formula. The formula is for instance as follows: “2/4/5/NA” and means “min/from/to/max”. Empty values will be translated into NA (NA=not available).
flowering_period_to	1 or II	{{Lead\|flowering period formula min-from-to-max=formula}}	“flowering period to” as month. This is translated into a formula. The formula is for instance as follows: “2/4/5/NA” and means “min/from/to/max”. Empty values will be translated into NA (NA=not available).
flowering_period_max	1 or II	{{Lead\|flowering period formula min-from-to-max=formula}}	most latest time of the flowering period as month. This is translated into a formula. The formula is for instance as follows: “2/4/5/NA” and means “min/from/to/max”. Empty values will be translated into NA (NA=not available).
altitudinal_zones	coll-mont or coll.-mont. (-subalp.)	{{Lead\|altitudinal zones=string}}	string of the whole range of altitudinal zones usually given by “(min–)from–to(–max)”
altitudinal_zone_min	coll	{{Lead\|altitudinal zone formula min-from-to-max=formula}}	Lowest altitudinal zone. This is translated into a formula. The formula is for instance as follows: “NA/colline/montane/NA” and means “min/from/to/max”. Empty values will be translated into NA (NA=not available).
altitudinal_zone_from	coll	{{Lead\|altitudinal zone formula min-from-to-max=formula}}	Lower limit of the altitudinal zones. This is translated into a formula. The formula is for instance as follows: “NA/colline/montane/NA” and means “min/from/to/max”. Empty values will be translated into NA (NA=not available).
altitudinal_zone_to	coll	{{Lead\|altitudinal zone formula min-from-to-max=formula}}	Upper limit of the altitudinal zones. This is translated into a formula. The formula is for instance as follows: “NA/colline/montane/NA” and means “min/from/to/max”. Empty values will be translated into NA (NA=not available).
altitudinal_zone_max	coll	{{Lead\|altitudinal zone formula min-from-to-max=formula}}	Highest altitudinal zone. This is translated into a formula. The formula is for instance as follows: “NA/colline/montane/NA” and means “min/from/to/max”. Empty values will be translated into NA (NA=not available).
altitudinal_zone_comment		{{Lead\|altitudinal zone comment=}}	Comment
occurrence_status	indigenous	{{Lead\|occurrence status=string}}	natural state, if indigenous, naturalised etc.
occurrence_ecology_typo	Sisymbrion, Alysso-Sedion, Caucalidion	{{Lead\|occurrence ecology typo=string}}	plant sociology
occurrence_ecology_values	U.1+43-444.k-t. 2n=28	{{Lead\|occurrence ecology values=string}}	basis is FI/FH and reviewed by AGY, ecological indication values after Landolt et al. (2010)
presence_territory	CH: X	{{Lead\|presence territory=string}}	Occurrence in the territory. Parameter not set: present; X: missing; ?: questionable
floristic_zones	Eurosiberian	{{Lead\|floristic zones=string}}
floristic_zones_comments	also Alps	{{Lead\|floristic zones comments=string}}
xenophyte		{{Lead\|xenophyte=string}}
toxicity	+	{{Lead\|toxicity=string}}	Toxicity class of a taxon after Flora Helvetica (+,++,+++)

Hidden Parameters

These parameters can be inserted into the data table, they get converted to Wiki code, but they are not evaluated. Mostly these are parameters that needs to be exported again.

Parameter Column Head	Type	Template Parameter (Correspondence)	Comment
taxon_treatment_hidden_comment	meta data	taxon treatment hidden comment	hidden comment
taxon_treatment_hidden_comment	attribute of decision	taxon treatment hidden comment	hidden comment
drawing_detail	attribute of decision	drawing detail	whether detail drawing is necessary (yes: “D”)
map_comment	attribute of decision	map comment	comment for the map
checklist_id	attribute of decision	result id list	checklist ID. Converted to `<span class="hide" data-term="checklist_id" data-prefix="Checklist">2013479</span>`. Hidden by CSS-layout-rules (MediaWiki:Common.css).
infoflora_id	attribute of decision	result id list	infoflora ID. Converted to `<span class="hide" data-term="infoflora_id" data-prefix="Infoflora">2013479</span>`. Hidden by CSS-layout-rules (MediaWiki:Common.css).
isfs_id	attribute of decision	result id list	isfs ID. Converted to `<span class="hide" data-term="isfs_id" data-prefix="ISFS">2013479</span>`. Hidden by CSS-layout-rules (MediaWiki:Common.css).

Structure of a file for {{ImageSwitch}}

The identification with {{ImageSwitch}} or the “Bildweiche” is based on pictures, all being “shown at the same time”, usually only on one page. On another page, the key can be continued. To convert multiple {{ImageSwitch}} at once, blocks of it can be provided in the identification matrix. Each Block begins with the page name, as a “heading” so to speak.

The following example spread sheet is to illustrate (taken from beach Explorer):

the first table heading indicates the user-defined column headings (ignored by the converter)
the second line of the column headings indicates the “standardized column parameters”, which can be used for a conversion.

German name	English name	Dutch name	Danish name	Scientific name			IDcomplete	Character description (above)	Image name	Result text (sub-key or species)	Link destination (species/sect. next level)	Creator
`common_names_de`	`common_names_en`	`common_names_nl`	`common_names_da`	`scientific_name`	`decision_number`	`decision_alternative_number`	`result_id`	`decision_alternative_text`	`primary_media`	`result_text`	`result_link`	`creators`
					1	0				Start BeachExplorer		Rainer Borcherding
					1	1	BExID:9900010	With hairs and feathers, moreover whales	File:BEQ1A V Robbe Moewe KT.jpg	four-legged animals, birds, whales	quadruped & birds & whales
					1	2	BExID:9900020	with fins, scales, branchial clefts	File:BEQ2A F Fische.jpg	fishes	fishes
					1	3	BExID:9900030	With lime shells and -shields	File:BEQ3A S Schalen.jpg	shellfishes	shellfishes
					1	4	BExID:9900040	skin soft, body shape very diverse	File:BEQ4A W Weiche Tiere.jpg	soft-skinned animals	soft-skinned animals
					1	5	BExID:9900050	branched, firmly grown, plant-like	File:BEQ5A G Gewaechse Knubbel.jpg	growths, crust, lumps	growths, crust, lumps
					1	6	BExID:9900060	holes, tubes, all kinds of traces	File:BEQ6A L Loecher Roehren.jpg	holes and tubes	holes and tubes
					1	7	BExID:9900070	with chitinous carapace, mostly land animals	File:BEQ7A I Kaeferspülsaum.jpg	insects and arthropods	insects and arthropods
					1	8	BExID:9800080	plastic, wood, stones, bones	File:BEQ8A M HolzSteinMüll.jpg	wast, wood and stones	wast, wood and stones
					1	9	BExID:9800090	peculiarities & riddles	File:BEQ9A D Dinger.jpg	eggs, blobs & puzzle things	eggs, blobs & puzzle things
…	…	…	…	…	…	…	…	…	…	…	…	…
					3	0				pinnipeds, seals		Rainer Borcherding
Seehund	Harbour seal	Gewone zeehond	Spættet sæl	Phoca vitulina	3	1	BExID:1370841	Up to 1.6 m, muzzle short, molars three-pointed	File:BEQ1E VR Seehund.jpg	Harbor seal	Harbor seal
Kegelrobbe	Grey seal	Grijze zeehond	Gråsæl	Halichoerus grypus	3	2	BExID:1370801	Up to 2.3 m, muzzle short, molars single pointed	File:BEQ1E VR Kegelrobbe.jpg	Grey seal	Grey seal
Ringelrobbe	Ringed Seal	Ringelrob	Ringsæl	Phoca hispida	3	3	BExID:1370831	Up to 1.6 m, muzzle very short, belly unspotted, otherwise rings	File:BEQ1E VR Ringelrobbe.jpg	Ringed seal	Ringed seal
Sattelrobbe	Harp seal	Zadelrob	Grønlandssæl	Pagophilus groenlandicus	3	4	BExID:1370821	Up to 1.9 m, muzzle long and flat, black back saddle	File:BEQ1E VR Sattelrobbe.jpg	Harp seal	Harp seal
Klappmütze	Hooded seal	Klapmuts	Klapmyds	Cystophora cristata	3	5	BExID:1370781	Up to 2.6 m, conspicuous black on light spotted	File:BEQ1E VR Klappmuetze.jpg	Hooded seal	Hooded seal
Bartrobbe	Bearded seal	Baardrob	Remmesæl	Erignathus barbatus	3	6	BExID:1370791	Up to 2.5 m, small head, long whiskers, hardly patterned	File:BEQ1E VR Bartrobbe.jpg	Bearded seal	Bearded seal
Walross	Walrus	Walrus	Hvalros	Odobenus rosmarus	3	7	BExID:1370771	front legs with joint, very clumsy and fat	File:BEQ1B VR Walross sonnend.jpg	Walrus	Walrus

Column parameters for {{ImageSwitch}} in Detail

As follows the possible parameters are explained in detail.

Type	Column Parameter	Description	{{ImageSwitch}} Correspondence
identification	decision_alternative_text	Text of a decision alternative (the whole ImageSwitch corresponds quasi to a “decision” having up to 30 decision alternatives)	`lead 1` … `lead 30`
identification	decision_alternative_textlines	the number of text lines of an alternative (can be specified globally for conversion)	`lead lines`
identification	decision_number	Index-number. If multiple keys, the index of the key (=decision). Eery key is associated to a decision_number, but for the alternatives (=decision_alternative_number) it has in itself variant indices.
identification	decision_alternative_number	Index number of the alternatives within the key (within the decision_number, of the decision)	1 … 30 in `lead 1` … `lead 30`
contribution	creators	Author or list of authors (interpreted as author of the key)	`creators`
contribution	contributors	contributor or list of contributors (interpreted as contributors of the key)	`contributors`
ID	decisionkey_id	id of the key on the wiki page itself (only to be specified if there are several keys on one page)	`id`
classification	decisionkey_rating	rating in numerical form (1=the lowest, ... 5=the highest; can be specified globally for all when converting)	`rating`
classification	decisionkey_recommendation_group	recommendation class for the key, e.g. “Plant identification (beginner)” and so forth (can be specified globally for all when converting)	`recommendation group`
media	primary_media_width	width of image (can be specified globally for all when converting)	`image width`
media	primary_media	full file name of the media file, as “File:filename.jpg”	`image 1` … `image 30`
layout, media	primary_media_caption_lines	the approximate number of caption lines of an image (globally specifiable for all when converting)	`caption lines`
layout, media	primary_media_caption_style	CSS style of image caption (globally specifiable for all when converting)	`caption style`
layout, key	decisionkey_style	CSS style of the whole key (globally specifiable for all when converting)	`style`
layout, key	decisionkey_format	2 formats are available: “result link top result text bottom” or “result link bottom result text top” (globally specifiable for all when converting)	`layout format`
result	reuslt_text	display text of the result	`result text 1` … `result text 30`
result	result_link	the result’s link target (page or URL)	`result 1` … `result 30`
ID	result_id	is a result ID that the author wants to include in the key data. The result ID should have a prefix to make the ID unique. Note: a result ID is useful if a species page will follow.	`result id 1` … `result id 30`
result	common_names_da common_names_de common_names_dk common_names_el common_names_en common_names_es common_names_et common_names_fi common_names_fr common_names_it common_names_lt common_names_lv common_names_nl common_names_no common_names_pl common_names_pt common_names_ru common_names_sv	List of common names for each language one column (…_da: Danish, …_de:German etc.; prefix “@de:” is added)	`common names 1` … `common names 30`
result	scientific_name	scientific name	`scientific name 1` … `scientific name 30`
heading	decisionkey_title	heading of the key	`title`

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

Writing Shortcut	Converted	Comment
<+-> <+/->	±
<2/3>	²/₃	All fractions up to X/10 will be translated, not as single character (to avoid character loss into ASCII conversion), but as ^superscript/_subscript
<=	≤
>=	≥
<m>	♂
<f>	♀
<mf>	⚥
<fm>	☿

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?
is the decision_alternative_text intended to be a kind of (sub)section in between, then use instead decision_heading.

Remarks:

↑ any literature sources?

[1] y literature sources?

[1]

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

Latest revision as of 12:13, 26 February 2020

Contents

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

Brief Example

Meta data for Identification Key in Detail

Columns of the Decision Key Matrix in Detail

Modes of the Decision

Columns of Determination

Special Organism-Properties

Hidden Parameters

Structure of a file for {{ImageSwitch}}

Column parameters for {{ImageSwitch}} in Detail

Shortcut Writing and Emphasis (Typography)

Problems During Import

Couplet_ID_missing!

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Main Page

Navigation

Mitarbeit

Tools

In other languages

@@ Line 1: / Line 1: @@
 <languages/>
 {{Bildwegweiser | Titel = [[:{{ns:category}}:Hilfe{{translation}}|Help]] | Größe =  35px | Hilfe}}
+{{Ombox
+|image=[[File:Translation - Intercultur.svg|x40px]]
+|text=Please help to translate the technical software texts into French (Italian). Thanks a lot! See [[Benutzer:Andreas Plank/Übersetzungstexte jKey und Extension „Excel2Decision Key Templates“]].
+}}
 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:
 : {{Tlx|Key Start}} with {{Tlx|Lead}}, file examples:
@@ Line 457: / Line 463: @@
 | description || || (analogue) || Free text, that has some more information supplementary to the title (semantic data: [[{{ns:property}}:dc:description]])
 |-
-| author_treatment_public_comment ||  || author&nbsp;treatment&nbsp;public&nbsp;comment || Comment
+| taxon_treatment_public_comment ||  || taxon&nbsp;treatment&nbsp;public&nbsp;comment || Comment
 |-
 | publicity || Deutscher Jugendbund für Naturbeobachtung (German Youth Association for Observation of Nature) || (analogue) || Own publicity or internet page of the author
@@ Line 633: / Line 639: @@
 |
 | <nowiki>{{Lead | … | remarks= }}</nowiki>
-| ''Free text''. Remarks, including historical information or human uses; tips on how to recall characters more easily etc.
+| ''Free text''. Remarks (used for <tt>taxon treatment public comment</tt>) including historical information or human uses; tips on how to recall characters more easily etc.
 |-
 | occurrence
@@ Line 736: / Line 742: @@
 | <code>label a</code><br />…<br /><code>label e</code>
 | label of a figure (needed only for text reference)
+|-
+| primary_media_width<br />primary_media_height
+| media
+| 100
+| <code>primary images width</code><br /><code>primary images height</code>
+| Width, height of all marginal images (default: 80, 80 as height, width)
+|-
+| primary_media_1_width<br />…<br />primary_media_5_width<br /><br />primary_media_1_height<br />…<br />primary_media_5_height
+| media
+| 100
+| <code>image a width</code><br />…<br /><code>image e width</code><br /><br /><code>image a height</code><br />…<br /><code>image e height</code>
+| Width, height of individual marginal images (default: 80, 80 as height, width)
 |-
 | large_primary_media_1<br />…<br />large_primary_media_2
@@ Line 754: / Line 772: @@
 | <code>label j</code><br />…<br /><code>label k</code>
 | label of a figure (needed only for text reference)
+|-
+| large_primary_media_1_width<br />large_primary_media_1_height<br /><br />large_primary_media_2_width<br />large_primary_media_2_height
+| media
+| 300
+| <code>image j width</code><br /><code>image j height</code><br /><br /><code>image k height</code><br /><code>image k height</code>
+| Width, height of individual large images (default: 400, 600 as height, width)
 |-
 | collapsed_media_1<br />…<br />collapsed_media_6
@@ Line 772: / Line 796: @@
 | <code>label m</code><br />…<br /><code>label r</code>
 | label of a figure (needed only for text reference)
+|-
+| collapsed_media_width<br />collapsed_media_height
+| media
+| 150
+| <code>extra images width</code><br /><code>extra images height</code>
+| Width, height of all hidden images (default: 200)
+|-
+| collapsed_media_1_width<br />…<br />collapsed_media_5_width<br /><br />collapsed_media_1_height<br />…<br />collapsed_media_5_height
+| media
+| 150
+| <code>image m width</code><br />…<br /><code>image r width</code><br /><br /><code>image m height</code><br />…<br /><code>image r height</code>
+| Width, height of induvidual hidden images (default: 200)
 |-
 | collapsed_media_captionlines
@@ Line 927: / Line 963: @@
 | Sisymbrion, Alysso-Sedion, Caucalidion
 | {{Tlx|Lead|occurrence ecology typo&#61;string}}
-| Pflanzensoziologie
+| plant sociology
 |-
 | occurrence_ecology_values
@@ Line 968: / Line 1,004: @@
 ! Parameter{{br}} Column Head !! Type !! Template Parameter{{br}} (Correspondence) !! Comment
 |-
-| author_treatment_hidden_comment
+| taxon_treatment_hidden_comment
 | meta data
-| author treatment hidden comment
+| taxon treatment hidden comment
 | hidden comment
 |-
-| author_treatment_hidden_comment
+| taxon_treatment_hidden_comment
 | attribute of decision
-| author treatment hidden comment
+| taxon treatment hidden comment
 | hidden comment
 |-
@@ Line 991: / Line 1,027: @@
 | attribute of decision
 | result id list
-| checklist ID. Converted to <code style="color:gray;">&lt;span class="<span style="color:black;">hide</span>" data-term="checklist_id" data-prefix="checklist">2013479&lt;/span></code>. Hidden by CSS-layout-rules ([[MediaWiki:Common.css]]).
+| checklist ID. Converted to <code style="color:gray;">&lt;span class="<span style="color:black;">hide</span>" data-term="checklist_id" data-prefix="Checklist">2013479&lt;/span></code>. Hidden by CSS-layout-rules ([[MediaWiki:Common.css]]).
 |-
 | infoflora_id
 | attribute of decision
 | result id list
-| infoflora ID. Converted to <code style="color:gray;">&lt;span class="<span style="color:black;">hide</span>" data-term="infoflora_id" data-prefix="checklist">2013479&lt;/span></code>. Hidden by CSS-layout-rules ([[MediaWiki:Common.css]]).
+| infoflora ID. Converted to <code style="color:gray;">&lt;span class="<span style="color:black;">hide</span>" data-term="infoflora_id" data-prefix="Infoflora">2013479&lt;/span></code>. Hidden by CSS-layout-rules ([[MediaWiki:Common.css]]).
 |-
 | isfs_id
 | attribute of decision
 | result id list
-| isfs ID. Converted to <code style="color:gray;">&lt;span class="<span style="color:black;">hide</span>" data-term="isfs_id" data-prefix="isfs">2013479&lt;/span></code>. Hidden by CSS-layout-rules ([[MediaWiki:Common.css]]).
+| isfs ID. Converted to <code style="color:gray;">&lt;span class="<span style="color:black;">hide</span>" data-term="isfs_id" data-prefix="ISFS">2013479&lt;/span></code>. Hidden by CSS-layout-rules ([[MediaWiki:Common.css]]).
 |}
 == Structure of a file for {{Tlx|ImageSwitch}} ==
-Die Bestimmung bei {{Tlx|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 {{Tlx|ImageSwitch}} mit einem Mal zu konvertieren, können Blöcke in der Bestimmungsmatrix sein. Jeder Block beginnt mit dem Seitennamen als „Überschrift“ sozusagen.
+The identification with {{Tlx|ImageSwitch}} or the “Bildweiche” is based on pictures, all being “shown at the same time”, usually only on one page. On another page, the key can be continued. To convert multiple {{Tlx|ImageSwitch}} at once, blocks of it can be provided in the identification matrix. Each Block begins with the page name, as a “heading” so to speak.
-Folgende Beispieltabelle soll das illustrieren (dem [http://offene-naturfuehrer.de/web/Start_BeachExplorer BeachExplorer] entnommen):
+The following example spread sheet is to illustrate (taken from [http://offene-naturfuehrer.de/web/Start_BeachExplorer beach Explorer]):
-# die erste Tabellenüberschrift kennzeichnet benutzerdefinierte Spaltenüberschriften, (die vom Konverter ignoriert werden)
+# the first table heading indicates the user-defined column headings (ignored by the converter)
-# die zweite Zeile der Spaltenüberschriften kennzeichnet die [[#Parameter ImageSwitch im Detail|''standardisierten Spaltenparameter'']], die für eine Konvertierung verwendet werden können.
+# the second line of the column headings indicates the [[#Parameter ImageSwitch im Detail|“standardized column parameters”]], which can be used for a conversion.
 <div style="height:800px;overflow:scroll;border: 2px inset gray;padding:1ex;font-size:smaller;">
@@ Line 1,113: / Line 1,150: @@
 | 4
 | BExID:9900040
-| Haut weich, Körperform sehr verschieden
+| skin soft, body shape very diverse
 | File:BEQ4A W Weiche Tiere.jpg
-| Weichhäutige Tiere
+| soft-skinned animals
-| Weichhäutige Tiere
+| soft-skinned animals
 |
@@ Line 1,128: / Line 1,165: @@
 | 5
 | BExID:9900050
-| Verzweigt, festgewachsen, pflanzenartig
+| branched, firmly grown, plant-like
 | File:BEQ5A G Gewaechse Knubbel.jpg
-| Gewächse, Kruste, Knubbel
+| growths, crust, lumps
-| Gewächse, Kruste, Knubbel
+| growths, crust, lumps
 |
@@ Line 1,143: / Line 1,180: @@
 | 6
 | BExID:9900060
-| Löcher, Röhren, Spuren aller Art
+| holes, tubes, all kinds of traces
 | File:BEQ6A L Loecher Roehren.jpg
-| Löcher und Röhren
+| holes and tubes
-| Löcher und Röhren
+| holes and tubes
 |
@@ Line 1,158: / Line 1,195: @@
 | 7
 | BExID:9900070
-| Mit Chitinpanzer, meist Landtiere
+| with chitinous carapace, mostly land animals
 | File:BEQ7A I Kaeferspülsaum.jpg
-| Insekten und Gliedertiere
+| insects and arthropods
-| Insekten und Gliedertiere
+| insects and arthropods
 |
@@ Line 1,173: / Line 1,210: @@
 | 8
 | BExID:9800080
-| Plastik, Holz, Steine, Knochen
+| plastic, wood, stones, bones
 | File:BEQ8A M HolzSteinMüll.jpg
-| Müll, Holz und Steine
+| wast, wood and stones
-| Müll, Holz und Steine
+| wast, wood and stones
 |
@@ Line 1,188: / Line 1,225: @@
 | 9
 | BExID:9800090
-| Merkwürdigkeiten & Rätsel
+| peculiarities & riddles
 | File:BEQ9A D Dinger.jpg
-| Eier, Kleckse & Rätseldinger
+| eggs, blobs & puzzle things
-| Eier, Kleckse & Rätseldinger
+| eggs, blobs & puzzle things
 |
@@ Line 1,220: / Line 1,257: @@
 |
 |
-| Robben
+| pinnipeds, seals
 |
 | Rainer Borcherding
@@ Line 1,233: / Line 1,270: @@
 | 1
 | BExID:1370841
-| Bis 1,6 m, Schnauze kurz, Backenzähne dreispitzig
+| Up to 1.6 m, muzzle short, molars three-pointed
 | File:BEQ1E VR Seehund.jpg
-| Seehund
+| Harbor seal
-| Seehund
+| Harbor seal
 |
@@ Line 1,248: / Line 1,285: @@
 | 2
 | BExID:1370801
-| Bis 2,3 m, Schnauze lang, Backenzähne einspitzig
+| Up to 2.3 m, muzzle short, molars single pointed
 | File:BEQ1E VR Kegelrobbe.jpg
-| Kegelrobbe
+| Grey seal
-| Kegelrobbe
+| Grey seal
 |
@@ Line 1,263: / Line 1,300: @@
 | 3
 | BExID:1370831
-| Bis 1,6 m, Schnauze sehr kurz, Bauch ungefleckt, sonst Ringe
+| Up to 1.6 m, muzzle very short, belly unspotted, otherwise rings
 | File:BEQ1E VR Ringelrobbe.jpg
-| Ringelrobbe
+| Ringed seal
-| Ringelrobbe
+| Ringed seal
 |
@@ Line 1,278: / Line 1,315: @@
 | 4
 | BExID:1370821
-| Bis 1,9 m, Schnauze lang und flach, schwarzer Rückensattel
+| Up to 1.9 m, muzzle long and flat, black back saddle
 | File:BEQ1E VR Sattelrobbe.jpg
-| Sattelrobbe
+| Harp seal
-| Sattelrobbe
+| Harp seal
 |
@@ Line 1,293: / Line 1,330: @@
 | 5
 | BExID:1370781
-| Bis 2,6 m, auffallend schwarz auf hell gefleckt
+| Up to 2.6 m, conspicuous black on light spotted
 | File:BEQ1E VR Klappmuetze.jpg
-| Klappmütze
+| Hooded seal
-| Klappmütze
+| Hooded seal
 |
@@ Line 1,308: / Line 1,345: @@
 | 6
 | BExID:1370791
-| Bis 2,5 m, kleiner Kopf, lange Barthaare, kaum gemustert
+| Up to 2.5 m, small head, long whiskers, hardly patterned
 | File:BEQ1E VR Bartrobbe.jpg
-| Bartrobbe
+| Bearded seal
-| Bartrobbe
+| Bearded seal
 |
@@ Line 1,323: / Line 1,360: @@
 | 7
 | BExID:1370771
-| Vorderbeine mit Gelenk, sehr plump und fett
+| front legs with joint, very clumsy and fat
 | File:BEQ1B VR Walross sonnend.jpg
-| Walross
+| Walrus
-| Walross
+| Walrus
 |
@@ Line 1,364: / Line 1,401: @@
 | identification
 | decision_alternative_number
-| Indexnummer der Alternativen innerhalb des Schlüssels (innerhalb der decision_number, der Entscheidung)
+| Index number of the alternatives within the key (within the decision_number, of the decision)
 | 1 … 30 in <code>lead ''1''</code> … <code>lead ''30''</code>
 |-
-| Mitarbeit
+| contribution
 | creators
-| Urheber oder Liste der Urheber (interprätiert als Urheber des Schlüssels)
+| Author or list of authors (interpreted as author of the key)
 | <code>creators</code>
 |-
-| Mitarbeit
+| contribution
 | contributors
-| Mitarbeier oder Liste der Mitarbeiter (interprätiert als Mitarbeiter des Schlüssels)
+| contributor or list of contributors (interpreted as contributors of the key)
 | <code>contributors</code>
@@ Line 1,382: / Line 1,419: @@
 | ID
 | decisionkey_id
-| id des Schlüssels auf der Wikiseite selbst (ist nur anzugeben, falls sich mehrere Schlüssel auf einer Seite befinden)
+| id of the key on the wiki page itself (only to be specified if there are several keys on one page)
 | <code>id</code>
 |-
-| Klassifikation
+| classification
 | decisionkey_rating
-| Bewertung in Zahlenform (1=am niedrigsten, … 5=am höchsten;  global für alle spezifizierbar beim Konvertieren)
+| rating in numerical form (1=the lowest, ... 5=the highest; can be specified globally for all when converting)
 | <code>rating</code>
 |-
-| Klassifikation
+| classification
 | decisionkey_recommendation_group
-| Empfehlungsklasse für den Schlüssel, z.B. „Pflanzenbestimmung (Anfänger)“ und dgl. (global für alle spezifizierbar beim Konvertieren)
+| recommendation class for the key, e.g. “Plant identification (beginner)” and so forth (can be specified globally for all when converting)
 | <code>recommendation group</code>
 |-
-| Medien
+| media
 | primary_media_width
-| Bilderbreite  (global für alle spezifizierbar beim Konvertieren)
+| width of image (can be specified globally for all when converting)
 | <code>image width</code>
 |-
-| Medien
+| media
 | primary_media
-| vollständiger Dateiname der Mediendatei, als '''„Datei:Dateiname.jpg“'''
+| full file name of the media file, as '''“File:filename.jpg”'''
 | <code>image 1</code> … <code>image 30</code>
 |-
-| Layout, Medien
+| layout, media
 | primary_media_caption_lines
-| die ungefähre Anzahl der Bildbeschriftungs-Zeilen (global für alle spezifizierbar beim Konvertieren)
+| the approximate number of caption lines of an image (globally specifiable for all when converting)
 | <code>caption lines</code>
 |-
-| Layout, Medien
+| layout, media
 | primary_media_caption_style
-| CSS-Stil der Bilderbeschriftung (global für alle spezifizierbar beim Konvertieren)
+| CSS style of image caption (globally specifiable for all when converting)
 | <code>caption style</code>
 |-
-| Layout, Schlüssel
+| layout, key
 | decisionkey_style
-| CSS-Stil des gesamten Schlüssels (global für alle spezifizierbar beim Konvertieren)
+| CSS style of the whole key (globally specifiable for all when converting)
 | <code>style</code>
 |-
-| Layout, Schlüssel
+| layout, key
 | decisionkey_format
-| 2 Formate verfügbar: „result link top result text bottom“ oder „result link bottom result text top“ (global für alle spezifizierbar beim Konvertieren)
+| 2 formats are available: “result link top result text bottom” or “result link bottom result text top” (globally specifiable for all when converting)
 | <code>layout format</code>
 |-
-| Ergebnis
+| result
 | reuslt_text
-| Anzeigetext des Ergebnisses
+| display text of the result
 | <code>result text 1</code> … <code>result text 30</code>
 |-
-| Ergebnis
+| result
 | result_link
-| Linkziel des Ergebnisses (Seite oder URL)
+| the result’s link target (page or URL)
 | <code>result 1</code> … <code>result 30</code>
@@ Line 1,448: / Line 1,485: @@
 | ID
 | result_id
-| eine Ergebnis ID, die der Autor in den Schlüsseldaten einpflegen möchte. Die Result-ID sollte ein Präfix haben um die ID eindeutig zu machen. Hinweis: eine Ergebnis-ID ist dann sinnvoll, wenn sich danach eine Artseite anschließt.
+| is a result ID that the author wants to include in the key data. The result ID should have a prefix to make the ID unique. Note: a result ID is useful if a species page will follow.
 | <code>result id 1</code> … <code>result id 30</code>
 |-
-| Ergebnis
+| result
 | common_names_da<br/>common_names_de<br/>common_names_dk<br/>common_names_el<br/>common_names_en<br/>common_names_es<br/>common_names_et<br/>common_names_fi<br/>common_names_fr<br/>common_names_it<br/>common_names_lt<br/>common_names_lv<br/>common_names_nl<br/>common_names_no<br/>common_names_pl<br/>common_names_pt<br/>common_names_ru<br/>common_names_sv
-| Liste umgangssprachlicher Namen für jede Sprache eine Spalte (…_da: Dänisch, …_de:Deutsch usw.; Präfix „@de:“ wird hinzugefügt)
+| List of common names for each language one column (…_da: Danish, …_de:German etc.; prefix “@de:” is added)
 | <code>common names 1</code> … <code>common names 30</code>
 |-
-| Ergebnis
+| result
 | scientific_name
-| Wissenschaftlicher Name
+| scientific name
 | <code>scientific name 1</code> … <code>scientific name 30</code>
 |-
-| Überschrift
+| heading
 | decisionkey_title
-| Überschrift des Schlüssels
+| heading of the key
 | <code>title</code>
@@ Line 1,504: / Line 1,541: @@
 Possible solutions, for the {{Tlx|Key Start}} with {{Tlx|Lead}}:
 * do the columns [[#Parameter decision_number|<code>decision_number</code>]] and <code>decision_alternative_number</code> have continued index numbers, even in the nested mode of determination?
+* is the [[#Parameter alternative_text|<code>decision_alternative_text</code>]] intended to be a kind of (sub)section in between, then use instead <code>decision_heading</code>.
 ----
-'''Anmerkungen:'''
+'''Remarks:'''
 <references />
 [[{{ns:category}}: Hilfe{{translation}}]]
 [[fr:Aide:Convertir des tableaux dans modèle clé de décision]]