Making MODS - Revision history

Kgmatheny: addition of info on errors, restructuring of page

Kgmatheny — Tue, 19 Feb 2013 18:00:01 GMT

addition of info on errors, restructuring of page

←Older revision		Revision as of 18:00, 19 February 2013
Line 15:		Line 15:

	*Open metadata (.xlsx) in Excel and choose SAVE AS.		*Open metadata (.xlsx) in Excel and choose SAVE AS.
-
-	*Choose the "Text (Tab delimited)" option as shown if the metadata has no diacritics/ "foreign" characters in it.
-	**If there are diacritics in the metadata, refer to [[Diacritics]] before proceeding.

	[[Image:MODS_1.png]]		[[Image:MODS_1.png]]
		+
		+	*Choose the "Text (Tab delimited)" option as shown if the metadata has no "foreign" characters (diacritics) in it or if you don't know if there are.
		+	**If you know there are diacritics in the metadata, go directly to [[Diacritics]] before proceeding.

	*Save the .txt file in a prepared "Metadata" folder in the Digital_Coll_Complete directory.		*Save the .txt file in a prepared "Metadata" folder in the Digital_Coll_Complete directory.

	*Open the .txt folder with your text editor.		*Open the .txt folder with your text editor.
-	**Do a find and replace to remove all the quotation marks that have appeared during the export	+	** Do a find and replace to remove all the quotation marks that have appeared during the export.
-	**Make sure the file is encoded as UTF-8 rather than ANSI or anything else. (In Notepad++, encoding will display in the bottom right corner of the screen. To change it, go to the Encoding menu and select Encode in UTF-8.)	+	** Check for [[Diacritics]] (unless you repaired them beforehand) and follow any applicable instructions before continuing
-	**Save the file.	+	** Make sure the file is encoded as UTF-8 rather than ANSI or anything else. (In Notepad++, encoding will display in the bottom right corner of the screen. To change it, go to the Encoding menu and select Encode in UTF-8.)
		+	** Save the file.

	*Open Archivist Utility.		*Open Archivist Utility.
Line 41:		Line 42:
	*Choose the "Update Output" tab to check for errors.		*Choose the "Update Output" tab to check for errors.

-	*Choose the "Log" tab to check for an error report.	+	*Choose the "Log" tab to check for an error report (see below for explanations)
-	**If you receive an error that reads "Invalid XML output, cannot tidy output," that means you have a diacritics issue (~~bad character~~) in your metadata text file. This is probably because some of the text in the spreadsheet was copied from Word. First, you can try to identify the character and correct it by hand. If that is not possible, try the steps found on the [[Diacritics]] page.	+

	*If no errors, chose "Export All Rows" and place the MODS output in the prepared MODS folder in the Digital_Coll_Complete directory.		*If no errors, chose "Export All Rows" and place the MODS output in the prepared MODS folder in the Digital_Coll_Complete directory.
		+
		+
		+	==Error and Warning Messages==
		+
		+	===invalid XML output, could not tidy output===
		+	* this means you have an issue with a nonprinting character, almost always a diacritic
		+	* the Row # it gives you will be one row up from where the row lies on the spreadsheet (your spreadsheet has headers, but Archivist Utility starts counting at the row below the header)
		+	** example: ''Error (u0003_0000581.txt row 147): invalid XML output, could not tidy output'' refers to a problem with spreadsheet line 148
		+
		+	===Missing Columns and Unused Columns===
		+
		+	====are different====
		+
		+	This means you're probably using the wrong template
		+
		+	This is what it looks like when you put an old-form spreadsheet into a m0# template
		+
		+	[[image:old-ss-form_in_new-ss-template.jpg]]
		+
		+	This is what it looks like when you put a m0# spreadsheet into an old-form template
		+
		+	[[image:new-ss-form_in_old-ss-template.jpg]]
		+
		+	====are almost the same====
		+
		+	This means there's probably a misspelling in the the column header
		+
		+	Example: if you've got a Missing Column called "Date Created" and an Unused Column called "DateCreated," that's the same problem: the column was labeled incorrectly in the spreadsheet

Kgmatheny at 16:18, 26 September 2012

Kgmatheny — Wed, 26 Sep 2012 16:18:25 GMT

←Older revision		Revision as of 16:18, 26 September 2012
Line 23:		Line 23:
	*Save the .txt file in a prepared "Metadata" folder in the Digital_Coll_Complete directory.		*Save the .txt file in a prepared "Metadata" folder in the Digital_Coll_Complete directory.

-	*Open the .txt folder with your text editor. Do a find and replace to remove all the quotation marks that have appeared during the export.	+	*Open the .txt folder with your text editor.
		+	**Do a find and replace to remove all the quotation marks that have appeared during the export
		+	**Make sure the file is encoded as UTF-8 rather than ANSI or anything else. (In Notepad++, encoding will display in the bottom right corner of the screen. To change it, go to the Encoding menu and select Encode in UTF-8.)
		+	**Save the file.

	*Open Archivist Utility.		*Open Archivist Utility.
-
-	[[Image:MODS_2.png]]

	*Load the correct MODS template by choosing the "Load XML Template".		*Load the correct MODS template by choosing the "Load XML Template".
Line 34:		Line 35:
	**Both of these templates can be found in S:\Digital Projects\Administrative\forSoftware\ArchivistUtility		**Both of these templates can be found in S:\Digital Projects\Administrative\forSoftware\ArchivistUtility

-	* Chose the "Load Data" tab and select your .txt file.	+	[[Image:MODS_2.png]]
		+
		+	*Chose the "Load Data" tab and select your .txt file.
		+
		+	*Choose the "Update Output" tab to check for errors.

-	*Choose the "Log" tab to check for ~~errors~~.	+	*Choose the "Log" tab to check for an error report.
	**If you receive an error that reads "Invalid XML output, cannot tidy output," that means you have a diacritics issue (bad character) in your metadata text file. This is probably because some of the text in the spreadsheet was copied from Word. First, you can try to identify the character and correct it by hand. If that is not possible, try the steps found on the [[Diacritics]] page.		**If you receive an error that reads "Invalid XML output, cannot tidy output," that means you have a diacritics issue (bad character) in your metadata text file. This is probably because some of the text in the spreadsheet was copied from Word. First, you can try to identify the character and correct it by hand. If that is not possible, try the steps found on the [[Diacritics]] page.

	*If no errors, chose "Export All Rows" and place the MODS output in the prepared MODS folder in the Digital_Coll_Complete directory.		*If no errors, chose "Export All Rows" and place the MODS output in the prepared MODS folder in the Digital_Coll_Complete directory.

Scpstu32: /* Steps */

Scpstu32 — Mon, 02 Jul 2012 17:41:00 GMT

Steps

←Older revision		Revision as of 17:41, 2 July 2012
Line 37:		Line 37:

	*Choose the "Log" tab to check for errors.		*Choose the "Log" tab to check for errors.
		+	**If you receive an error that reads "Invalid XML output, cannot tidy output," that means you have a diacritics issue (bad character) in your metadata text file. This is probably because some of the text in the spreadsheet was copied from Word. First, you can try to identify the character and correct it by hand. If that is not possible, try the steps found on the [[Diacritics]] page.

	*If no errors, chose "Export All Rows" and place the MODS output in the prepared MODS folder in the Digital_Coll_Complete directory.		*If no errors, chose "Export All Rows" and place the MODS output in the prepared MODS folder in the Digital_Coll_Complete directory.

Scpstu32 at 15:15, 26 June 2012

Scpstu32 — Tue, 26 Jun 2012 15:15:58 GMT

←Older revision		Revision as of 15:15, 26 June 2012
Line 1:		Line 1:
	==Introduction==		==Introduction==
	This page demonstrates how to create MODS files using Archivist Utility from an Excel metadata spreadsheet.		This page demonstrates how to create MODS files using Archivist Utility from an Excel metadata spreadsheet.
		+
		+	for information on how to upload MODS, see [[Uploading MODS]]


Line 36:		Line 38:
	*Choose the "Log" tab to check for errors.		*Choose the "Log" tab to check for errors.

-	*If no errors, chose "Export All Rows" and place the MODS output in the prepared MODS folder in the Digital_Coll_Complete directory.	+	*If no errors, chose "Export All Rows" and place the MODS output in the prepared MODS folder in the Digital_Coll_Complete directory.
-		+
-		+
-		+
-		+
-	~~for information on how to upload MODS, see [[Uploading MODS]]~~	+

Scpstu32: /* Steps */

Scpstu32 — Tue, 26 Jun 2012 15:15:25 GMT

Steps

←Older revision		Revision as of 15:15, 26 June 2012
Line 32:		Line 32:
	**Both of these templates can be found in S:\Digital Projects\Administrative\forSoftware\ArchivistUtility		**Both of these templates can be found in S:\Digital Projects\Administrative\forSoftware\ArchivistUtility

		+	* Chose the "Load Data" tab and select your .txt file.

		+	*Choose the "Log" tab to check for errors.

-		+	*If no errors, chose "Export All Rows" and place the MODS output in the prepared MODS folder in the Digital_Coll_Complete directory.


		+

	for information on how to upload MODS, see [[Uploading MODS]]		for information on how to upload MODS, see [[Uploading MODS]]

Scpstu32: /* Steps */

Scpstu32 — Tue, 26 Jun 2012 15:12:40 GMT

Steps

←Older revision		Revision as of 15:12, 26 June 2012
Line 25:		Line 25:
	*Open Archivist Utility.		*Open Archivist Utility.

-	[[Image:~~Example~~.~~jpg~~]]	+	[[Image:MODS_2.png]]

	*Load the correct MODS template by choosing the "Load XML Template".		*Load the correct MODS template by choosing the "Load XML Template".

Scpstu32: /* Steps */

Scpstu32 — Tue, 26 Jun 2012 15:12:09 GMT

Steps

←Older revision		Revision as of 15:12, 26 June 2012
Line 18:		Line 18:

	[[Image:MODS_1.png]]		[[Image:MODS_1.png]]
		+
		+	*Save the .txt file in a prepared "Metadata" folder in the Digital_Coll_Complete directory.
		+
		+	*Open the .txt folder with your text editor. Do a find and replace to remove all the quotation marks that have appeared during the export.
		+
		+	*Open Archivist Utility.
		+
		+	[[Image:Example.jpg]]
		+
		+	*Load the correct MODS template by choosing the "Load XML Template".
		+	**For "old" metadata spreadsheets, this template is MODS-template_7.ds.xml
		+	**For m01 metadata spreadsheets, this template is AU_template.m01_5.xml
		+	**Both of these templates can be found in S:\Digital Projects\Administrative\forSoftware\ArchivistUtility

Scpstu32: /* Steps */

Scpstu32 — Tue, 26 Jun 2012 14:55:40 GMT

Steps

←Older revision		Revision as of 14:55, 26 June 2012
Line 15:		Line 15:

	*Choose the "Text (Tab delimited)" option as shown if the metadata has no diacritics/ "foreign" characters in it.		*Choose the "Text (Tab delimited)" option as shown if the metadata has no diacritics/ "foreign" characters in it.
-	**If there are diacritics in the metadata, refer to [[Diacritics]].	+	**If there are diacritics in the metadata, refer to [[Diacritics]] before proceeding.
		+
		+	[[Image:MODS_1.png]]

Scpstu32: /* Steps */

Scpstu32 — Tue, 26 Jun 2012 14:55:04 GMT

Steps

←Older revision		Revision as of 14:55, 26 June 2012
Line 13:		Line 13:

	*Open metadata (.xlsx) in Excel and choose SAVE AS.		*Open metadata (.xlsx) in Excel and choose SAVE AS.
		+
		+	*Choose the "Text (Tab delimited)" option as shown if the metadata has no diacritics/ "foreign" characters in it.
		+	**If there are diacritics in the metadata, refer to [[Diacritics]].

Scpstu32 at 14:52, 26 June 2012

Scpstu32 — Tue, 26 Jun 2012 14:52:11 GMT

←Older revision		Revision as of 14:52, 26 June 2012
Line 3:		Line 3:


-	=What You Need=	+	==What You Need==

	*Microsoft Excel		*Microsoft Excel
Line 10:		Line 10:


-	~~----~~	+	==Steps==
		+
		+	*Open metadata (.xlsx) in Excel and choose SAVE AS.
		+

-	A brief, Microsoft Word '''tutorial''' describing the steps to generate MODS is available [http://intranet.lib.ua.edu/wiki/digcoll/images/8/80/MakingMODS.docx here.]