Project

General

Profile

Bug #2721

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

Added by Michael Lee almost 14 years ago. Updated about 11 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.

History

#1 Updated by Michael Lee almost 12 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.

#2 Updated by Michael Lee about 11 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.

#3 Updated by Robert Peet about 11 years ago

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

#4 Updated by Michael Lee about 11 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.

#5 Updated by Michael Lee about 11 years ago

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

#6 Updated by Redmine Admin over 7 years ago

Original Bugzilla ID was 2721

Also available in: Atom PDF