Project

General

Profile

Actions

bug #6627

closed

Remaining cdm light issues

Added by Katja Luther almost 7 years ago. Updated almost 2 years ago.

Status:
Closed
Priority:
Highest
Assignee:
Category:
cdmadapter
Target version:
Start date:
Due date:
% Done:

60%

Estimated time:
Severity:
normal
Found in Version:

Description

  • Instance name and instance ID

  • TitlePageYear (in 5.0)

  • support for misapplied names (in 5.0)

  • fix handling of synonym secundum (in 5.0)

  • Collation: Wird nicht ausgegeben. Konkateniert aber auch nur die zwei folgenden (Vol/Issue, Detail) mit Doppelpunkt und Leerzeichen dazwischen (Note AM: nein da kommen im generischen Fall noch mehr Felder dazu, z.B. series)

  • eigene Tabelle für Identifier

  • Facts containing only media data should be moved to an extra table.

  • Discuss whether we should handle the citation facts separate to the other simple facts because it is confusing that the row in the simple fact table is no information.

  • add export of usage data

  • add export of annotations

  • add export of name facts

  • add export of IndividualsAssociations and TaxonInteractions

Open "bugs" from WGB:

  • User friendly result
  • Sonderzeichen
  • Collation leer (s.o.)
  • Problem bei CommonNames, es wird nicht iteriert sondern immer der gleiche angezeigt
  • ScientificName.AbbreviatedTitle für Book ist leer
  • Taxon_FK missing in SpecimenFact

Related issues

Related to EDIT - feature request #6752: Add verbatimDateClosedAndreas Müller

Actions
Related to EDIT - task #6754: Adapt DwcA Export to CDM light export strategyClosedAndreas Müller

Actions
Related to EDIT - bug #6968: Unexpected error in CDM light when exporting Individuals Association with no unit attachedClosedKatja Luther

Actions
Related to EDIT - feature request #7334: Make pro parte and partial synonyms real concept relationshipsClosedAndreas Müller

Actions
Related to EDIT - feature request #8175: add name facts to cdm light exportClosedKatja Luther

Actions
Related to EDIT - feature request #8322: add sortindex to cdm light exportResolvedAndreas Müller

Actions
Related to EDIT - feature request #6516: Add instance name and instance ID to CDM meta dataIn ProgressAndreas Müller

Actions
Precedes EDIT - feature request #8412: Remaining issues for cdm light export (II)In ProgressKatja Luther

Actions
Copied from EDIT - feature request #6314: CDM light (csv) export implementedClosedKatja Luther

Actions
Actions #1

Updated by Katja Luther almost 7 years ago

Actions #2

Updated by Andreas Müller almost 7 years ago

Actions #3

Updated by Andreas Müller almost 7 years ago

Actions #4

Updated by Andreas Müller almost 7 years ago

  • Description updated (diff)
Actions #5

Updated by Andreas Müller almost 7 years ago

Actions #6

Updated by Andreas Müller almost 7 years ago

  • Description updated (diff)
Actions #7

Updated by Andreas Müller almost 7 years ago

  • Description updated (diff)
Actions #8

Updated by Katja Luther almost 7 years ago

Katja Luther wrote:

  • Instance name and instance ID

  • TitlePageYear

  • Collation: Wird nicht ausgegeben. Konkateniert aber auch nur die zwei folgenden (Vol/Issue, Detail) mit Doppelpunkt und Leerzeichen dazwischen (Note AM: nein da kommen im generischen Fall noch mehr Felder dazu, z.B. series)

  • eigene Tabelle für Identifier

  • Facts containing only media data should be moved to an extra table.

  • Discuss whether we should handle the citation facts separate to the other simple facts because it is confusing that the row in the simple fact table is no information.

  • add export of usage data

  • add export of annotations

  • add export of IndividualsAssociations and TaxonInteractions

Open "bugs" from WGB:

  • User friendly result
  • Sonderzeichen
  • Collation leer (s.o.)
  • Problem bei CommonNames, es wird nicht iteriert sondern immer der gleiche angezeigt
  • ScientificName.AbbreviatedTitle für Book ist leer
Actions #9

Updated by Andreas Müller almost 7 years ago

  • Description updated (diff)
Actions #10

Updated by Katja Luther over 6 years ago

Hallo,

wir haben Zitate, die z.B. folgendermaßen aussehen:
Mauria heterophylla Kunth, Nov. Gen. Sp. 7: 13-14, t. 606. "1825" [1824].
Das ist aus der Salvador Datenbank
Basellaceae Raf., Fl. Tellur. 3: 44. "1836" [1837]. nom. cons.
aus Caryophyllales_spp

Das bedeutet, dass das gedruckte Datum (in Anführungsstrichen, meist auf der Titelseite) falsch ist, und die Publikation wirklich erst im in eckigen Klammern angegebenen Jahr erfolgte. (Es gibt auch noch andere Schreibweisen, dies scheint mir aber die eindeutigste von den Kurzformen zu sein; IPNI macht’s neuerdings ganz ausführlich:

Leuenbergeria Lodé -- Cact.-Avent. Int. 97: 26. 2012 [dt. Jan 2013; issued 28 Dec 2012] ).

Im CDM habe wir keine atomisierte Angabe des TitlePageYears (also der Angabe in Anführungszeichen), die man aber besser in „VerbatimDate“ oder „VerbatimPublicationDate“ umtaufen sollte.

Im Editor wird das korrekte Publikationsjahr (hier 1889) für das atomisierte Date genommen, ein Feld für das auf der Titelseite (fälschlich) angegebene gibt es noch nicht, daher schreiben wir den ganzen string in der von uns gewünschten Formatierung in das Freetext Feld, das dann, wenn vorhanden, bevorzugt in die Ausgabe genommen wird:

Im Export haben wir nun drei Spalten, DatePublished, YearPublished und TitlePageYear und Du hast recht, das geht noch ein bisschen durcheinander. Bisher scheint es so zu sein:
Bei PublicationDate kommt der Freetext heraus, wenn vorhanden, sonst das atomisierte Jahr.
Bei PublicationYear kommt das atomisierte Jahr (ggf. als Range)
Bei TitlePageYear garnichts.
In meiner Ausgabe habe ich daher immer das PublicationDate benutzt.

Ich schlage vor, das gleich langfristig in Ordnung zu bringen:
PublicationDate: Der Start/End Date Range.
PublicationYear: Nur das Jahr aus dem Start/End Date Range

@Andreas – ist eine Angabe des „VerbatimDate“ im Modell angedacht? Wenn ja, sollten wir das TitlePageYear in VerbatimYear umbenennen und in der Ausgabe lassen, zwecks späterer Nutzung, jetzt aber leer.

Wenn nicht, sollten wir das TitlePageYear rauslassen und statt dessen eine Spalte „OutputDate“ einfügen, in der dann das steht, was bisher in das PublicationDate geschrieben wurde, also Freetext und wenn dieser leer das PublicationDate (range).

Wenn Du das so einrichtest, sag‘ mir bitte Bescheid, wie bei jeder Strukturänderung muss ich das dann in meinen Ausgaben entsprechend ändern.

Herzlichen Gruß
Walter

Actions #11

Updated by Andreas Müller over 6 years ago

Actions #12

Updated by Andreas Müller over 6 years ago

  • Related to task #6754: Adapt DwcA Export to CDM light export strategy added
Actions #13

Updated by Andreas Müller over 6 years ago

  • Subject changed from Remaining output model issues to Remaining cdm light issues
Actions #14

Updated by Katja Luther over 6 years ago

  • Target version changed from Release 4.8 to Release 4.10
Actions #15

Updated by Andreas Müller over 6 years ago

  • Related to bug #6968: Unexpected error in CDM light when exporting Individuals Association with no unit attached added
Actions #16

Updated by Andreas Müller over 6 years ago

  • Target version changed from Release 4.10 to Release 4.11
Actions #17

Updated by Andreas Müller over 6 years ago

  • Target version changed from Release 4.11 to Release 4.12
Actions #18

Updated by Andreas Müller over 6 years ago

  • Target version changed from Release 4.12 to Release 4.13
Actions #19

Updated by Katja Luther about 6 years ago

the isProParte flag is added to the synonym table

Actions #20

Updated by Andreas Müller about 6 years ago

  • Target version changed from Release 4.13 to Release 4.14
Actions #21

Updated by Andreas Müller about 6 years ago

  • Target version changed from Release 4.14 to Release 5.0
Actions #22

Updated by Andreas Müller almost 6 years ago

Actions #23

Updated by Andreas Müller almost 6 years ago

  • Target version changed from Release 5.0 to Release 5.1
Actions #24

Updated by Andreas Müller almost 6 years ago

  • Description updated (diff)
  • % Done changed from 0 to 10
Actions #25

Updated by Andreas Müller almost 6 years ago

  • Description updated (diff)
Actions #26

Updated by Andreas Müller over 5 years ago

  • Target version changed from Release 5.1 to Release 5.2
Actions #27

Updated by Andreas Müller over 5 years ago

  • Target version changed from Release 5.2 to Release 5.3
Actions #28

Updated by Katja Luther over 5 years ago

  • Target version changed from Release 5.3 to Release 5.4
Actions #29

Updated by Andreas Müller over 5 years ago

  • Target version changed from Release 5.4 to Release 5.5
Actions #30

Updated by Katja Luther about 5 years ago

  • Description updated (diff)
  • Target version changed from Release 5.5 to Release 5.6
Actions #31

Updated by Andreas Müller about 5 years ago

  • Target version changed from Release 5.6 to Reviewed Next Major Release
Actions #32

Updated by Katja Luther about 5 years ago

  • Target version changed from Reviewed Next Major Release to Release 5.6

the name facts should be implemented in 5.6

Actions #33

Updated by Andreas Müller about 5 years ago

Can you add the name facts to the TODO list? Is there an explicit ticket?

Actions #34

Updated by Katja Luther about 5 years ago

  • Description updated (diff)
Actions #35

Updated by Katja Luther about 5 years ago

Actions #36

Updated by Katja Luther about 5 years ago

the name facts are implemented now, see #8175

Actions #37

Updated by Katja Luther almost 5 years ago

  • Description updated (diff)
Actions #38

Updated by Katja Luther almost 5 years ago

  • Target version changed from Release 5.6 to Release 5.7
Actions #39

Updated by Katja Luther almost 5 years ago

  • Target version changed from Release 5.7 to Release 5.8
Actions #40

Updated by Katja Luther almost 5 years ago

Actions #41

Updated by Andreas Müller over 4 years ago

  • Status changed from New to Feedback
  • % Done changed from 10 to 60

should we close this ticket and create a new remaining (II) ticket with the now open issues.

Most of the tasks have been implemented in the meanwhile as it looks like.

Actions #42

Updated by Katja Luther over 4 years ago

Actions #43

Updated by Katja Luther over 4 years ago

  • Status changed from Feedback to Resolved

created a new "remaining issues" ticket and close this one

Actions #44

Updated by Katja Luther almost 2 years ago

Actions #45

Updated by Katja Luther almost 2 years ago

Actions #46

Updated by Katja Luther almost 2 years ago

  • Status changed from Resolved to Closed

Close this ticket because a new ticket with remaining issues are created, the blocking ticket is now a related ticket.

Actions

Also available in: Atom PDF