Project

General

Profile

Actions

Bug #2721

closed

check sppID and NC_Codes in "old" archive db before updating to new

Added by Michael Lee about 17 years ago. Updated over 14 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
ArchiveDB
Target version:
Start date:
01/13/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2721

Description

The old database has two fields that seem to key into the CarSpList from HerbData, and TreeDataSml, but in reality it's only SppID. Some changes may have been made to old_NC_Code field, and these two fields need to be checked prior to migrating to the new archive DB.

Actions #1

Updated by Michael Lee over 15 years ago

A spreadsheet was made, marking the few cases where there are disagreements between the two. There are a few where we may want to double-check the final species ID from the next Excel spreadsheet of species updates.

Actions #2

Updated by Michael Lee over 14 years ago

The Excel spreadsheet in question is here:
CVS_Occurrences\speciesPossiblyNeedingFixes_NCCode_oldNCCode.xls

forbes and I will deal with this hopefully this week.

Actions #3

Updated by Robert Peet over 14 years ago

I am not sure what is going on here. I need to have a conversation with Michael about this migration process.

Actions #4

Updated by Michael Lee over 14 years ago

These have been fixed in archive version 1.1.37

relevant files moved to
CVS_Occurrences\OLD
so that they are out of the way.

Actions #5

Updated by Michael Lee over 14 years ago

OLD ARCHIVE DATABASE, CVS_b2G.mdb (NCVSProto4.mdb derived, not from VegBank). I'm calling this 1.0.0 in Bugzilla.

Actions #6

Updated by Redmine Admin about 11 years ago

Original Bugzilla ID was 2721

Actions

Also available in: Atom PDF