Project

General

Profile

Actions

task #7435

open

Handle also published in correctly

Added by Andreas Müller almost 6 years ago. Updated almost 5 years ago.

Status:
In Progress
Priority:
Priority14
Category:
data
Start date:
Due date:
% Done:

80%

Estimated time:
2:00 h
Severity:
normal
Tags:

Description

Some names do have a second nomenclatural reference (or at least a second reference). This is usually handled as name fact (NameFactCategoryFk = 1).

But sometimes this information is also to be found in some of the notes fields (detail Notes, taxonNotes, nameNotes, ...).

  • This information needs to be checked, and in case it is correct moved to the name fact to be imported correctly if not already duplicated there.

  • Also the import needs to be adapted to import name facts of cat=1 as either

    • original source of type "2nd nom ref" or "also published in" (both do not exist yet) or "nomenclatural reference" or
    • name fact of type "also published in" (does not exist yet and name facts will be removed soon)
    • extension of type "also published in" (does not exist yet)

Discuss with ERS what the exact semantic is in E+M for this category.

Also published in name facts:

SELECT n.NameCache, n.FullNameCache, 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
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 = 1)
ORDER BY pt.PTRefFk, n.FullNameCache

====

Excel:

  • AlsoPublishedIn.xlsx

Related issues

Related to EDIT - task #7796: [CHECK] Handle Bibliography Name Facts correctlyResolvedAndreas Müller

Actions
Related to EDIT - feature request #7653: [DISCUSS] Delete NameFacts => Result: noClosedAndreas Müller

Actions
Related to EDIT - feature request #7797: Second nomenclatural referenceNewAndreas Müller

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

Actions
Blocks EDIT - feature request #7437: Handle also published in data portalNewAndreas Kohlbecker

Actions
Actions

Also available in: Atom PDF