Release v0.6

New features:

• Allow update of existing subrecords and also addition of new subrecords via extra blank columns
• Support deletion of subrecords when column entries are cleared
• Include columns for instances whereby sub container and top container fields can be set
• Date type is defaulted based on the presence of an end date column entry
• Add validation to ensure archival objects in spreadsheet exist
• Configurable delete of sub records via AppConfig[:spreadsheet_bulk_updater_apply_deletes]
• Configurable creation of new top containers (for those in the spreadsheet not found used within the hierarchy of the current resource) via AppConfig[:spreadsheet_bulk_updater_create_missing_top_containers]

Bug fixes:

• Support prefix in staff UI routes
• Exclude the resource id from the spreadsheet (archival objects only)

Release v0.5

Sprinkle of extra parenthesis and escape of literal SQL query to try and avoid SQL errors when counting notes.

Release v0.4

Fixed a bug whereby an AO with no notes throws an exception.

Release v0.3

Support notes! Well... support text only notes for multipart note types "bioghist", "scopecontent" and "accessrestrict".

Release v0.2

Update the columns in the spreadsheet to:

• Title
• Level of Description
• Dates (subrecord)
  • Expression
  • Begin
  • End
  • Certainty
• Extent (subrecord)
  • Portion
  • Number
  • Type
  • Container Summary

And support more than 26 columns!

Release v0.1

Initial version for proof of concept and testing/sanity checking.