Cialfo - Access
Throughout the school year, counselors receive many test reports for students from different testing organisations (College Board, ACT, etc.) With Upload, counselors will be able to bulk Import Test Scores into Cialfo easily.
What test scores can I upload in bulk?
ACT
SAT
PSAT 10 or PSAT NMSQT
IELTS
TOEFL
More coming to you soon... (AP, IB, SAT2 or SAT Subject)
Where do I navigate to find Upload (Tests)?
On the left-hand menu, select Upload, then click Import Test Scores.
Step 1 - Uploading your data file - (.csv) or (.xls) or (.xlsx) only
a. Click the upload box, then browse and select the file you want to upload OR
b. Drag the file that you want to upload from its folder and drop it into the upload box
Step 2 - Configuring the settings of your upload
Select whether you would like to import ACT, SAT, PSAT, IELTS or TOEFL scores
Make sure to determine which format the dates in your file are in so that the data is read accurately by the uploader - our system current accepts Day-Month-Year, Month-Day-Year, and Year-Month-Day date formats
Step 3 - Matching data columns to Cialfo fields
First, determine which row of data in your file contains the column headers. Next, looking at the data fields that are available on Cialfo, match the columns of data you have in your file to them. For ease of future uploads, your method of matching will also be saved and automatically applied on the next upload :)
Note: All required fields are marked with an asterisk (*). For optional fields, there is an option to Ignore this column and no data will be imported under that data field.
Step 4 - Preview & Confirm
Reviewing errors found
After processing your data, the magical wizard will then tell you exactly which row of data in your file contains errors and also what the errors are specifically. With this information, you can then do the necessary corrections. Alternatively, you may also download an error report.
Confirming test scores to be imported
On the next tab New, you will be able to see exactly what data will be imported by the uploader and also confirm the test scores and test dates you are about to import.
Turning on the "Update" function (Optional)
Intelligently enough, Upload 2.0 is also able to detect whether test scores already exist within Cialfo, based on the test dates that are entered. When this is the case, you have the option of deciding whether to update the scores for the test that has been taken on the same date.
Note: Turning on update will override/replace any existing data
Step 5 - Confirming your upload
Last but not least, click Finish Import and voila - all done!
Watch your upload status turn green, and just in case you ever need to refer back to it, you can always check the details of it on the Upload Log page.
That's the end of Uploading Tests, happy uploading!
For any questions - feel free to use our Chat with Cialfo to speak to our team :)