A Small Java Utility Program for Doing Post Archon Migration Data Clean Up.
This utility is meant to be used inconjunction with the Archon Migration tool to normalize the transferred records. It makes changes directly to the ASpace backend MySQL database, so needs to be run after the migration. The current release:
- Removes Classifications records which are not linked to any Resource or Accession records.
- Removes duplicate Location records.
- Removes orphaned Archival Object records.
#####Usage
- Stop the ASpace instance.
- Backup the ASpace MYSQL database.
- Unzip the aspaceDBUtil.zip into any directory on the server which ASpace is installed on.
- From the command line change into the aspaveDBUtil directory and issue the following command:
- java -jar aspaceDBUtil.jar jdbc:mysql://localhost:3306/aspaceDB username password
- Replace the jdbc URL, username, and password with those for the ASpace instance.
- Use java -jar aspaceDBUtil.jar jdbc:mysql://localhost:3306/aspaceDB username password TEST to run the program without actually making any database changes.
- Change to [archivesspace directory]/data and delete the following directories indexer_state, solr_backups, and solr_index. This will force a re-index of all records when ASpace is resarted.
- Restart the ASpace instance and wait for the records to re-indexed.
It is also possible to run this program on any computer which has Java 1.6 or later installed, and which has direct access to the ASpace MYSQL database.