Difference between revisions of "Import description matrix (Artenquiz)"
From Biowikifarm Metawiki
m (Tags → Upper case Identification) |
m (→Metadata rows: +notes on creators / contributors) |
||
| Line 35: | Line 35: | ||
==Metadata rows== | ==Metadata rows== | ||
| − | Below the main matrix table | + | Below the main matrix table must be a blank row followed by the word <code>[METADATA]</code> 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: |
{| class="wikitable" | {| class="wikitable" | ||
| Line 50: | Line 50: | ||
|<!-- -->'''Creators:''' ||<!-- -->A. First; B. Second | |<!-- -->'''Creators:''' ||<!-- -->A. First; B. Second | ||
|- | |- | ||
| − | |<!-- -->Emails: ||<!-- -->first@ | + | |<!-- -->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. <small>(Mapping to SDD:Dataset/Representation/Detail)</small><br/> | |<!-- -->Description: ||<!-- -->Free form text, including information about source of information, literature used, geographic or taxonomic scope, etc. <small>(Mapping to SDD:Dataset/Representation/Detail)</small><br/> | ||
| Line 71: | Line 75: | ||
; Copyright : … | ; Copyright : … | ||
; License : … | ; License : … | ||
| − | ; Creators : semicolon separated list | + | ; Creators : (mandatory) semicolon separated list |
| − | ; Description : Free form text, including information about source of information, literature used, geographic or taxonomic scope, etc. <small>(Mapping to SDD:Dataset/Representation/Detail)</small> | + | ; 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. <small>(Mapping to SDD:Dataset/Representation/Detail)</small> | |
| − | ; Tags : an internal (filter) tagging label, e.g. Identification (semicolon separated list) | + | ; Language : (mandatory) language code ([http://en.wikipedia.org/wiki/ISO_639-1 ISO-639-1]) |
| − | ; Title : a concise title | + | ; Tags : (optional) an internal (filter) tagging label, e.g. Identification (semicolon separated list) |
| + | ; Title : (mandatory) a concise title | ||
==== Taxonomic fields: ==== | ==== Taxonomic fields: ==== | ||
| − | + | ; Kingdom : (mandatory) | |
| − | + | ; Phylum, Division : … | |
| − | + | ; Class : … | |
| − | + | ; Subclass : … | |
| − | + | ; Order : … | |
| − | + | ; Suborder : … | |
| − | + | ; Family : … | |
| − | + | ; Subfamily : … | |
[[Category: Import]] | [[Category: Import]] | ||
Revision as of 11:44, 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
- …
