Actions
task #6557
closedImport Bogota data
Added by Andreas Müller about 7 years ago. Updated almost 7 years ago.
Start date:
Due date:
% Done:
80%
Estimated time:
40:00 h
Severity:
major
Tags:
Description
Import checklist and later import specimen data
Open issues:
Files
| Bogota Import.msg (82.5 KB) Bogota Import.msg | Mail to Grischa after import | Andreas Müller, 05/04/2017 12:26 AM |
Related issues
Updated by Andreas Müller about 7 years ago
- Related to task #6137: Urgent imports added
Updated by Andreas Müller about 7 years ago
- Status changed from New to In Progress
- Priority changed from New to Highest
Updated by Andreas Müller about 7 years ago
- Target version changed from Release 4.8 to Release 4.7
Updated by Andreas Müller about 7 years ago
- Related to feature request #6576: Implement operation that guesses all basionyms for a syonymy added
Updated by Andreas Müller about 7 years ago
- Status changed from In Progress to Resolved
- % Done changed from 30 to 50
Applied in changeset cdmlib|4cd473206ecc56a523020c28166c0750afc1484f.
Updated by Andreas Müller about 7 years ago
- Description updated (diff)
- % Done changed from 50 to 30
Updated by Andreas Müller about 7 years ago
- Description updated (diff)
Name.titleCache duplicates:
SELECT titleCache, count(*) as n
FROM TaxonNameBase
GROUP BY titleCache
Having n > 1
some are hybrid parents, some are duplicates (synonyms + accepted infraspecific)
Updated by Andreas Müller about 7 years ago
Homonyme and similar:
SELECT tnb.titleCache, tnb.nameCache
FROM TaxonNameBase tnb INNER JOIN
(SELECT nameCache
FROM TaxonNameBase
GROUP BY nameCache
Having count(*) > 1
) as drv ON tnb.nameCache = drv.nameCache
ORDER BY tnb.nameCache, tnb.titleCache
Updated by Andreas Müller about 7 years ago
- Related to feature request #6577: Make sp. nov. parsable added
Updated by Andreas Müller about 7 years ago
- Related to bug #6578: Implement name cache for hybrid formulas added
Updated by Andreas Müller about 7 years ago
- % Done changed from 30 to 50
Applied in changeset cdmlib-apps|f7802e9485fc42ca4716224ffc524e5022effa4f.
Updated by Andreas Müller almost 7 years ago
- Related to task #6606: Import Bogota specimen data added
Updated by Andreas Müller almost 7 years ago
- % Done changed from 50 to 80
Created new ticket for specimen data #6606.
Still need to add logfile mail to Grischa and then can close this ticket.
Updated by Andreas Müller almost 7 years ago
- File Bogota Import.msg Bogota Import.msg added
Updated by Andreas Müller almost 7 years ago
- Status changed from Resolved to Closed
- Target version deleted (
Release 4.7)
Actions