How to export SMS exam data from iSchool SMS and import into SAP123?

SAP function has been enhanced to allow exported Exam result data  cum with student performance remarks to be imported into SAP123 version 4.0  only. The purpose of this features introduce will helps school users eliminating their time to do duplicated data entry both in iSchool SMS and SAP exam data entry.

Step 1 – Identify the SMS exam type with SAP123 exam type

Please ensure SAP Exam Code is match to your school exam type where it’s use to identify which exam type in the SMS to be import into SAP123. Please go to Parameter Setup ~ > Exam Code & Type ~ > Edit for details.

Step 2 – Export SMS Exam Data to SAP123 File Format

SMS Exam data can be exported to SAP123 file format via SMS E – Report Card Module. To export SMS exam data to SAP123,  Please go to SAP – SAP Data Export Option. Please note that, SAP123 only allow for user to import Form 1, 2 or 3 exam data.

Step 3 – Import SMS Exam Data to SAP123

Step 3.1: On the SAP123 programe, go to menubar  ~ > Utiliti ~ > Utiliti

Step 3.2:  Insert floppy disk on A drive. and click on the “Import data dari A (ZIP FILE)” button and click on “OK”  to proceed.

OR

Step 3.2:  Extract out the Zip file (DATASAP) content from your SMS exam data export and copy & paste the 5 different files to your PC’s SAP123 program directory which normally installed at C:\SAP123.

Then, go to utiliti page, click on the “Import data dari C” button and click on “OK”  to proceed.

Step 3.3: Please ignore the warning messages and click ”OK” button to continue. A “PERLU LAKUKAN PROCESS MP”  messages alert user to run the process to compute and grade the newly exam marks imported of the students in the class as well as in the level.

Once the steps as above is completed, repeated the same steps for following level until all the form 1, 2 & 3 is completed imported into SAP123.

Step 4 – Edit Subject marks information in SAP123

User is required to update or remove any subjects student’s exam data in SAP123 which are not required before submitting to MOE.