Bookings

1. Prepackaged Reports > New Query > Query for confirmation numbers of current bookings:

SELECT CONFIRM_NO
FROM MEDIA_SCHEDULE;

2. Media Scheduling > Search > Bookings > Confirmation Number
3. Enter first number from step 2.
4. Discharge, cancel or delete booking.
5. 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

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

2. Cataloging > File > Pick and Scan
3. Use Pick and Scan and .txt file from step 3 to clear Media Type from item records.
4. Media System Administration > Media Scheduling > Media Types
5. Highlight media type
6. Click delete.
7. 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