Metacat

correctly use document revision for object format and resource map joins.

use correct children of 'publisher' element

include the resourceMapId for the metadata objects, not just the data files.

updated LDAP dump and corrected missing entries that had been removed from LDAP.

handle null givenNames from the LDAP dump.

make sure we only get the publisher text content (not attribute value)

DOI registration:
-include more revision history based on the identifier table not just the generated SM metadata
-include ecogrid data urls for revisions (long query in xml_nodes_revisions table)

update creator and publisher using LDAP dump. unfortunately LDAP has shifted over the years and not all identities are still active in LDAP...but we did get quite a few creator names updated!
https://redmine.dataone.org/issues/2815

save point - adding more columns for access, data packaging, revision history
https://redmine.dataone.org/issues/2815

update the table to indicate which DOI account we are targeting
https://redmine.dataone.org/issues/2815

use production cn url for the resolve url

encode '/' and ':' in the DOI used for the resolve URL

include revisions table in the initial temp table population.
use the "first" creator listed in the EML (either org or person).
use other reasonable default values as needed to fully populate the spreadsheet columns
https://redmine.dataone.org/issues/2815

add columns: publisher and pub_date. include default values for all columns - even data files should have title.
still a few todos but closer.
https://redmine.dataone.org/issues/2815

script to generate DOI registration spreadsheet
https://redmine.dataone.org/issues/2815