PhycoBank

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%'

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

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

[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

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!!!

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