====== MAVIS-SAMMA Integration ======
**by ʻUluʻulu : The Henry Kuʻualoha Giugni Moving Image Archive of Hawaiʻi**

ʻUluʻulu uses SAMMA machinery and software for physical inspection of video tapes, and the cleaning and migration of 3/4" U-matic video tapes.  We use xml files and csv files for integrating metadata created by SAMMA processes into MAVIS.  What follows is a summary of our workflow as it pertains to MAVIS-SAMMA integration.  [see [[#overall_workflow|appendix]] for workflow diagram]

===== Accessioning =====

The first thing we do is accession our video tapes, and add basic metadata for each tape.  This is done on a MAVIS Workstation, with metadata entered manually through MAVIS Client.  As each carrier is created, we paste the carrier item id number into our label printing software, print out an item id label, and put this on the video tape container.  When all of the tapes have been accessioned, we export the item list out of MAVIS Client. [see appendix for [[#accessioning1|flowchart]], [[#export_for_samma_prep_stylesheet|export stylesheet]]]

===== Importing .csv file into SAMMA Prep =====

At this point, we have a comma-separated values file with the following fields to be imported into the SAMMA Prep software:

tapeid^video_standard^tape_format^stocklength^tapeid_sequence^location^description^author^comments^output_filename

==== Change encoding of .csv file ====

We need to change the encoding of the .csv file to UTF-8, so that it will be read correctly by the SAMMA software.

==== Log into SAMMA Prep ====

Since we use a Virtual Private Network (VPN) connection to access our MAVIS database, we need to log out of MAVIS Client and disconnect from the VPN before starting the SAMMA Prep software.  This is because the Prep software needs to connect to the main SAMMA database, which is on a computer on our local network, which becomes unreachable when our workstation is logged into the VPN.  After disconnecting from the VPN, we open the SAMMA Prep software log in.

==== Import file ====

SAMMA Prep has a CSV Import tool.  We open this tool, load the .csv file, and import the data into the SAMMA database.

==== Input metadata into online spreadsheet ====

At this stage, we also input metadata into an online spreadsheet that is accessible to all staff that needs to manipulate its data.  These spreadsheets will be imported into MAVIS further down in the workflow.  We currently use Google Docs.  Which spreadsheet we use depends on the format of the video tape and how it is destined to be migrated.  The main options are the SAMMA post-migration spreadsheet, the Migrating with Final Cut Pro spreadsheet, and the Outside Vendor spreadsheet.

For video tapes to be migrated with the SAMMA Solo, we open the .csv file as a spreadsheet and paste the tape ids and file names into our sammaPostMigrationMetadata online spreadsheet.  This gives our media specialist a list of everything to be migrated with SAMMA, and a place to add metadata that is not automatically created by SAMMA during the migration process.

==== Mark .csv file as Imported ====

We then move the .csv file into a folder that lets us know that it has already been imported into SAMMA Prep.

===== Physical Inspection =====

At this point, the video tapes we accessioned should exist in the SAMMA database.  The next step is going through the SAMMA Prep process, which entails physically inspecting the item and printing out SAMMA barcodes.  This is currently done on our SAMMA Laptop Workstation, using SAMMA Prep software.  After physically inspecting the video tape, committing the record, and printing/attaching the barcodes, we need to create an xml file.  This is not created automatically during the Prep process.  We need to re-open the recently committed record, go to the Finish tab, and Save As an .xml file.  The correct file name needs to be entered by the operator.

===== Importing Prep XML into MAVIS =====

After a tape has been physically inspected at the Physical Inspection Station, an xml record should exist on the SAMMA Laptop Workstation.  These xml files should be copied onto a MAVIS Workstation on a regular weekly basis and uploaded into MAVIS.

==== Retrieve XML files ====

We currently transfer the xml files through our local network, using the Windows file browser on the MAVIS Workstation (although the visibility and accessibility of networked computers is a bit inconsistent).  So the file transfer process is basically a drag and drop procedure.  After a file has been transferred to the MAVIS Workstation, the file on the SAMMA Laptop Workstation is moved into a special folder marking it as having been moved to the MAVIS Workstation.

==== Import XML files ====

We then open MAVIS Client on the MAVIS Workstation, and import the xml file using a special stylesheet.  This creates a treatment record and condition notes for each video tape carrier, using the physical inspection categories and values from SAMMA Prep.  [see [[#import_from_samma_prep_stylesheet|appendix]] for stylesheet]

**END OF SAMMA Integration Procedures for NON-U-matic VIDEO TAPES**

===== SAMMA Clean =====

We have a 3/4" U-matic SAMMA Clean machine.  For these tapes, the next step in the process is cleaning.  The cleaning process is done on the SAMMA Laptop Workstation, using the SAMMA Clean software.  A clean.xml file is automatically created during the cleaning process.  We then import this file into MAVIS.

===== Importing Clean XML into MAVIS =====

This process is similar to the Prep process, however, it is slightly different because the Clean process also creates a clean.pdf file for each tape.  So first, we copy the clean XML files onto the MAVIS Workstation computer.  Next, we back up the clean.pdf files on our servers.  After that, we import the XML file, using MAVIS Client.  This creates a clean treatment record and a reference material (pointing to the location of the clean pdf) for each video tape carrier.  [see [[#import_from_samma_clean_stylesheet|appendix]] for stylesheet]

===== SAMMA Migration =====

The next step for 3/4" tapes is their digitization.  This occurs at our SAMMA Solo Workstation, using SAMMA Solo software.  The relevant part of this workflow is the SAMMA operator entering their MAVIS name ID number in the SAMMA record's "Migrated By" section.  Each SAMMA video tape record already has the MAVIS information that was imported into the SAMMA database during the SAMMA Prep stage.  An XML file is automatically created during the migration (along with the digital video files and a PDF file).

===== Post-Migration Procedures =====

==== Entering metadata in online spreadsheet ====

There is certain information that we want to attach to the created files that is not included in the Solo XML file.  For this we use our sammaPostMigrationMetadata online spreadsheet.  We have fields for color type and audio information, examiner notes,  examiner user name, and checksum.  This is all input during our QC process.

==== Backing up files on Servers ====

After running and recording checksum information, we back up our files on our servers.

==== Importing Solo XML files into MAVIS ====

After backing up the media files, we are ready to import the Solo XML files.

=== Retrieve XML files ===

We retrieve the XML files created during the SAMMA Solo migration using Filezilla, since, in addition to housing the SAMMA database, the Solo computer also has an FTP Server.  On the MAVIS Workstation, we connect to the ftp server (must be disconnected from the VPN first) and download the Solo XML files.

=== Import files ===

This is done on the MAVIS Workstation, using MAVIS Client.  This import creates Digital Components and copied from info for each file created with the SAMMA Solo.  [see [[#import_from_samma_solo_stylesheet|appendix]] for stylesheet]

==== Importing post-Migration Metadata into MAVIS ====

=== Add MAVIS item numbers to the online Spreadsheet ===

Before importing the metadata that was added to the sammaPostMigrationMetadata spreadsheet, we need to add MAVIS item numbers, so that the data gets attached to the correct records.  We need to retrieve the component and carrier item ids for the items that were just created during the Solo XML import.  We get these numbers through a MAVIS Client export from an items list window.  [see [[#export_for_online_spreadsheet_stylesheet|appendix]] for stylesheet] We then open up the exported file and copy and paste numbers into their proper locations in the online spreadsheet.  

=== Proofread Data ===

Then we proofread the data.

=== Import Data ===

== Convert to .csv file ==

First we download the online spreadsheet as an OpenOffice spreadsheet.  Then we open the file and clean it up, getting rid of extraneous rows.  Then we save it as a .csv file with the proper delimiters.

== Import into MAVIS ==

This is done on the MAVIS Workstation, using MAVIS Client.  We choose the .csv file and use the convert delimited file option.  This import adds checksum info and the examiner notes to the recently created items.  [see [[#import_from_online_spreadsheet_stylesheet|appendix]] for stylesheet]

===== Other Things =====

Something to keep in mind is that every time we make a change in SAMMA configuration, we need to change MAVIS codes and import stylesheets.  And procedures get slightly more complicated when multiple SAMMA profiles (PRJ's and SXT's) are being used.

===== Conclusion =====

Anyway, that is the end of our MAVIS-SAMMA integration procedures.  We start in MAVIS, export data to be imported into SAMMA Prep.  In MAVIS, we import XML files from SAMMA Prep, Clean, and Solo.  We export data from MAVIS to be input into an online spreadsheet.  We then import this spreadsheet as a CSV file back into MAVIS.  And that is that.  More detailed workflows can be provided upon request.

===== Appendix A: Diagrams =====

==== Overall Workflow ====

{{:playground:samma_mavis_workflow.png?direct&|}}

==== Accessioning ====

{{:uluulu:accessioningvideotapesworkflow.png?direct&|}}

===== Appendix B: Stylesheets =====

==== Export for SAMMA Prep Stylesheet ====

<code>

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet

	version="1.0"

	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

	xmlns:fo="http://www.w3.org/1999/XSL/Format"

	xmlns:xl="http://www.w3.org/TR/xlink"

	xmlns:mv="http://www.wizardis.com.au/2005/12/MAVIS">

<!-- 

   Create SAMMA Prep CSV



   Modification History

   ********************

   13/12/10  FLS ????????   Created

   21/12/10  JRR ????????   Modified - took out first ^

   07/01/11  JRR ????????   Modified - deleted umid,cleaned,MigrationProfile

   07/01/11  JRR ????????   Modified - changed tapeid to map to mv:itemId, not mv:rackNo

   11/01/11  JRR ????????   Modified - added rack number to end of location field; added rackNo variable

   11/01/11  JRR ????????   Modified - deleted variables cleaned,profile

   17/02/11  JRR ????????   Modified - added acquisition source as author

   18/02/11  JRR ????????   Modified - added collection number to file name; changed output filename

   20/07/11  JRR ????????   Modified - changed description field from xl:title to ../../mv:itemDescr

   tapeid^video_standard^tape_format^stocklength^tapeid_sequence^location^description^author^comments^output_filename



-->

	<xsl:output method="text"/>

	<xsl:variable name="cr" select="'&#xA;'"/>

	<xsl:variable name="delim" select="'^'"/>

	<xsl:variable name="ofComponent" select="' of component '"/>

	<xsl:variable name="rackNo" select="' : '"/>

	<xsl:variable name="collection" select="'c'"/>

	<xsl:variable name="underscore" select="'_'"/>





<xsl:template match="mv:mavis">tapeid^video_standard^tape_format^stocklength^tapeid_sequence^location^description^author^comments^output_filename

<xsl:for-each select="//mv:VideoTapeCarrier">

		<xsl:value-of select="mv:itemId"/><xsl:value-of select="$delim"/>

		<xsl:value-of select="../../mv:videoMode"/><xsl:value-of select="$delim"/>

		<xsl:value-of select="../../mv:techCode/@xl:title"/><xsl:value-of select="$delim"/>

		<xsl:value-of select="../../mv:stockLength"/><xsl:value-of select="$delim"/>

		<xsl:value-of select="mv:carrierNo"/><xsl:value-of select="$ofComponent"/><xsl:value-of select="substring-after(mv:component/@xl:href,'/VideoTapeComponent/key/')"/><xsl:value-of select="$delim"/>

		<xsl:choose>

			<xsl:when test="mv:currentLocation"><xsl:value-of select="mv:currentLocation"/></xsl:when>

			<xsl:when test="mv:permanentLocation"><xsl:value-of select="mv:permanentLocation"/></xsl:when>

		</xsl:choose><xsl:value-of select="$rackNo"/><xsl:value-of select="mv:rackNo"/><xsl:value-of select="$delim"/>

		<xsl:value-of select="../../mv:itemDescr"/><xsl:value-of select="$delim"/>

		<xsl:value-of select="../../mv:source/@xl:title"/><xsl:value-of select="$delim"/>

		<xsl:value-of select="mv:notes"/><xsl:value-of select="$delim"/>

		<xsl:value-of select="$collection"/><xsl:value-of select="substring-after(../../mv:collection/@xl:href,'/Collection/key/')"/><xsl:value-of select="$underscore"/><xsl:value-of select="mv:itemId"/><xsl:value-of select="$delim"/>

		<xsl:value-of select="$cr"/>

	</xsl:for-each>

</xsl:template>



</xsl:stylesheet>

</code>

==== Import from SAMMA Prep Stylesheet ====

<code>

<?xml version="1.0" encoding="ISO-8859-13"?>

<xsl:stylesheet

	version="1.0"

	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

	xmlns:xl="http://www.w3.org/TR/xlink"

	xmlns="http://www.wizardis.com.au/2005/12/MAVIS">

<!-- 

   Add carrier conditions to a video, using SammaPrep xml

   Modification History

   ********************

   13/12/10  FLS ????????   Created

   18/02/11  JRR ????????   Modified: added Odor, changed numbers

   22/02/11  JRR ????????   Modified: added DamagedShell, TapeTorn, Dirt, Cinching, LooseWind, TapeWarping, PowderyResidue, LiquidStaining, SpokingPopping

   08/03/11  JRR ????????   Modified: added treatments; added assessedBy parameter to conditions

   27/04/11  JRR ????????   Modified: updated criteria numbers to match Samma Prep; added comments to treatment summary

   27/01/12  JRR ????????   Modified: added examined by prepOperator and prepTime to be included in carrier general tab; added entered date into carrier treatment; changed performedBy to prepOperator; added entered date into carrier conditions; changed assessedBY to prepOperator





-->

<xsl:output encoding="ISO-8859-13" indent="yes"/>



<xsl:variable name="passed" select="'Passed Inspection. '"/>

<xsl:variable name="notpassed" select="'Did not pass Inspection. '"/>



<xsl:template match="SAMMAPrep">

	<mavis>

	

	<xsl:for-each select="//Tape">

		<xsl:if test="Details/UMID">

			<VideoTapeCarrier><xsl:attribute name="xl:href">/VideoTapeCarrier/key/<xsl:value-of select="Details/UMID"/></xsl:attribute>

				<whoExamined><xsl:value-of select="Details/PrepOperator"/></whoExamined>

				<!--<examinedDate><xsl:value-of select="substring(Details/PrepTime, 6, 2)"/>/<xsl:value-of select="substring(Details/PrepTime, 9, 2)"/>/<xsl:value-of select="substring(Details/PrepTime, 1, 4)"/></examinedDate>-->

				<examinedDate><xsl:value-of select="substring(Details/PrepTime, 1, 10)"/></examinedDate>

				<treatments>

					<xsl:call-template name="addTreatment">

						<xsl:with-param name="treatmentCode">PE</xsl:with-param>

						<xsl:with-param name="treatmentLocation">I</xsl:with-param>

						<xsl:with-param name="summary">

							<xsl:choose>

								<xsl:when test="Results/PassedInspection = 1"><xsl:value-of select="$passed"/><xsl:value-of select="Results/Comments"/></xsl:when>

								<xsl:otherwise><xsl:value-of select="$notpassed"/><xsl:value-of select="Results/Comments"/></xsl:otherwise>

							</xsl:choose>

						</xsl:with-param>

						<xsl:with-param name="performedBy">

							<xsl:value-of select="Details/PrepOperator"/>

						</xsl:with-param>

						<xsl:with-param name="enteredDate">

							<xsl:value-of select="Details/PrepTime"/>

						</xsl:with-param>

					</xsl:call-template>

				</treatments>

				<conditions>

					<xsl:if test="Results/Odor">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">OD</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/Odor = 0">0</xsl:when>

									<xsl:when test="Results/Odor = 2">3</xsl:when>

									<xsl:otherwise>2</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/Mold">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">MO</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/Mold = 0">0</xsl:when>

									<xsl:when test="Results/Mold = 4">3</xsl:when>

									<xsl:otherwise>2</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/DamagedShell">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">DS</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/DamagedShell = 5">3</xsl:when>

									<xsl:otherwise>0</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/TapeTorn">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">TT</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/TapeTorn = 6">3</xsl:when>

									<xsl:otherwise>0</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/Dirt">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">DI</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/Dirt = 0">0</xsl:when>

									<xsl:when test="Results/Dirt = 9">3</xsl:when>

									<xsl:when test="Results/Dirt = 8">2</xsl:when>

									<xsl:otherwise>1</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/Cinching">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">CI</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/Cinching = 10">2</xsl:when>

									<xsl:otherwise>0</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/LooseWind">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">LW</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/LooseWind = 0">0</xsl:when>

									<xsl:when test="Results/LooseWind = 12">3</xsl:when>

									<xsl:otherwise>2</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/EdgeDamage">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">ED</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/EdgeDamage = 0">0</xsl:when>

									<xsl:when test="Results/EdgeDamage = 14">2</xsl:when>

									<xsl:when test="Results/EdgeDamage = 15">3</xsl:when>

									<xsl:otherwise>1</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/TapeWarping">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">TW</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/TapeWarping = 0">0</xsl:when>

									<xsl:when test="Results/TapeWarping = 17">3</xsl:when>

									<xsl:otherwise>2</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/PowderyResidue">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">PR</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/PowderyResidue = 0">0</xsl:when>

									<xsl:when test="Results/PowderyResidue = 19">2</xsl:when>

									<xsl:when test="Results/PowderyResidue = 20">3</xsl:when>

									<xsl:otherwise>1</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/LiquidStaining">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">LS</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/LiquidStaining = 0">0</xsl:when>

									<xsl:when test="Results/LiquidStaining = 22">2</xsl:when>

									<xsl:when test="Results/LiquidStaining = 23">3</xsl:when>

									<xsl:otherwise>1</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

					<xsl:if test="Results/SpokingPopping">

						<xsl:call-template name="addCondition">

							<xsl:with-param name="conditionCode">SP</xsl:with-param>

							<xsl:with-param name="conditionDegree">

								<xsl:choose>

									<xsl:when test="Results/SpokingPopping = 0">0</xsl:when>

									<xsl:when test="Results/SpokingPopping = 25">2</xsl:when>

									<xsl:when test="Results/SpokingPopping = 26">3</xsl:when>

									<xsl:otherwise>1</xsl:otherwise>

								</xsl:choose>	

							</xsl:with-param>

							<xsl:with-param name="assessedBy"><xsl:value-of select="Details/PrepOperator"/></xsl:with-param>

							<xsl:with-param name="enteredDate"><xsl:value-of select="Details/PrepTime"/></xsl:with-param>	

						</xsl:call-template>

					</xsl:if>

				</conditions>

			</VideoTapeCarrier>

		</xsl:if>

	</xsl:for-each>

	</mavis>

</xsl:template>



<xsl:template match="*">

	<!-- Do not output anything except what's in the "SAMMAPrep" template -->

</xsl:template>



<xsl:template name="addTreatment">

	<xsl:param name="treatmentCode"/>

	<xsl:param name="treatmentLocation"/>

	<xsl:param name="summary"/>

	<xsl:param name="performedBy"/>

	<xsl:param name="enteredDate"/>

		<CarrierTreatment>

			<treatmentCode><xsl:value-of select="$treatmentCode"/></treatmentCode>

			<treatmentLocation><xsl:value-of select="$treatmentLocation"/></treatmentLocation>

			<summary><xsl:value-of select="$summary"/></summary>

			<performedBy><xsl:value-of select="$performedBy"/></performedBy>

			<enteredDate><xsl:value-of select="substring($enteredDate, 6, 2)"/>/<xsl:value-of select="substring($enteredDate, 9, 2)"/>/<xsl:value-of select="substring($enteredDate, 1, 4)"/> - <xsl:choose><xsl:when test="substring($enteredDate, 12, 2) &gt; 12"><xsl:value-of select="substring($enteredDate, 12, 2) - 12"/>:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> PM</xsl:when><xsl:when test="substring($enteredDate, 12, 2) = '12'">12:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> PM</xsl:when><xsl:when test="substring($enteredDate, 12, 2) = '00'">12:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> AM</xsl:when><xsl:otherwise><xsl:value-of select="substring($enteredDate, 12, 2)"/>:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> AM</xsl:otherwise></xsl:choose></enteredDate>

		</CarrierTreatment>

		

</xsl:template>



<xsl:template name="addCondition">

	<xsl:param name="conditionCode"/>

	<xsl:param name="conditionDegree"/>

	<xsl:param name="assessedBy"/>

	<xsl:param name="enteredDate"/>

		<CarrierCondition>

			<conditionCode><xsl:value-of select="$conditionCode"/></conditionCode>

			<conditionDegree><xsl:value-of select="$conditionDegree"/></conditionDegree>

			<assessedBy><xsl:value-of select="$assessedBy"/></assessedBy>

			<enteredDate><xsl:value-of select="substring($enteredDate, 6, 2)"/>/<xsl:value-of select="substring($enteredDate, 9, 2)"/>/<xsl:value-of select="substring($enteredDate, 1, 4)"/> - <xsl:choose><xsl:when test="substring($enteredDate, 12, 2) &gt; 12"><xsl:value-of select="substring($enteredDate, 12, 2) - 12"/>:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> PM</xsl:when><xsl:when test="substring($enteredDate, 12, 2) = '12'">12:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> PM</xsl:when><xsl:when test="substring($enteredDate, 12, 2) = '00'">12:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> AM</xsl:when><xsl:otherwise><xsl:value-of select="substring($enteredDate, 12, 2)"/>:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> AM</xsl:otherwise></xsl:choose></enteredDate>

		</CarrierCondition>

</xsl:template>



</xsl:stylesheet>

</code>

==== Import from SAMMA Clean Stylesheet ====

<code>

<?xml version="1.0" encoding="ISO-8859-13"?>

<xsl:stylesheet

	version="1.0"

	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

	xmlns:xl="http://www.w3.org/TR/xlink"

	xmlns="http://www.wizardis.com.au/2005/12/MAVIS">

<!-- 

   Add treatment to video carrier, using SammaClean xml

   Modification History

   ********************

   24/02/11  JRR ????????   Created

   10/03/11  JRR ????????   Modified: added reference material template

   17/03/11  JRR ????????   Modified: made enteredDate format conversion

   24/05/11  JRR ????????   Modified: changed ref material to url, added url variable

   31/10/11  JRR ????????   Modified: added <isOlcDisplay>Y</isOlcDisplay> to reference material



To do: Maybe want to add url prefix to ini file so that if it changes, each resource id does not have to be redone (this might mean the resource id type would be path/filename) 

-->



<xsl:output encoding="ISO-8859-13" indent="yes"/>



<xsl:variable name="cleaner" select="'CLEAN'"/>

<xsl:variable name="qf" select="' Quality Factor: '"/>

<xsl:variable name="url" select="'http://serverurl/metadata/'"/>

<xsl:variable name="cleanPDF" select="'_clean.pdf'"/>



<xsl:template match="SammaCleaner">

	<mavis>

	

	<xsl:for-each select="//Tape">

		<xsl:if test="Results/TapeId">

			<VideoTapeCarrier><xsl:attribute name="xl:href">/VideoTapeCarrier/key/<xsl:value-of select="Results/TapeId"/></xsl:attribute>

				<treatments>

					<xsl:call-template name="addTreatment">

						<xsl:with-param name="treatmentCode">CR</xsl:with-param>

						<xsl:with-param name="treatmentLocation">I</xsl:with-param>

						<xsl:with-param name="summary">

							<xsl:value-of select="Results/CleanedResult"/>

							<xsl:value-of select="$qf"/><xsl:value-of select="Results/QualityFactor"/>

						</xsl:with-param>

						<xsl:with-param name="performedBy">

							<xsl:value-of select="$cleaner"/>

						</xsl:with-param>

						<xsl:with-param name="enteredDate">

							<xsl:value-of select="//Results/CleanedDateTime"/>

						</xsl:with-param>

					</xsl:call-template>

				</treatments>

				<xsl:call-template name="referenceMaterial"/>

			</VideoTapeCarrier>

		</xsl:if>

	</xsl:for-each>



	</mavis>

</xsl:template>



<xsl:template match="*">

	<!-- Do not output anything except what's in the "SammaCleaner" template -->

</xsl:template>



<xsl:template name="addTreatment">

	<xsl:param name="treatmentCode"/>

	<xsl:param name="treatmentLocation"/>

	<xsl:param name="summary"/>

	<xsl:param name="performedBy"/>

	<xsl:param name="enteredDate"/>

		<CarrierTreatment>

			<treatmentCode><xsl:value-of select="$treatmentCode"/></treatmentCode>

			<treatmentLocation><xsl:value-of select="$treatmentLocation"/></treatmentLocation>

			<summary><xsl:value-of select="$summary"/></summary>

			<performedBy><xsl:value-of select="$performedBy"/></performedBy>

			<enteredDate><xsl:value-of select="substring($enteredDate, 6, 2)"/>/<xsl:value-of select="substring($enteredDate, 9, 2)"/>/<xsl:value-of select="substring($enteredDate, 1, 4)"/> - <xsl:choose><xsl:when test="substring($enteredDate, 12, 2) &gt; 12"><xsl:value-of select="substring($enteredDate, 12, 2) - 12"/>:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> PM</xsl:when><xsl:when test="substring($enteredDate, 12, 2) = '12'">12:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> PM</xsl:when><xsl:when test="substring($enteredDate, 12, 2) = '00'">12:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> AM</xsl:when><xsl:otherwise><xsl:value-of select="substring($enteredDate, 12, 2)"/>:<xsl:value-of select="substring($enteredDate, 15, 2)"/>:<xsl:value-of select="substring($enteredDate, 18, 2)"/> AM</xsl:otherwise></xsl:choose></enteredDate>

		</CarrierTreatment>

		

</xsl:template>



<xsl:template name="referenceMaterial">

	<objectReferenceMaterials>

		<ObjectReferenceMaterial>

			<referenceMaterialType>SC</referenceMaterialType>

			<isOlcDisplay>Y</isOlcDisplay>

			<objectResourceIdentifiers>

				<ResourceIdentifier>

					<resourceIdentifier>

						<xsl:value-of select="$url"/>

						<xsl:value-of select="Results/Filename"/>

						<xsl:value-of select="$cleanPDF"/>

					</resourceIdentifier>

					<resourceIdentifierType>URL</resourceIdentifierType>

				</ResourceIdentifier>

			</objectResourceIdentifiers>

		</ObjectReferenceMaterial>

	</objectReferenceMaterials>

</xsl:template>



</xsl:stylesheet>

</code>

==== Import from SAMMA Solo Stylesheet ====

<code>

<?xml version="1.0" encoding="ISO-8859-13"?>

<xsl:stylesheet

	version="1.0"

	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

	xmlns:xl="http://www.w3.org/TR/xlink"

	xmlns="http://www.wizardis.com.au/2005/12/MAVIS">

<!-- 

   Add digital files to a video, using SammaSolo xml

   Modification History

   ********************

   17/07/11  JRR ????????   Copied from sammaSolo_8bitMOV_DV_wmv_mov_flv.xsl

   21/07/11  JRR ????????   Modified: got rid of extra tabs in reference material

   14/10/11  JRR ????????   Modified: added Duration entry into seconds field

   27/10/11  JRR ????????   Modified: added Duration for videoTapeCarrier

   31/10/11  JRR ????????   Modified: added <isOlcDisplay>Y</isOlcDisplay> to reference material

   10/07/12  JRR ????????   Modified: changed INT file Sound Field from Mono to Stereo; changed software used to current Samma Solo version SS431

   18/07/12  JRR ????????   Modified: added imported from field, value SAMMA





NOTE: must update preservation folder number as it changes - current is preservation03

This style sheet is CURRENT

Use this stylesheet for the following prj files:

HKG Umatic Uncompressed_dv_wmv_h.264_mxf_12_01_2011.prj

   

to do: TEST DURATION IMPORT! TEST IMPORTED FROM IMPORT!

To do: Maybe want to add url prefix to ini file so that if it changes, each resource id does not have to be redone (this might mean the resource id type would be path/filename) 



-->

	<xsl:output encoding="ISO-8859-13" indent="yes"/>

	<xsl:variable name="ofComponent" select="' of component '"/>

	<!--<xsl:variable name="motionJPEG" select="'_pres_2.mxf'"/>  -->

	<xsl:variable name="url" select="'http://serverurl/'"/>

	<xsl:variable name="pdf" select="'_solo.pdf'"/>

	<xsl:variable name="sammaSolo" select="'Samma Solo'"/>

	<xsl:variable name="capSet" select="'; '"/>

	

<xsl:template match="SammaSolo">

	<mavis>

	<xsl:for-each select="//Settings">

		<xsl:if test="Details/TapeId">

			<VideoTapeCarrier>

				<xsl:attribute name="xl:href">

					/VideoTapeCarrier/key/<xsl:value-of select="Details/TapeId"/>

				</xsl:attribute>

				<xsl:call-template name="referenceMaterial"/>

				<durationSec><xsl:value-of select="Duration"/></durationSec>

			</VideoTapeCarrier>

		</xsl:if>

	</xsl:for-each>

	<xsl:for-each select="EncodedFiles/*">

		<xsl:if test="Type!='MOTION_JPEG2000' and Type!='_acc_2.wmv'">

			<DigitalComponent>

				<xsl:call-template name="workOrUnattached"/>

				<typeMaterial>V</typeMaterial>

				<categoryMaterial>

					<xsl:choose>

						<xsl:when test="Type='_pres_1.mov'">PC</xsl:when>

						<xsl:when test="Type='_acc_1.mov'">AC</xsl:when>

						<xsl:when test="Type='_int_1.mov'">IC</xsl:when>

					</xsl:choose>

				</categoryMaterial>

				<collection><xsl:value-of select="substring-after(substring-before(../../Settings/Details/Filename,'_'),'c')"/></collection>

				<itemDescr><xsl:value-of select="../../Settings/Details/Description"/></itemDescr>

				<importedFrom>SAMMA</importedFrom>

				<whoCaptured><xsl:value-of select="../../Settings/Details/MigratedBy"/></whoCaptured>

				<dateTimeCaptured><xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 6, 2)"/>/<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 9, 2)"/>/<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 1, 4)"/> - <xsl:choose><xsl:when test="substring(../../Settings/Details/MigrationDateTime, 12, 2) &gt; 12"><xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 12, 2) - 12"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 15, 2)"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 18, 2)"/> PM</xsl:when><xsl:when test="substring(../../Settings/Details/MigrationDateTime, 12, 2) = '12'">12:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 15, 2)"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 18, 2)"/> PM</xsl:when><xsl:when test="substring(../../Settings/Details/MigrationDateTime, 12, 2) = '00'">12:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 15, 2)"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 18, 2)"/> AM</xsl:when><xsl:otherwise><xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 12, 2)"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 15, 2)"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 18, 2)"/> AM</xsl:otherwise></xsl:choose></dateTimeCaptured>

				<xsl:call-template name="componentCopyHistory"/>

				<xsl:call-template name="workOrUnattached"/>

				<carriers>

					<DigitalCarrier>

						<fileFormat>

							<xsl:choose>

								<xsl:when test="Type='_pres_1.mov'">VQ</xsl:when>

								<xsl:when test="Type='_acc_1.mov'">VM4</xsl:when>

								<xsl:when test="Type='_int_1.mov'">VQ</xsl:when>

							</xsl:choose>

						</fileFormat>

						<fileSize><xsl:value-of select="FileSize"/></fileSize>	

						<xsl:call-template name="carrierCopyHistory"/>

						<!--<xsl:call-template name="shaIdentifier"/>-->

						<xsl:call-template name="resourceIdentifier"/>

						<captureDeviceType>PCI</captureDeviceType>

						<captureDeviceMake>FPD</captureDeviceMake>

						<captureDeviceModel><xsl:value-of select="$sammaSolo"/></captureDeviceModel>

						<captureDeviceSettings><xsl:value-of select="../../Settings/General/Template"/><xsl:value-of select="$capSet"/><xsl:value-of select="../../Settings/Encoder2/ProjectFile"/></captureDeviceSettings>

						<!--

						<videoDurationHr></videoDurationHr>

						<videoDurationMin></videoDurationMin>-->

						<videoDurationSec><xsl:value-of select="Duration"/></videoDurationSec>

						<dateTimeCaptured><xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 6, 2)"/>/<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 9, 2)"/>/<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 1, 4)"/> - <xsl:choose><xsl:when test="substring(../../Settings/Details/MigrationDateTime, 12, 2) &gt; 12"><xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 12, 2) - 12"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 15, 2)"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 18, 2)"/> PM</xsl:when><xsl:when test="substring(../../Settings/Details/MigrationDateTime, 12, 2) = '12'">12:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 15, 2)"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 18, 2)"/> PM</xsl:when><xsl:when test="substring(../../Settings/Details/MigrationDateTime, 12, 2) = '00'">12:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 15, 2)"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 18, 2)"/> AM</xsl:when><xsl:otherwise><xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 12, 2)"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 15, 2)"/>:<xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 18, 2)"/> AM</xsl:otherwise></xsl:choose></dateTimeCaptured>

						<operatingSystem>WXP</operatingSystem>

						<softwareUsed>SS431</softwareUsed>

						<xsl:choose>

							<xsl:when test="Type='_pres_1.mov'">

								<videoCompression>UN8</videoCompression>

								<videoSamplingHierarchy>422</videoSamplingHierarchy>

								<videoAspectRatio>TV</videoAspectRatio>

								<videoFrameLayout>I</videoFrameLayout>

								<videoColourSpace>YCbCr</videoColourSpace>

								<videoHeight>480</videoHeight>

								<videoWidth>720</videoWidth>

								<videoAudioCompression>LP</videoAudioCompression>

								<videoSoundField>ST</videoSoundField>

								<videoAudioSampleRate>48</videoAudioSampleRate>

								<videoAudioNoChannels>2</videoAudioNoChannels>

								<videoFrameRate>29.97</videoFrameRate>

							</xsl:when>

							<xsl:when test="Type='_acc_1.mov'">

								<videoCompression>H264</videoCompression>

								<!--<videoSamplingHierarchy>422</videoSamplingHierarchy>-->

								<videoAspectRatio>TV</videoAspectRatio>

								<videoFrameLayout>D</videoFrameLayout>

								<videoColourSpace>YCbCr</videoColourSpace>

								<videoHeight>480</videoHeight>

								<videoWidth>640</videoWidth>

								<videoAudioCompression>AAC</videoAudioCompression>

								<videoSoundField>ST</videoSoundField>

								<videoAudioSampleRate>48</videoAudioSampleRate>

								<videoAudioNoChannels>2</videoAudioNoChannels>

								<videoFrameRate>29.97</videoFrameRate>

							</xsl:when>

							<xsl:when test="Type='_int_1.mov'">

								<videoCompression>DVCP25</videoCompression>

								<videoSamplingHierarchy>411</videoSamplingHierarchy>

								<videoAspectRatio>TV</videoAspectRatio>

								<videoFrameLayout>I</videoFrameLayout>

								<videoColourSpace>YCbCr</videoColourSpace>

								<videoHeight>480</videoHeight>

								<videoWidth>720</videoWidth>

								<videoAudioCompression>LP</videoAudioCompression>

								<videoSoundField>ST</videoSoundField>

								<videoAudioSampleRate>48</videoAudioSampleRate>

								<videoAudioNoChannels>2</videoAudioNoChannels>

								<videoFrameRate>29.97</videoFrameRate>

							</xsl:when>

						</xsl:choose>				

					</DigitalCarrier>

				</carriers>

			</DigitalComponent>

		</xsl:if>

	</xsl:for-each>

	

	</mavis>

</xsl:template>



<xsl:template match="*">

	<!-- Do not output anything except what's in the "SAMMAPrep" template -->

</xsl:template>



<xsl:template name="carrierCopyHistory">

	<xsl:if test="../../Settings/Details/TapeId">

		<copiedFromItems>

			<ItemCopy>

				<item><xsl:attribute name="xl:href">/VideoTapeCarrier/key/<xsl:value-of select="../../Settings/Details/TapeId"/></xsl:attribute></item>

				<copiedDate><xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 1, 10)"/></copiedDate>

			</ItemCopy>

		</copiedFromItems>

	</xsl:if>

</xsl:template>





<xsl:template name="componentCopyHistory">

	<xsl:if test="contains(../../Settings/Details/TapeIdSequence,'of component')">

		<copiedFromItems>

			<ItemCopy>

				<item><xsl:attribute name="xl:href">/VideoTapeComponent/key/<xsl:value-of select="substring-after(../../Settings/Details/TapeIdSequence,$ofComponent)"/></xsl:attribute></item>

				<copiedDate><xsl:value-of select="substring(../../Settings/Details/MigrationDateTime, 1, 10)"/></copiedDate>

			</ItemCopy>

		</copiedFromItems>

	</xsl:if>

</xsl:template>



<xsl:template name="shaIdentifier">

	<xsl:if test="ShaDigest">

		<objectIdentifiers>

			<ObjectIdentifier>

				<identifier><xsl:value-of select="ShaDigest"/></identifier>

				<identifierType>SHA-DIGEST</identifierType>

			</ObjectIdentifier>

		</objectIdentifiers>

	</xsl:if>

</xsl:template>



<xsl:template name="resourceIdentifier">

	<xsl:if test="Filename">

		<objectResourceIdentifiers>

			<ResourceIdentifier>

				<resourceIdentifier>

					<xsl:value-of select="$url"/>

					<xsl:choose>

						<xsl:when test="Type='_pres_1.mov'">preservation03/<xsl:value-of select="../../Settings/Details/Filename"/><xsl:value-of select="Type"/></xsl:when>

						<xsl:when test="Type='_acc_1.mov'">access/<xsl:value-of select="../../Settings/Details/Filename"/>_acc_1.mp4</xsl:when>

						<xsl:when test="Type='_int_1.mov'">intermediate/<xsl:value-of select="../../Settings/Details/Filename"/><xsl:value-of select="Type"/></xsl:when>

					</xsl:choose>					

				</resourceIdentifier>

				<resourceIdentifierType>URL</resourceIdentifierType>

			</ResourceIdentifier>

		</objectResourceIdentifiers>

	</xsl:if>

</xsl:template>



<xsl:template name="referenceMaterial">

	<objectReferenceMaterials>

		<ObjectReferenceMaterial>

			<referenceMaterialType>SS</referenceMaterialType>

			<isOlcDisplay>Y</isOlcDisplay>

			<objectResourceIdentifiers>

				<ResourceIdentifier>

					<resourceIdentifier>

						<xsl:value-of select="$url"/>metadata/<xsl:value-of select="Details/Filename"/><xsl:value-of select="$pdf"/>

					</resourceIdentifier>

					<resourceIdentifierType>URL</resourceIdentifierType>

				</ResourceIdentifier>

			</objectResourceIdentifiers>

		</ObjectReferenceMaterial>

	</objectReferenceMaterials>

</xsl:template>

				

<xsl:template name="workOrUnattached">

	<xsl:variable name="tapeId"><xsl:value-of select="../../Settings/Details/TapeIdSequence"/></xsl:variable>

	<xsl:variable name="workId"><xsl:value-of select="substring-before(substring-after($tapeId,$ofComponent),'-')"/></xsl:variable>

	

	<xsl:choose>

		<xsl:when test="contains($tapeId,$ofComponent)">

			<xsl:choose>

				<xsl:when test="$workId != ''">

					<work><xsl:attribute name="xl:href">/Work/key/<xsl:value-of select="$workId"/></xsl:attribute></work>

				</xsl:when>

				<xsl:otherwise><isUnattached>Y</isUnattached></xsl:otherwise>		

			</xsl:choose>

		</xsl:when>	

		<xsl:otherwise><isUnattached>Y</isUnattached></xsl:otherwise>

	</xsl:choose>

</xsl:template>



				

</xsl:stylesheet>



</code>

==== Export for Online Spreadsheet Stylesheet ====

<code>

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet

	version="1.0"

	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

	xmlns:fo="http://www.w3.org/1999/XSL/Format"

	xmlns:xl="http://www.w3.org/TR/xlink"

	xmlns:mv="http://www.wizardis.com.au/2005/12/MAVIS">



<!-- 

   Create export for Access File Creation Spreadsheet



   Modification History

   ********************

   18/04/11  JRR ????????   Created

   20/12/11  JRR ????????   Added file names for special case copied from (this can be commented out), added title numbers



Media specialist searches for digital acquisition with category IC; selects all; exports using this stylesheet

This stylesheet is also used for sammaPostMigrationMetadata procedures.



-->



	<xsl:output method="text"/>

	<xsl:variable name="cr" select="'&#xA;'"/>

	<xsl:variable name="delim" select="'^'"/>



<xsl:template match="mv:mavis">Item Description^Component Item Number^Carrier Item Number^Copied From^File Name Int^File Name Acc^Title Number

<xsl:for-each select="//mv:DigitalCarrier">

	<xsl:value-of select="../../mv:itemDescr"/><xsl:value-of select="$delim"/>

	<!--<xsl:value-of select="substring-after(../../mv:collection/@xl:href,'/Collection/key/')"/><xsl:value-of select="$delim"/>-->

	<xsl:value-of select="../../mv:itemId"/><xsl:value-of select="$delim"/>

	<xsl:value-of select="mv:itemId"/><xsl:value-of select="$delim"/>

	<xsl:for-each select=".//mv:ResourceIdentifier">

		<xsl:value-of select="mv:resourceIdentifier"/><xsl:value-of select="$delim"/>

	</xsl:for-each>c<xsl:value-of select="substring-after(../../mv:collection/@xl:href,'/Collection/key/')"/>_<xsl:value-of select="mv:itemId"/>_int_1.mov<xsl:value-of select="$delim"/>c<xsl:value-of select="substring-after(../../mv:collection/@xl:href,'/Collection/key/')"/>_<xsl:value-of select="mv:itemId"/>_acc_1.mp4<xsl:value-of select="$delim"/>

	<xsl:value-of select="substring-after(mv:work/@xl:href,'/TitleWork/key/')"/>

	<xsl:value-of select="$cr"/>

	</xsl:for-each>

</xsl:template>



</xsl:stylesheet>

</code>

==== Import from Online Spreadsheet Stylesheet ====

<code>

<?xml version="1.0" encoding="ISO-8859-13"?>

<xsl:stylesheet

	version="1.0"

	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

	xmlns:xl="http://www.w3.org/TR/xlink"

	xmlns="http://www.wizardis.com.au/2005/12/MAVIS">

<!-- 

   Add digital components and migration data to a video or film, using vendor xml

   Modification History

   ********************

   11/08/11  JRR ????????   Copied from vendor import access Stylesheet

   18/07/12  JRR ????????   Modified: Added check to only import migrated records; Added href attribute to identify correct files; eliminated fields that are extraneous; eliminated obsolete templates; added templates for other file checksums; added for int and acc; 

   19/07/12  JRR ????????   Modified: changed encompassing if statement to check the dataEntryComplete field instead of migrated field



NEED TO TEST!!!! 



to do: add bit rate stuff?

TO DO: do we want to make if statements so that xml conversion failure warnings about empty tags being ignored do not appear?

TO DO: WILL Carrier Notes FIELD BE OVERWRITTEN?  IS THERE A WAY TO APPEND INFO???



-->

	<xsl:output encoding="ISO-8859-13" indent="yes"/>

	<xsl:variable name="cr" select="'&#xA;'"/>

	<xsl:variable name="macPro" select="'Mac Pro'"/>

	

<xsl:template match="document">

	<mavis>

	<xsl:for-each select="//record">

		<xsl:if test="string(dataEntryComplete)">



		<xsl:if test="string(presChecksum)">

			<DigitalComponent>

				<xsl:attribute name="xl:href">

					/DigitalComponent/key/<xsl:value-of select"presComponentNumber"/>

				</xsl:attribute>

				<xsl:choose>

					<xsl:when test="string(titleNo)">

						<work><xsl:attribute name="xl:href">/Work/key/<xsl:value-of select="titleNo"/></xsl:attribute></work>

					</xsl:when>

					<xsl:otherwise><isUnattached>Y</isUnattached></xsl:otherwise>

				</xsl:choose>

				<carriers>

					<DigitalCarrier>

						<xsl:attribute name="xl:href">

							/DigitalCarrier/key/<xsl:value-of select"presCarrierNumber"/>

						</xsl:attribute>

						<whoExamined><xsl:value-of select="presExaminedBy"/></whoExamined>

						<xsl:call-template name="presChecksum"/>



						<videoColourType><xsl:value-of select="colorType"/></videoColourType>

						<notes>HKG Examiner Notes: <xsl:value-of select="examinerNotes"/><xsl:value-of select="$cr"/><xsl:value-of select="$cr"/>Audio: <xsl:value-of select="audio"/></notes>

					</DigitalCarrier>

				</carriers>

			</DigitalComponent>

		</xsl:if>



		<xsl:if test="string(intChecksum)">

			<DigitalComponent>

				<xsl:attribute name="xl:href">

					/DigitalComponent/key/<xsl:value-of select"intComponentNumber"/>

				</xsl:attribute>

				<xsl:choose>

					<xsl:when test="string(titleNo)">

						<work><xsl:attribute name="xl:href">/Work/key/<xsl:value-of select="titleNo"/></xsl:attribute></work>

					</xsl:when>

					<xsl:otherwise><isUnattached>Y</isUnattached></xsl:otherwise>

				</xsl:choose>

				<carriers>

					<DigitalCarrier>

						<xsl:attribute name="xl:href">

							/DigitalCarrier/key/<xsl:value-of select"intCarrierNumber"/>

						</xsl:attribute>

						<whoExamined><xsl:value-of select="intExaminedBy"/></whoExamined>

						<xsl:call-template name="intChecksum"/>



						<videoColourType><xsl:value-of select="colorType"/></videoColourType>

						<notes>HKG Examiner Notes: <xsl:value-of select="examinerNotes"/><xsl:value-of select="$cr"/><xsl:value-of select="$cr"/>Audio: <xsl:value-of select="audio"/></notes>

					</DigitalCarrier>

				</carriers>

			</DigitalComponent>

		</xsl:if>



		<xsl:if test="string(accChecksum)">

			<DigitalComponent>

				<xsl:attribute name="xl:href">

					/DigitalComponent/key/<xsl:value-of select"accComponentNumber"/>

				</xsl:attribute>

				<xsl:choose>

					<xsl:when test="string(titleNo)">

						<work><xsl:attribute name="xl:href">/Work/key/<xsl:value-of select="titleNo"/></xsl:attribute></work>

					</xsl:when>

					<xsl:otherwise><isUnattached>Y</isUnattached></xsl:otherwise>

				</xsl:choose>

				<carriers>

					<DigitalCarrier>

						<xsl:attribute name="xl:href">

							/DigitalCarrier/key/<xsl:value-of select"accCarrierNumber"/>

						</xsl:attribute>

						<whoExamined><xsl:value-of select="accExaminedBy"/></whoExamined>

						<xsl:call-template name="accChecksum"/>



						<videoColourType><xsl:value-of select="colorType"/></videoColourType>

						<notes>HKG Examiner Notes: <xsl:value-of select="examinerNotes"/><xsl:value-of select="$cr"/><xsl:value-of select="$cr"/>Audio: <xsl:value-of select="audio"/></notes>

					</DigitalCarrier>

				</carriers>

			</DigitalComponent>

		</xsl:if>



		</xsl:if>

	</xsl:for-each>

	

	</mavis>

</xsl:template>





<xsl:template match="*">

	<!-- Do not output anything except what's in the "shipment" template -->

</xsl:template>



<xsl:template name="presChecksum">

	<xsl:if test="string(presChecksum)">

		<objectIdentifiers>

			<ObjectIdentifier>

				<identifier><xsl:value-of select="presChecksum"/></identifier>

				<identifierType>HKGCS</identifierType>

			</ObjectIdentifier>

		</objectIdentifiers>

	</xsl:if>

</xsl:template>



<xsl:template name="intChecksum">

	<xsl:if test="string(intChecksum)">

		<objectIdentifiers>

			<ObjectIdentifier>

				<identifier><xsl:value-of select="intChecksum"/></identifier>

				<identifierType>HKGCS</identifierType>

			</ObjectIdentifier>

		</objectIdentifiers>

	</xsl:if>

</xsl:template>



<xsl:template name="accChecksum">

	<xsl:if test="string(accChecksum)">

		<objectIdentifiers>

			<ObjectIdentifier>

				<identifier><xsl:value-of select="accChecksum"/></identifier>

				<identifierType>HKGCS</identifierType>

			</ObjectIdentifier>

		</objectIdentifiers>

	</xsl:if>

</xsl:template>



				

</xsl:stylesheet>



</code>