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

Latest revision as of 13:46, 25 August 2017

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	Haut weich, Körperform sehr verschieden	File:BEQ4A W Weiche Tiere.jpg	Weichhäutige Tiere	Weichhäutige Tiere
					1	5	BExID:9900050	Verzweigt, festgewachsen, pflanzenartig	File:BEQ5A G Gewaechse Knubbel.jpg	Gewächse, Kruste, Knubbel	Gewächse, Kruste, Knubbel
					1	6	BExID:9900060	Löcher, Röhren, Spuren aller Art	File:BEQ6A L Loecher Roehren.jpg	Löcher und Röhren	Löcher und Röhren
					1	7	BExID:9900070	Mit Chitinpanzer, meist Landtiere	File:BEQ7A I Kaeferspülsaum.jpg	Insekten und Gliedertiere	Insekten und Gliedertiere
					1	8	BExID:9800080	Plastik, Holz, Steine, Knochen	File:BEQ8A M HolzSteinMüll.jpg	Müll, Holz und Steine	Müll, Holz und Steine
					1	9	BExID:9800090	Merkwürdigkeiten & Rätsel	File:BEQ9A D Dinger.jpg	Eier, Kleckse & Rätseldinger	Eier, Kleckse & Rätseldinger
…	…	…	…	…	…	…	…	…	…	…	…	…
					3	0				Robben		Rainer Borcherding
Seehund	Harbour seal	Gewone zeehond	Spættet sæl	Phoca vitulina	3	1	BExID:1370841	Bis 1,6 m, Schnauze kurz, Backenzähne dreispitzig	File:BEQ1E VR Seehund.jpg	Seehund	Seehund
Kegelrobbe	Grey seal	Grijze zeehond	Gråsæl	Halichoerus grypus	3	2	BExID:1370801	Bis 2,3 m, Schnauze lang, Backenzähne einspitzig	File:BEQ1E VR Kegelrobbe.jpg	Kegelrobbe	Kegelrobbe
Ringelrobbe	Ringed Seal	Ringelrob	Ringsæl	Phoca hispida	3	3	BExID:1370831	Bis 1,6 m, Schnauze sehr kurz, Bauch ungefleckt, sonst Ringe	File:BEQ1E VR Ringelrobbe.jpg	Ringelrobbe	Ringelrobbe
Sattelrobbe	Harp seal	Zadelrob	Grønlandssæl	Pagophilus groenlandicus	3	4	BExID:1370821	Bis 1,9 m, Schnauze lang und flach, schwarzer Rückensattel	File:BEQ1E VR Sattelrobbe.jpg	Sattelrobbe	Sattelrobbe
Klappmütze	Hooded seal	Klapmuts	Klapmyds	Cystophora cristata	3	5	BExID:1370781	Bis 2,6 m, auffallend schwarz auf hell gefleckt	File:BEQ1E VR Klappmuetze.jpg	Klappmütze	Klappmütze
Bartrobbe	Bearded seal	Baardrob	Remmesæl	Erignathus barbatus	3	6	BExID:1370791	Bis 2,5 m, kleiner Kopf, lange Barthaare, kaum gemustert	File:BEQ1E VR Bartrobbe.jpg	Bartrobbe	Bartrobbe
Walross	Walrus	Walrus	Hvalros	Odobenus rosmarus	3	7	BExID:1370771	Vorderbeine mit Gelenk, sehr plump und fett	File:BEQ1B VR Walross sonnend.jpg	Walross	Walross

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	Indexnummer der Alternativen innerhalb des Schlüssels (innerhalb der decision_number, der Entscheidung)	1 … 30 in `lead 1` … `lead 30`
Mitarbeit	creators	Urheber oder Liste der Urheber (interprätiert als Urheber des Schlüssels)	`creators`
Mitarbeit	contributors	Mitarbeier oder Liste der Mitarbeiter (interprätiert als Mitarbeiter des Schlüssels)	`contributors`
ID	decisionkey_id	id des Schlüssels auf der Wikiseite selbst (ist nur anzugeben, falls sich mehrere Schlüssel auf einer Seite befinden)	`id`
Klassifikation	decisionkey_rating	Bewertung in Zahlenform (1=am niedrigsten, … 5=am höchsten; global für alle spezifizierbar beim Konvertieren)	`rating`
Klassifikation	decisionkey_recommendation_group	Empfehlungsklasse für den Schlüssel, z.B. „Pflanzenbestimmung (Anfänger)“ und dgl. (global für alle spezifizierbar beim Konvertieren)	`recommendation group`
Medien	primary_media_width	Bilderbreite (global für alle spezifizierbar beim Konvertieren)	`image width`
Medien	primary_media	vollständiger Dateiname der Mediendatei, als „Datei:Dateiname.jpg“	`image 1` … `image 30`
Layout, Medien	primary_media_caption_lines	die ungefähre Anzahl der Bildbeschriftungs-Zeilen (global für alle spezifizierbar beim Konvertieren)	`caption lines`
Layout, Medien	primary_media_caption_style	CSS-Stil der Bilderbeschriftung (global für alle spezifizierbar beim Konvertieren)	`caption style`
Layout, Schlüssel	decisionkey_style	CSS-Stil des gesamten Schlüssels (global für alle spezifizierbar beim Konvertieren)	`style`
Layout, Schlüssel	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)	`layout format`
Ergebnis	reuslt_text	Anzeigetext des Ergebnisses	`result text 1` … `result text 30`
Ergebnis	result_link	Linkziel des Ergebnisses (Seite oder URL)	`result 1` … `result 30`
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.	`result id 1` … `result id 30`
Ergebnis	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	Liste umgangssprachlicher Namen für jede Sprache eine Spalte (…_da: Dänisch, …_de:Deutsch usw.; Präfix „@de:“ wird hinzugefügt)	`common names 1` … `common names 30`
Ergebnis	scientific_name	Wissenschaftlicher Name	`scientific name 1` … `scientific name 30`
Überschrift	decisionkey_title	Überschrift des Schlüssels	`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.

Anmerkungen:

↑ any literature sources?

[1] y literature sources?

[1]

@@ 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,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>.
 ----

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

Latest revision as of 13:46, 25 August 2017

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