Note: need to check that this workflow properly describes standard procedures for all ʻUluʻulu created items

Populate online spreadsheet

• Find item numbers that the files are copied from
  • In MAVIS client, perform applicable search: eg. item search with digital acquisition number
  • HKG Item View the results
  • Export using export_accessSpreadsheet.xsl into IMPORT-EXPORT\MAVISexportforAccessFiles folder
• Paste component and carrier item numbers into copied from columns in online spreadsheet
  • should be in same order that it was imported in from the spreadsheet (might need to add spaces for non-digitized carriers)
• Add any other relevant info into relevant columns

Convert to .csv file

• Download spreadsheet
  • Make sure all columns are filled out with proper formatting
  • Download as OpenOffice
  • Save file
• Open spreadsheet
• Clean up spreadsheet
  • Remove description row and any rows already imported.
  • For training runs, change appropriate item numbers, title numbers, acquisition numbers, etc.
• Save as
  • Save as type: csv
  • Navigate to proper folder in IMPORT-EXPORT folder
  • edit filter settings
  • keep current format
    • Baltic (Windows-1257)
    • ^ field delimiter
    • no text delimiter

Import into MAVIS

• Open MAVIS Client
• Click Admin → Import from XML file…
• XML File/Path : Click File…
• Navigate to csv file
• Select the csv file
• If applicable, choose Input format:
• Choose appropriate stylesheet
• Convert delimited file? should be checked
• Delimited by Caret ^
• Optionally enclosed by nothing
• Save converted XML? should be checked
• Archive imported files? should be checked
• Run Import (or check Submit in background? and Run Import)
• Should be no errors. Click okay and close export window.

Check that records imported okay.

• Find relevant items
• Look at the metadata

Mark as Imported

• Move Files
  • csv and xml file should be in IMPORT-EXPORT\savedImports
  • Move these files into proper folder\imported folder.
• Clean up Downloads folder
• Update online spreadsheet
  • highlight rows and columns that have been imported
  • change background to light green color