Films on Demand
-
Login to Films on Demand at http://admin.films.com/ with the following:
-
Username: XXXXXX
-
Password: XXXXXX
-
-
Click on Title Data > MARC Records
-
Click Generate New Records to create a file that includes all records since the last download. It will appear in the table below with the current date a “Not Downloaded” status.
-
Download the file.
New records:
-
Open file in MarcEdit.
-
Go to Tools > Current Tasks > Films on Demand (This will update the 856$z, add 856$x fields, and add a 949$l field for the Kenyon item. *** See the MarcEdit task details below.)
-
Go to Tools > Add/Delete Field. In the new window, type 910 in the field box, and in the data field, add a note that reflects the current date (e.g. $afod-20180521). Check the insert last box, and click Add Field.
-
Save file and compile to MARC using UTF-8 as the Save as type.
-
In Sierra, go to Data Exchange
-
Select Process = Load records via locally created load profiles (local)
-
Click Get PC
-
Browse desktop to select the MARC file
-
Upload
-
When prompted to rename, remove the .mrc extension and select the .lfts extension from the dropdown menu
-
Click OK
-
-
Select the .lfts file and click Prep
-
Click Start
-
Select the .lmarc file and click Load
-
Select LOAD a SVIDEO file
-
Check the “video” load profile for the following:
-
ov_action=“d” (so item records aren’t created for overlays)
-
#com=“dflt”@dflt=“kensv,conrei” (so kenyon bib is created)
-
001 = as is
-
856 = no proxy
-
Uncomment this line if loading new records:
-
|||0|0| | |0|n|G|0|@link="i:1:949"
-
-
-
Click Test. Usually, these are new records. OhioLINK will usually indicate if these are overlays with any other records.
-
Click Load
-
Spot check a few of the records in both staff and public displays
Deletes:
-
Open file in MarcEdit
-
Go to Tools > Current Tasks > Films on Demand (we need to run the MarcEdit task to insert the “fod” prefix in the 001 field in order to match the existing 001 in the bib).
-
Save file and compile to MARC
-
In Sierra, go to Data Exchange
-
Select Process = Load records via locally created load profiles (local)
-
Click Get PC
-
Browse desktop to select the MARC file
-
Upload
-
When prompted to rename, remove the .mrc extension and select the .lfts extension from the dropdown menu
-
Click OK
-
-
Select the .lfts file and click Prep
-
Click Start
-
Select the .lmarc file and click Load
-
Select LOAD a SVIDEO file
-
Check the “video” load profile for the following:
-
ov_action=“u” (The “u” value [reject] keeps us from creating a new record
-
001 = as is
-
856 = no proxy
-
Comment out this line:
-
#|||0|0| | |0|n|G|0|@link="i:1:949”
-
-
-
Click Test (if load table is correct, records should be shown as overlays)
-
Check the “Use Review Files” box (We’ll need the review file to make the deletions)
-
Click Load
-
Select Create List function from the dropdown list
-
Find an empty list between 300 and 310 with the capacity to contain the number of records loaded (see Max Records column).
-
With empty list highlighted, select the Copy icon, and find the desired file in the list. Overlaid files will be grouped together near the end of the options. Once found, click OK.
-
It’ll ask if you want to remove the file being copied from. Click Yes.
-
Go to Global Update
-
Under the “1. Select Records” tab on the left, use the dropdown menu to select Review. Use the dropdown menu for “Review file” to select the file (the number will match the list number you created), then click Search.
-
Under the “2. Command input tab”, select Change fixed-length field, and click OK.
-
Fixed-length = 31 SUPPRESS
-
Find = <any>
-
Replace = y DELETE
-
Click OK
-
-
Click the “3. Preview” tab to review the changes
-
If the changes are appropriate, click Process
-
The delete files will be processed by an automated function that will submit the titles to Summon for removal from their database. Records are deleted manually from Sierra on Mondays using the “Delete from Summon” list.
____________________________________________________________________________
***MarcEdit tasks:
1.
FIND:
=001 (.*)
REPLACE:
=001 fod$1
2.
FIND:
=856(.*)\$z(.*)\$u(.*)
REPLACE:
=856$1$zKenyon view online at Films on Demand$u$3
3.
FIND:
=856(.*)
REPLACE:
=856$1$xCollection: Films on Demand$xProvider: Films Media Group
4.
ADD:
Field: 949
Field data: $lken