task #7796
open[CHECK] Handle Bibliography Name Facts correctly
80%
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
Related issues
Updated by Andreas Müller about 5 years ago
- Related to task #7435: Handle also published in correctly added
Updated by Andreas Müller about 5 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)
Updated by Andreas Müller about 5 years ago
- Related to bug #7456: E+M: NameFacts von ILDIS Daten added
Updated by Andreas Müller about 5 years ago
- Related to deleted (bug #7456: E+M: NameFacts von ILDIS Daten)
Updated by Andreas Müller about 5 years ago
- Has duplicate bug #7456: E+M: NameFacts von ILDIS Daten added
Updated by Andreas Müller about 5 years ago
- File picture897-1.png picture897-1.png added
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.
Updated by Andreas Müller about 5 years ago
ERS: probably not to be imported at all
Updated by Andreas Müller about 5 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
Updated by Andreas Müller about 5 years ago
- Subject changed from ERS: Handle Bibliography Name Facts correctly to [CHECK] Handle Bibliography Name Facts correctly
Updated by Andreas Müller over 4 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.
Updated by Andreas Müller over 4 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)