Sierra Scheduler Task Builder

The Sierra Scheduler Task Builder creates and edits tasks that can subsequently be scheduled to run with Job Scheduler.

Creating a New Task

Choose the Scheduler option from the OTHER WEB APPLICATIONS section of the Admin App menu.
Choose the Tasks option from the Scheduler Admin App menu. The available task types appear along with all tasks that have been created from those task types.
Choose the ADD button associated with the appropriate task type.
If your institution is set up with multiple environments, select the appropriate one from the Choose environment drop-down menu.
Enter a Name for the task.
Enter one or more Email Addresses for staff who are to receive email notification when the task is run as a job. Separate multiple email addresses with commas.
Enter the parameters for the task. See Task Profiles for details on the parameters for each task type.
Choose OK to save or CANCEL to exit without saving your changes.

Editing an Existing Task

Choose the Scheduler option from the OTHER WEB APPLICATIONS section of the Admin App menu.
Choose the Tasks option from the Scheduler Admin App menu. The available task types display along with all tasks that have been created from those task types.
Choose the task to edit. A new tab opens with a list of the task's current parameters.
Select the EDIT button.
Edit the task parameters. See Task Profiles for the task parameters that are applicable to the task type.
Choose OK to save your changes or CANCEL to exit without saving your changes.

Deleting an Existing Task

Choose the Scheduler option from the OTHER WEB APPLICATIONS section of the Admin App menu.
Choose the Tasks option from the Scheduler Admin App menu. The available task types appear along with all tasks that have been created from those task types.
Choose the task to delete. A new tab opens with a list of the task's current parameters.
Select the DELETE button.
The system asks Are you sure? Select the Yes button to delete or No to keep the task.

Task Profiles

Each task type has a unique set of Profile parameters, which vary according to the task type.

Task Profile for Create Review File

Note that if a review file is updated or created while you are viewing Sierra Scheduler in the Admin App, you must exit, then reenter Scheduler in order to see the changes reflected.

The system presents a form which you fill out as appropriate. The first two elements on the form are:

Name: Specifies the task's name.
Email Addresses: Specifies the email addresses to which notification is sent when the task runs.

The remaining parameters are grouped into a set of Task-specific Parameters:

Task-Specific Parameters

Review File: Specifies a review file that contains the source records.
Rename as: Specifies the name to assign to the new review file.
Store Record Type: Specifies the type of records that are stored in the new review file.
Retain each box separately in review file: Specifies whether the review file should store every checkin card in the review file or simply store the complete holdings record.
Search on: In the drop-down menu, specify the range, review file, index, or advanced syntax to search. If you are searching on a range of records, enter the starting record number, including the record type indicator (for example, "b" for bibliographic, "i" for item, and so on) in the Start box and the ending record number in the Stop box. To specify that you want to search to the end of the database, enter the record type indicator followed by an asterisk (for example, b* for bibliographic, i* for item, and so on). Whenever this review file is regenerated, the system will search to the end of the database, even if new records have been added since the search criteria were set up.
Login: Specifies the user to associate with the new review file.
Saved Search: Specifies a saved search strategy to be used for the new review file. You must choose a search strategy created in the Sierra Create Lists function. You cannot create a search strategy within the Scheduler Admin App.

Task Profile for Output Delimited Records

Name: Specifies the task's name. If you do not specify a file extension, Sierra uses ".out".
Email Addresses: Specifies the email addresses to which notification is sent when the task runs.

The remaining parameters are grouped into a set of Task-specific Parameters and a set of FTP Parameters.

Task-Specific Parameters

Review File: Specifies a review file that contains the source records.
Rename as: Specifies the name to assign to the new review file.
Store Record Type: Specifies the type of records that are stored in the new review file.
Retain each box separately in review file: Specifies whether the review file should save the data from each box in the checkin card separately and thereby allow the system to output the box data when listing the review file.
Search on: In the drop-down menu, specify the range, review file, index, or advanced syntax to search. If you are searching on a range of records, enter the starting record number, including the record type indicator (for example, "b" for bibliographic, "i" for item, and so on) in the Start box and the ending record number in the Stop box. To specify that you want to search to the end of the database, enter the record type indicator followed by an asterisk (for example, b* for bibliographic, i* for item, and so on). Whenever this review file is regenerated, the system will search to the end of the database, even if new records have been added since the search criteria were set up.
Login: Specifies the user to associate with the new review file.
Saved Search: Specifies a saved search strategy to be used for the new review file. You must choose a search strategy created in the Sierra Create Lists function. You cannot create a search strategy within Scheduler.
Fields To Be Exported: Specifies the fields to include in the exported file.
Export Field Delimiter: Specifies the delimiter between fields in the exported file.
Export Text Qualifier: Specifies the delimiter for text fields in the exported file. This character precedes and follows each text field.
Export Repeated Field Delimiter: Specifies the delimiter between repeated fields of the same type.
Export Maximum Field Length: Specifies the maximum number of characters exported from each field.
Filename: Specifies the name of the file to which the records are written.

FTP Parameters

Host: Specifies the Host machine IP to which the record data is sent.
User Name: Specifies the login name for connecting to the remote machine.
Password: Specifies the password for connecting to the remote machine.
Remote Directory: Specifies the directory on the remote machine to which the record data is sent.
Remote Directory Text Box
Do not leave the Remote Directory text box blank. If you are loading the files from your login's home directory on the remote server, enter "." (a "dot" or period).
Secure Transfer: Specifies whether the connection is a secure FTP session or not.
Transfer Type: Specifies whether the data should be sent in ASCII or BINARY format.

Task Profile for Output MARC Records

Name: Specifies the task's name. If you do not specify a file extension, Sierra uses ".out".
Email Addresses: Specifies the email addresses to which notification is sent when the task runs.

The remaining parameters are grouped into a set of Task-specific Parameters and a set of FTP Parameters.

Task-Specific Parameters

Review File: Specifies a review file that contains the source records.
Rename as: Specifies the name to assign to the new review file.
Store Record Type: Specifies the type of records that are stored in the new review file.
Retain each box separately in review file: Specifies whether the review file should store every checkin card in the review file or simply store the complete holdings record.
Search on: In the drop-down menu, specify the range, review file, index, or advanced syntax to search. If you are searching on a range of records, enter the starting record number, including the record type indicator (for example, "b" for bibliographic, "i" for item, and so on) in the Start box and the ending record number in the Stop box. To specify that you want to search to the end of the database, enter the record type indicator followed by an asterisk (for example, b* for bibliographic, i* for item, and so on). Whenever this review file is regenerated, the system searches to the end of the database, even if new records have been added since the search criteria were set up.
Login: Specifies the user to associate with the new review file.
Saved Search: Specifies a saved search strategy to be used for the new review file. You must choose a search strategy created in the Sierra Create Lists function. You cannot create a search strategy within Scheduler.
Export Table: Specifies the table used to map Innovative fixed-length and variable-length fields to MARC fields and subfields when the MARC records are exported.
Create MARC Label File for OCLC?: Used for sending records to OCLC.
Originating System ID: Used for sending records to OCLC.
Project Identification: Used for sending records to OCLC.
Filename: Specifies the name of the file to which the MARC records are written.

FTP Parameters

Host: Specifies the Host machine IP to which the record data is sent.; If you are outputting MARC records to an Ex Libris product (such as Primo or Summon), enter the host and port values used to connect to the server in the following format: <host>:<port>.
User Name: Specifies the login name for connecting to the remote machine.
Password: Specifies the password for connecting to the remote machine.; If you are outputting MARC records for an Ex Libris product (such as Primo or Summon), enter the key provided by Ex Libris in this field.
Remote Directory: Specifies the directory on the remote machine to which the record data is sent.
Remote Directory Text Box
Do not leave the Remote Directory text box blank. If you are loading the files from your login's home directory on the remote server, enter "." (a "dot" or period).
Secure Transfer: Specifies whether the connection is a secure FTP session or not.
Transfer Type: Specifies whether the data should be sent in ASCII or BINARY format.

Date Appended to File Name

To prevent files from being overlaid when you transfer a new file to a vendor, Scheduler appends the date to the file name. The timestamp format is:

yyyymmddhhmmss

For example:

650SIERRRA-15844MARC.20140813094501.out

Scheduler appends the date/time stamp to the output data file only when a MARC Label file is not being created (Create MARC Label File for OCLC is set to "No") in Output MARC Records tasks.

Task Profile for Load Tasks

Sierra Scheduler loads Patron and MARC records by default. Note that the Load MARC Records task includes MARC file preprocessing. You do not have to perform the preprocessing separately when using Scheduler.

Optional Load Task Features

SUDOC is an acronym for Système universitaire de documentation. The Load SUDOC Records task type is available exclusively to French institutions.
When loading UNIMARC authority records, Sierra Scheduler can automatically use established headings in bibliographic records to determine whether to load authority records as name authority records, subject authority records, both, or neither. To have this feature set up, please contact the Help Desk.

The system presents a form which you fill out as appropriate. The first two elements on the form are:

Name: Specifies the task's name.
Email Addresses: Specifies the email addresses to which notification is sent when the task runs.

The remaining parameters are grouped into a set of Task-specific Parameters and a set of FTP Parameters:

Task-Specific Parameters

Format: Specifies the format of the file to be loaded. Choose format 1 for Marc-like text files. Choose format 3 for fixed-length text files. (Formats 2 and 4 are deprecated.); This option appears only when you choose to Load Patron TEXT Records.
Load (Conversion) Table: Specifies the table that maps MARC fields and subfields to Innovative fixed-length and variable-length fields when the MARC records are imported.
Load Type: Specifies the format of the data.
Update Database: If this option is set to No, the records are loaded, but are not written to the database. This can be used to test transfer parameters before attempting an actual transfer.
Create Review File: If this option is set to Yes, Sierra creates a system-generated review file in Create Lists containing the records that were loaded.

FTP Parameters

Host: Specifies the Host machine IP from which the record data is retrieved.; If you are loading MARC records from an Ex Libris product (such as Open 360 Services), enter the host and port values used to connect to the server in the following format: <host>:<port>.
User Name: Specifies the login name for connecting to the remote machine.
Password: Specifies the password for connecting to the remote machine.; If you are loading MARC records from an Ex Libris product (such as Open 360 Services), enter the key provided by Ex Libris in this field.
Remote Directory: Specifies the directory on the remote machine from which the record data is read.
NOTE
Do not leave the Remote Directory text box blank. If you are loading the files from your login's home directory on the remote server, enter "." (a "dot" or period).
Secure Transfer: Specifies whether the connection is a secure FTP session or not.
Transfer Type: Specifies whether the data should be sent in ASCII or BINARY format.
File Name Type: Specifies whether a specific file (the name option) or all files matching a given pattern are to be retrieved.
File Name/Pattern: Specifies a filename pattern. The filename pattern is used in an FTP 'ls' command on the host machine's remote directory. The results of the 'ls' command are the group of files that will be loaded. The host machine rules determine the allowed filename patterns in an 'ls' command.
Check Remote List: This option is enabled when you have specified a filename pattern. When selected, the system checks the remote directory on the host machine for files matching the specified pattern and allows you to select files for transfer from a list of those found.
Loaded Files: Displays a list of files that have already been transferred with this task.

Sierra Scheduler Task Builder

Creating a New Task

Editing an Existing Task

Deleting an Existing Task

Task Profiles

Task-Specific Parameters

FTP Parameters

Task-Specific Parameters

Task-Specific Parameters

Date Appended to File Name

FTP Parameters

Remote Directory Text Box

Task-Specific Parameters

FTP Parameters

Remote Directory Text Box

Date Appended to File Name

Optional Load Task Features

Task-Specific Parameters

FTP Parameters

NOTE