Project

General

Profile

Actions

task #7713

open

Atomize last scrutiny references

Added by Andreas Müller over 5 years ago. Updated almost 5 years ago.

Status:
In Progress
Priority:
Priority14
Category:
data
Start date:
Due date:
% Done:

40%

Estimated time:
1:30 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 referenceResolvedAndreas Müller

Actions
Related to EDIT - feature request #3990: [DISCUSS] How to implement citation suggestion to each taxonClosedAndreas Müller

Actions
Actions #1

Updated by Andreas Müller over 5 years ago

  • Status changed from New to In Progress
Actions #3

Updated by Andreas Müller over 5 years ago

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

Updated by Andreas Müller over 5 years ago

Actions #5

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions #6

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions #7

Updated by Andreas Müller over 5 years 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

Actions #8

Updated by Andreas Müller over 5 years 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
Actions #9

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions #10

Updated by Andreas Müller over 5 years ago

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

Updated by Andreas Müller over 5 years ago

  • Estimated time set to 1:30 h
Actions #12

Updated by Andreas Müller almost 5 years ago

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

we will do this after migration

Actions

Also available in: Atom PDF