TABLE OF CONTENTS

• Preamble
  • Step 1: Configure the CEO Maintland/NewCastle SAS Sync
  • Step 2: Exporting Data

The following information has been provided by the CEO Maintland/NewCastle SAS team and was correct at the time of publication. Please check the CEO Maintland/NewCastle SAS documentation for any changes to the process. Please contact them for any support required in the set up in this system, as Tes consultants are not able to advise.

The CEO Maintland/NewCastle SAS export function from Tes will export two TXT files:

1. Subjects
2. Timetable

Step 1: Configure the CEO Maintland/NewCastle SAS Sync

The settings must first be configured prior to exporting the required data. This step may only be required once, as Tes will remember your settings.

1.  In Tes, select File > Synchronisation > Configure

1. In the Configure tab, select CEO Maintland/NewCastle SAS from the drop down list of options.

1. In the Connection tab, select Browse to choose the output destination folder on your computer or network.
2. If you would like to have the files exported every time a save is done, you can tick the 'Sync each time you save' box

Multiple systems can be set up to sync. It is common to have both the Edval webserver and the school's learning management system configured along with any other systems the school wishes to regularly sync to.

1. Navigate to File > Synchronisation > Sync now.

1. After the file is exported successfully, you will see the following success message

1. You can navigate to the file location to look at the data if desired.

The below table explains what type of data each flat file contains when exported.

If you want to view the correct presentation of the columns please open the flat files with excel spreadsheet.

File Name

Data column (A)

Data column (B)

Data column (C)

Data column (D)

Data column (E)

Data column (F)

Data column (G)

Data Column (H)

Data Column (I)

Data Column (J)

Data Column (K)

Data Column (L)

Data Column (M)

Subjects.csv (Subjects data)

Student ID

Student Surname

Student first name

Year

Sporting House

Tutor Code

Tutor Name

Subject Code

Subject Name

Teacher Code

Teacher Name

Room Code

Room Name

Timetable.csv (Timetable data)

Student ID

Subject Code

Teacher Code

Room Code

Day

Period

NA

NA

NA

NA

NA

NA

NA

For the process on how to import this to CEO Maintland/NewCastle SAS, Please here to contact the CEO Maintland/NewCastle SAS support team.