Local IT Task
Task that automates the export of information from SchoolFront to a 3rd party application when a triggered event occurs via a windows service located on your district's server.
Task Type Group:
There are three options of groups of people the tasks can be used for; Applicants, Employees, or Both.
The useful group for this task is: Both
Photo:
Field Names and Descriptions:
Task Name: Here you can determine which script to run.
Disabled: If disabled, the task will be skipped when part of a current task profile.
Task Description: Describe the intention of the task.
Example:
Generally, you would have to manually dig through employee files for the required staff information you are after. You could configure to run script using the markers and fields listed below, and the service would replace the field indicators with the actual data from SchoolFront.
Setup:
You would need to install a windows service on a server at your district which would pole SchoolFront every (set amount of time) and check for pending IT tasks. You would have to configure to run a script and the service would replace markers with the actual data from SchoolFront.
Markers:
add Key="SFUsername" Value="your username" Requires the username to authenticate to SchoolFront
add Key="SFPassword" Value="your password" Requires the password to authenticate further.
add Key="TestMode" Value="false" Only required if you want to prevent batch execution and the employee from being removed from the queue on completion.
add Key="Verbose" Value="false" Only required if you want details output to the command window, automatically true if test mode is true.
add Key="QueueName1" Value="test" The task name defined in SchoolFront. If multiple tasks are to be executed via one batch file, you can add more keys below following the same format "QueueName2" "QueneName3" and so on.
add Key="BatchFile1" Value="f:\tmp\onboardingbatch.bat"
add Key="BatchTemplate1" Value="---FName--- ---LName--- ---Work Email---" This is where you will enter the fields you would like the batch file to pull.
Fields:
---ApplicantID---
---UserID---
---ApplicantRefNumber---
---PermanentStreetAddress---
---PermanentCity---
---PermanentState---
---PermanentZip---
---DateAvailable---
---DateCreated---
---DateModified---
---CivilServiceListItemID---
---UnderGraduateAllCoursesGPA---
---GraduateGPA---
---MilitaryMemberCustomListItemID---
---MilitaryBranch---
---MilitaryStartDate---
---MilitaryEndDate---
---MilitaryDischargeCustomListItemID---
---MilitaryDuties---
---ADACustomListItemID---
---LawConvictionCustomListItemID---
---LawExplanation---
---ResumeFileID---
---CoverLetterFileID---
---Reference1FileID---
---Reference2FileID---
---Reference3FileID---
---QuestionWhyAreYouHere---
---FName---
---MName---
---LName---
---EmailAddress---
---Username---
---DateLastPWChange---
---CellPhone---
---HomePhone---
---WorkPhone---
---Address---
---Address2---
---City---
---StateProvidence---
---Zipcode---
---Country---
---Salutation---
---Birthdate---
---Gender---
---SSN---
---MedicalNotes---
---Notes---
---FoodAllergy---
---Suffix---
---WorkEmail---
---Initials---
---Nickname---
---Citizenship---
---BirthPlace---
---FullName---
---FullNameDirectory---
---OtherPhone1---
---OtherPhone2---
---FaxNumber---
---Age---
---SSNumberLast4---
---CivilServiceTest---
---MilitaryMember---
---MilitaryDischarge---
---LawConviction---
---CertAreaList---
---ADA---
---CertDualCustomListItemID---
---CertDualType---
---CertFingerprintedCustomListItemID---
---CertFingerprintedType---
---CertNationalBoardCustomListItemID---
---CertNationalBoardType---
---CertNationalBoardNumber---
---CertNYInStateCustomListItemID---
---CertNYInStateType---
---CertNYSTeacherNumber---
---CertNYRetirementCustomListItemID---
---CertNYRetirementType---
---CertOutOfStateCustomListItemID---
---CertOutOfStateType---
---CertPendingDescription---
---DistrictExperience---
---PaidTeachingExperience---
---PaidTeachingExplanation---
---PaidTeachingOneYear---
---PaidTeachingType---
---PrivateYears---
---PrivateYearsAdmin---
---PrivateYearsTeaching---
---PublicYears---
---PublicYearsAdmin---
---PublicYearsTeaching---
---Tenure---
---TenureDate---
---TenureExplanation---
---TenureSchoolDistrict---
---CurrentlyEmployedDistrictID---
---HowYouHearAbout---
---NYSTeachID---
---LicensingPlan---
---LicensingTypeCustomListID---
---ProNumber---
---Experience---
---PhilosophyCustomListItemID---
---PhilosophyCompleted---
---TheoryCompleted---
---HealthScienceCustomListItemID---
---Institution---
---CertificationComplyDate---
----TheoryCustomListItemID---
---HealthScienceCompleted---
---FirstAidCompleted---
---CPRCompleted---
---SaveTrainingCompleted---
---ChildAbuseCompleted---
---DASACompleted---
---CoachingLicenseType---
---HealthScienceType---
---PhilosophyType---
---TheoryType---
---DistrictApplicantID---
---ApplicantDistrictID---
---ApplicantShareDate---
---ApplicantShared---
---DistrictDeleted---
---ApplicantStatusCustomListItemID---
---ApplicantIndicatorCustomListItemID---
---ApplicantFlagCustomListItemID---
---DistrictApplicantDateModified---
---DistrictApplicantDateCreated---
---FinancialSystemImportStatusID---
---DistrictApplicantFlag---
---DistrictApplicantIndicator---
---DistrictApplicantStatus---
---ApplicantDistrict---