Project

General

Profile

Actions

task #7796

open

[CHECK] Handle Bibliography Name Facts correctly

Added by Andreas Müller about 4 years ago. Updated over 3 years ago.

Status:
Resolved
Priority:
Priority14
Category:
cdmadapter
Target version:
Start date:
Due date:
% Done:

80%

Estimated time:
0:30 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


Files

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

Related issues

Related to EDIT - task #7435: Handle also published in correctlyIn ProgressAndreas Müller

Actions
Has duplicate EDIT - bug #7456: E+M: NameFacts von ILDIS DatenDuplicateAndreas Müller

Actions
Actions #1

Updated by Andreas Müller about 4 years ago

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

Updated by Andreas Müller about 4 years ago

  • Description updated (diff)
Actions #3

Updated by Andreas Müller about 4 years 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)
Actions #5

Updated by Andreas Müller about 4 years ago

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

Updated by Andreas Müller about 4 years ago

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

Updated by Andreas Müller about 4 years ago

  • Has duplicate bug #7456: E+M: NameFacts von ILDIS Daten added
Actions #8

Updated by Andreas Müller about 4 years 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.

Actions #9

Updated by Andreas Müller about 4 years ago

  • Description updated (diff)
Actions #10

Updated by Andreas Müller about 4 years ago

  • Estimated time set to 1:30 h
Actions #11

Updated by Andreas Müller about 4 years ago

ERS: probably not to be imported at all

Actions #12

Updated by Andreas Müller about 4 years ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 80
  • Estimated time changed from 1:30 h to 0:30 h
Actions #13

Updated by Andreas Müller about 4 years ago

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

Updated by Andreas Müller over 3 years ago

  • Description updated (diff)
Actions #15

Updated by Andreas Müller over 3 years ago

  • Description updated (diff)
Actions #16

Updated by Andreas Müller over 3 years 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.

Actions #17

Updated by Andreas Müller over 3 years 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)

Actions

Also available in: Atom PDF