Project

General

Profile

task #7435

Updated by Andreas Müller over 1 year ago

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

fact.
But sometimes this information is also to be found find 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 original source of type "2nd nom ref" or "also published in".

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, NameFact.NameFactId, NameFact.PTNameFk, NameFact.NameFact, NameFact.NameFactCategoryFk, NameFact.NameFactRefFk, NameFact.DoubtfulFlag, NameFact.PublishFlag,
NameFact.Created_When, NameFact.Updated_When, NameFact.Created_Who, NameFact.Updated_Who, NameFact.Notes, NameFact.NameFactRefDetail
FROM NameFact INNER JOIN
Name AS n ON NameFact.PTNameFk = n.NameId
WHERE (NameFact.NameFactCategoryFk = 1)
~~~
correctly.

Back

Add picture from clipboard (Maximum size: 40 MB)