How do I setup Cases21 for export of Staff and Classes data to 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)
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.
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
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
Click Finish