Import PASI Files

Import PASI Files (Transcript Marks)

Overview

Maplewood is actively working on real-time Course Marks integration and had a solution to replace the RCM file that was real-time, however, for many reasons it was decided to release this manual import tool. Please talk with your division support team for a detailed explanation as we have shared correspondence with them on the matter.

1. Download the Marks Files from PASIprep and Save in CSV format

The XML file you can download from PASIprep is not saved in the expected format (it is a XML Spreadsheet 2003 type and we require CSV). After downloading the files from PASIprep, you will have to open each in Excel and Save as CSV (Comma delimited).

2. Run Maplewood’s Import PASI Files (Transcript Marks)

From each school’s Maplewood menu, select Reports, PASI, Import PASI Files (Transcript Marks)

Simply browse to find the Exam Marks and the Official Marks files. Users must select both Exam and Mark file to import.

Once both files are specified, press the import button. The progress will show the status of the import. Once the import is complete if there are courses found on the file that are not in the students’ History record, a report will appear. The appropriate and corresponding marks (based on course number) will be imported into the students’ history.

It is recommended, if using Requirements on the students’ history tab, to run Credit Requirements Achieved to ensure graduation requirements are correctly updated and reflected.

Important Notes:

As with its predecessor, this is only for Current Students. Thus, you must run this prior to Transferring to Current and it must be run at the school level as the PASI file has no school reference for the file.

The Mark on the student transcript will not be altered, this is the school mark. This import will only write to the Exam and Final fields of matching courses (number) in the students’ transcripts.

If a course exists in the PASIprep file but it is not in the student’s transcript, then the course will not be processed and they will appear on the log file.

If only the exam mark is present in the PASIprep file (course is only present in the exam file with an exam mark), the is “Exam Written On Date” is what will be used to match to the transcript (since this was the only date available for the course).

If applicable, Maplewood will create the following four log files:

1. admin\logs\AlCmRe\StuNotFound_YYYYMMDD_HHMM.log
Logs students not found in Maplewood with the ASN provided in CSV Log contains: "STUDENT INFORMATION (Surname, Given Name, ASN)|CSV Mark File|CSV Exam File|User|Computer"

2. Admin\logs\AlCmRe\StuMarkImp_YYYYMMDD_HHMM.log
Gives a detailed log of the students that were updated. Contains the course , exam and final mark in the log.

3. Admin\logs\AlCmRe\StuMissingMark_YYYYMMDD_HHMM.log
Log students found but no marks in either CSV files. Log contains: "STUDENT INFORMATION (Surname, Given Name, ASN)|CSV Mark File|CSV Exam File|User|Computer"