On this page, configure the file format for importing student schedules.
This page includes configuration settings for auto-importing files daily.
Note: Theses options only apply if eRATEX > Booklist Config > Booklist Personalization is set to Student Schedule Import. See Booklist Config for more information on this.
Setting
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
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
Setting
Description
Start Position
The column of the import file that contains data for each field (0 based)
Length
The length of each column in characters for import data (e.g. length of the Student ID fields)
Static Value
If you are importing data without Campus and/or Term information, enter a default value here
Columns
The Import File Position field is 0-based, so use 0 for the first column, 1 for the second, etc.
For fields not included in the import file, leave the Position field blank.
Column Name
Description
Student ID
University student ID in the file
Catalog ID
University course catalog ID
Term
VR Term ID for the class
Campus
University Campus ID
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 student schedule 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.StudentScheduleImport.AutoRun.Enabled
Enable this to have the Student
Schedule Import process run automatically every day at the time specified in
the RATEX.StudentScheduleImport.AutoRun.Time AppConfig
RATEX.StudentScheduleImport.AutoRun.Time
Set this to the integer hour
(Eastern Time) that the Student Schedule Import Auto Run process should run
every day.
RATEX.StudentScheduleImport.ColumnDelimiter
Characters used to define the
delimiter between columns in the import file.
RATEX.StudentScheduleImport.ColumnLength.Campus
Length of the Campus field in
the fixed-width input file.
Length of the StudentID field in
the fixed-width input file.
RATEX.StudentScheduleImport.ColumnLength.Term
Length of the StudentID field in
the fixed-width input file.
RATEX.StudentScheduleImport.ColumnNumber.Campus
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.
RATEX.StudentScheduleImport.ColumnNumber.Course
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.
RATEX.StudentScheduleImport.ColumnNumber.Dept
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.
RATEX.StudentScheduleImport.ColumnNumber.Section
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 StudentID field. This value is 0-based, so
use 0 for the first column, 1 for the second, etc.
RATEX.StudentScheduleImport.ColumnNumber.Term
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 StudentID field begins. This value is 0-based, so use 0
for the first position, 1 for the second, etc.
RATEX.StudentScheduleImport.ColumnStartIndex.Term
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.StudentScheduleImport.ImportFilePath
Path to the student schedule
import file.
RATEX.StudentScheduleImport.IsDelimited
Enable this to indicate that the
Student Schedule Import file is a delimited file, and specify a delimiter in
the RATEX.StudentScheduleImport.ColumnDelimiter AppConfig. If the file is
fixed-width, disable this and set the column specification AppConfigs.
RATEX.StudentScheduleImport.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.
RATEX.StudentScheduleImport.StaticValue.Campus
Static value to use for Campus
if not included in the input file.
RATEX.StudentScheduleImport.StaticValue.Term
Static value to use for Term if
not included in the input file.
Email This Article
Previous Article
Next Article