BATCH Metadata - Revision history

Kgmatheny: deprecated

2013-01-08T22:17:20Z

deprecated

←Older revision		Revision as of 22:17, 8 January 2013
Line 1:		Line 1:
-	for a PDF document of this information with images please see [http://www.lib.ua.edu/wiki/digcoll/images/3/37/Creating_Batch_metadata_for_upload.pdf here].	+	As of January 2013, we no longer use this method of isolating batch metadata. Please see [[Batches]] for more information.
		+
		+	-----
		+
		+	<font color="grey">for a PDF document of this information with images please see [http://www.lib.ua.edu/wiki/digcoll/images/3/37/Creating_Batch_metadata_for_upload.pdf here].

	==Make list of item identifiers to include in the batch==		==Make list of item identifiers to include in the batch==

Jjcolonnaromano at 21:39, 12 November 2012

2012-11-12T21:39:17Z

←Older revision		Revision as of 21:39, 12 November 2012
Line 1:		Line 1:
-	for a ~~Word~~ document of this information with images please see [http://www.lib.ua.edu/wiki/digcoll/images/3/37/Creating_Batch_metadata_for_upload.pdf here].	+	for a PDF document of this information with images please see [http://www.lib.ua.edu/wiki/digcoll/images/3/37/Creating_Batch_metadata_for_upload.pdf here].

	==Make list of item identifiers to include in the batch==		==Make list of item identifiers to include in the batch==

Jjcolonnaromano at 21:38, 12 November 2012

2012-11-12T21:38:09Z

←Older revision		Revision as of 21:38, 12 November 2012
Line 1:		Line 1:
-		+	for a Word document of this information with images please see [http://www.lib.ua.edu/wiki/digcoll/images/3/37/Creating_Batch_metadata_for_upload.pdf here].
-		+
-	for a Word document of this information with images please see here.	+

	==Make list of item identifiers to include in the batch==		==Make list of item identifiers to include in the batch==

Jjcolonnaromano at 21:32, 12 November 2012

2012-11-12T21:32:31Z

←Older revision		Revision as of 21:32, 12 November 2012
Line 1:		Line 1:
-	~~'''bold''' copy text [[Image:filename.jpg]]~~	+

	for a Word document of this information with images please see here.		for a Word document of this information with images please see here.

	==Make list of item identifiers to include in the batch==		==Make list of item identifiers to include in the batch==
-	#Use a DOS prompt to run “FOR” loops to generate reports of all tif files you want to include in the batch. The “FOR” loop is written like this: For /r %i in (*.tif) do echo %~nxi >> output.txt	+	#Use a DOS prompt to run “FOR” loops to generate reports of all .tif files you want to include in the batch. The “FOR” loop is written like this: For /r %i in (*.tif) do echo %~nxi >> output.txt
	#Open the resulting output files in excel and remove any extensions, or, sub-item level naming with a “LEFT” text formula The “LEFT” formula it written like this: =LEFT(Text,Num_chars) And in our case we use 21 for the number of characters as that includes only up to item level identification.		#Open the resulting output files in excel and remove any extensions, or, sub-item level naming with a “LEFT” text formula The “LEFT” formula it written like this: =LEFT(Text,Num_chars) And in our case we use 21 for the number of characters as that includes only up to item level identification.
	#Drag this formula down the length of the list to populate all the cells with the row adjusted formula		#Drag this formula down the length of the list to populate all the cells with the row adjusted formula

Jjcolonnaromano at 21:24, 12 November 2012

2012-11-12T21:24:46Z

←Older revision		Revision as of 21:24, 12 November 2012
Line 1:		Line 1:
	'''bold''' copy text [[Image:filename.jpg]]		'''bold''' copy text [[Image:filename.jpg]]

		+	for a Word document of this information with images please see here.

-	==Make list of ~~tifs for upload:~~==	+	==Make list of item identifiers to include in the batch==
-	~~using~~ a ~~FOR loop in~~ DOS to ~~create lists~~ of ~~tifs~~:	+	#Use a DOS prompt to run “FOR” loops to generate reports of all tif files you want to include in the batch. The “FOR” loop is written like this: For /r %i in (*.tif) do echo %~nxi >> output.txt
-	#	+	#Open the resulting output files in excel and remove any extensions, or, sub-item level naming with a “LEFT” text formula The “LEFT” formula it written like this: =LEFT(Text,Num_chars) And in our case we use 21 for the number of characters as that includes only up to item level identification.
		+	#Drag this formula down the length of the list to populate all the cells with the row adjusted formula
		+	#Then select the whole column, copy, and “paste special - values” back over the formulas
		+	#While the column is still selected run “remove duplicates” from the “data” tab to reduce the list down to just unique item level identifiers.

-	==~~Chomping~~ list of ~~file names in EXCEL:~~==	+	==Use list of item ids to parse out rows from the descriptive Metadata==
-	~~using~~ the ~~LEFT text formula~~ and ~~Remove Duplicates~~ in ~~excel:~~	+	#Copy the list of unique item level ids from the output .xlsx and temporarily paste them into a blank column in the descriptive metadata for the collection from which you are making the batch.
		+	#Select the list of unique ids and the “filename” column on the main sheet of the descriptive metadata, and apply “conditional formatting” “duplicate values”
		+	#The item level identifiers in the filename column will now be highlighted if there is a match with an id collected from the items in the scans folder being processed for upload

-	==:==	+	==Make notation of batch in collection descriptive metadata and save==
		+	#Mark the “staff notes” or “batch column” in the highlighted rows with the number of the batch being processed, then delete the temporary list of unique item level ids and save the collection descriptive metadata.
		+	#Sort the whole sheet by the values in the batch column then copy and paste those rows of metadata into a new spreadsheet.
		+	#Copy and paste the header row from the descriptive metadata to the batch spreadsheet
		+	#Close the collection descriptive metadata without saving the sort.
		+
		+	==Save copy of parsed out rows to a separate batch xlsx document==
		+	#Save the batch metadata as an .xlsx excel spreadsheet file
		+	#This file is also ready to be exported from excel as a tab delimited text file for use in making MODS.xml files and upload to the server.
		+
		+	==Export tab delimited text document in utf-8 for use in creating MODS.xml==
		+	#From Excel, Save as “Text (Tab delimited) (*.txt)” and open the resulting file in Notepad++
		+	#In Notepad++ select all the text in the file and from the ”Search” drop down open the “replace” window.
		+	#First replace “quote tab” with tab then replace “tab quote” with tab. Doing these two replacements removes quotes placed around fields by excel The “tab” character is written as \t so “tab quote” is written like \t”
		+	#Encode the batch text file in “UTF-8 without BOM”
		+	#Save the. txt file as it is now ready to be used for making MODS.xml files for upload

Jjcolonnaromano: New page: '''bold''' copy text Image:filename.jpg ==Make list of tifs for upload:== using a FOR loop in DOS to create lists of tifs: # ==Chomping list of file names in EXCEL:== using the LE...

2012-10-19T22:20:28Z

New page: '''bold''' copy text Image:filename.jpg ==Make list of tifs for upload:== using a FOR loop in DOS to create lists of tifs: # ==Chomping list of file names in EXCEL:== using the LE...

New page

'''bold''' copy text [[Image:filename.jpg]]

==Make list of tifs for upload:==
using a FOR loop in DOS to create lists of tifs:
#

==Chomping list of file names in EXCEL:==
using the LEFT text formula and Remove Duplicates in excel:

==:==