Skip to main content
CollegeSource Production

Questions and Answers Import Record Format

The new role of Program Administrator offers the ability to import/export both questions and answers via flat file, which may be in one of two two available formats: (new) Transferology record format or (legacy) u.select schema.

 

Application:

Terminology:

New

Transferology

"Record Format" *



 

Old

u.select

"Schema" *

Questions

  • Import

 

Transferology Questions Import Record Format

 

Legacy u.select Questions Import Schema

  • Export
Transferology Questions Export Record Format Legacy u.select Questions Export Schema
 

Answers

  • Import

 

Transferology Answers Import Record Format


 

 

Legacy u.select Answers Import Schema

  • Export
Transferology Answers Export Record Format Legacy u.select Answers Export Schema

* The use of the term "schema" is being phased out, with new references replaced with the term "record format" to avoid confusion with XML schema.

Both formats–new and old–are recognized and made available in the Lab in an effort to eliminate a school's need to revise current program data export processes from its campus SIS.

When importing questions and answers, it is good practice to import the question file FIRST and then the program file to ensure that the questions are linked up correctly with their corresponding programs.

While questions and answers are listed separately, they can be combined into one file and do not need to be imported separately

Questions

Transferology Questions Import/Export Record Format

Both School Administrators and Program Administrators can import and/or export questions in the Transferology format.

The Transferology Questions Import Record Format is the same as the Transferology Questions Export Record Format.

The Transferology Questions format is very similar to that of legacy u.select Questions. In fact, the only differences lie in the Answer fields:

Rcredit Field

For pseudo course answers:

  • The export format is the same: a number with 5 digits after the decimal point.
  • Any valid number is allowed on import.

For non-pseudo courses answers:

  • u.select format will export 0.0000 and Transferology format will leave the field blank.
  • This field is ignored when a non-pseudo course answer is imported.

Pflag Field

For pseudo course answers:

  • u.select format uses "True" and "False" for imports and exports.
  • Transferology format uses "Y" and "N".

For non-pseudo course answers:

  • u.select always exports "False".
  • Transferology leaves the field blank.
  • This field is also ignored when a non-pseudo course answer is imported.

Legacy u.select Questions Import/Export Schema

Both School Administrators and Program Administrators can import questions in the legacy u.select format. Only superusers can export questions in the legacy u.select format.

The legacy u.select Questions Import Schema is the same as the legacy u.select Questions Export Schema.

Questions

Field

Format

Length

Pattern

Description

Import Type

Character

 

QUESTION

Identifies the line as a question

Question Number

Numeric

2

0,1,2,3,4, etc.

The number that represents the order in which the question will display to users

Question Description

Variable Character

128 max

 

A description of the questions; used to distinguish it from other questions

Question Text

Variable Character

255 max

 

The question as it will appear to users creating plans

Question Type

Character

1

I, P or F

Identifies the question as an Institution question, a Program question, or a Followup question


Answers

Transferology Answers Import/Export Record Format

Both School Administrators and Program Administrators can import and/or export answers in the Transferology format.

The Transferology Answers Import Record Format is the same as the Transferology Answers Export Record Format.

The Transferology Answers format is very similar to that of legacy u.select Answers. In fact, the only differences lie in the Answer fields. Below are the differences:

Rcredit Field

For pseudo course answers:

  • The export format is the same: a number with 5 digits after the decimal point.
  • Any valid number is allowed on import.

For non-pseudo courses answers:

  • u.select format will export 0.0000 and Transferology format will leave the field blank. This field is ignored when a non-pseudo course answer is imported.

Pflag Field

For pseudo course answers:

  • u.select format uses "True" and "False" for imports and exports.
  • Transferology format uses "Y" and "N".

For non-pseudo course answers:

  • u.select always exports "False".
  • Transferology leaves the field blank.
  • This field is also ignored when a non-pseudo course answer is imported.

Legacy u.select Answers Import/Export Schema

Both School Administrators and Program Administrators can import answers in the legacy u.select format. Only superusers can export answers in the legacy u.select format.

The legacy u.select Answers Import Schema is the same as the legacy u.select Answers Export Schema.

Answers

Field

Format

Length

Pattern

Description

Required

Fields that are required, regardless of what you are adding with your answer

Import Type

Character

 

ANSWER

Identifies the line as an answer.

Required

Associated Question Description

Variable Character

128 max

 

The question description of the question to which this is an answer.

Required

Answer Number

Numeric

2

1,2,3,4, etc

The number that represents the order in which the answer will display to users.

Required

Followup Question Description

Variable Character

128 max

 

The question description of the question users will be asked as a followup to this answer.

Optional

The Answer

Variable Character

255 max

 

The answer as it will appear to users.

Required

Action Type

Character

1

M, C or N

Action to take when this answer is chosen by a user. M = Marker, C = Pseudo Course, N = Nothing

Required

Pseudo Course Flag

Variable Character

 

N or Y

Indicates whether or not the course is a true pseudo course.

Required

Fields that are needed for adding a PSEUDO course with your answer

InstIDQ

Numeric

2

71, 72, 73 or 74

The InstID Qualifier used for your Pseudo course.

Required

InstID

Variable Character

4 - 6

 

The institution ID that corresponds with the IDQ used.

Required

InstCD

Variable Character

3

 

The institution CD associated with the course.

Required

Pseudo Course Department

Variable Character

15

 

The department of the course that's being added.

Required

Pseudo Course Number

Numeric

15

 

The course number of the course being added.

Optional

Pseudo Course Y/M

Numeric

6

CCYYMM

The year to be added for the course.

Required

Pseudo Course Title

Variable Character

29

 

The title of the course as it will be displayed on the plan.

Optional

Pseudo Course Hours

Numeric

1 - 8

 

The credit hours associated with the course.

Optional

Pseudo Course Grade

Character

1 - 4

 

The grade to be assigned the course.

Required

Fields that needed for adding a MARKER with your answer

Marker Requirement Name

Variable Character

1 - 9

 

The requirement name as found in the degree audit system. Value will begin with a $

Required

Marker Type

Character

1

R or D

Identifies what type of marker is added. R = Marker Requirement. D = Marker List

Required

Marker Req/List Value

Variable Character

1 - 9

 

The replacement requirement name to be included in the degree audit. Value replaces the $Marker.

Required

Catalog Y/T

Numeric

4 digits followed by 0-2 alphanumeric characters

CCYYMM

The catalog year for the marker requirement/list if a specific y/t is to be used rather than the y/t selected by the user when creating their plan.

Optional

School Code

Numeric

1 - 3

 

The InstCD value if different from the InstCD defined for your institution in Transferology.

Optional

Control Code

Numeric

1 - 2

 

The exception control code.

Required

Example:

QUESTION|0|OTM|Have you completed the Ohio Transfer Module?|I|

ANSWER|OTM|1||Yes|C|73|OBR||true|TRANMOD||000000||0.0|P|||||||

ANSWER|OTM|2||No|N||||false||||||||||||

ANSWER|OTM|3||Maybe|M||||false|||||||$MARKER|R|Name|||CD|

  • Was this article helpful?