Project

General

Profile

task #7796

[CHECK] Handle Bibliography Name Facts correctly

Added by Andreas Müller 4 months ago. Updated 3 months ago.

Status:
In Progress
Priority:
Priority14
Category:
cdmadapter
Target version:
Start date:
09/28/2018
Due date:
% Done:

80%

Estimated time:
0.50 h
Severity:
normal
Tags:

Description

There are 13568 name facts of type "Bibliography" (Cat=3).

These are currently attached to the according names as TaxonNameDescription with feature "Citation".

The citations seem to come from ILDIS but the names are also used in 7600000 so they often appear twice.

The Citations currently do not show up in the BM data portal. In CDM they show up as behind the name formatted like second nomenclatural references.

Decisions to take:

  • Should they show up in the data portal => probably not (see #7796#note-8)
  • Depending on this, keep them as TaxonName Citations or make them TaxonName extensions. The later may not show up in the portal by default.

Implementations:

  • If keeping them as TaxonNameDescriptions make these available by TaxEditor again
  • If extensions, implement extension import (with own feature)

picture897-1.png View (17.1 KB) Andreas Müller, 09/29/2018 01:20 AM


Related issues

Related to Edit - task #7435: ERS: Handle also published in correctly In Progress 05/24/2018
Duplicated by Edit - bug #7456: E+M: NameFacts von ILDIS Daten Duplicate 06/07/2018

Associated revisions

Revision 52e6e4b5 (diff)
Added by Andreas Müller 3 months ago

ref #7796 remove ILDIS Bibliographie NameFacts from E+M import

History

#1 Updated by Andreas Müller 4 months ago

  • Related to task #7435: ERS: Handle also published in correctly added

#2 Updated by Andreas Müller 4 months ago

  • Description updated (diff)

#3 Updated by Andreas Müller 4 months ago

SELECT n.NameCache, n.FullNameCache, n.NomRefFk, pt.PTRefFk, fact.NameFactId, fact.PTNameFk, fact.NameFact, n.notes, pt.Notes,
     fact.NameFactCategoryFk, fact.NameFactRefFk, fact.DoubtfulFlag, fact.PublishFlag, 
     fact.Created_When, fact.Updated_When, fact.Created_Who, fact.Updated_Who, fact.Notes, fact.NameFactRefDetail,
     pt.PublishFlag
FROM  NameFact fact 
     INNER JOIN Name AS n ON fact.PTNameFk = n.NameId
     LEFT OUTER JOIN PTaxon pt ON pt.PTNameFk = fact.PTNameFk AND pt.PTRefFK NOT IN (500000) 
WHERE (fact.NameFactCategoryFk = 3) 
ORDER BY pt.PTRefFk, n.FullNameCache;
SELECT DISTINCT fact.NameFactId
FROM  NameFact fact
WHERE (fact.NameFactCategoryFk = 3)

#5 Updated by Andreas Müller 4 months ago

  • Related to bug #7456: E+M: NameFacts von ILDIS Daten added

#6 Updated by Andreas Müller 4 months ago

  • Related to deleted (bug #7456: E+M: NameFacts von ILDIS Daten)

#7 Updated by Andreas Müller 4 months ago

  • Duplicated by bug #7456: E+M: NameFacts von ILDIS Daten added

#8 Updated by Andreas Müller 4 months ago

ERS: (2014-11-08)

diese Angaben in eckigen Klammern hinter der eigentlichen nom.ref. stammen aus dem ILDIS-Import. In Euro+Med oder PESI wollen wir sie nicht ausgeben; das wurden sie bisher auch nicht.

#9 Updated by Andreas Müller 4 months ago

  • Description updated (diff)

#10 Updated by Andreas Müller 4 months ago

  • Estimated time set to 1.50 h

#11 Updated by Andreas Müller 4 months ago

ERS: probably not to be imported at all

#12 Updated by Andreas Müller 3 months ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 80
  • Estimated time changed from 1.50 h to 0.50 h

#13 Updated by Andreas Müller 3 months ago

  • Subject changed from ERS: Handle Bibliography Name Facts correctly to [CHECK] Handle Bibliography Name Facts correctly

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)