Project

General

Profile

task #6279

task #6009: Import the IAPT database into a cdm instance

task #6034: DataCleaning after final import

remove all 'nom. val' status from name

Added by Andreas Kohlbecker over 3 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Highest
Category:
Import
Start date:
12/13/2016
Due date:
% Done:

100%


Description

during the import all name which did not have an explicitly stated status, did receive the status 'nom. valid'. This turned out to be not correct in all cases. So we need to remove all the 'nom. val' status from names

this can be done using a sql script.

 delete t_n from TaxonNameBase_NomenclaturalStatus t_n where t_n.status_id in (select n.id from NomenclaturalStatus n where n.type_id = 860);
 delete n from NomenclaturalStatus n where n.type_id = 860;

History

#1 Updated by Andreas Kohlbecker over 3 years ago

  • Description updated (diff)

#2 Updated by Andreas Kohlbecker over 3 years ago

  • Status changed from New to Resolved
  • Assignee changed from Andreas Kohlbecker to Wolf-Henning Kusber
  • % Done changed from 0 to 80

sql script applied to production and test database.

@Henning: please review

#3 Updated by Wolf-Henning Kusber over 3 years ago

  • Status changed from Resolved to Closed
  • % Done changed from 80 to 100

some records checked in test portal: all are okay. Set "Done" to 100% and close ticket (2017-03-17)

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)