Project

General

Profile

Actions
Copy link

task #7532

closed

Final creation of Registrations for the production database

Added by Andreas Kohlbecker almost 6 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
New
Assignee:
Andreas Kohlbecker
Category:
Import
Target version:
Registry prototype available
Start date:
Due date:
% Done:

100%

Estimated time:

Description

For the phycobank production database the Registrations need to be created from the TaxonName extensions.

The according functionality has been implemented in #7055.

Running the Registration creation process fails with the production database due to a couple of data problems:

Files

2018-07-05-phycobank-registration-creation.log (272 KB) 2018-07-05-phycobank-registration-creation.log Andreas Kohlbecker, 07/05/2018 08:51 AM
Actions
Copy link
 #1

Updated by Andreas Kohlbecker almost 6 years ago

1.

Ich habe Schwierigkeiten mit folgenden Namen:
Ich habe Schwierigkeiten mit folgenden Namen:

bc68aae3-cc6e-4931-87a4-057e70f15d4e Chroomonas sp. 1 Hoef-Emden {"date":"2018-05-XX","regId":100143,"office":"PhycoBank Berlin","formNumber":null}
7ac34a69-dd7a-4f30-abe2-a652fdc18246 Chroomonas sp. 2 Hoef-Emden {"date":"2018-05-XX","regId":100142,"office":"PhycoBank Berlin","formNumber":null}

die Daten 2018-05-XX kann ich nicht parsen, ich importiere sie erstmal als 2018-05-01, Das musst du später von Hand anpassen.

select n.uuid, n.titleCache, e.value from TaxonName n 
  join TaxonName_Extension n_e on n.id = n_e.TaxonName_id
  join Extension e on n_e.extensions_id = e.id
  where e.value like '%2018-05-XX%'

select * from Extension e 
  where e.value like '%2018-05-XX%'
Actions
Copy link
 #2

Updated by Andreas Kohlbecker almost 6 years ago 

IAPT Registration for Surirella anassae Cholnoky ... 

[phycobank_production] 07:56:11,267 ERROR [main][eu.et.cd.da.RegistrationRequiredDataInserter] - Error mapping json from extension to IAPTRegData
com.fasterxml.jackson.databind.exc.InvalidFormatException: Can not construct instance of java.lang.Integer from String value '100022,': not a valid Integer value
 at [Source: {"date":"2017-03-29","regId":"100022,"office":"PhycoBank Berlin"}; line: 1, column: 21] (through reference chain: eu.etaxonomy.cdm.dataInserter.IAPTRegData["regId"])

minor issues:

[phycobank_production] 07:56:07,685 DEBUG [main][eu.et.cd.da.RegistrationRequiredDataInserter] - IAPT Registration for Chroomonas sp. 1 Hoef-Emden ...
[phycobank_production] 07:56:07,686 ERROR [main][eu.et.cd.da.RegistrationRequiredDataInserter] - Missing TypeDesignation Citation in Phycobank data

[phycobank_production] 07:56:07,689 DEBUG [main][eu.et.cd.da.RegistrationRequiredDataInserter] - IAPT Registration for Chroomonas sp. 2 Hoef-Emden ...
[phycobank_production] 07:56:07,690 ERROR [main][eu.et.cd.da.RegistrationRequiredDataInserter] - Missing TypeDesignation Citation in Phycobank data
Actions
Copy link
 #3

Updated by Andreas Kohlbecker almost 6 years ago

The issue in the Surirella anassae Cholnoky Extension is fixed in the db.

Actions
Copy link
 #4

Updated by Andreas Kohlbecker almost 6 years ago 

[phycobank_production] 08:42:23,850 DEBUG [main][eu.et.cd.da.RegistrationRequiredDataInserter] - IAPT Registration for Surirella oliffii Cholnoky ...
[phycobank_production] 08:42:23,852 DEBUG [main][eu.et.cd.da.RegistrationRequiredDataInserter] - skipping name published in older referece
[phycobank_production] 08:42:23,852 ERROR [main][eu.et.cd.da.RegistrationRequiredDataInserter] - Missing TypeDesignation Citation in Phycobank data
Actions
Copy link
 #5

Updated by Andreas Kohlbecker almost 6 years ago

Adding logfile of successful Registration creation

Actions
Copy link
 #6

Updated by Andreas Kohlbecker almost 6 years ago

bc68aae3-cc6e-4931-87a4-057e70f15d4e Chroomonas sp. 1 Hoef-Emden {"date":"2018-05-XX","regId":100143,"office":"PhycoBank Berlin","formNumber":null}
7ac34a69-dd7a-4f30-abe2-a652fdc18246 Chroomonas sp. 2 Hoef-Emden {"date":"2018-05-XX","regId":100142,"office":"PhycoBank Berlin","formNumber":null}

need to be unbublished!!!

Actions
Copy link
 #7

Updated by Andreas Kohlbecker almost 6 years ago

Andreas Kohlbecker wrote:

bc68aae3-cc6e-4931-87a4-057e70f15d4e Chroomonas sp. 1 Hoef-Emden {"date":"2018-05-XX","regId":100143,"office":"PhycoBank Berlin","formNumber":null}
7ac34a69-dd7a-4f30-abe2-a652fdc18246 Chroomonas sp. 2 Hoef-Emden {"date":"2018-05-XX","regId":100142,"office":"PhycoBank Berlin","formNumber":null}

need to be unbublished!!!

Fixed in testserver cdm_phycobank_production

Actions
Copy link
 #8

Updated by Andreas Kohlbecker over 5 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100
Actions
Copy link

Also available in: Atom PDF