# OneRoster v1.1 Reference CSV Files Testset Details

This is the set of CSV files that are to be used for testing OneRoster v1.1 systems that claim conformance to the importing of CSV files. Each testset is provided as a '.zip' file as required by the OneRoster 1.1 specification. This testset includes files with known errors.

1. Valid CSV Testset - the set of CSV test fies that are syntactically and semantically correct;
   1. Rostering Valid CSV Testset - tests focused on rostering functionality
   2. Resources Valid CSV Testset - tests focused on resources functionality
   3. Gradebook Valid CSV Testset - tests focused on gradebook functionality
   4. Mixed Rostering, Resources and Gradebook Valid CSV Testset - tests focused on all of the CSV functionality
2. Invalid CSV Testset - the set of CSV test files that contain known syntactic and/or semantic errors.
   1. Rostering Invalid CSV Testset - tests focused on rostering functionality
   2. Resources Invalid CSV Testset - tests focused on resources functionality
   3. Gradebook Invalid CSV Testset - tests focused on gradebook functionality
   4. Mixed Rostering, Resources and Gradebook Invalid CSV Testset - tests focused on all of the CSV functionality

The key for the tables is:

- "Test ID" - the unique identifier for the set of CSV files (this is also the name of the directory containing the associated set of CSV files);
- "Records" - enumerated as { Single | Multiple } to denote the number of records contained in each of the CSV files;
- "Data" - enumerated as { Req | Req+ | All } to denote the set of data objects supported i.e. only those required, required plus some optional and all;
- "Ext" - enumerated as { Yes | No } to denote whether or not the CSV files contain extension data objects;
- "Description" - a description of the nature and objectives of test being provided by the set of test CSV files.

Each test file is supplied as a '.zip' file (as required by the standard). The naming convention for the files is designed to be indicative of the objectives and contents of the file itself. The naming convention is based upon a string of "ABCZZZ":

- "A" - is defined as { V | I } where:-
  - "V" denotes tests where the file set is syntactically and semantically valid
  - "I" denotes tests where the file set is syntactically and/or semantically invalid
- "B" - is defined as { R | C | O | X } where:-
  - "R" denotes tests for rostering information only
  - "C" denotes tests for resources information only
  - "G" denotes tests for gradebook information only
  - "X" denotes tests for rostering, resources and gradebook mixed information
- "C" - is defined as { b | d | m } where:-
  - "b" denotes tests with bulk processing only
  - "d" denotes tests with delta processing only
  - "m" denotes tests with files that require bulk and delta processing
- "ZZZ" - is a number in the range '000' to '999'.

Two examples to demonstrate the naming convention are:

- 'VRb001' - contains a test with valid data for rostering and with bulk processing only
- 'ICd009' - contains a test with invalid data for resources and with delta processing only.

The CSV files are split into three functional categories:

- Rostering - the set of CSV files focused on rostering i.e. "academicSessions.csv", "classes.csv", "courses.csv", "demographics.csv", "enrollments.csv", "orgs.csv" and "users.csv";
- Resources - the set of CSV files focused on resources i.e. "classResources.csv", "courseResources.csv" and "resources.csv";
- Gradebook - the set of CSV files focused on gradebook i.e. "categories.csv", "lineItems.csv" and "results.csv".

ALL systems MUST support rostering. Support for resources and gradebook processing is optional. The reference tests are split into groups to reflect these functional categories. The tests that should be used are shown in Table A.

Table A The set of files that should be used for CSV import systems testing for the various functional capabilites.
Processing | Bulk Processing | Bulk and Delta Processing
--- | --- | ---
Valid Files | Invalid Files | Valid Files | Invalid Files
Rostering ONLY | Table 1 | Table 13 | Table 1 Table 2 Table 3 | Table 13 Table 14 Table 15
Rostering and Resources | Table 1, Table 4 | Table 13, Table 16 | Table 1, Table 4 Table 2, Table 5 Table 3, Table 6 | Table 13, Table 16 Table 14, Table 17 Table 15, Table 18
Rostering and Gradebook | Table 1, Table 7 | Table 13, Table 19 | Table 1, Table 7 Table 2, Table 8 Table 3, Table 9 | Table 13, Table 19 Table 14, Table 20 Table 15, Table 21
Rostering, Resources and Gradebook | Table 1, Table 4, Table 7, Table 10 | Table 13, Table 16, Table 19, Table 22 | Table 1, Table 4, Table 7, Table 10 Table 2, Table 5, Table 8, Table 11 Table 3, Table 6, Table 9, Table 12 | Table 13, Table 16, Table 19, Table 22 Table 14, Table 17, Table 20, Table 23 Table 15, Table 18, Table 21, Table 24

The changes in this release are:

- The following valid file sets have been corrected:- VRb100, VRd004, VRd141, VRd143, VCd108, VGb107 and VGd109;
- The following invalid file sets have been corrected:- IRb100, IRb101, IRb102, IRb103, IRb104, IRb107, IRb208, IRb213, IRb262, IRd100, IRd101, IRd102, IRd103, IRd104, IRd107 and IRd208;
- New test files are denoted by (*).

top

## 1. Valid CSV File Test-Sets

This is the set of test files which are syntactically and semantically correct.

### 1.1 Rostering Valid CSV File Test-Sets

The set of tests to be used for establishing the correct importing of rostering information. All CSV importing systems must use these test files as part of conformance testing. Each set of files includes the "manifest.csv" file and one or more of the "academicSessions.csv", "classes.csv", "courses.csv", "demographics.csv", "enrollments.csv", "orgs.csv" and "users.csv" files.

#### Bulk Processing

These files contain bulk processing information only.

Table 1 Valid CSV test files for bulk roster processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VRb001 | - | - | - | This is just the "manifest.csv" file. All of the accompanying data file entries are marked as 'absent'.
VRb002 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv" data file. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VRb003 | Single | Req | No | The "manifest.csv" file and the "orgs.csv" data file. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VRb004 | Single | Req | No | The "manifest.csv" file and the "users.csv" and "orgs.csv" data file (two files for semantic consistency). The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VRb005 | Single | Req | No | The "manifest.csv" file and the "courses.csv" and "orgs.csv" data files (two files for semantic consistency). The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VRb006 | Single | Req | No | The "manifest.csv" file and the "classes.csv", courses.csv", "orgs.csv" and "academicSessions.csv" data file (four files for semantic consistency). The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VRb007 | Single | Req | No | The "manifest.csv" file and the "demographics.csv", "users.cvs" and "orgs.csv" data files (three files for semantic consistency). The data files each contain a single record identified as 'bulk' transfers with only the 'birthDate' value supplied. Note that this file should only be used by systems that support the optional processing of "demographics.csv" files.
VRb008 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv" and "academicSessions.csv" data file (six files for semantic consistency). The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VRb100 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "academicSessions.csv", "resources.csv", "classResources.csv", "courseResources.csv", "lineItems.csv", "categories.csv" and "results.csv" data file (all files for semantic consistency). The data files each contain necessary records identified as 'bulk' transfers with only the required data objects.
VRb101 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VRb102 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. acedemicSession of "gradingPeriod"
VRb0103 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. acedemicSession of "schoolYear"
VRb0104 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. acedemicSession of "term"
VRb105 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. acedemicSession with parentSourcedId reference.
VRb106 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. classes with grades of 5
VRb107 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. classes with grades list of "05,06"
VRb108 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. classes with classType of homeroom
VRb109 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. classes with subjectCodes of 01002
VRb110 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. classes with periods of “1,3,5”
VRb111 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. courses with schoolYearSourcedId of ACADSESS_01 from the acedimicSessions.csv file
VRb112 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. courses with grades of "05,06"
VRb113 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. courses with subject and subject codes of "course A, course B" and "01002,01003"
VRb114 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with sex of "male"
VRb115 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with sex of "female"
VRb116 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with americanIndianOrAlaskaNative of "true"
VRb117 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with asian of "true"
VRb118 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with blackOrAfricanAmerican of "true"
VRb119 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with nativeHawaiianOrOtherPacificIslander of "true"
VRb120 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with white of "true"
VRb121 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with nativeHawaiianOrOtherPacificIslander, white and demographicRaceTwoOrMoreRaces set to "true"
VRb122 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with hispanicOrLatinoEthnicity of "true"
VRb123 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with countryOfBirthCode of "US"
VRb124 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with stateOfBirth of "CO"
VRb125 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with cityOfBirth of "Denver"
VRb126 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. demographics with publicSchoolResidenceStatus of "01652"
VRb127 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. enrollment of teacher no primary indicator.
VRb128 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. enrollment of teacher with 1 primary.
VRb129 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. enrollment with begin and end dates aligned with academic session
VRb130 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. users with userIds
VRb131 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. users with identifier, sms, phone and email
VRb132 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. users with grade of "05"
VRb133 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. users with password of "password"
VRb134 | Single | Req | Yes | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. courses with suggested metadata "metadata.duration" and user metadata "metadata.pnpfileurl"
VRb135 | Single | Req | Yes | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", courses.csv", "demographics.csv" "enrollments.csv", "orgs.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. orgs with suggested metadata "metadata.classification" ,"metadata.gender", "metadata.boarding", "metadata.address1", "metadata.address2 , "metadata.city", "metadata.state", "metadata.postCode", "metadata.country"

top

#### Delta Processing

These files contain delta processing information only.

Table 2 Valid CSV test files for delta roster processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VRd002 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VRd003 | Single | Req | No | The "manifest.csv" file and the "orgs.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VRd004 | Single | Req | No | The "manifest.csv" file and the "users.csv" and "orgs.csv" data file (two files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VRd005 | Single | Req | No | The "manifest.csv" file and the "courses.csv" and "orgs.csv" data files (two files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VRd006 | Single | Req | No | The "manifest.csv" file and the "classes.csv", courses.csv", "orgs.csv" and "academicSessions.csv" data file (four files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VRd007 | Single | Req | No | The "manifest.csv" file and the "demographics.csv", "users.cvs" and "orgs.csv" data files (three files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the 'birthDate' value supplied. Note that this file should only be used by systems that support the optional processing of "demographics.csv" files.
VRd008 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv" and "academicSessions.csv" data file (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VRd100 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency.
VRd101 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency.
VRd102 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv" and "demographics.csv". "academicSessions.csv" data file is removed. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency.
VRd103 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. "classes.csv" data file is removed. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency.
VRd104 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. "courses.csv" data file is removed. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency.
VRd105 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", "courses.csv", "orgs.csv" and "demographics.csv" data file. "academicSessions.csv" data file is removed. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency.
VRd106 | Single | Req | No | The "manifest.csv" file and the "users.csv", "classes.csv", "courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. "enrollments.csv" data file is removed. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency.
VRd107 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", "courses.csv", "demographics.csv" and "academicSessions.csv" data file. "orgs.csv" data file is removed. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency.
VRd108 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "classes.csv", "courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. "users.csv" data file is removed.The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency.
VRd109 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", "courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. acedemicSession of "gradingPeriod"
VRd110 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", "courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. acedemicSession of "schoolYear"
VRd111 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. acedemicSession of "term"
VRd112 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. acedemicSession with parentSourcedId reference.
VRd113 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. classes with grades of 5
VRd114 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. classes with grades list of "05,06"
VRd115 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. classes with classType of homeroom
VRd116 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. classes with subjectCodes of 01002
VRd117 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. classes with periods of “1,3,5”
VRd118 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. courses with schoolYearSourcedId of ACADSESS_01 from the acedimicSessions.csv file
VRd119 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. courses with grades of "05,06"
VRd120 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. courses with subject and subject codes of "course A, course B" and "01002,01003"
VRd121 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with sex of "male"
VRd122 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with sex of "female"
VRd123 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with americanIndianOrAlaskaNative of "true"
VRd124 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with asian of "true"
VRd125 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with blackOrAfricanAmerican of "true"
VRd126 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with nativeHawaiianOrOtherPacificIslander of "true"
VRd127 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with white of "true"
VRd128 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with nativeHawaiianOrOtherPacificIslander, white and demographicRaceTwoOrMoreRaces set to "true"
VRd129 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with hispanicOrLatinoEthnicity of "true"
VRd130 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with countryOfBirthCode of "US"
VRd131 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with stateOfBirth of "CO"
VRd132 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with cityOfBirth of "Denver"
VRd133 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. demographics with publicSchoolResidenceStatus of "01652"
VRd134 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. enrollment of teacher no primary indicator.
VRd135 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. enrollment of teacher with 1 primary.
VRd136 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. enrollment with begin and end dates aligned with academic session
VRd137 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. users with userIds
VRd138 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. users with identifier, sms, phone and email
VRd139 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. users with grade of "05"
VRd140 | Single | Req | No | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. users with password of "password"
VRd141 | Single | Req | Yes | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. courses with suggested metadata "metadata.duration" and user metadata "metadata.pnpfileurl"
VRd142 | Single | Req | Yes | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency.
VRd143 | Single | Req | Yes | The "manifest.csv" file and the "enrollments.csv", "users.csv", "classes.csv", courses.csv", "orgs.csv", "demographics.csv" and "academicSessions.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects and for semantic consistency. orgs with suggested metadata "metadata.classification" ,"metadata.gender", "metadata.boarding", "metadata.address1", "metadata.address2 , "metadata.city", "metadata.state", "metadata.postCode", "metadata.country"

top

#### Bulk and Delta Processing

These files contain bulk and delta processing information only.

Table 3 Valid CSV test files for bulk and delta roster processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VRm001 | ? | ? | ? | ...To be completed...

top

### 1.2 Resources Valid CSV File Test-Sets

The set of tests to be used for establishing the correct importing of resource information. All CSV importing systems must use these test files as part of conformance testing. Each set of files includes the "manifest.csv" file and one or more of the "academicSessions.csv", "classes.csv", "courses.csv", "demographics.csv", "enrollments.csv", "orgs.csv", "users.csv", "resources.csv", classResources.csv" and 'courseResoures.csv" files.

#### Bulk Processing

These files contain bulk processing information only.

Table 4 Valid CSV test files for bulk resources processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VCb001 | Single | Req | No | The "manifest.csv" file and the "resources.csv" data file. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VCb002 | Single | Req | No | The "manifest.csv" file and the "courseResources.csv", "courses.csv", "resources.csv" and "orgs.csv" data files (four files for semantic consistency). The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VCb003 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VCb100 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VCb101 | Multiple | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). orgs with different types and parentSourcedId references, resources with different roles and each file has at least 10 records with cross references.
VCb102 | Multiple | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). classes with at least 1 different classType, a mix of class periods and subject and associated subjectCodes. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VCb103 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). academicSession of type schoolYear, courses with associated academicSession schoolYearSourcedId, grades of "05" The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VCb104 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). courses with subject and subject codes of "English/Language Arts II" and 01002. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VCb105 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). orgs with a parentSourcedId link and different type. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VCb106 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). resources with multiple types and levels of importance. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VCb107 | Single | Req | Yes | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). orgs with suggested metadata "metadata.classification" ,"metadata.gender", "metadata.boarding", "metadata.address1", "metadata.address2 , "metadata.city", "metadata.state", "metadata.postCode", "metadata.country". The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VCb108 | Single | Req | Yes | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). courses with suggested metadata "metadata.duration" The data files each contain a single record identified as 'bulk' transfers with only the required data objects.

top

#### Delta Processing

These files contain delta processing information only.

Table 5 Valid CSV test files for delta resource processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VCd001 | Single | Req | No | The "manifest.csv" file and the "resources.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VCd002 | Single | Req | No | The "manifest.csv" file and the "courseResources.csv", "courses.csv", courses.csv", "orgs.csv" and "academicSessions.csv" data files (five files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VCd100 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects. "classes.csv", "classResources.csv" excluded
VCd101 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects. A full set of delta files.
VCd102 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects. "courses.csv", "courseResources.csv" excluded
VCd103 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects. "classes.csv" excluded.
VCd104 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects. "courses.csv" excluded
VCd105 | Single | Req | No | The "manifest.csv" file and the "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects. "academicSessions.csv" excluded.
VCd106 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv" and "resources.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects. "orgs.csv" excluded.
VCd107 | Single | Req | No | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects. "orgs.csv" excluded.
VCd108 | Single | Req | Yes | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects. orgs with suggested metadata "metadata.classification" ,"metadata.gender", "metadata.boarding", "metadata.address1", "metadata.address2 , "metadata.city", "metadata.state", "metadata.postCode", "metadata.country" and courses with suggested metadata "metadata.duration"
VCd109 | Multiple | Req | Yes | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VCd110 | Single | Req | Yes | The "manifest.csv" file and the "academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "courseResources.csv", "resources.csv" and "orgs.csv" data files (six files for semantic consistency). The data files each contain a single record identified as 'delta' transfers with only the required data objects. courses with suggested metadata "metadata.duration" with different info.

top

#### Bulk and Delta Processing

These files contain bulk and delta processing information only.

Table 6 Valid CSV test files for bulk and delta resource processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VCm001 | ? | ? | ? | ...To be completed...

top

### 1.3 Gradebook Valid CSV File Test-Sets

The set of tests to be used for establishing the correct importing of gradebook information. All CSV importing systems must use these test files as part of conformance testing. Each set of files includes the "manifest.csv" file and one or more of the "academicSessions.csv", "classes.csv", "courses.csv", "demographics.csv", "enrollments.csv", "orgs.csv", "users.csv", "categories.csv", "results.csv" and "lineItems.csv" files.

#### Bulk Processing

These files contain bulk processing information only.

Table 7 Valid CSV test files for bulk gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VGb001 | Single | Req | No | The "manifest.csv" file and the "categories.csv" data file. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VGb002 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "academicSessions.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VGb003 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VGb100 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. Base set of all files needed for a full Gradebook delivery.
VGb101 | Single | Req | No | The "manifest.csv" file and the "orgs.csv", "results.csv" and "users.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VGb102 | Multiple | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.
VGb103 | Multiple | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. "academicSessions.csv" different types and parentSourcedId.
VGb104 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. "classes.csv" with grades for the class of 05, 06 and 07 for 3 of the classes. classType of homeroom and scheduled. subject and subjectCodes and periods added to several classes.
VGb105 | Multiple | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. "courses.csv" with grades of "05,06" and subject and subject codes of "course A, course B" and "01002,01003" and an "academicSessions.csv" cross reference
VGb106 | Single | Req | Yes | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. courses with suggested metadata "metadata.duration" with different info.
VGb107 | Single | Req | Yes | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects. orgs with suggested metadata "metadata.classification" ,"metadata.gender", "metadata.boarding", "metadata.address1", "metadata.address2 , "metadata.city", "metadata.state", "metadata.postCode", "metadata.country" and courses with suggested metadata "metadata.duration"
VGb108 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'bulk' transfers with only the required data objects.

top

#### Delta Processing

These files contain delta processing information only.

Table 8 Valid CSV test files for delta gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VGd001 | Single | Req | No | The "manifest.csv" file and the "categories.csv" data file. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VGd100 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VGd101 | Single | Req | No | The "manifest.csv" file and the "classes.csv", "courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VGd102 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VGd103 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VGd104 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", "courses.csv", "orgs.csv", "results.csv", "academicSessions.csv" and "users.csv" data files. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VGd105 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", "courses.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VGd106 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", "courses.csv", "orgs.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VGd107 | Single | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", "courses.csv", "orgs.csv", "results.csv", "academicSessions.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VGd108 | Multiple | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'delta' transfers with only the required data objects.
VGd109 | Multiple | Req | No | The "manifest.csv" file and the "categories.csv", "classes.csv", courses.csv", "orgs.csv", "results.csv", "academicSessions.csv", "users.csv" and "lineItems.csv" data files. The data files each contain a single record identified as 'delta' transfers with only the required data objects. "academicSessions.csv" with different types and parentSourcedId references. "classes.csv" with grades, classType, subject and subjectCodes and periods added in. "courses.csv" with grades, subject and subjectCodes added in. "orgs.csv" with different enumerated types and agentSourcedIds. "resulsts.csv" with enumerated types for scoreStatus. "user.csv" with enumerated types for roles, valid grades, password and a few records with full PII information.

top

#### Bulk and Delta Processing

These files contain bulk and delta processing information only.

Table 9 Valid CSV test files for bulk and delta gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VOm001 | ? | ? | ? | ...To be completed...

top

### 1.4 Mixed Rostering, Resources and Gradebook Valid CSV File Test-Sets

The set of tests to be used for establishing the correct importing of all CSV-based information. All CSV importing systems must use these test files as part of conformance testing. Each set of files includes the "manifest.csv" file and one or more of the "academicSessions.csv", "categories.csv", "classes.csv", "classResources.csv", "courseResources.csv", "courses.csv", "demographics.csv", "enrollments.csv", "linetems.csv", "orgs.csv", "resources.csv", "results.csv" and "users.csv" files.

#### Bulk Processing

These files contain bulk processing information only.

Table 10 Valid CSV test files for bulk rostering, resources and gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VXb001 | ? | ? | ? | ...To be completed...

top

#### Delta Processing

These files contain delta processing information only.

Table 11 Valid CSV test files for delta rostering, resources and gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VXd001 | ? | ? | ? | ...To be completed...

top

#### Bulk and Delta Processing

These files contain bulk and delta processing information only.

Table 12 Valid CSV test files for bulk and delta rostering, resources and gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
VXm001 | ? | ? | ? | ...To be completed...

top

## 2. Invalid CSV File Test-Sets

This is the set of test files that contains know errors. A system is required to detect that there are errors in the files and to indicate that it has detected the errors. The manner in which this notification is supplied will be implementation dependent. The subsequent processing of the file once the error(s) have been identified is also implementation dependent.

### 2.1 Rostering Invalid CSV File Test-Sets

The set of test files for CSV-based Rostering that contain known errors.

#### Bulk Processing

These files contain bulk processing information only.

Table 13 Invalid CSV test files for bulk rostering processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
IRb001 | - | - | - | This is a zip that contains only one file and this is an incorrectly named manifest file.
IRb002 | Single | Req | No | This zip file contains a single valid bulk processing data file (academicSessions.csv as per test VRb002) but the manifest file is missing.
IRb003 | Single | Req | No | This zip file contains a single valid bulk processing data file (orgs.csv as per test VRb003) but the manifest file is missing.
IRb004 | Single | Req | No | This zip file contains two valid bulk processing data file (orgs.csv and users.csv as per test VRb004) but the manifest file is missing.
IRb005 | Single | Req | No | This zip file contains teo valid bulk processing data file (orgs.csv and courses.csv as per test VRb005) but the manifest file is missing.
IRb006 | Single | Req | No | This zip file contains four valid bulk processing data file (academicSessions.csv, classes.csv, orgs.csv and courses.csv as per test VRb006) but the manifest file is missing.
IRb007 | Single | Req | No | This zip file contains three valid bulk processing data file (demographics.csv, users.cvs" and orgs.csv data files as per test VRb007) but the manifest file is missing.
IRb008 | Single | Req | No | This zip file contains six valid bulk processing data file (academicSessions.csv, classes.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv as per test VRb008) but the manifest file is missing.
Invalid Headers | Academic Sessions |  |  |
IRb100 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId Consistency Check : termSourcedId missing
IRb101 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid status Missing Header for CSV File: status
IRb102 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRb103 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid title Mandatory Header for CSV File is Missing: title Record #1 -> There is no value found for field: title
IRb104 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid type Mandatory Header for CSV File is Missing: type Record #1 -> There is no value found for field: type
IRb105 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid startDate Mandatory Header for CSV File is Missing: startDate Record #1 -> There is no value found for field: startDate
IRb106 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid endDate Mandatory Header for CSV File is Missing: endDate Record #1 -> There is no value found for field: endDate
IRb107 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid parentSourcedId Missing Header for CSV File: parentSourcedId
IRb108 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid schoolYear Mandatory Header for CSV File is Missing: schoolYear Record #1 -> There is no value found for field: schoolYear
Invalid Headers | Classes |  |  |
IRb109 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
IRb110 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid status Missing Header for CSV File: status
IRb111 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRb112 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid title Mandatory Header for CSV File is Missing: title Record #1 -> There is no value found for field: title
IRb113 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid grades Missing Header for CSV File: grades
IRb114 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid courseSourcedId Mandatory Header for CSV File is Missing: courseSourcedId Record #1 -> There is no value found for field: courseSourcedId Consistency Check : courseSourcedId missing
IRb115 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid classCode Missing Header for CSV File: classCode
IRb116 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid classType Mandatory Header for CSV File is Missing: classType Record #1 -> There is no value found for field: classType
IRb117 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid location Missing Header for CSV File: location
IRb118 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid schoolSourcedId Mandatory Header for CSV File is Missing: schoolSourcedId Record #1 -> There is no value found for field: schoolSourcedId Consistency Check : schoolSourcedId missing
IRb119 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid termSourcedIds Mandatory Header for CSV File is Missing: termSourcedIds Record #1 -> There is no value found for field: termSourcedIds Consistency Check : Exception validating Classes consistency. Invalid data
IRb120 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid subjects Missing Header for CSV File: subjects
IRb121 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid subjectCodes Missing Header for CSV File: subjectCodes
IRb122 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid periods Missing Header for CSV File: periods
Invalid Headers | Courses |  |  |
IRb123 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
IRb124 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid status Missing Header for CSV File: status
IRb125 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRb126 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid schoolYearSourcedId Missing Header for CSV File: schoolYearSourcedId
IRb127 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid title Mandatory Header for CSV File is Missing: title Record #1 -> There is no value found for field: title
IRb128 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid courseCode Missing Header for CSV File: courseCode
IRb129 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid grades Missing Header for CSV File: grades
IRb130 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid orgSourcedId Mandatory Header for CSV File is Missing: orgSourcedId Record #1 -> There is no value found for field: orgSourcedId Consistency Check : orgSourcedId missing
IRb131 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid subjects Missing Header for CSV File: subjects
IRb132 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid subjectCodes Missing Header for CSV File: subjectCodes
Invalid Headers | demographics |  |  |
IRb133 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId Consistency Check : sourcedId missing
IRb134 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid status Missing Header for CSV File: status
IRb135 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRb136 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid birthDate Missing Header for CSV File: birthDate
IRb137 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid sex Missing Header for CSV File: sex
IRb138 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid americanIndianOrAlaskaNative Missing Header for CSV File: americanIndianOrAlaskaNative
IRb139 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid asian Missing Header for CSV File: asian
IRb140 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid blackOrAfricanAmerican Missing Header for CSV File: blackOrAfricanAmerican
IRb141 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid nativeHawaiianOrOtherPacificIslander Missing Header for CSV File: nativeHawaiianOrOtherPacificIslander
IRb142 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid white Missing Header for CSV File: white
IRb143 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid demographicRaceTwoOrMoreRaces Missing Header for CSV File: demographicRaceTwoOrMoreRaces
IRb144 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid hispanicOrLatinoEthnicity Missing Header for CSV File: hispanicOrLatinoEthnicity
IRb145 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid countryOfBirthCode Missing Header for CSV File: countryOfBirthCode
IRb146 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid stateOfBirthAbbreviation Missing Header for CSV File: stateOfBirthAbbreviation
IRb147 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid cityOfBirth Missing Header for CSV File: cityOfBirth
IRb148 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid publicSchoolResidenceStatus Missing Header for CSV File: publicSchoolResidenceStatus
Invalid Headers | enrollments |  |  |
IRb149 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
IRb150 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid status Missing Header for CSV File: status
IRb151 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRb152 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid classSourcedId Mandatory Header for CSV File is Missing: classSourcedId Record #1 -> There is no value found for field: classSourcedId Consistency Check : classSourcedId missing
IRb153 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid schoolSourcedId Mandatory Header for CSV File is Missing: schoolSourcedId Record #1 -> There is no value found for field: schoolSourcedId Consistency Check : schoolSourcedId missing
IRb154 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid userSourcedId Mandatory Header for CSV File is Missing: userSourcedId Record #1 -> There is no value found for field: userSourcedId Consistency Check : userSourcedId missing
IRb155 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid role Mandatory Header for CSV File is Missing: role Record #1 -> There is no value found for field: role
IRb156 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid primary Missing Header for CSV File: primary
IRb157 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid beginDate Missing Header for CSV File: beginDate
IRb158 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid endDate Missing Header for CSV File: endDate
Invalid Headers | orgs |  |  |
IRb159 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId - users - Invalid orgSourcedIds Consistency Check : User orgSourcedIds not found - courses - Invalid orgSourcedId Consistency Check : orgSourcedId missing - classes - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing - enrollments - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing
IRb160 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid status Missing Header for CSV File: status
IRb161 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRb162 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid name Mandatory Header for CSV File is Missing: name Record #1 -> There is no value found for field: name
IRb163 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid type Mandatory Header for CSV File is Missing: type Record #1 -> There is no value found for field: type
IRb164 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid identifier Missing Header for CSV File: identifier
IRb165 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid parentSourcedId Missing Header for CSV File: parentSourcedId
Invalid Headers | users |  |  |
IRb166 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId - demographics - Invalid sourcedId Consistency Check : sourcedId missing - enrollments - Invalid userSourcedId Consistency Check : userSourcedId missing
IRb167 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid status Missing Header for CSV File: status
IRb168 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRb169 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid enabledUser Mandatory Header for CSV File is Missing: enabledUser Record #1 -> There is no value found for field: enabledUser
IRb170 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid orgSourcedIds Mandatory Header for CSV File is Missing: orgSourcedIds Record #1 -> There is no value found for field: orgSourcedIds
IRb171 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid role Mandatory Header for CSV File is Missing: role Record #1 -> There is no value found for field: role
IRb172 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid username Mandatory Header for CSV File is Missing: username Record #1 -> There is no value found for field: username
IRb173 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid userIds Missing Header for CSV File: userIds
IRb174 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid givenName Mandatory Header for CSV File is Missing: givenName Record #1 -> There is no value found for field: givenName
IRb175 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid familyName Mandatory Header for CSV File is Missing: familyName Record #1 -> There is no value found for field: familyName
IRb176 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid middleName Missing Header for CSV File: middleName
IRb177 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid identifier Missing Header for CSV File: identifier
IRb178 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid email Missing Header for CSV File: email
IRb179 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid sms Missing Header for CSV File: sms
IRb180 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid phone Missing Header for CSV File: phone
IRb181 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid agentSourcedIds Missing Header for CSV File: agentSourcedIds
IRb182 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid grades Missing Header for CSV File: grades
IRb183 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid password Missing Header for CSV File: password
Invalid Data | Academic Sessions |  |  |
IRb200 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - classes - Invalid termSourcedIds Consistency Check : termSourcedId missing
IRb201 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid status Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: status
IRb202 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid dateLastModified Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: dateLastModified
IRb203 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid title Record #1 -> There is no value found for field: title
IRb204 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid type Record #1 -> There is an invalid value found for field: type : value found: enumeration
IRb205 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid startDate Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: startDate : value found: 2016-01 Record #1 -> Date Parsing Exception: Unparseable date: "2016-01"
IRb206 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid endDate Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: endDate : value found: 2016-07 Record #1 -> Date Parsing Exception: Unparseable date: "2016-07"
IRb207 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid parentSourcedId Consistency Check : Academic Sessions parentSourcedId Not Found
IRb208 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid schoolYear Record #1 -> There is no value found for field: schoolYear
Invalid Data | Classes |  |  |
IRb209 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId
IRb210 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid status Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: status
IRb211 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid dateLastModified Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: dateLastModified
IRb212 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid title Record #1 -> There is no value found for field: title
IRb213 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - "grades" conformant. grade values not validated.
IRb214 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid courseSourcedId Record #1 -> There is no value found for field: courseSourcedId Consistency Check : courseSourcedId missing
IRb215 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid courseSourcedId Consistency Check : courseSourcedId missing
IRb216 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid classType Record #1 -> There is no value found for field: classType
IRb217 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid classType Record #1 -> There is an invalid value found for field: classType : value found: enumeration
IRb218 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid schoolSourcedId Record #1 -> There is no value found for field: schoolSourcedId Consistency Check : schoolSourcedId missing
IRb218a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing
IRb219 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid termSourcedIds Record #1 -> There is no value found for field: termSourcedIds Consistency Check : termSourcedId missing
IRb219 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid termSourcedIds Consistency Check : termSourcedId missing
Invalid Data | Courses |  |  |
IRb223 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - classes - Invalid courseSourcedId Consistency Check : courseSourcedId missing
IRb224 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid status Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: status
IRb225 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid dateLastModified Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: dateLastModified
IRb226 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid schoolYearSourcedId Consistency Check : schoolYearSourcedId missing
IRb227 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid title Record #1 -> There is no value found for field: title
IRb229 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - "grades" column conformant as they are not validated at this time.
IRb230 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid orgSourcedId Record #1 -> There is no value found for field: orgSourcedId Consistency Check : orgSourcedId missing
IRb231 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid orgSourcedId Consistency Check : orgSourcedId missing
Invalid Data | demographics |  |  |
IRb233 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId Consistency Check : sourcedId missing
IRb234 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid status Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: status
IRb235 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid dateLastModified Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: dateLastModified
IRb246 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid stateOfBirthAbbreviation Record #1 -> There is an invalid value found for field: stateOfBirthAbbreviation : value found: JJJ
Invalid Data | enrollments |  |  |
IRb249 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId
IRb250 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid status Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: status
IRb251 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid dateLastModified Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: dateLastModified
IRb252 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid classSourcedId Record #1 -> There is no value found for field: classSourcedId Consistency Check : classSourcedId missing
IRb252a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid classSourcedId Consistency Check : classSourcedId missing
IRb253 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid schoolSourcedId Record #1 -> There is no value found for field: schoolSourcedId Consistency Check : schoolSourcedId missing
IRb253a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing
IRb254 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid userSourcedId Record #1 -> There is no value found for field: userSourcedId Consistency Check : userSourcedId missing
IRb254a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid userSourcedId Consistency Check : userSourcedId missing
IRb255 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid role Record #1 -> There is no value found for field: role
IRb255a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid role Record #1 -> There is an invalid value found for field: role : value found: enumeration
IRb256 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid primary Record #1 -> There is an invalid value found for field: primary : value found: boolean. Value required: 'true' or 'false'
IRb257 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid beginDate Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: beginDate : value found: 2017-01 Record #1 -> Date Parsing Exception: Unparseable date: "2017-01"
IRb258 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid endDate Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: endDate : value found: 2017-01 Record #1 -> Date Parsing Exception: Unparseable date: "2017-01"
Invalid Data | orgs |  |  |
IRb259 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - users - Invalid orgSourcedIds Consistency Check : User orgSourcedIds not found - courses - Invalid orgSourcedId Consistency Check : orgSourcedId missing - classes - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing - enrollments - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing
IRb260 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid status Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: status
IRb261 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid dateLastModified Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: dateLastModified
IRb262 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid name Record #1 -> There is no value found for field: name
IRb263 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid type Record #1 -> There is an invalid value found for field: type : value found: enumeration
IRb264 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid parentSourcedId Consistency Check : parentSourcedId for sourcedId Not Found
Invalid Data | users |  |  |
IRb266 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - demographics - Invalid sourcedId Consistency Check : sourcedId missing - enrollments - Invalid userSourcedId Consistency Check : userSourcedId missing
IRb267 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid status Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: status
IRb268 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid dateLastModified Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: dateLastModified
IRb269 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid enabledUser Record #1 -> There is no value found for field: enabledUser
IRb270 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid orgSourcedIds Record #1 -> There is no value found for field: orgSourcedIds
IRb271 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid role Record #1 -> There is no value found for field: role
IRb272 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid username Record #1 -> There is no value found for field: username
IRb273 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid orgSourcedIds Consistency Check : User orgSourcedIds not found
IRb274 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid givenName Record #1 -> There is no value found for field: givenName
IRb275 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid familyName Record #1 -> There is no value found for field: familyName
IRb281 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid agentSourcedIds Consistency Check : User agentSourcedIds Not Found
IRb282 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid "grades" column data

top

#### Delta Processing

These files contain delta processing information only.

Table 14 Invalid CSV test files for delta rostering processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
IRd002 | Single | Req | No | This zip file contains a single valid delta processing data file (academicSessions.csv as per test VRd002).
IRd003 | Single | Req | No | This zip file contains a single valid delta processing data file (orgs.csv as per test VRd003).
IRd004 | Single | Req | No | This zip file contains two valid delta processing data files (orgs.csv and users.csv as per test VRd004).
IRd005 | Single | Req | No | This zip file contains two valid bulk processing data file (orgs.csv and courses.csv as per test VRd005).
IRd006 | Single | Req | No | This zip file contains four valid bulk processing data file (academicSessions.csv, classes.csv, orgs.csv and courses.csv as per test VRd006).
IRd007 | Single | Req | No | This zip file contains three valid delta processing data file (demographics.csv, users.cvs" and orgs.csv data files as per test VRd007).
IRd008 | Single | Req | No | This zip file contains six valid delta processing data file (academicSessions.csv, classes.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv as per test VRb008).
Invalid Headers | Academic Sessions |  |  |
IRd100 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
IRd101 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid status Missing Header for CSV File: status
IRd102 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRd103 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid itle Mandatory Header for CSV File is Missing: title Record #1 -> There is no value found for field: title
IRd104 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid type Mandatory Header for CSV File is Missing: type Record #1 -> There is no value found for field: type
IRd105 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid startDate Mandatory Header for CSV File is Missing: startDate Record #1 -> There is no value found for field: startDate
IRd106 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid endDate Mandatory Header for CSV File is Missing: endDate Record #1 -> There is no value found for field: endDate
IRd107 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid parentSourcedId Missing Header for CSV File: parentSourcedId
IRd108 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid schoolYear Mandatory Header for CSV File is Missing: schoolYear Record #1 -> There is no value found for field: schoolYear
Invalid Headers | Classes |  |  |
IRd109 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId - enrollments - Invalid classSourcedId Consistency Check : classSourcedId missing
IRd110 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid status Missing Header for CSV File: status
IRd111 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRd112 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid title Mandatory Header for CSV File is Missing: title Record #1 -> There is no value found for field: title
IRd113 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid grades Missing Header for CSV File: grades
IRd114 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid courseSourcedId Mandatory Header for CSV File is Missing: courseSourcedId Record #1 -> There is no value found for field: courseSourcedId Consistency Check : courseSourcedId missing
IRd115 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid classCode Missing Header for CSV File: classCode
IRd116 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid classType Mandatory Header for CSV File is Missing: classType Record #1 -> There is no value found for field: classType
IRd117 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid location Missing Header for CSV File: location
IRd118 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid schoolSourcedId Mandatory Header for CSV File is Missing: schoolSourcedId Record #1 -> There is no value found for field: schoolSourcedId Consistency Check : schoolSourcedId missing
IRd119 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid ermSourcedIds Mandatory Header for CSV File is Missing: termSourcedIds Record #1 -> There is no value found for field: termSourcedIds Consistency Check : Exception validating Classes consistency. Invalid data
IRd120 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid subjects Missing Header for CSV File: subjects
IRd121 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid subjectCodes Missing Header for CSV File: subjectCodes
IRd122 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid periods Missing Header for CSV File: periods
Invalid Headers | Courses |  |  |
IRd123 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId - classes - Invalid courseSourcedId Consistency Check : courseSourcedId missing
IRd124 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid status Missing Header for CSV File: status
IRd125 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRd126 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid schoolYearSourcedId Missing Header for CSV File: schoolYearSourcedId
IRd127 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid title Mandatory Header for CSV File is Missing: title Record #1 -> There is no value found for field: title
IRd128 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid courseCode Missing Header for CSV File: courseCode
IRd129 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid grades Missing Header for CSV File: grades
IRd130 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid orgSourcedId Mandatory Header for CSV File is Missing: orgSourcedId Record #1 -> There is no value found for field: orgSourcedId Consistency Check : orgSourcedId missing
IRd131 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid subjects Missing Header for CSV File: subjects
IRd132 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid subjectCodes Missing Header for CSV File: subjectCodes
Invalid Headers | demographics |  |  |
IRd133 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId Consistency Check : sourcedId missing
IRd134 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid status Missing Header for CSV File: status
IRd135 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRd136 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid birthDate Missing Header for CSV File: birthDate
IRd137 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid sex Missing Header for CSV File: sex
IRd138 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid americanIndianOrAlaskaNative Missing Header for CSV File: americanIndianOrAlaskaNative
IRd139 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid asian Missing Header for CSV File: asian
IRd140 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid blackOrAfricanAmerican Missing Header for CSV File: blackOrAfricanAmerican
IRd141 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid nativeHawaiianOrOtherPacificIslander Missing Header for CSV File: nativeHawaiianOrOtherPacificIslander
IRd142 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - white Missing Header for CSV File: white
IRd143 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid demographicRaceTwoOrMoreRaces Missing Header for CSV File: demographicRaceTwoOrMoreRaces
IRd144 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid hispanicOrLatinoEthnicity Missing Header for CSV File: hispanicOrLatinoEthnicity
IRd145 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid countryOfBirthCode Missing Header for CSV File: countryOfBirthCode
IRd146 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid stateOfBirthAbbreviation Missing Header for CSV File: stateOfBirthAbbreviation
IRd147 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid cityOfBirth Missing Header for CSV File: cityOfBirth
IRd148 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid publicSchoolResidenceStatus Missing Header for CSV File: publicSchoolResidenceStatus
Invalid Headers | enrollments |  |  |
IRd149 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
IRd150 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid status Missing Header for CSV File: status
IRd151 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRd152 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid classSourcedId Mandatory Header for CSV File is Missing: classSourcedId Record #1 -> There is no value found for field: classSourcedId Consistency Check : classSourcedId missing
IRd153 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid schoolSourcedId Mandatory Header for CSV File is Missing: schoolSourcedId Record #1 -> There is no value found for field: schoolSourcedId Consistency Check : schoolSourcedId missing
IRd154 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid userSourcedId Mandatory Header for CSV File is Missing: userSourcedId Record #1 -> There is no value found for field: userSourcedId Consistency Check : userSourcedId missing
IRd155 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid role Mandatory Header for CSV File is Missing: role Record #1 -> There is no value found for field: role
IRd156 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid primary Missing Header for CSV File: primary
IRd157 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid beginDate Missing Header for CSV File: beginDate
IRd158 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid endDate Missing Header for CSV File: endDate
Invalid Headers | orgs |  |  |
IRd159 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId - users - Invalid orgSourcedIds Consistency Check : User orgSourcedIds not found - courses - Invalid orgSourcedId Consistency Check : orgSourcedId missing - classes - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing - enrollments - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing
IRd160 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid status Missing Header for CSV File: status
IRd161 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRd162 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid name Mandatory Header for CSV File is Missing: name Record #1 -> There is no value found for field: name
IRd163 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid type Mandatory Header for CSV File is Missing: type Record #1 -> There is no value found for field: type
IRd164 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid identifier Missing Header for CSV File: identifier
IRd165 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid parentSourcedId Missing Header for CSV File: parentSourcedId
Invalid Headers | users |  |  |
IRd166 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId - demographics - Invalid sourcedId Consistency Check : sourcedId missing - enrollments - Invalid userSourcedId Consistency Check : userSourcedId missing
IRd167 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid status Missing Header for CSV File: status
IRd168 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IRd169 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid enabledUser Mandatory Header for CSV File is Missing: enabledUser Record #1 -> There is no value found for field: enabledUser
IRd170 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid orgSourcedIds Mandatory Header for CSV File is Missing: orgSourcedIds Record #1 -> There is no value found for field: orgSourcedIds
IRd171 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid role Mandatory Header for CSV File is Missing: role Record #1 -> There is no value found for field: role
IRd172 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid username Mandatory Header for CSV File is Missing: username Record #1 -> There is no value found for field: username
IRd173 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid userIds Missing Header for CSV File: userIds
IRd174 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid givenName Mandatory Header for CSV File is Missing: givenName Record #1 -> There is no value found for field: givenName
IRd175 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid familyName Mandatory Header for CSV File is Missing: familyName Record #1 -> There is no value found for field: familyName
IRd176 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid middleName Missing Header for CSV File: middleName
IRd177 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid identifier Missing Header for CSV File: identifier
IRd178 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid email Missing Header for CSV File: email
IRd179 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid sms Missing Header for CSV File: sms
IRd180 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid phone Missing Header for CSV File: phone
IRd181 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid agentSourcedIds Missing Header for CSV File: agentSourcedIds
IRd182 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid grades Missing Header for CSV File: grades
IRd183 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid password Missing Header for CSV File: password
Invalid Data | Academic Sessions |  |  |
IRd200 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - classes - Invalid termSourcedIds Consistency Check : termSourcedId missing
IRd201 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid status Record #1 -> There is an invalid value found for field: status : value found: boolean
IRd202 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid dateLastModified Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dateLastModified : value found: 2016-04 Record #1 -> Date Parsing Exception: Unparseable date: "2016-04"
IRd203 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid title Record #1 -> There is no value found for field: title
IRd204 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid type Record #1 -> There is an invalid value found for field: type : value found: enumeration
IRd205 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid startDate Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: startDate : value found: 2016-01 Record #1 -> Date Parsing Exception: Unparseable date: "2016-01"
IRd206 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid endDate Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: endDate : value found: 2016-07 Record #1 -> Date Parsing Exception: Unparseable date: "2016-07"
IRd207 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid parentSourcedId Consistency Check : Academic Sessions parentSourcedId Not Found
IRd208 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - academicSessions - Invalid schoolYear Record #1 -> There is no value found for field: schoolYear
Invalid Data | Classes |  |  |
IRd209 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - enrollments - Invalid classSourcedId Consistency Check : classSourcedId missing
IRd210 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid status Record #1 -> There is an invalid value found for field: status : value found: boolean
IRd211 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid dateLastModified Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dateLastModified : value found: 2016-04 Record #1 -> Date Parsing Exception: Unparseable date: "2016-04"
IRd212 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid title Record #1 -> There is no value found for field: title
IRd214 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid courseSourcedId Record #1 -> There is no value found for field: courseSourcedId Consistency Check : courseSourcedId missing
IRd214a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid courseSourcedId Consistency Check : courseSourcedId missing
IRd216 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid classType Record #1 -> There is an invalid value found for field: classType : value found: enumeration
IRd218 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid schoolSourcedId Record #1 -> There is no value found for field: schoolSourcedId Consistency Check : schoolSourcedId missing
IRd218a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing
IRd219 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid termSourcedIds Record #1 -> There is no value found for field: termSourcedIds Consistency Check : termSourcedId missing
IRd219a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - classes - Invalid termSourcedIds Consistency Check : termSourcedId missing
Invalid Data | Courses |  |  |
IRd223 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - classes - Invalid courseSourcedId Consistency Check : courseSourcedId missing
IRd224 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid status Record #1 -> There is an invalid value found for field: status : value found: boolean
IRd225 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid dateLastModified Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dateLastModified : value found: 2016-04 Record #1 -> Date Parsing Exception: Unparseable date: "2016-04"
IRd226 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid schoolYearSourcedId Consistency Check : schoolYearSourcedId missing
IRd227 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid title Record #1 -> There is no value found for field: title
IRd230 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid orgSourcedId Record #1 -> There is no value found for field: orgSourcedId Consistency Check : orgSourcedId missing
IRd230a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - courses - Invalid orgSourcedId Consistency Check : orgSourcedId missing
Invalid Data | demographics |  |  |
IRd233 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid sourcedId Consistency Check : sourcedId missing - academicSessions - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - classes - Invalid termSourcedIds Consistency Check : termSourcedId missing
IRd234 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid status Record #1 -> There is an invalid value found for field: status : value found: boolean
IRd235 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid dateLastModified Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dateLastModified : value found: 2016-04- Record #1 -> Date Parsing Exception: Unparseable date: "2016-04-"
IRd246 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - demographics - Invalid stateOfBirthAbbreviation Record #1 -> There is an invalid value found for field: stateOfBirthAbbreviation : value found: JJJ
Invalid Data | enrollments |  |  |
IRd249 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
IRd250 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid status Record #1 -> There is an invalid value found for field: status : value found: boolean
IRd251 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid dateLastModified Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dateLastModified : value found: 2016-04 Record #1 -> Date Parsing Exception: Unparseable date: "2016-04"
IRd252 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid classSourcedId Record #1 -> There is no value found for field: classSourcedId Consistency Check : classSourcedId missing
IRd252a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid classSourcedId Consistency Check : classSourcedId missing
IRd253 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid schoolSourcedId Record #1 -> There is no value found for field: schoolSourcedId Consistency Check : schoolSourcedId missing
IRd253a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing
IRd254 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid userSourcedId Record #1 -> There is no value found for field: userSourcedId Consistency Check : userSourcedId missing
IRd254a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid userSourcedId Consistency Check : userSourcedId missing
IRd255 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid role Record #1 -> There is no value found for field: role
IRd255a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid role Record #1 -> There is an invalid value found for field: role : value found: enumeration
IRd256 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid primary Record #1 -> There is an invalid value found for field: primary : value found: boolean. Value required: 'true' or 'false'
IRd257 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid beginDate Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: beginDate : value found: 2017-01 Record #1 -> Date Parsing Exception: Unparseable date: "2017-01"
IRd258 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - enrollments - Invalid endDate Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: endDate : value found: 2017-01 Record #1 -> Date Parsing Exception: Unparseable date: "2017-01"
Invalid Data | orgs |  |  |
IRd259 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - users - Invalid orgSourcedIds Consistency Check : User orgSourcedIds not found - courses - Invalid orgSourcedId Consistency Check : orgSourcedId missing - classes - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing - enrollments - Invalid schoolSourcedId Consistency Check : schoolSourcedId missing
IRd260 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid status Record #1 -> There is an invalid value found for field: status : value found: boolean
IRd261 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid dateLastModified Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dateLastModified : value found: 2016-04 Record #1 -> Date Parsing Exception: Unparseable date: "2016-04"
IRd262 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid name Record #1 -> There is no value found for field: name
IRd263 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid type Record #1 -> There is an invalid value found for field: type : value found: enumeration
IRd265 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - orgs - Invalid parentSourcedId Consistency Check : parentSourcedId for sourcedId Not Found
Invalid Data | users |  |  |
IRd266 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - demographics - Invalid sourcedId Consistency Check : sourcedId missing - enrollments - Invalid userSourcedId Consistency Check : userSourcedId missing
IRd267 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid status Record #1 -> The file is being processed as BULK. As a result, there should be no value for the following field: status
IRd268 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid dateLastModified Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dateLastModified : value found: 2016-04 Record #1 -> Date Parsing Exception: Unparseable date: "2016-04"
IRd269 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid enabledUser Record #1 -> There is no value found for field: enabledUser
IRd269a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid enabledUser Record #1 -> There is no value found for field: enabledUser
IRd270 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid orgSourcedIds Record #1 -> There is no value found for field: orgSourcedIds
IRd270a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid orgSourcedIds Consistency Check : User orgSourcedIds not found
IRd271 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid role Record #1 -> There is no value found for field: role
IRd271a | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid role Record #1 -> There is no value found for field: role
IRd272 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid username Record #1 -> There is no value found for field: username
IRd274 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid givenName Record #1 -> There is no value found for field: givenName
IRd275 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid familyName Record #1 -> There is no value found for field: familyName
IRd281 | Single | Req | No | This zip file contains delta processing data (academicSessions.csv, classes.csv, demographics.csv, enrollments.csv, orgs.csv, users.cvs and courses.csv). - users - Invalid agentSourcedIds Consistency Check : User agentSourcedIds Not Found

top

#### Bulk and Delta Processing

These files contain bulk and delta processing information only.

Table 15 Invalid CSV test files for bulk and delta rostering processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
IRm001 | ? | ? | ? | ...To be completed...

top

### 2.2 Resources Invalid CSV File Test-Sets

The set of test files for CSV-based Resources that contain known errors.

#### Bulk Processing

These files contain bulk processing information only.

Table 16 Invalid CSV test files for bulk resource processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
ICb001 | Single | Req | No | This zip file contains a single valid bulk data file (resources.csv as per test VCb001) but the manifest file is missing.
ICb002 | Single | Req | No | This zip file contains a single valid bulk data files ("courseResources.csv", "courses.csv", "resources.csv" and "orgs.csv as per text VCb002) but the manifest file is missing.
ICb003 | Single | Req | No | This zip file contains a single valid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv"as per VCB003) but the manifest file is missing.
Invalid Headers | classResources |  |  |
ICb123 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - classResources - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
ICb124 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - classResources - Invalid status Missing Header for CSV File: status
ICb125 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - classResources - Invalid dateLastModified Missing Header for CSV File: dateLastModified
ICb126 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - classResources - Invalid title Missing Header for CSV File: title
ICb127 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - classResources - Invalid classSourcedId Mandatory Header for CSV File is Missing: classSourcedId Record #1 -> There is no value found for field: classSourcedId Consistency Check : classSourcedId missing
ICb128 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - classResources - Invalid resourceSourcedId Mandatory Header for CSV File is Missing: resourceSourcedId Record #1 -> There is no value found for field: resourceSourcedId Consistency Check : resourceSourcedId missing
Invalid Headers | courseResources |  |  |
ICb129 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - courseResources - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
ICb130 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - courseResources - Invalid status Mandatory Header for CSV File is Missing: status
ICb131 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - courseResources - Invalid dateLastModified Mandatory Header for CSV File is Missing: dateLastModified
ICb132 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - courseResources - Invalid title Mandatory Header for CSV File is Missing: title
ICb133 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - courseResources - courseSourcedId Mandatory Header for CSV File is Missing: courseSourcedId Record #1 -> There is no value found for field: courseSourcedId Consistency Check : courseSourcedId missing
ICb134 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - courseResources - Invalid resourceSourcedId Mandatory Header for CSV File is Missing: resourceSourcedId Record #1 -> There is no value found for field: resourceSourcedId Consistency Check : resourceSourcedId missing
Invalid Headers | resources |  |  |
ICb152 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - resources - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
ICb153 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - resources - Invalid status Missing Header for CSV File: status
ICb154 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - resources - Invalid dateLastModified Missing Header for CSV File: dateLastModified
ICb155 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - resources - Invalid vendorResourceId Mandatory Header for CSV File is Missing: vendorResourceId Record #1 -> There is no value found for field: vendorResourceId
ICb156 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - resources - Invalid title Missing Header for CSV File: title
ICb157 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - resources - Invalid roles Missing Header for CSV File: roles
ICb158 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - resources - Invalid importance Missing Header for CSV File: importance
ICb159 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - resources - Invalid vendorId Missing Header for CSV File: vendorId
ICb160 | Single | Req | No | This zip file contains a single invalid bulk data files ("academicSessions.csv", "classes.csv", "classResources.csv", "courses.csv", "resources.csv" and "orgs.csv") - resources - Invalid applicationId Missing Header for CSV File: applicationId

top

#### Delta Processing

These files contain delta processing information only.

Table 17 Invalid CSV test files for delta resource processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
ICd001 | Single | Req | No | This zip file contains a single valid delta data file (resources.csv as per test VCd001) but the manifest file is missing.
ICd002 | Single | Req | No | This zip file contains a single valid delta data files ("courseResources.csv", "courses.csv", "resources.csv" and "orgs.csv as per text VCd002) but the manifest file is missing

top

#### Bulk and Delta Processing

These files contain bulk and delta processing information only.

Table 18 Invalid CSV test files for bulk and delta resource processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
ICm001 | ? | ? | ? | ...To be completed...

top

### 2.3 Gradebook Invalid CSV File Test-Sets

The set of test files for CSV-based Gradebook that contain known errors.

#### Bulk Processing

These files contain bulk processing information only.

Table 19 Invalid CSV test files for bulk gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
IGb001 | Single | Req | No | This zip file contains a single valid bulk data file (categories.csv) as per test VGb001 but the manifest file is missing.
IGb002 | Single | Req | No | This zip file contains six valid bulk data files ("categories.csv", "classes.csv", courses.csv", "orgs.csv", "academicSessions.csv" and "lineItems.csv") - as per test VGb002 but the manifest file is missing.
IGb003 | Single | Req | No | This zip file contains eight valid bulk data files ("categories.csv", "classes.csv", courses.csv", "orgs.csv", "academicSessions.csv", "results.org", "users.csv" and "lineItems.csv") - as per test VGb003 .
Invalid Headers | categories |  |  |
IGb108a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - categories - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
IGb108b | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - categories - Invalid status Missing Header for CSV File: status
IGb108c | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - categories - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IGb108d | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - categories - Invalid title Mandatory Header for CSV File is Missing: title Record #1 -> There is no value found for field: title
Invalid Headers | lineItems |  |  |
IGb133 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId - results - Invalid lineItemSourcedId Consistency Check : lineItemSourcedId missing
IGb134 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid status Missing Header for CSV File: status
IGb135 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IGb136 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid title Mandatory Header for CSV File is Missing: title Record #1 -> There is no value found for field: title
IGb137 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid description Missing Header for CSV File: description
IGb138 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid assignDate Mandatory Header for CSV File is Missing: assignDate Record #1 -> There is no value found for field: assignDate
IGb139 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid dueDate Mandatory Header for CSV File is Missing: dueDate Record #1 -> There is no value found for field: dueDate
IGb140 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid classSourcedId Mandatory Header for CSV File is Missing: classSourcedId Record #1 -> There is no value found for field: classSourcedId Consistency Check : classSourcedId missing
IGb141 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid categorySourcedId Mandatory Header for CSV File is Missing: categorySourcedId Record #1 -> There is no value found for field: categorySourcedId Consistency Check : categorySourcedId missing
IGb142 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid gradingPeriodSourcedId Mandatory Header for CSV File is Missing: gradingPeriodSourcedId Record #1 -> There is no value found for field: gradingPeriodSourcedId Consistency Check : gradingPeriodSourcedId missing
IGb143 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid resultValueMin Mandatory Header for CSV File is Missing: resultValueMin Record #1 -> There is no value found for field: resultValueMin
IGb144 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid resultValueMax Mandatory Header for CSV File is Missing: resultValueMax Record #1 -> There is no value found for field: resultValueMax
Invalid Headers | results |  |  |
IGb165a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid sourcedId Mandatory Header for CSV File is Missing: sourcedId Record #1 -> There is no value found for field: sourcedId
IGb165b | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid status Missing Header for CSV File: status
IGb165c | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid dateLastModified Missing Header for CSV File: dateLastModified
IGb165d | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid lineItemSourcedId Mandatory Header for CSV File is Missing: lineItemSourcedId Record #1 -> There is no value found for field: lineItemSourcedId Consistency Check : lineItemSourcedId missing
IGb165e | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid studentSourcedId Mandatory Header for CSV File is Missing: studentSourcedId Record #1 -> There is no value found for field: studentSourcedId Consistency Check : UID studentSourcedId missing
IGb165f | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid scoreStatus Mandatory Header for CSV File is Missing: scoreStatus Record #1 -> There is no value found for field: scoreStatus
IGb165g | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid score Mandatory Header for CSV File is Missing: score Record #1 -> There is no value found for field: score
IGb165h | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid scoreDate Mandatory Header for CSV File is Missing: scoreDate Record #1 -> There is no value found for field: scoreDate
IGb165i | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid comment Missing Header for CSV File: comment
Invalid Data | categories |  |  |
IGd209 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - categories - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId
IGd210 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - categories - Invalid status Record #1 -> There is an invalid value found for field: status : value found: boolean
IGd211 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - categories - Invalid dateLastModified Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dateLastModified : value found: 2015-12-0 Record #1 -> Date Parsing Exception: Unparseable date: "2015-12-0"
IGd212 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - categories - Invalid title Record #1 -> There is no value found for field: title
Invalid Data | lineItems |  |  |
IGd236 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId - results - Invalid lineItemSourcedId Consistency Check : lineItemSourcedId missing
IGd237 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid status Record #1 -> There is an invalid value found for field: status : value found: boolean
IGd238 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid dateLastModified Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dateLastModified : value found: 2015-12-0 Record #1 -> Date Parsing Exception: Unparseable date: "2015-12-0"
IGd239 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid title Record #1 -> There is no value found for field: title
IGd241 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid assignDate Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: assignDate : value found: 2016-03 Record #1 -> Date Parsing Exception: Unparseable date: "2016-03"
IGd242 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - InvaliddueDate Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dueDate : value found: 2016-03 Record #1 -> Date Parsing Exception: Unparseable date: "2016-03"
IGd243 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid classSourcedId Record #1 -> There is no value found for field: classSourcedId Consistency Check : classSourcedId missing
IGd243a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid classSourcedId Consistency Check : classSourcedId missing
IGd244 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid categorySourcedId Record #1 -> There is no value found for field: categorySourcedId Consistency Check : categorySourcedId missing
IGd244a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid categorySourcedId Consistency Check : categorySourcedId missing
IGd245 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid gradingPeriodSourcedId Record #1 -> There is no value found for field: gradingPeriodSourcedId Consistency Check : gradingPeriodSourcedId missing
IGd245a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid gradingPeriodSourcedId Consistency Check : gradingPeriodSourcedId missing
IGd246 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid resultValueMin Record #1 -> There is no value found for field: resultValueMin
IGd247 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - lineItems - Invalid resultValueMax Record #1 -> There is no value found for field: resultValueMax
Invalid Data | results |  |  |
IGd255 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid sourcedId Record #1 -> There is no value found for field: sourcedId
IGd256 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid status Record #1 -> There is an invalid value found for field: status : value found: boolean
IGd257 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid dateLastModified Record #1 -> Date Format Error: The value found was not in the required YYYY-MM-DD format (or has an out of bounds value for one or more of the date format values) for type: dateLastModified : value found: 2015-12-0 Record #1 -> Date Parsing Exception: Unparseable date: "2015-12-0"
IGd258 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid lineItemSourcedId Record #1 -> There is no value found for field: lineItemSourcedId Consistency Check : lineItemSourcedId missing
IGd258a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid lineItemSourcedId Consistency Check : lineItemSourcedId missing
IGd259 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid studentSourcedId Record #1 -> There is no value found for field: studentSourcedId Consistency Check : UID studentSourcedId missing
IGd259a | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid studentSourcedId Consistency Check : UID studentSourcedId missing
IGd260 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid studentSourcedId Consistency Check : UID studentSourcedId missing
IGd261 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid score Record #1 -> There is no value found for field: score
IGd262 | Single | Req | No | This zip file contains bulk processing data (academicSessions.csv, categories.csv, classes.csv, courses.csv, lineItems.csv, orgs.csv, users.cvs and results.csv) . - results - Invalid scoreDate Record #1 -> There is no value found for field: scoreDate

top

#### Delta Processing

These files contain delta processing information only.

Table 20 Invalid CSV test files for delta gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
IGd001 | Single | Req | No | This zip file contains a single valid delta data file (categories.csv) as per test VOd001 but the manifest file is missing.

top

#### Bulk and Delta Processing

These files contain bulk and delta processing information only.

Table 21 Invalid CSV test files for bulk and delta gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
IGm001 | ? | ? | ? | ...To be completed...

top

### 2.4 Mixed Rostering, Resources and Gradebook Invalid CSV File Test-Sets

The set of test files for CSV-based mixed Rostering, Resources and Gradebook that contain known errors.

#### Bulk Processing

These files contain bulk processing information only.

Table 22 Invalid CSV test files for bulk and delta mixed rostering, resources and gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
IXb001 | ? | ? | ? | ...To be completed...

top

#### Delta Processing

These files contain delta processing information only.

Table 23 Invalid CSV test files for bulk and delta mixed rostering, resources and gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
IXd001 | ? | ? | ? | ...To be completed...

top

#### Bulk and Delta Processing

These files contain bulk and delta processing information only.

Table 24 Invalid CSV test files for bulk and delta mixed rostering, resources and gradebook processing.
Test ID | Records | Data | Ext | Description
--- | --- | --- | --- | ---
IXm001 | ? | ? | ? | ...To be completed...

top

Colin Smythe (IMS Global, UK)
29th March, 2021