This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
guidebook:importing_copied_items [2012/07/03 15:36] jros created |
— (current) | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== COPIED ITEMS ====== | ||
- | 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 |