Project

General

Profile

feature request #7799

AM: Parse authorteams

Added by Andreas Müller 8 months ago. Updated 11 days ago.

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

90%

Estimated time:
3.00 h
Severity:
normal
Tags:

Description

many of them are single persons and also the resulting persons/teams could be parsed probably


Related issues

Related to Edit - feature request #7800: Parse preliminary RefDetails In Progress 09/29/2018
Related to Edit - feature request #7801: AM: Deduplicate references In Progress 09/29/2018
Related to Edit - bug #7817: Team caches should not show '& al.' New 10/11/2018

Associated revisions

Revision c277d1a7 (diff)
Added by Andreas Müller 8 months ago

ref #7799 handle protected titlecache for teamOrPerson.getFullTitle

Revision 1b9b7bfd (diff)
Added by Andreas Müller 8 months ago

ref #7799 handle initials for teamOrPerson.getFullTitle

Revision f4b9ac06 (diff)
Added by Andreas Müller 8 months ago

ref #7799 implement author parsing for AuthorTeam and Reference.RefAuthorString

Revision a5e9dc2f (diff)
Added by Andreas Müller 8 months ago

ref #7799 and others reinstall null check

Revision 31e71264 (diff)
Added by Andreas Müller 8 months ago

ref #7799 improve performance of authorteam loading

Revision 3f3714e3 (diff)
Added by Andreas Müller 7 months ago

ref #7799 compute author caches in deduplicationHelper

Revision 6943d396 (diff)
Added by Andreas Müller 7 months ago

ref #7799 deduplicate and parse authorteams

History

#1 Updated by Andreas Müller 8 months ago

  • Tags set to euro+med

#3 Updated by Andreas Müller 8 months ago

#4 Updated by Andreas Müller 8 months ago

#6 Updated by Andreas Müller 8 months ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 30

#7 Updated by Andreas Müller 7 months ago

Useful scripts

DECLARE @authorId as int;
Set @authorId = 3395
;

SELECT *
FROM Name n INNER JOIN dbo.v_cdm_exp_namesAll v ON n.NameId = v.NameId
WHERE (1=0)
   OR n.AuthorTeamFk IN (@authorId) OR n.ExAuthorTeamFk IN (@authorId) OR n.BasAuthorTeamFk IN (@authorId) OR n.ExBasAuthorTeamFk IN (@authorId)
   OR n.NomRefFk IN (SELECT r.RefId
FROM Reference r INNER JOIN v_cdm_exp_refAll v ON v.RefId = r.RefId  
WHERE r.NomAuthorTeamFk  IN (@authorId))
   ;
SELECT *
FROM Reference r INNER JOIN v_cdm_exp_refAll v ON v.RefId = r.RefId  
WHERE r.NomAuthorTeamFk  IN (@authorId);

SELECT *
FROM AuthorTeam at
WHERE at.AuthorTeamId IN (@authorId);

SELECT *
FROM AuthorTeamSequence seq
WHERE seq.AuthorTeamFk IN (@authorId)
DECLARE @id int;

SET @id = 3453;  -- 697, 2168, 3453
--113977, 88135, 88204 
SELECT n.*
FROM Name n INNER JOIN dbo.v_cdm_exp_namesAll v ON n.NameId = v.NameId
WHERE n.NomRefFk IN (@id)

SELECT *
FROM v_cdm_exp_refSourceNumbers
WHERE RefId IN (@id);

SELECT *
FROM v_cdm_exp_refNomStatusRefs
WHERE RefId IN (@id);

SELECT pt.*
FROM PTaxon pt INNER JOIN dbo.v_cdm_exp_taxaAll v ON pt.RIdentifier = v.RIdentifier
WHERE pt.PTRefFk IN (@id) or pt.LastScrutinyFk IN (@id)

SELECT *
FROM v_cdm_exp_refLanguageRefs
WHERE RefId IN (@id);

SELECT *
FROM v_cdm_exp_refFactRefs
WHERE RefId IN (@id);

SELECT *
FROM v_cdm_exp_refInRefs
WHERE RefId IN (@id);

#8 Updated by Andreas Müller 7 months ago

  • Related to bug #7817: Team caches should not show '& al.' added

#9 Updated by Andreas Müller 11 days ago

  • Status changed from In Progress to Resolved

This should be fixed. We may check for not atomized authors after import again

#10 Updated by Andreas Müller 11 days ago

  • % Done changed from 30 to 90

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)