Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    No longer using Media Scheduling and want to delete the data

    • Product: Voyager Media Scheduling

    Question

    We no longer use Media Scheduling and want to remove it. How should we go about removing Media Scheduling data?

    Answer

    It is important to delete the data before having Media Scheduling uninstalled because of the links to Voyager data you will continue to use - you may see other errors when trying to work with or remove Voyager data in the future if you do not remove Media data now.

    Delete each of the following data types in the order listed. Failing to do so will result in errors deleting data types further down the list. If you encounter a problem deleting any of the data below, contact Support before moving on to the next data type.

    Bookings
    1. Prepackaged Reports > New Query > Query for confirmation numbers of current bookings:
    SELECT CONFIRM_NO
    FROM MEDIA_SCHEDULE;
    
    1. Media Scheduling > Search > Bookings > Confirmation Number
    2. Enter first number from step 2.
    3. Discharge, cancel or delete booking.
    4. Repeat steps 3 and 4 until all bookings deleted.
    Equipment Maintenance
    1. Media Schedule > Inventory > Equipment Maintenance
    2. Delete any equipment maintenance items
    Equipment Groups
    1. Media Schedule > Inventory > Equipement Groups > Equipment Group Type
    2. Highlight group.
    3. Click delete.
    4. Repeat steps 2 and 3 for all group types
    Equipment Records
    1. Media Schedule > Equipment > Equipment Type
    2. Highlight equipment record
    3. Click delete
    4. Repeat steps 2 and 3 for all equipment types
    Room Records
    1. Media Schedule > Inventory > Rooms > Room Types
    2. Highlight room type
    3. Click delete.
    4. Repeat steps 2 and 3 for all room types

    When deleting anything from Media Schedule > Inventory, the counts on the left may display inaccurately. If this happens, you can restart the client and the count will be reset.

    Staff
    1. Media Scheduling > Schedule > Staffing
    2. Highlight staff
    3. Click delete.
    4. Repeat steps 2 and 3 for all staff
    Policy Groups
    1. Media System Administration > Media Scheduling > Policy Groups
    2. Highlight Policy Group
    3. Click delete.
    4. Repeat steps 2 and 3 for all policy groups
    Policy Settings

    1. Media System Administration > Media Scheduling > Policy Settings > Room / Equipment / Item tabs
    2. Highlight room / equipment / item setting
    3. Click delete for each setting
    4. Repeat steps 2 and 3 for all (you will not be able to delete default settings)

    Media Room Detail Types
    1. Media System Administration > Media Scheduling > Media Room Detail Types 
    2. Highlight room detail type
    3. Click delete.
    4. Repeat steps 2 and 3 for all room detail types
    Media Room Types
    1. Media System Administration > Media Scheduling > Media Room Type
    2. Highlight room type
    3. Click delete.
    4. Repeat steps 2 and 3 for all room types
    Maintenance Types
    1. Media System Administration > Media Scheduling > Maintenance Types
    2. Highlight maintenance type
    3. Click delete.
    4. Repeat steps 2 and 3 for all maintenance types
    Equipment Types
    1. Media System Administration > Media Scheduling > Equipment Types
    2. Highlight equipment type
    3. Click delete.
    4. Repeat steps 2 and 3 for all equipment types
    Media Types
    1. Prepackaged Reports > New query > Find items with MEDIA_TYPE_ID not equal to zero and get barcodes:
    SELECT IB.ITEM_BARCODE
    FROM ITEM I
    JOIN ITEM_BARCODE IB
    ON I.ITEM_ID=IB.ITEM_ID
    WHERE I.MEDIA_TYPE_ID <> 0;
    

    Save barcodes in .txt file

    1. Cataloging > File > Pick and Scan
    2. Use Pick and Scan and .txt file from step 3 to clear Media Type from item records.
    3. Media System Administration > Media Scheduling > Media Types
    4. Highlight media type
    5. Click delete.
    6. Repeat steps 5 and 6 for all media types.
    Operator Profiles
    1. Media Scheduling > Operator Security > Operators > Operator ID > Edit
    2. Select <none>
    3. Save.
    4. Repeat steps for every operator.
    Locations
    1. Media Scheduling > Operator Security > Locations > Location Name > Edit
    2. Uncheck any security profiles.
    3. Repeat for every location.
    Security Profiles
    1. Media Scheduling > Operator Security > Security Profiles
    2. Highlight each profile
    3. Click delete.
    4. Repeat steps 2 and 3 for all security profiles

    • Article last edited: 10-Jul-2018