Difference between revisions of "Import description matrix (Artenquiz)"
From Biowikifarm Metawiki
m (→Metadata rows: +notes on creators / contributors) |
m (→Taxon columns) |
||
| Line 3: | Line 3: | ||
== Taxon columns == | == Taxon columns == | ||
<dl> | <dl> | ||
| − | <dd>The first column in the spreadsheet ''must always'' be the primary name of the organism (= taxon). If this is the only name column, it may be either the common or scientific name (but see below). | + | <dd style="margin-left: 1.95em;">The first column in the spreadsheet ''must always'' be the primary name of the organism (= taxon). If this is the only name column, it may be either the common or scientific name (but see below). |
| − | <dd> <dl style="border-left:1px solid gray"> | + | <dd style="margin-left: 1.95em;"> <dl style="border-left:1px solid gray"> |
| − | <dd> If any of the 2nd to 5th column is labeled "Scientific Name", "scientific name", or "Wissenschaftlicher Name", it will be considered the scientific name of the organism. The first column will be the common name. <!-- SDD: maps to representation/label in taxon, with xml:lang="zxx-x-taxon" --> | + | <dd style="margin-left: 1.95em;"> If any of the 2nd to 5th column is labeled "Scientific Name", "scientific name", or "Wissenschaftlicher Name", it will be considered the scientific name of the organism. The first column will be the common name. <!-- SDD: maps to representation/label in taxon, with xml:lang="zxx-x-taxon" --> |
| − | <dd> <dl style="border-left:1px solid gray"> | + | <dd style="margin-left: 1.95em;"> <dl style="border-left:1px solid gray"> |
| − | <dd> If any of the 2nd to 5th column is labeled "Images", "images", "Image", "image", "Bilder" or "Bild", it will be considered to contain a list of organism (taxon) images. Image references starting with http:// are direct web links, those starting with "File:" or "Datei:" are internal links to files. Each link must be written between double square brackets (e.g. <nowiki>[[File:...]]</nowiki>). No delimiter is needed for multiple images. | + | <dd style="margin-left: 1.95em;"> If any of the 2nd to 5th column is labeled "Images", "images", "Image", "image", "Bilder" or "Bild", it will be considered to contain a list of organism (taxon) images. Image references starting with http:// are direct web links, those starting with "File:" or "Datei:" are internal links to files. Each link must be written between double square brackets (e.g. <nowiki>[[File:...]]</nowiki>). No delimiter is needed for multiple images. |
| − | <dd> <dl style="border-left:1px solid gray"> | + | <dd style="margin-left: 1.95em;"> <dl style="border-left:1px solid gray"> |
| − | <dd> If any of the 2nd to 5th column is labeled "URL" or "url", it will be considered a link to a species or taxon page. Only links to web pages are supported (e.g. <nowiki>http://...</nowiki>) and each link must be written in double square brackets (<nowiki>[[http://...]]</nowiki>). | + | <dd style="margin-left: 1.95em;"> If any of the 2nd to 5th column is labeled "URL" or "url", it will be considered a link to a species or taxon page. Only links to web pages are supported (e.g. <nowiki>http://...</nowiki>) and each link must be written in double square brackets (<nowiki>[[http://...]]</nowiki>). |
| − | <dd> <dl style="border-left:1px solid gray"> | + | <dd style="margin-left: 1.95em;"> <dl style="border-left:1px solid gray"> |
| − | <dd> If any of the 2nd to 5th column is labeled "Scope", "scope", "Stadium", "Geltungsbereich" or "Gültigkeitsbereich" it will be considered a a scope like "female", "male", "juvenile", "adult", "larvae", "imago", "breeding plumage/Prachtkleid", "eclipse plumage/Schlichtkleid". Using this method, a single species with different appearances can be separately described in two different rows. | + | <dd style="margin-left: 1.95em;"> If any of the 2nd to 5th column is labeled "Scope", "scope", "Stadium", "Geltungsbereich" or "Gültigkeitsbereich" it will be considered a a scope like "female", "male", "juvenile", "adult", "larvae", "imago", "breeding plumage/Prachtkleid", "eclipse plumage/Schlichtkleid". Using this method, a single species with different appearances can be separately described in two different rows. |
<dd> <dl style="border-left:1px solid gray"><br/></dl> | <dd> <dl style="border-left:1px solid gray"><br/></dl> | ||
</dl> | </dl> | ||
Revision as of 11:47, 21 August 2013
Excel to SDD converter is the basis for this import module of the django application Artenquiz.
Taxon columns
- The first column in the spreadsheet must always be the primary name of the organism (= taxon). If this is the only name column, it may be either the common or scientific name (but see below).
- If any of the 2nd to 5th column is labeled "Scientific Name", "scientific name", or "Wissenschaftlicher Name", it will be considered the scientific name of the organism. The first column will be the common name.
- If any of the 2nd to 5th column is labeled "Images", "images", "Image", "image", "Bilder" or "Bild", it will be considered to contain a list of organism (taxon) images. Image references starting with http:// are direct web links, those starting with "File:" or "Datei:" are internal links to files. Each link must be written between double square brackets (e.g. [[File:...]]). No delimiter is needed for multiple images.
- If any of the 2nd to 5th column is labeled "URL" or "url", it will be considered a link to a species or taxon page. Only links to web pages are supported (e.g. http://...) and each link must be written in double square brackets ([[http://...]]).
- If any of the 2nd to 5th column is labeled "Scope", "scope", "Stadium", "Geltungsbereich" or "Gültigkeitsbereich" it will be considered a a scope like "female", "male", "juvenile", "adult", "larvae", "imago", "breeding plumage/Prachtkleid", "eclipse plumage/Schlichtkleid". Using this method, a single species with different appearances can be separately described in two different rows.
| ‹1› | ‹2› | ‹3› | ‹4› | ‹5› | ‹character_1› | ‹character_2› | … |
| … | … | … | … | … | … | … | … |
Metadata rows
Below the main matrix table must be a blank row followed by the word [METADATA] that indicates the start of key-wide metadata. Column one contains the metadata field name and the second column the corresponding value. The following fields are recommended:
| ‹DATA MATRIX› | ‹DATA MATRIX› |
| ‹blank line› | ‹blank line› |
| [METADATA] | |
| Title: | A key to XXX |
| Creators: | A. First; B. Second |
| Emails: | first@email.me; second@email.me |
| Contributors: | C. Name; D. Name |
| Emails: | cname@email.me; dname@email.me |
| Description: | Free form text, including information about source of information, literature used, geographic or taxonomic scope, etc. (Mapping to SDD:Dataset/Representation/Detail) |
| Language: | en |
| Kingdom: | Aves |
| Tags: | Identification |
| Copyright: | (c) A. First and B. Second 2010 |
| License: | Creative commons by-sa 3.0 |
Note: The field names (left column) are recognized with and without the colon (both Title: and Title are accepted).
Fields
- Copyright
- …
- License
- …
- Creators
- (mandatory) semicolon separated list
- Contributors
- (optional) semicolon separated list
- Emails
- (optional) emails that correspond to each creator (semicolon separated list). If “Contributors:” precedes “Emails:” then it will be treated as contributor's email. If “Creators:” precedes “Emails:” then it will be treated as creator's email
- Description
- (optional) Free form text, including information about source of information, literature used, geographic or taxonomic scope, etc. (Mapping to SDD:Dataset/Representation/Detail)
- Language
- (mandatory) language code (ISO-639-1)
- Tags
- (optional) an internal (filter) tagging label, e.g. Identification (semicolon separated list)
- Title
- (mandatory) a concise title
Taxonomic fields:
- Kingdom
- (mandatory)
- Phylum, Division
- …
- Class
- …
- Subclass
- …
- Order
- …
- Suborder
- …
- Family
- …
- Subfamily
- …
