Data cleanup completed by hand for Lots

  • Erased duplicate entries and reassign all lots in the duplicate entry to the remaining, single entry.
  • Cleaned up lot number prefix formatting for all IL lots.
  • Re-assigned objects in "?" lots to their proper lots.
  • Accession method: moved all data from this field to "Lot Description."
  • Assigned all existing IL objects to available lots.
  • Note: I fixed all of the records that showed up on my excel report for lots. Due to the fact that formatting inconsistencies of IL numbers (some of which include a hyphen) sometimes prevents lots or objects from showing up on search, there is a small possibility that the reports were not complete for that reason, and that some unedited records remain in the database. See Bugs in Search and Reporting.