Check - fix creation date

[zubeydecivelek]

invenio-migrator is dumping the records from hstRECORD table and the first entry of this table is in 2003-05-30 so before this date records dont have any revisions.

This causes the old records(older than 2003) are missing their initial revision in the table. This leads to an incorrect creation_date, since the first available revisionis not the actual record creation. In this case bibrec table has the correct creation date.

• Check and confirm this is the actual case for the migrated records.
  • Confirm all the records created after 2003-05-30 has the same date in both tables
  • Confirm records created before 2003-05-30 has different dates
• Update invenio-migrator to get the correct date
• Update migrator kit to get the correct date
• Fix the migrated records creation date in cds-rdm and videos with a script

[zubeydecivelek]

Checked the migrated records:

• ✅ Confirm records created before 2003-05-30 has different dates
• ❌ Confirm all the records created after 2003-05-30 has the same date in both tables
  • Still some records has the wrong date

Results of records migrated to CDS Videos:

Searched with: 8567_x:'Absolute master path' 8567_d:/mnt/master_share* 980__c:MIGRATED

Total records: 22198
Wrong creation date records: 432
Correct creation date records: 21766

file with correct dates: link

Results of records migrated to CDS-RDM:

Searched with: 980__c:MIGRATED 970__d:https://repository.cern/*

Total records: 115518
Wrong creation date records: 10802
Correct creation date records: 104716

file with correct dates: link