task #7435
Updated by Andreas Müller almost 6 years ago
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:
~~~ sql
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