Converting LC data to MAVIS

1
Converting LC data to MAVIS

• One down, 899,999 to go

2
MAVIS Conversion Strategies

• One-time conversion (nearly one million titles)
• Gateway for current records passing between ILS
  and MAVIS

3
Legacy data sources

• LC ILS (MARC records)
• Sound recordings and moving images (500,000?)
• SONIC (Cuadra STAR)
• 400,000 sound recordings
• Convert to MARC first?
• PC databases (Access, dBASE, Filemaker, mySQL)
• Card Catalog (manual entry into MAVIS)
• 100,000? Moving images

4
MARC vs MAVIS data model

• MARC is top-heavy in intellectual data
• MAVIS is bottom-heavy in technical data
• MAVIS links to authorities
• MARC includes names, subjects, etc. in-line

5
MAVIS XML import options

• One at a time or multiples
• One big file or split into different business
  objects Titles, Roles, Component/Carrier
• Need to add any names, subjects, codes, etc.
  before loading records that refer to them

6
Example Import Files

• 78s from dBASE IV
• MARC from file or live from ILS
• PBS database now in mySQL
• Coca-Cola TV ads

7
XML Import Challenges

• Programming by target
• Syntax is difficult, to say the least
• Still fairly buggy
• Physical info from MARC doesnt parse well
• Conversion in batches by format (lots of
  boilerplate)
• How to import related titles, segments, etc.?

8
Batch import/export specification

• Will eventually allow for export via query
• Could be the means for sharing records with ILS
• Scheduled imports important
• Improved error reporting