Where can I find the Upload feature?
On the top right-hand corner, click on your Profile Picture and a drop-down menu should appear. Under Account, select Bulk Upload.
Upon landing on the Upload page, select 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 PSAT 10/NMSQT
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
Click on "Next Step"
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.
