Project

General

Profile

task #7713

Atomize last scrutiny references

Added by Andreas Müller 9 months ago. Updated 12 days ago.

Status:
In Progress
Priority:
Priority14
Category:
data
Start date:
08/31/2018
Due date:
% Done:

40%

Estimated time:
1.50 h
Severity:
normal
Tags:

Description

Last scrutiny references currently are all(?) flat and with protected cache. They should:

  • use inreferences (sometimes in-in-references)
  • RefCategory should be Website
  • years should be extracted, also ask ERS if all "xxxx+" years are correct of if some ordinary years should be "+" years
  • extract authors
  • extract titles

Also we need to include references to import references!

Open issues:

  • authors sometimes look like: "Aedo, C., Estébanez, B. & Navarro, C.; with contributions from Raab-Straube, E. von & Parolly, G."
  • Compositae references do not yet have in-references
  • think about using PartOf (CatFk=2) which gives better formatting results or adapt formatting
  • handle references which are currently not last scrutiny references but should (#7713#note-8)
  • correct formatting for in-in-references

Related issues

Related to Edit - bug #3992: [CHECK] Use last scrutiny instead of sec reference Resolved 01/24/2014
Related to Edit - feature request #3990: [DISCUSS] How to implement citation suggestion to each taxon Resolved 01/24/2014

Associated revisions

Revision e1d0f581 (diff)
Added by Andreas Müller 9 months ago

ref #3992, ref #7713, ref #3990 Atomize last scrutiny references

Revision d0c77267 (diff)
Added by Andreas Müller 9 months ago

ref #3992, ref #7713, ref #3990 add test for differing synonym relation references

History

#1 Updated by Andreas Müller 9 months ago

  • Status changed from New to In Progress

#3 Updated by Andreas Müller 9 months ago

  • Related to bug #3992: [CHECK] Use last scrutiny instead of sec reference added

#4 Updated by Andreas Müller 9 months ago

#5 Updated by Andreas Müller 9 months ago

  • Description updated (diff)

#6 Updated by Andreas Müller 9 months ago

  • Description updated (diff)

#7 Updated by Andreas Müller 9 months ago

SELECT  RefId, Notes, RefYear, RefCategoryFk, RefCache, NomRefCache, PreliminaryFlag, InRefFk, Title, NomTitleAbbrev, NomAuthorTeamFk, RefAuthorString, DateString, Edition, Volume, Series, PageString, ISSN, ISBN, URL, ExportDate, PublicationTown, Publisher, ThesisFlag, RefDepositedAt, InformalRefCategory, IsPaper, RefSourceFk, IdInSource, NomStandard, Created_When, Updated_When, Created_Who, Updated_Who, IdInMCL
FROM Reference AS r
WHERE (RefId IN
   (SELECT  LastScrutinyFk
    FROM    PTaxon AS pt
    WHERE  (LastScrutinyFk IS NOT NULL))) 
          AND (RefCache NOT LIKE '%xxxx%')
  OR (InRefFk = 9005392)
ORDER BY RefId

InRefFk = 9005392 nicht notwendig, nur zur Sicherheit

#8 Updated by Andreas Müller 9 months ago

Find last scrutiny references not in use:

SELECT *
FROM   Reference AS r
WHERE  (RefId NOT IN
  (SELECT  LastScrutinyFk
   FROM  PTaxon AS pt
   WHERE        (LastScrutinyFk IS NOT NULL))) 
 AND (RefCache LIKE '%+Med Plantbase - the information resource for Euro-Med%')
ORDER BY RefId

#9 Updated by Andreas Müller 9 months ago

  • Description updated (diff)

#10 Updated by Andreas Müller 9 months ago

  • Description updated (diff)
  • % Done changed from 0 to 40

#11 Updated by Andreas Müller 8 months ago

  • Estimated time set to 1.50 h

#12 Updated by Andreas Müller 12 days ago

  • Target version changed from Euro+Med Migration to Euro+Med post migration

we will do this after migration

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)