This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
finding_aids [2024/09/16 21:22] jeremy |
finding_aids [2025/01/07 19:13] (current) kay |
||
---|---|---|---|
Line 64: | Line 64: | ||
* Make sure dates and folder numbers are correct, spelling errors are fixed, etc. You can have as many columns as you want, but whatever columns you want in your inventory will need to be mapped to an EAD element. | * Make sure dates and folder numbers are correct, spelling errors are fixed, etc. You can have as many columns as you want, but whatever columns you want in your inventory will need to be mapped to an EAD element. | ||
- | * Title you columns //exactly// how the element appears in EAD (e.g. unittitle, unitdatenormal, unitdate, etc.) | + | * Title you columns //exactly// how the element appears in EAD. These are the elements available in this XSLT transformation: unittitle, unitdatenormal, unitdate, unitid, box, folder, drawer, scopecontent, extent, creator, arrangement, subject, genreform, accessrestrict. |
- | * For approximate dates, you will need to insert one column titled //approximate// and then type the word approximate for any date that is approximate. | + | * For approximate dates, you will need to insert one column titled //approximate// and then type the word 'approximate' for any date that is approximate. |
* Before you ingest it into Oxygen, you will have the option to not include certain columns, so you don't need to delete columns like "notes", "digitized", "file name", etc. if you want to keep the spreadsheet for more detailed information. | * Before you ingest it into Oxygen, you will have the option to not include certain columns, so you don't need to delete columns like "notes", "digitized", "file name", etc. if you want to keep the spreadsheet for more detailed information. | ||
* To include the normal="XXXX/XXXX" date attribute, you will need to create an additional date column with the dates formatted that way (e.g. YYYY-MM-DD/YYYY-MM-DD, YYYY/YYYY, etc.) | * To include the normal="XXXX/XXXX" date attribute, you will need to create an additional date column with the dates formatted that way (e.g. YYYY-MM-DD/YYYY-MM-DD, YYYY/YYYY, etc.) | ||
* Delete any blank columns and rows or it will introduce several blank elements. | * Delete any blank columns and rows or it will introduce several blank elements. | ||
+ | * You can create separate tabs if you have multiple series for easier integration/organization. This is helpful during the copy/paste process, but not necessary. | ||
+ | * Here is a [[https://docs.google.com/spreadsheets/d/1fwcWfFG2lVcPgM0svrs56pXW7Ln3ufTojdQkhVqt_v8/edit?gid=1986408204#gid=1986408204|sample google spreadsheet]] to use as a model. | ||
Open Oxygen and set up the "XSLT Transformation Scenario" | Open Oxygen and set up the "XSLT Transformation Scenario" |