Questions and Answers Import Record Format

The 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 Import Record Format
Legacy u.select Questions Import Schema
Answers
  • Import

Transferology Questions Import Record Format

Legacy u.select Questions Import Schema
  • Export
Transferology Questions Import Record Format Legacy u.select Questions Import 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

TABLE

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

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

Field Format Length Pattern Description Required
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.
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

 
Field Format Length Pattern Description Required
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

 
Field Format Length Pattern Description Required
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|<br>