Actions
task #6279
closedtask #6009: Import the IAPT database into a cdm instance
task #6034: DataCleaning after final import
remove all 'nom. val' status from name
Status:
Closed
Priority:
Highest
Assignee:
Category:
Import
Target version:
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;
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
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