Skip to content

How do I setup Cases21 for export of Staff and Classes data to Sentral?

Cases21 allows you to build your own export/reports, and Sentral have worked out a method to, leveraging these reports, get this data into Sentral.

Important to Note:
This procdure requires and assumes a reasonable level of computer knowledge, particularly around Cases21 use.

To create the exports;
  • Open Cases21
  • Choose Utilities and Click on Export Data
  • Choose ‘Export data from the database”
  • Choose “New Format”


The Format Name is Sentral Export Staff and Classes
The Description is Sentral Export for staff and classes


Click Next


Ensure Reports is selected, and Click Next




Browse to a drive on either:
Option 1.
  • The curriculum server (usually a staff share).
  • Create a folder called Sentral
  • Create (type in) a file name called sentral-staff.csv (note - .csv rather than .txt)
OR

Option 2 (Note: NOT RECOMMENDED)
If the curriculum server is not mapped to a drive, and your IT person cannot do this for you, then you will need to save it to any admin server drive that you can access.
This will mean that the automated linking of files cannot be setup and is not the recommended option.
If only able to access admin drives, then
  • Create a folder on an admin drive called Sentral
  • Create a file name called sentral-staff.csv (note - .csv rather than .txt)
  • Once done, click next.
Click the SQL button to the left of the SQL box


You will need to copy the sql statement that is provided by Sentral Education into the screen that has opened

  • Find the sentral-staff-sql.txt file that was sent to the school
  • Open the sentral-staff-sql.txt file in notepad
  • Select all, and copy
  If you do not have this to hand, you can copy and paste the SQL from here:

SELECT *
FROM SF
  LEFT JOIN KGC ON (SF.SFKEY = KGC.TEACHER)
WHERE SF.STAFF_STATUS = 'ACTV'  
  • Go back to the Cases screen , delete the existing data and paste in the SQL query
  • Click the apply button and confirm changes
  • Click next


Nothing needs to be altered on the following screen



Click Finish




Feedback and Knowledge Base