Recent Searches

No recent searches

    Popular Articles

      Articles
      View all
        Topics
        View all
          Tickets
          View all
            no results

            Sorry! nothing found for

            E10 - Synchronisation to Denbigh via Export

            Modified on Thu, 14 Aug at 1:01 AM

            TABLE OF CONTENTS



            Preamble

            Timetabling data that exists in Timetable files are usually sent on to one or more other non-Tes systems, such as student learning management systems, reporting systems, administration systems, and many more. The Tes integration team works with other systems to make sure that the data required to be sent is in the correct format.
            This document can be referenced for:
            1. new school file set up
            2. synchronisation processes
            3. synchronisation troubleshooting
            Info
            While Tes takes all care to ensure any mention to the other system is correct and up to date, it is the user's responsibility to check with the other system prior to an initial sync. If the user becomes aware of any changes to the other system, we would very much appreciate this feedback.

            Type of sync

            This sync is performed by exporting correctly formatted files, usually CSV or TXT formats, ready uploading into the other system.

            Which data is sent to the other system?

            This table lists many of the data and features found in Tes and, where known by Tes specialists, whether they are also understood by the other system.
            Alert
            Note that Tes builds many excellent features to help users build high quality timetables, and while these features can be sent onto the other system through the synchronisation process, not all systems have built the capability on their end to receive/display these features. 
            Tes Timetable feature
            Notes on feature
            Is this feature received 
            by the other system?
            Other notes
            Bell times
            Bell times as per Grid structures
            No

            Campuses
            Campuses and their associated rooms
            No

            Classes
            Classes as per Class data screens
            Yes

            Class lists

            Yes

            Composite classes (linked classes)
            One teacher teaching more than one class at the same time
            Yes

            Duty roster

            Yes

            Faculty data

            No

            Grid structure codes

            Yes

            Multi-file
            Two (or more) timetable files
            No

            Multi-grid
            Multiple grids with different bell times
            No

            On-call roster

            Yes

            Priority classes
            The priority class that shows on student's timetables where they have class clashes
            No

            Room data
            Room Code, Name, Size, Campus, Comment
            No

            Rotation classes
            Classes from particular rotations
            No
            Only exports classes of current rotation
            RTO roster

            Yes

            Student data
            Student Code, Name, Preferred name, Year level, Letter group, House, Gender, StatewideID, Email, Phone
            Yes

            Study roster
            Study classes, staffing and rooming roster
            No

            Sub-classes

            Yes

            Teacher data
            Teacher Code, Name, Preferred name, Faculty, Gender, Email, Phone
            Yes

            Teacher days off (Unavailables)

            No

            Timetable data

            Yes

            Two (or more) rooms at once

            Yes

            Two (or more) teachers at once

            Yes

            Year levels (non-numeric)
            Year levels such as SPT, LSUP, ROLL, Yr9+10 etc
            Yes


            Yes - The data is sent from our end and is being received and processed by 3rd party system. 
            No - The data is not supported by 3rd party systems and is not sent from the timetable file. 
            Unsure - The data is being sent from the timetable file but we are unsure if it is being processed and supported by 3rd party system. 

            Steps to synchronise data

            Step 1: Configure the Timetable file

            1. Go to 'File > Synchronise > Configure'
            2. In the 'Sync' tab, Click on the blue '+' to add another sync drop-down box
            3. Select 'Denbigh' from the drop-down list
            4. Click on the 'Configure' button next to 'Denbigh'

            5. Click on the 'Browse' button and select the location of where the files are to be exported to.
            6. Tick the 'Sync each time you save' if you need the export to occur when the etz file is manually saved.

            Step 2: Perform the Export

            1. Go to 'File > Synchronise > Sync now'.
            2. Select  'Denbigh' from the 'Filter' drop-down at the top right.
            3. Click on 'Create TT publish file

            Step 3: Importing into Denbigh

            1. The sync produces 4 .TXT files
              1. SCOURSES.TXT
              2. STAFF.TXT
              3. STUDENTS.TXT
              4. TTABLE.TXT
            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)
            SCOURSES.TXT
            (Student Class lists)
            Student Code
            Course Code
            (Eg.7MAT)
            Class Code
            (Eg.7MAT.1)
            Subject Name
            Teacher Code
            Year Level
            N/A
            N/A
            STAFF.TXT
            (Teacher Data)
            Teacher Code
            Teacher Last Name
            Teacher First Name
            N/A
            N/A
            N/A
            N/A
            N/A
            STUDENTS.TXT
            (Student Data)
            Student Code
            Student Last Name
            Student First Name
            Gender
            Year Level
            Letter Group
            Enrollment status
            (Current)*
            N/A
            TTABLE.TXT
            (Timetable data)
            Day
            Period
            Class Code
            (Eg.7MAT.1)
            Class Code
            (Eg.7MAT.1)
            Subject Name
            Teacher Code
            Room Code
            Year Level
            Notes
            *Enrollment status will always appear as 'Current'. If a student is marked as 'Inactive', they will not appear in the export
            Info
            Please refer to this system's documentation for instructions on how to upload/import the files.

            Was this article helpful?

            That’s Great!

            Thank you for your feedback

            Sorry! We couldn't be helpful

            Thank you for your feedback

            Let us know how can we improve this article!

            Select at least one of the reasons
            CAPTCHA verification is required.

            Feedback sent

            We appreciate your effort and will try to fix the article

            Preview
            0 of 0