Astra Schedule Help (8.0)

Import Pathways

Hide Navigation Pane

Import Pathways

Previous topic Next topic  

Import Pathways

Previous topic Next topic JavaScript is required for the print function  

Pathways can be imported using an Excel spreadsheet template. A copy of the Excel template - RoadMapTemplate.xls - is included in the application installation files (\Files\ATEConfiguration\Spokes\SIS\Excel\ExampleDataTemplates) and can be provided by Ad Astra support or consulting staff.

 

The Pathway import template consists of three tabs: Roadmaps, RoadmapCourses, and RoadmapCampuses.

 

Pathway_Import_ExcelTabs

 

The Roadmaps tab establishes the Pathway record itself and includes the following fields:

 

Column

Comment

SISKey *

This will be the ID of the Pathway record created.  It can be the same as the name, but with no spaces. Must be unique.

Name *

Must be unique

CatalogVersionSISKey *

Must match an existing catalog version siskey in the system

DegreCredentialName *

Parent Program of Study association

IsDefault

This sets the Pathway in question as the default Pathway for its Program of Study

 

Values can be true, false, or null.  Null is treated as false.

 

There should be only one Pathway flagged as the default. During import, the system will remove the default flag from any existing Pathway for the Program of Study and replace with the imported value.

 

* = Required field

 

The RoadmapCourses tab is used to add rows to the Pathway for courses, course groups, or alternate courses/groups, and includes the following fields:

 

Column

Comment

SISKey *


RoadmapSISKey *


SubjectCode

String

CourseNumber

String

 

NOTE:

 

SubjectCode and CourseNumber must either both be supplied or both be empty.

 

If SubjectCode and CourseNumber are supplied, then CourseGroupName must be empty.

 

If CourseGroupName is supplied, then SubjectCode and CourseNumber must be empty.

 

Any validation problems will halt the import.

 

CourseGroupName

Must match an existing course group name exactly

AlternateSubjectCode

String

AlternateCourseNumber

String

AlternateCourseGroupName

Must match an existing course group name exactly

RequiredCreditHours

Numeric

Sequence *

Numeric, duplicates are allowed

UserPredPercent


 

* = Required field

 

Note: Subject and Course values are strings, but make sure they match existing subject and course values in the system exactly. If they do not match, processes that use this information will fail when looking up courses using these values.

 

The RoadmapCampuses tab is used to specify campuses to which the Pathway applies, and includes the following fields:

 

Column

Comment

RoadmapSISKey

required if using this option

CampusSISKey

must match existing campus record SISKey if using this option

 

* = Required field

 

*Multiple rows per Pathway are allowed to specify multiple campuses.

*This is optional. If none are specified, the campus defaults to "Any".

 

NOTE:  

Before import, be sure to select all cells in the sheets and convert them to "text" format.

 

Reason:

The default cell format for the generated Excel template is "general". Cells formatted as "general" are interpreted by Excel on-the-fly as content is entered - pure numbers are treated as numeric; values with alpha characters are treated as text; etc. When importing Excel data into a database, the import driver must determine a single type for the column. This is achieved by scanning a small sample of the document (8 rows) and setting the type to match the majority case. If numeric wins, cells with alpha characters will be null, and errors can occur.

 

To ensure that data is read correctly, select all cells in the sheet and change the format to "text".