By default, course information in booklist URLs is passed from the university's server to the eRATEX Book List in plain text. Some schools encrypt the course data in the URL, and eRATEX now supports this.
Here, you configure settings for importing encrypted links to courses from files.
You may also configure auto-run functionality to import encrypted link files daily.
Setting
Settings
Description
File Path
Location of the file to import
File is Delimited
Select this if the fields in the file are delimited by a punctuation mark or special character
Column Delimiter
Type the column delimiter. For example, if you are importing a CSV file, type , (comma)
Ignore First Row
Select this if the first row of the file you are importing contains headers
Field Mappings
The following fields are for importing encrypted course links that are not delimited
Setting
Description
Column Name
The column for the type of data imported
Start Position
The number of characters into the file of the beginning of the data
Length
The length of the data
Static Value
If you are importing data without Campus and/or Term information, enter a default value here
Columns
Column Name
Description
Encrypted Course
VR Course ID
Catalog ID
University catalog ID
Term
VR Term ID for the class
Campus
VR Campus code
Dept
VR Department ID for the course
Course
Course number
Section
Section number
Auto-Run Settings
Setting
Description
Enabled
Select this to enable auto-import of encrypted course link files
Daily Auto-Run Time
Select the time the auto-import runs (daily)
Button
Description
Save Settings
Save the student file import configurations
Save and Begin Process
Save the configurations and run
View Value Mappings
Related Parameters
Parameter
Description
RATEX.EncryptedCourseLinksImport.AutoRun.Enabled
Enable this to have the
Encrypted Course Links Import process run automatically every day at the time
specified in the RATEX.EncryptedCourseLinksImport.AutoRun.Time AppConfig
RATEX.EncryptedCourseLinksImport.AutoRun.Time
Set this to the integer hour
(Eastern Time) that the Encrypted Course Links Import Auto Run process should
run every day.
RATEX.EncryptedCourseLinksImport.ColumnDelimiter
Characters used to define the
delimiter between columns in the import file.
Column number in the input file
of the column that represents the Campus field. This value is 0-based, so use
0 for the first column, 1 for the second, etc.
Column number in the input file
of the column that represents the CatalogID field. This value is 0-based, so
use 0 for the first column, 1 for the second, etc.
Column number in the input file
of the column that represents the Course field. This value is 0-based, so use
0 for the first column, 1 for the second, etc.
Column number in the input file
of the column that represents the Dept field. This value is 0-based, so use 0
for the first column, 1 for the second, etc.
Column number in the input file
of the column that represents the EncryptedCourse field. This value is
0-based, so use 0 for the first column, 1 for the second, etc.
Column number in the input file
of the column that represents the Section field. This value is 0-based, so
use 0 for the first column, 1 for the second, etc.
Column number in the input file
of the column that represents the Term field. This value is 0-based, so use 0
for the first column, 1 for the second, etc.
Position in the fixed-width
input file where the CatalogID field begins. This value is 0-based, so use 0
for the first position, 1 for the second, etc.
Position in the fixed-width
input file where the EncryptedCourse field begins. This value is 0-based, so
use 0 for the first position, 1 for the second, etc.
Position in the fixed-width
input file where the Term field begins. This value is 0-based, so use 0 for
the first position, 1 for the second, etc.
RATEX.EncryptedCourseLinksImport.ImportFilePath
Path to the Encrypted Course
Links import file.
RATEX.EncryptedCourseLinksImport.IsDelimited
Enable this to indicate that
the Encrypted Course Links Import file is a delimited file, and specify a
delimiter in the RATEX.EncryptedCourseLinksImport.ColumnDelimiter AppConfig.
If the file is fixed-width, disable this and set the column specification AppConfigs.
RATEX.EncryptedCourseLinksImport.SkipFirstRow
Set to yes to skip the first
row of the import. This may be used because the import file has column
headers in the first row, or some other header.
Email This Article
Previous Article
Next Article