Project

General

Profile

Actions

task #6279

closed

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 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Highest
Category:
Import
Start date:
Due date:
% Done:

100%

Estimated time:

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;
Actions #1

Updated by Andreas Kohlbecker over 6 years ago

  • Description updated (diff)
Actions #2

Updated by Andreas Kohlbecker over 6 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

Actions #3

Updated by Wolf-Henning Kusber about 6 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)

Actions

Also available in: Atom PDF