Project

General

Profile

bug #7828

Remove date published from journals in E+M

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

Status:
In Progress
Priority:
New
Category:
data
Start date:
10/15/2018
Due date:
% Done:

90%

Severity:
normal
Found in Version:
Tags:

Description

1200 journals from the initial import in 2004 do have a date published. Journals generally should not have a date published.

This is critical for the deduplication as the date published is handled as difference. Also in general it should be cleaned.


SELECT  ref.*
FROM Reference ref 
WHERE ref.datePublished_start IS NOT NULL AND ref.refType = 'JOU' ;

SELECT DISTINCT subRef.title, subRef.id, subRef.*, ref.*
FROM Reference ref INNER JOIN Reference subRef ON subRef.inReference_id = ref.id
WHERE ref.datePublished_start IS NOT NULL AND ref.refType = 'JOU' AND subRef.datePublished_start IS NULL

Also journals should not have authors.


Related issues

Related to Edit - bug #7915: Remove date published from journals and print series Closed 11/20/2018
Related to Edit - bug #7913: Remove authorship from IJournal and IPrintSeries Closed 11/20/2018

History

#1 Updated by Andreas Müller 6 months ago

  • Subject changed from Remove date published from journals to Remove date published from journals in E+M

#2 Updated by Andreas Müller 6 months ago

  • Duplicates bug #7839: IJournal should not have author, date published etc. added

#3 Updated by Andreas Müller 6 months ago

  • Status changed from New to Duplicate

#4 Updated by Andreas Müller 6 months ago

  • Duplicates deleted (bug #7839: IJournal should not have author, date published etc.)

#5 Updated by Andreas Müller 6 months ago

  • Status changed from Duplicate to In Progress

#6 Updated by Andreas Müller 6 months ago

  • Related to bug #7915: Remove date published from journals and print series added

#7 Updated by Andreas Müller 6 months ago

  • Related to bug #7913: Remove authorship from IJournal and IPrintSeries added

#8 Updated by Andreas Müller 6 months ago

  • Description updated (diff)

#9 Updated by Andreas Müller 11 days ago

  • Description updated (diff)

#10 Updated by Andreas Müller 11 days ago

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

AM:

folgende 2 Journals haben noch ein Datum, was eigentlich nicht sein soll (der Artikel soll das Datum haben):

1.
Wiegm. Archiv.: nom. ref. Inreferenz von Colchicum pannonicum Griseb. & Schenk (id 4957)

  1. J. Bot. (Schrader) (id: 2433)

Das ist die Inreferenz der nom.refs. von
Asplenium fontanum (L.) Bernh.
Dennstaedtia Bernh./ Huperzia Bernh./ Sphaeropteris Bernh./ Sphaeropteris medullaris (G. Forst.) Bernh.
Astragalus palaestinus Eig
Dianthus legionensis (Willk.) F. N. Williams
Euphrasia officinalis subsp. rostkoviana (Hayne) Towns.
Acrostichum chrysophyllum Sw./ Acrostichum squamosum Sw./ Adiantum hispidulum Sw. etc.
Alyssum simplex Rudolphi
Tulipa australis Link
Utricularia intermedia Hayne
Lisaea strigosa (Banks & Sol.) Eig

Können diese beiden Datumsangaben weg? Können wir auch noch nach dem Import machen, andererseits ist das vermutlich ne Kleinigkeit.

#11 Updated by Andreas Müller 11 days ago

  • % Done changed from 0 to 90

This is generally solved. I final check should be done after import. (currently the 2 above issues are still open)

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)