TRELLO SHIPPING FULL

Therefor, if you scan a box and the barcode is not on the expected barcode list, Column B will remain colored red with the CHECK BARCODE value, instructing you to double-check the barcode. Column B (“Inventory Box Barcodes Confirmation”) value defaults to the value “CHECK BARCODE”.Boxes on carts are brought to LSC room 306 and palletized wrap 2 with plastic if possible to give shippers a head start.īox Check-Out/In Google Sheet Color-Coding Guide.If any discrepancies occur, box barcodes must be checked against the metadataInventory spreadsheet tab. The check-out sheet confirms that the scanned barcode matches the list of barcodes that is expected from the finalized Metadata Inventory in the Vendor Project Worksheet.

TRELLO SHIPPING FULL

Once a cart is full and ready to move, PAMI Media Preservation Coordinator or Assistant scans box barcodes into the prepared Box Check-Out sheet - before they are moved to LSC room 306.Boxes are pulled by SFP team & PAMI staff by staging boxes on carts to prepare for movement.Test by entering in valid and invalid barcodes into the column. To do this, ‘add rows’ and drag drag formulas in columns A & B down to the last row, so that all formulas are working properly for all rows. The check-out/in sheets may need to have rows added to them in order to accommodate the actual number of boxes that exist in the project. the ‘box-check-out’ and ‘box-check-in’ tabs are pre-filled with formulas that should pull the box barcodes from the auto-populated list.When you import the CMS batch export data, the ‘box-barcode-list’ tab in that sheet should be autopopulated using the values from the ‘metadataInventory’ tab. The template for the box check-out sheet is included in the Vendor Project Worksheet template.Send the “clean” metadata inventory to the vendor and have them confirm all fields appear correct (failture to confirm inventory is formatted correctly will result in invalid JSON).Double check to make sure the spreadsheet was updated correctly.Cleanup metadata inventory using clean_cms_excel.py:Īmi-preservation/ami_scripts/clean_cms_excel.py -c ami-preservation/ami_scripts/config.json -v -s path/to/source.After copying the CMS export into the template, these values and characters must be removed using clean_cms_excel.py before the spreadsheet (the “…metadataInventory.xlsx” sheet) is sent to vendors for database import. Import the contents of the CMS batch export into the ‘metadataInventory’ tab of the project worksheet, ensuring that the data is entered into the correct columns.ĬMS exports often contain characters and values which are incompatible with JSON metadata.20#_keyword#_metadataInventory_DATE - TEMPLATE.MPC creates a copy of the Vendor Project Worksheet Template:.EXAMPLE: ```dnc - mellon CMS batch #:… next available sequential # (can we put a placeholder in PAMI work orders until this is ready?).For PAMI metadata, pull item records from the original metadata inventory from initial project and create internal db records (remembering to change the cms project code).On return, media goes back into they’re original boxes.

Manager will pull objects and box-up according to project fund.

Manager will forward the DNC list separately, and you can review to identify what should be sent to PAMI.

No need to separate by unit or research center. Separate the items by original project fund (pami work orders should at a minimum be separated by project fund).

Capture Issues Report Data Cleanup: Find & delete the following characters in the vendor’s DNC reports & HDmanifests.

Project summaries are created by compiling mediainfo manifests and capture issue reports. NYPL AMI Vendor Labs Project Close-Out Project Summaries

Upon arrival, all deliverables (hard drive or network-based shipments) are logged in the AMI Vendor Project Tracking sheet document.

The PAMI Database is used to establish project IDs, track deliverables, and generate statistics and metadata for AMI digitization projects.

Vendor Project Worksheet & Metadata Inventory.The following preparatory documents are stored in AMI folders on Google Drive A project ID (“PAMI ID”) is generated in the PAMI Database (PAMI DB) and used to begin all documentation.Digitization batch inventories are generated by Preservation and Collections Processing, exported from CMS, and emailed to the PAMI Manager / MPC.The following pages detail workflows, policies, and procedures for coordinating mass audio, video, and film digitization and optical media migration, broken down into the following processes: Box Check-Out/In Google Sheet Color-Coding Guide.CMS Export (Metadata Inventory) Cleanup:.Oursourced Digitization Table of contents

Trello shipping