Project

General

Profile

Actions
Copy link

bug #7828

open

Remove date published from journals in E+M

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

Status:
In Progress
Priority:
New
Assignee:
Andreas Müller
Category:
data
Target version:
Euro+Med post migration
Start date:
Due date:
% Done:

90%

Estimated time:
Severity:
normal
Found in Version:
Tags:
euro+med

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 seriesClosedKatja Luther

Actions
Related to EDIT - bug #7913: Remove authorship from IJournal and IPrintSeriesClosedKatja Luther

Actions
Actions
Copy link
 #1

Updated by Andreas Müller over 5 years ago

  • Subject changed from Remove date published from journals to Remove date published from journals in E+M
Actions
Copy link
 #2

Updated by Andreas Müller over 5 years ago

  • Is duplicate of bug #7839: IJournal should not have author, date published etc. added
Actions
Copy link
 #3

Updated by Andreas Müller over 5 years ago

  • Status changed from New to Duplicate
Actions
Copy link
 #4

Updated by Andreas Müller over 5 years ago

  • Is duplicate of deleted (bug #7839: IJournal should not have author, date published etc.)
Actions
Copy link
 #5

Updated by Andreas Müller over 5 years ago

  • Status changed from Duplicate to In Progress
Actions
Copy link
 #6

Updated by Andreas Müller over 5 years ago

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

Updated by Andreas Müller over 5 years ago

  • Related to bug #7913: Remove authorship from IJournal and IPrintSeries added
Actions
Copy link
 #8

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions
Copy link
 #9

Updated by Andreas Müller almost 5 years ago

  • Description updated (diff)
Actions
Copy link
 #10

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

Actions
Copy link
 #11

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

Actions
Copy link

Also available in: Atom PDF