task #7811: Import higher classifications - EDIT - EDIT Project Management

Custom queries

5.33
cdm-dataportal (open)
last 7 days tickets
mine in current release
phycobank
phycobank-index-closed
phycobank-registration-closed
potentially missed issues
recently updated
Release3.7
Release3.8
Release4.0
Release4.1
Release4.10
Release4.11
Release4.12
Release4.13
Release4.14
Release4.16
Release4.2
Release4.3
Release4.4
Release4.5
Release4.6
Release4.7
Release4.8
Release4.9
Release4.9
Release5.0
Release5.1
Release5.10
Release5.11
Release5.12
Release5.13
Release5.14
Release5.15
Release5.16
Release5.17
Release5.18
Release5.19
Release5.2
Release5.20
Release5.21
Release5.22
Release5.23
Release5.24
Release5.25
Release5.26
Release5.27
Release5.28
Release5.29
Release5.3
Release5.30
Release5.31
Release5.32
Release5.33
Release5.34
Release5.35
Release5.36
Release5.37
Release5.38
Release5.39
Release5.4
Release5.40
Release5.41
Release5.5
Release5.6
Release5.7
Release5.8
Release5.9
Remoting-Versions
Taxeditor-UX (Platform Etablierung)

Actions

Copy link

task #7811

open

Import higher classifications

Added by Andreas Kohlbecker over 5 years ago. Updated about 1 year ago.

Status:

Feedback

Priority:

Priority10

Assignee:

Wolf-Henning Kusber

Category:

data

Target version:

Release 5.5

Start date:

Due date:

% Done:

90%

Estimated time:

Severity:

minor

Tags:

phycobank

Description

The following classifications need to be imported using the import created for #7420

Frey W. 2015: Syllabus of the plant families. Borntraeger, Stuttgart.
1. spreadsheet preparation: almost ready, data in sheet is being reviewed by henning
2. import: pending
WoRMS World Register of Marine Species. [2018-04-20] http://www.marinespecies.org/index.php
1. spreadsheet preparation: TODO
2. import: TODO

Files

Algen_Syllabus_Produktion_2019-01-08_Import.xlsx (198 KB) Algen_Syllabus_Produktion_2019-01-08_Import.xlsx

Import file for PhycoBank Backbone

Wolf-Henning Kusber, 01/08/2019 07:12 PM

Related issues

Copied from EDIT - task #7420: Import for higher taxon graph for phycobank

Closed

Andreas Müller

Actions

Copied to EDIT - bug #10272: Import WoRMS (and other) higher classifications for Phycobank

New

Andreas Müller

Actions

Issue # Delay: days Cancel

History
Notes
Property changes

Actions

Copy link

Updated by Andreas Kohlbecker over 5 years ago

Status changed from New to In Progress
% Done changed from 0 to 10

Actions

Copy link

Updated by Andreas Kohlbecker over 5 years ago

Copied from task #7420: Import for higher taxon graph for phycobank added

Actions

Copy link

Updated by Wolf-Henning Kusber over 5 years ago

related to #7948

Actions

Copy link

Updated by Wolf-Henning Kusber over 5 years ago

File Algen_Syllabus_Produktion_2019-01-08_Import.xlsx Algen_Syllabus_Produktion_2019-01-08_Import.xlsx added
Assignee changed from Wolf-Henning Kusber to Andreas Müller

The Excel file is finished for a test import.
May be there are minor issues (duplicates etc.)

The file includes 3404 genus names from 5 references.
Updated file structure documented in https://dev.e-taxonomy.eu/redmine/issues/7948#note-1

Please note that two collumns differ from the first test import.
Collumn A is the PhycoBank-UUID of the used reference.
Collumn J "Stop" includes a hashtag to stop the import within one line (new)

Actions

Copy link

Updated by Andreas Kohlbecker over 5 years ago

Project changed from PhycoBank to EDIT
Category deleted (~~Import~~)
Status changed from In Progress to Resolved
Target version deleted (~~Registry released~~)
Severity set to normal

Actions

Copy link

Updated by Andreas Kohlbecker over 5 years ago

Category set to data
Target version set to Release 5.5
Severity changed from normal to critical

Actions

Copy link

Updated by Andreas Müller about 5 years ago

Priority changed from Highest to Priority14

Actions

Copy link

Updated by Andreas Müller about 5 years ago

Also there is a new column subfam. As rank columns are hardcoded in import code all new columns need to be explicitly mentioned before import.

Actions

Copy link

Updated by Andreas Müller about 5 years ago

Priority changed from Priority14 to Highest

Eolimna exists twice in 03c791d0-2da4-42d0-8bc6-15a2154ad241. Once as direct child of Naviculales (line 754), other time as child of Naviculales-Sellaphorineae-Sellaphoraceae (line 721)

Actions

Copy link

#10

Updated by Andreas Müller about 5 years ago

Ordo of Polypodochrysis in 03c791d0-2da4-42d0-8bc6-15a2154ad241 (Pinguioch r ysidales)
differs from above Ordo (Pinguiochysidales). Seems to be a typo.

Actions

Copy link

#11

Updated by Wolf-Henning Kusber about 5 years ago

#9
Eolimna exists twice in 03c791d0-2da4-42d0-8bc6-15a2154ad241.
To be deleted: Once as direct child of Naviculales (line 754)
Correct one: as child of Naviculales-Sellaphorineae-Sellaphoraceae (line 721)

#10
Ordo of Polypodochrysis in 03c791d0-2da4-42d0-8bc6-15a2154ad241 (Pinguioch r ysidales)
differs from above Ordo (Pinguiochysidales). Seems to be a typo.
It's the other way round

Ordo=Pinguiochrysidales (with "r") is the correct one (Line 838)
Typo: Ordo=Pinguiochysidales - It should be Pinguiochrysidales
4x Ordo in lines 834, 835, 836, 837 to be corrected

Actions

Copy link

#12

Updated by Andreas Müller about 5 years ago

Gymnocystodinium exists 2x in 174d5905-9b28-406d-8e15-98958123b4ae: with parent Gymnodiniaceae and child Gymnodinium and with parent Phytodiniaceae
and child Cystodinium.

Actions

Copy link

#13

Updated by Andreas Müller about 5 years ago

% Done changed from 10 to 30

Arachnophyllum exists 2x in ae5e4774-9657-4910-812c-937e2ebe5647. Once as child of Delesserioideae, 2nd time as child of Nitophylloideae

Actions

Copy link

#14

Updated by Andreas Müller about 5 years ago

Wolf-Henning Kusber wrote:

#9
Eolimna exists twice in 03c791d0-2da4-42d0-8bc6-15a2154ad241.
To be deleted: Once as direct child of Naviculales (line 754)
Correct one: as child of Naviculales-Sellaphorineae-Sellaphoraceae (line 721)

#10
Ordo of Polypodochrysis in 03c791d0-2da4-42d0-8bc6-15a2154ad241 (Pinguioch r ysidales)
differs from above Ordo (Pinguiochysidales). Seems to be a typo.
It's the other way round

Ordo=Pinguiochrysidales (with "r") is the correct one (Line 838)
Typo: Ordo=Pinguiochysidales - It should be Pinguiochrysidales
4x Ordo in lines 834, 835, 836, 837 to be corrected

I deleted line 754 and updated line 834-837

Actions

Copy link

#15

Updated by Wolf-Henning Kusber about 5 years ago

Gymnocystodinium exists 2x in 174d5905-9b28-406d-8e15-98958123b4ae: with parent Gymnodiniaceae and child Gymnodinium and with parent Phytodiniaceae
and child Cystodinium.

Achtung: Cystodinium and Gymnodinium are not childs of Gymnocystodinium because they are behind the decided stop-sign = #

correct: Gymnocystodinium exists 2x in 174d5905-9b28-406d-8e15-98958123b4ae: with parent Gymnodiniaceae
false: Gymnodinium and with parent Phytodiniaceae = to be deleted

Actions

Copy link

#16

Updated by Wolf-Henning Kusber about 5 years ago

% Done changed from 30 to 10

Arachnophyllum exists 2x in ae5e4774-9657-4910-812c-937e2ebe5647. Once as child of Delesserioideae, 2nd time as child of Nitophylloideae
Correct: Arachnophyllum as child of Nitophylloideae
False: Arachnophyllum as child of Delesserioideae = to be deleted

Actions

Copy link

#17

Updated by Andreas Müller about 5 years ago

% Done changed from 10 to 30

Navicula exists 2x as accepted taxon in Phycobank, with 2 different authors. During import of 03c791d0-2da4-42d0-8bc6-15a2154ad241 Navicula Grunow was arbitrarily taken. Please correct in production if not correct.

Actions

Copy link

#18

Updated by Wolf-Henning Kusber about 5 years ago

Navicula Grunow is an old import error to be deleted

Navicula Bory is the only right one

Actions

Copy link

#19

Updated by Andreas Müller about 5 years ago

Wolf-Henning Kusber wrote:

Gymnocystodinium exists 2x in 174d5905-9b28-406d-8e15-98958123b4ae: with parent Gymnodiniaceae and child Gymnodinium and with parent Phytodiniaceae
and child Cystodinium.

Achtung: Cystodinium and Gymnodinium are not childs of Gymnocystodinium because they are behind the decided stop-sign = #

correct: Gymnocystodinium exists 2x in 174d5905-9b28-406d-8e15-98958123b4ae: with parent Gymnodiniaceae
false: Gymnodinium and with parent Phytodiniaceae = to be deleted

I updated the data accordingly

Actions

Copy link

#20

Updated by Andreas Müller about 5 years ago

Wolf-Henning Kusber wrote:

Arachnophyllum exists 2x in ae5e4774-9657-4910-812c-937e2ebe5647. Once as child of Delesserioideae, 2nd time as child of Nitophylloideae
Correct: Arachnophyllum as child of Nitophylloideae
False: Arachnophyllum as child of Delesserioideae = to be deleted

I updated the data accordingly

Actions

Copy link

#21

Updated by Andreas Müller about 5 years ago

Wolf-Henning Kusber wrote:

Navicula Grunow is an old import error to be deleted

Navicula Bory is the only right one

The name itself needs to be deleted? It exists 2x as synonym of Astartiella bahusiensis (Grunow) Witk. and as accepted taxon in the new classification. If name is to be deleted what is the basionym of Astartiella bahusiensis (Grunow) Witk. then?

Actions

Copy link

#22

Updated by Andreas Müller about 5 years ago

Euastrum exists with 2 authors. Arbitrarily Euastrum Ralfs, Brit. Desmid.: 49, 78. 1848 has been taken for import of 03c791d0-2da4-42d0-8bc6-15a2154ad241. Please check correctnes.

By the way Euastrum Ehrenb. und Euastrum carteri D.B.Will. seem currently to be registered in preparation. Correct? Therefore they have no taxon relationships yet.

Actions

Copy link

#23