Project

General

Profile

bug #6276

PhycoBank - task #6009: Import the IAPT database into a cdm instance

PhycoBank - task #6034: DataCleaning after final import

Nomenclatural references show parsed date string instead of publication year

Added by Andreas Kohlbecker over 3 years ago. Updated about 1 month ago.

Status:
Closed
Priority:
Highest
Category:
cdmlib
Target version:
Start date:
12/13/2016
Due date:
% Done:

100%

Estimated time:
4.00 h
Severity:
normal
Found in Version:

Description

For example 'Staurastrum longebrachiatum var. quadrifidum (Grönblad) A.A.Gontsch.' in the phycobank database:

The nomenclatural titlecache as shown in the Taxeditor details view and in the name contains the parsed date string: '10.1998'
But the date string has been parsed correctly and the titleCache of the reference correctly contains only the year.

During the attempt to fix this the Reference editor behaves surprisingly strange:

  1. Deleting the text in the parse field causes the atomized date to be deleted also. This was impossible to recover, the date data was lost afterwards.
  2. Adding the atomized data manually finally fixes the titleCache of the nomenclatural reference.

I think the nomencaltural reference should use same the titleCache as the reference.

nomref-titlecache.png View (94.8 KB) Andreas Kohlbecker, 12/13/2016 02:53 PM

picture288-1.png View (3.35 KB) Andreas Müller, 09/06/2018 03:43 PM

Associated revisions

Revision bf3b1132 (diff)
Added by Andreas Müller about 1 month ago

ref #9071, ref #6276 Change TimePeriodFormatting to YYYY-MMM-DD

Revision ce666ef3 (diff)
Added by Andreas Müller about 1 month ago

ref #9071, ref #6276 fix order of TimePeriodFormatting to DD MMM YYYY

Revision fddcac5e (diff)
Added by Andreas Müller about 1 month ago

ref #9071, ref #6276 fix order of TimePeriodFormatting to DD MMM YYYY (cont.)

Revision b0ceec1a (diff)
Added by Andreas Müller about 1 month ago

ref #6276, ref 9071 adapt dataportal tests to new TimePeriod formatting

Revision def46519 (diff)
Added by Andreas Müller about 1 month ago

ref #9071, ref #6276 improve TimePeriod parsing for periods with shared year or month and some other

Revision e90c7158 (diff)
Added by Andreas Müller about 1 month ago

ref #6276, ref 9071 adapt dataportal tests to new TimePeriod formatting (cont.)

Revision 8fe64a0b (diff)
Added by Andreas Müller about 1 month ago

ref #9071, ref #6276 improve TimePeriod parsing with continued

Revision 4b24820e (diff)
Added by Andreas Müller about 1 month ago

ref #9071 improve with-month-name period parsing

History

#1 Updated by Andreas Kohlbecker over 3 years ago

  • Tags set to phycobank
  • Project changed from PhycoBank to Edit
  • Category set to cdmlib
  • Assignee set to Andreas Müller
  • Priority changed from New to Highest
  • Target version set to Release 4.5
  • Severity set to normal

Hi Andreas,

this issue is important for us. We need at least an idea of why this is happening and if the nomencaltural references can be easily fixed automatically or if manual action at ~1000 names is required. Therefore I am setting this to highest

Andreas

#3 Updated by Andreas Kohlbecker over 3 years ago

  • Description updated (diff)

#4 Updated by Andreas Müller over 3 years ago

  • Target version changed from Release 4.5 to Release 4.6

#5 Updated by Andreas Kohlbecker over 2 years ago

  • Target version changed from Release 4.6 to Release 4.13

i am moving this issue to the current release milestone so that it is not getting lost

#6 Updated by Andreas Müller over 2 years ago

  • Target version changed from Release 4.13 to Release 4.14

#7 Updated by Andreas Müller over 2 years ago

  • Target version changed from Release 4.14 to Release 5.0

#8 Updated by Andreas Müller about 2 years ago

  • Tags changed from phycobank to phycobank, euro+med
  • Description updated (diff)

#9 Updated by Andreas Müller about 2 years ago

  • Target version changed from Release 5.0 to Release 5.1
  • Estimated time set to 4.00 h

#10 Updated by Andreas Müller about 2 years ago

  • Subject changed from Nonemclatural references show parsed date string instead of publication year to Nomenclatural references show parsed date string instead of publication year

#11 Updated by Andreas Kohlbecker about 2 years ago

[Henning wrote:]

Im Produktionssystem wird als Publikationsdatum ein deutsches Datum eingesetzt. Es gibt auch ein Ticket dazu, dass ich diese Repräsentation nicht will. Das liegt daran, dass auch der amerikanische Standard oder das ISO-Datum hier nicht passt.

Ich möchte das Thema noch mal ansprechen, denn in den ICN-Apendices gibt es dasselbe Problem.

Kurzform:
Geht gar nicht (aktueller Stand): Surirella kerguelensis Grunow in A.W.F.Schmidt, Atlas Diatom.-Kunde: pl. 56: fig. 24. 15.8.1877

Wäre für PhyoBank okay: Surirella kerguelensis Grunow in A.W.F.Schmidt, Atlas Diatom.-Kunde: pl. 56: fig. 24. 15 Aug 1877.

So geht es im Augenblick nur und das ist nicht schön (Datum im gewünschten Format in Verbatim eingegeben): Surirella kerguelensis Grunow in A.W.F.Schmidt, Atlas Diatom.-Kunde: pl. 56: fig. 24. 15.8.1877 ["15 Aug 1877"]

In den ICN-Apendices gibt es dasselbe Problem.

Dort hat man das Problem so gelöst, dass das Publikationsdatum in einer international verständlichen Form in der zur Verfügung stehenden Genauigkeit angibt, im Pint (ICN) und in einer Datenbank (Appendix).

Das Format:

T oder TT

1
2
3
…
31


[dann ein Leerzeichen ohne Trenner, d.h. ohne Punkt oder Komma]

Monat (3 Buchstaben ohne Punkt abgekürzt, vom Lateinischen abgeleitet)

Jan
Feb
Mar
Apr
Mai
Jun
Jul
Aug
Sep
Oct
Nov
Dec

[dann ein Leerzeichen ohne Trenner, d.h. ohne Punkt oder Komma]

YYYY

Tatsächlich vorkommende Daten aus den gedruckten Appendicees mit Spannen:

… . 12 Mar 1807.
… . Jul-Aug. 1763

Im Gegensatz zur bisherigen Ausgabe könnte ich mit dem Format für PhycoBank gut leben.

#12 Updated by Andreas Müller about 2 years ago

  • Target version changed from Release 5.1 to Release 5.2

#13 Updated by Andreas Müller almost 2 years ago

  • Target version changed from Release 5.2 to Release 5.3

#14 Updated by Andreas Müller almost 2 years ago

  • Target version changed from Release 5.3 to Release 5.4

#16 Updated by Andreas Müller almost 2 years ago

Sorry, wrong ticket

#17 Updated by Andreas Müller almost 2 years ago

  • Target version changed from Release 5.4 to Release 5.5

#18 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 5.5 to Release 5.6

#19 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 5.6 to Release 5.7

#20 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 5.7 to Release 5.8

#21 Updated by Andreas Müller about 1 year ago

  • Target version changed from Release 5.8 to Release 5.10

#22 Updated by Andreas Müller 11 months ago

  • Target version changed from Release 5.10 to Release 5.11

#23 Updated by Andreas Müller 9 months ago

  • Target version changed from Release 5.11 to Release 5.12

#24 Updated by Andreas Müller 7 months ago

  • Target version changed from Release 5.12 to Release 5.13

#25 Updated by Andreas Müller 5 months ago

  • Target version changed from Release 5.13 to Release 5.14

#26 Updated by Andreas Müller 4 months ago

  • Target version changed from Release 5.14 to Release 5.15

#27 Updated by Andreas Müller about 2 months ago

  • Target version changed from Release 5.15 to Release 5.17

#28 Updated by Andreas Müller about 1 month ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 30

#29 Updated by Andreas Müller about 1 month ago

  • Status changed from In Progress to Resolved
  • Assignee changed from Andreas Müller to Andreas Kohlbecker
  • % Done changed from 30 to 70

This should be fixed now.

#30 Updated by Andreas Müller about 1 month ago

  • Target version changed from Release 5.17 to Release 5.16

#31 Updated by Andreas Kohlbecker about 1 month ago

  • Status changed from Resolved to Closed
  • % Done changed from 70 to 100

from what I've seen during the last days, this seems to be solved completely.

#32 Updated by Andreas Kohlbecker about 1 month ago

  • Assignee changed from Andreas Kohlbecker to Andreas Müller

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)