Project

General

Profile

task #7796

[CHECK] Handle Bibliography Name Facts correctly

Added by Andreas Müller 8 months ago. Updated 9 days ago.

Status:
Resolved
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 behind the name formatted same as 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)

Decisition: we keep them as citations

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


Related issues

Related to Edit - task #7435: 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 7 months ago

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

History

#1 Updated by Andreas Müller 8 months ago

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

#2 Updated by Andreas Müller 8 months ago

  • Description updated (diff)

#3 Updated by Andreas Müller 8 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 8 months ago

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

#6 Updated by Andreas Müller 8 months ago

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

#7 Updated by Andreas Müller 8 months ago

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

#8 Updated by Andreas Müller 8 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 8 months ago

  • Description updated (diff)

#10 Updated by Andreas Müller 8 months ago

  • Estimated time set to 1.50 h

#11 Updated by Andreas Müller 7 months ago

ERS: probably not to be imported at all

#12 Updated by Andreas Müller 7 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 7 months ago

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

#14 Updated by Andreas Müller 9 days ago

  • Description updated (diff)

#15 Updated by Andreas Müller 9 days ago

  • Description updated (diff)

#16 Updated by Andreas Müller 9 days ago

  • Target version changed from Euro+Med Migration to Euro+Med Portal Release

Move to check if they are really not shown in production portal.

#17 Updated by Andreas Müller 9 days ago

  • Status changed from In Progress to Resolved
  • Target version changed from Euro+Med Portal Release to Euro+Med Migration

As in note 11 it was decided not to import them at all this ticket is fixed (in code this is already implemented)

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)