DigiTool Migration Workflow - Revision history

Kpowell: /* Quality Assurance (QA) */

2019-02-22T17:13:48Z

Quality Assurance (QA)

← Older revision		Revision as of 17:13, 22 February 2019
Line 167:		Line 167:
	* For the complex Migration workflow (METS)		* For the complex Migration workflow (METS)
	** '''submissions\[PartnerCode]\METS'''		** '''submissions\[PartnerCode]\METS'''

	~~=Quality Assurance (QA)=~~

Kpowell: /* Rosetta Ingest */

2019-01-30T16:42:40Z

Rosetta Ingest

← Older revision		Revision as of 16:42, 30 January 2019
Line 162:		Line 162:
	=Rosetta Ingest=		=Rosetta Ingest=

	# Copy the '''[YYYYMMDD]-[PartnerCode]-[DescriptiveText]_deposit''' folder to the appropriate submissions folder.		'''1. Copy the '''[YYYYMMDD]-[PartnerCode]-[DescriptiveText]_deposit''' folder to the appropriate submissions folder.'''
	#* For the simple Migration workflow (CSV)		* For the simple Migration workflow (CSV)
	#** '''submissions\[PartnerCode]\CSV'''		** '''submissions\[PartnerCode]\CSV'''
	#* For the complex Migration workflow (METS)		* For the complex Migration workflow (METS)
	#** '''submissions\[PartnerCode]\METS'''		** '''submissions\[PartnerCode]\METS'''

	=Quality Assurance (QA)=		=Quality Assurance (QA)=

Kpowell: /* ALEPH Reconciliation */

2019-01-30T16:37:47Z

ALEPH Reconciliation

← Older revision		Revision as of 16:37, 30 January 2019
Line 112:		Line 112:

	:: [[File:Update_marc.png\|border\|500px]]		:: [[File:Update_marc.png\|border\|500px]]
	* If these ~~MARC~~ records are associated with a parent collection, add the ALEPH System Number for that parent collection in the pop up window.		* If these MARCXML records are associated with a parent collection, add the ALEPH System Number for that parent collection in the pop up window.

	:: [[File:Coll num.PNG\|border\|500px]]		:: [[File:Coll num.PNG\|border\|500px]]

Kpowell: /* ALEPH Reconciliation */

2019-01-30T16:37:21Z

ALEPH Reconciliation

← Older revision		Revision as of 16:37, 30 January 2019
Line 109:		Line 109:
	=ALEPH Reconciliation=		=ALEPH Reconciliation=
	'''1. Update MARCXML Batch.'''		'''1. Update MARCXML Batch.'''
	* Open the Rosetta Migration Utility and go to Tools --> Update ~~MARC~~. Locate the MARCXML Batch.		* Open the Rosetta Migration Utility and go to Tools --> Update MARCXML. Locate the MARCXML Batch.

	:: [[File:Update_marc.png\|border\|500px]]		:: [[File:Update_marc.png\|border\|500px]]

Kpowell: /* Process */

2019-01-30T16:36:38Z

Process

← Older revision		Revision as of 16:36, 30 January 2019
Line 79:		Line 79:
	==Process==		==Process==
	'''1. Supply path to CSV template'''		'''1. Supply path to CSV template'''

	'''2. Supply path to export folder'''		'''2. Supply path to export folder'''

Kpowell at 23:35, 29 January 2019

2019-01-29T23:35:13Z

← Older revision		Revision as of 23:35, 29 January 2019
Line 140:		Line 140:
	* '''/exlibris/aleph/u22_1/cjh01/scratch'''		* '''/exlibris/aleph/u22_1/cjh01/scratch'''

	'''4. Open Aleph and, follow ~ THIS GUIDE ~ for adding records.'''		'''4. Open Aleph and follow ~ THIS GUIDE ~ for adding records.'''
	* Write down the name of the log file created during the manage-18 job. This can be used in the next step as the input file.		* Write down the name of the log file created during the manage-18 job. This can be used in the next step as the input file.

Kpowell at 23:34, 29 January 2019

2019-01-29T23:34:42Z

← Older revision		Revision as of 23:34, 29 January 2019
Line 142:		Line 142:
	'''4. Open Aleph and, follow ~ THIS GUIDE ~ for adding records.'''		'''4. Open Aleph and, follow ~ THIS GUIDE ~ for adding records.'''
	* Write down the name of the log file created during the manage-18 job. This can be used in the next step as the input file.		* Write down the name of the log file created during the manage-18 job. This can be used in the next step as the input file.
	* Once the records are added, follow ~ THIS GUIDE ~ for downloading MARCXML from ALEPH.
	* Use the commands below to add Aleph System Numbers to a copy of the original deposit CSV.
	* If successful, the script will create an edited version of the original deposit CSV with the ALEPH system numbers added.
	* If the edited Deposit CSV is correct, move the original CSV to another location.

	~~== Adding~~ ALEPH system numbers to deposit CSV ==		'''5. Follow ~ THIS GUIDE ~ for downloading MARCXML from ALEPH. '''

			'''6. Add ALEPH system numbers to deposit CSV'''
	* Open Command Prompt		* Open Command Prompt
	* cd into the directory containing add_aleph_sys.py		* cd into the directory containing add_aleph_sys.py

Kpowell: /* ALEPH Reconciliation */

2019-01-29T23:33:00Z

ALEPH Reconciliation

← Older revision		Revision as of 23:33, 29 January 2019
Line 107:		Line 107:

	=ALEPH Reconciliation=		=ALEPH Reconciliation=
	If the ~~Deposit Processor extracted~~ MARC ~~records from the DigiTool export, open a sample amount to see if they have ALEPH system numbers in~~ the ~~001 controlfield~~. ~~If they do not have ALEPH system numbers, they need to be added to ALEPH:~~		'''1. Update MARCXML Batch.'''
			* Open the Rosetta Migration Utility and go to Tools --> Update MARC. Locate the MARCXML Batch.

	~~# Create MARCXML Batch from extracted MARC records.~~		:: [[File:Update_marc.png\|border\|500px]]
	~~# Open the Rosetta Deposit Processor and go to Tools --> Migration Tools --> Update MARC. Locate the MARCXML Batch.~~		* If these MARC records are associated with a parent collection, add the ALEPH System Number for that parent collection in the pop up window.
	#: [[File:Update_marc.png\|border\|500px]]
	# If these MARC records are associated with a parent collection, add the ALEPH System Number for that parent collection in the pop up window.		:: [[File:Coll num.PNG\|border\|500px]]
	#: [[File:Coll num.PNG\|border\|500px]]
	~~# Once the batch has been updated, open~~ MarcEdit. Go to File --> MARC Tools --> "MARC21XML => MARC"		'''2. Open MarcEdit. Go to File --> MARC Tools --> "MARC21XML => MARC"'''
	#: [[File:Marc edit 1.png\|border\|500px]]
	# Under Input File supply the path to the updated MARCXML batch file.		:: [[File:Marc edit 1.png\|border\|500px]]
	# Under Output File supply a path for a new .MRC file.
	#* Use the '''[YYYYMMDD]-[PartnerCode]-[DescriptiveText]''' naming convention, but make sure it is entirely in lower case. Aleph does not like capital letters in input file names.		* Under Input File supply the path to the updated MARCXML batch file.
	# Make sure UTF-8 is chosen as Default Character Encoding		* Under Output File supply a path for a new .MRC file.
	#: [[File:Marc edit 2.png\|border\|500px]]		** Use the '''[YYYYMMDD]-[PartnerCode]-[DescriptiveText]''' naming convention, but make sure it is entirely in lower case. Aleph does not like capital letters in input file names.
	# Click Execute		* Make sure UTF-8 is chosen as Default Character Encoding
	# After the MRC file is created, double click it. This will open MARC Edit again and prompt you to create a human-readable MRK file.
	#: [[File:Marc edit 3.PNG\|border\|500px]]		:: [[File:Marc edit 2.png\|border\|500px]]
	# Open the MRK file to double check the MARC records. Make sure there aren't ~~two~~ leaders in a record.
	#: [[File:Marc edit 4.PNG\|border\|500px]]		* Click Execute
	#* If there are ~~two~~ leaders, contact the Rosetta Systems Administrator		* After the MRC file is created, double click it. This will open MARC Edit again and prompt you to create a human-readable MRK file.
	~~# If the~~ MRC file ~~is ready to go, upload it~~ to ~~this location on~~ the ALEPH server
	#* '''/exlibris/aleph/u22_1/cjh01/scratch'''		:: [[File:Marc edit 3.PNG\|border\|500px]]
	# Open Aleph and, follow ~ THIS GUIDE ~ for adding records.
	# Write down the name of the log file created during the manage-18 job. This can be used in the next step as the input file.		* Open the MRK file to double check the MARC records. Make sure there aren't bad leaders in a record. You can do this by doing a "Find All" search for "=LDR" and looking for "^" symbols.
	# Once the records are added, follow ~ THIS GUIDE ~ for downloading MARCXML from ALEPH.
	# Use the commands below to add Aleph System Numbers to a copy of the original deposit CSV.		:: [[File:Marc edit 4.PNG\|border\|500px]]
	# If successful, the script will create an edited version of the original deposit CSV with the ALEPH system numbers added.
	# If the edited Deposit CSV is correct, move the original CSV to another location.		* If there are bad leaders, contact the Rosetta Systems Administrator

			'''3. Upload MRC file to the ALEPH server'''
			* '''/exlibris/aleph/u22_1/cjh01/scratch'''

			'''4. Open Aleph and, follow ~ THIS GUIDE ~ for adding records.'''
			* Write down the name of the log file created during the manage-18 job. This can be used in the next step as the input file.
			* Once the records are added, follow ~ THIS GUIDE ~ for downloading MARCXML from ALEPH.
			* Use the commands below to add Aleph System Numbers to a copy of the original deposit CSV.
			* If successful, the script will create an edited version of the original deposit CSV with the ALEPH system numbers added.
			* If the edited Deposit CSV is correct, move the original CSV to another location.

	== Adding ALEPH system numbers to deposit CSV ==		== Adding ALEPH system numbers to deposit CSV ==

Kpowell: /* CSV Processing */

2019-01-29T23:27:57Z

CSV Processing

← Older revision		Revision as of 23:27, 29 January 2019
Line 87:		Line 87:
	* This process extracts the technical and administrative metadata exported by DigiTool and creates Metadata Update files. These files will be used to update the migrated objects' metadata once they're ingested into Rosetta.		* This process extracts the technical and administrative metadata exported by DigiTool and creates Metadata Update files. These files will be used to update the migrated objects' metadata once they're ingested into Rosetta.
	* An example of a successful DigiTool Migration process log can be [[Media:Migration log.txt\|viewed here]].		* An example of a successful DigiTool Migration process log can be [[Media:Migration log.txt\|viewed here]].


	= METS Processing =		= METS Processing =

Kpowell: /* Process */

2019-01-29T23:27:40Z

Process

← Older revision		Revision as of 23:27, 29 January 2019
Line 101:		Line 101:
	'''1. Supply path to export folder'''		'''1. Supply path to export folder'''

	:: [[File:Migration 2.PNG\|border\|500px]]		:: [[File:Migration complex.PNG\|border\|500px]]

	'''2. Submit'''		'''2. Submit'''