Project

General

Profile

bug #7449

E+M: Import common names with no regionFk correctly

Added by Andreas Müller about 1 year ago. Updated 11 months ago.

Status:
Resolved
Priority:
Highest
Category:
cdmadapter
Target version:
Start date:
06/03/2018
Due date:
% Done:

0%

Severity:
normal
Found in Version:
Tags:

Description

Currently it looks they are not imported at all as there is an iteration over the set of regions and for each region a common name is created.

Note: also check if multiple regionFks are correctly imported.


Related issues

Related to Edit - task #7341: [Check] CommonName import issues Resolved 04/03/2018

Associated revisions

Revision dfeeeb8b (diff)
Added by Andreas Müller about 1 year ago

ref #7449 try to fix common name import for names with no region and ref #7447 add misapplied name common name import source

History

#1 Updated by Andreas Müller about 1 year ago

  • Related to task #7341: [Check] CommonName import issues added

#2 Updated by Andreas Müller 11 months ago

  • Target version changed from Euro+Med Portal Release to Euro+Med Migration

#3 Updated by Andreas Müller 11 months ago

  • Description updated (diff)
  • Status changed from New to Resolved

The empty ones are all common names for ILDIS taxa:

SELECT n.FullNameCache, n.NameCache, cn.*
FROM emCommonName cn INNER JOIN Name n ON n.nameId = cn.PTNameFk
WHERE cn.RegionFks IS NULL 

I checked for AND PTNameFk = 21911 (Medicago minima (L.) L.) , which had the common names with empty refFk now (e.g. commonNameID = 125272).

====

There are only 19 with regionFk.size > 1

SELECT n.FullNameCache, n.NameCache, cn.*
FROM emCommonName cn INNER JOIN Name n ON n.nameId = cn.PTNameFk
WHERE cn.RegionFks like '%,%'  AND PTNameFk = 28017

I found both with commonNameID source 32965 in import

So this ticket seems to be fixed.

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)