...
Create a spreadsheet containing a list of students eligible for a student card. The template is available at the PCS Operations hub.
Drop a copy of the spreadsheet to the Identicam import folder \\appdata.royalroads.ca\prod\Agresso\Import\GLLC-IDCARDS
After 10 am or 10 pm, the Welcome desk can print ID cards for the imported students.
An email notification will be sent (GLLC@royalroads.ca) if the file was successfully imported or had any import issues.
If the import is successful, the spreadsheet of students will be moved into the Import files folder.
If the import fails, the spreadsheet will remain in the import folder until all errors have been corrected. Please correct the errors identified in the sent email and resave for import.
Possible errors and solutions
Program code exceeds 60 characters - Reduce the length of the program name to less than 60 characters
Year end values not 4-digit - The year end date is not in the correct format (e.g., 2024)
More than one Excel file in the folder - The system sees more than one import file in the same folder. Remove one of the files.
First name missing - a student is missing a first name.
Family name missing - a student is missing a family name. If the student has no family name, enter a period character “.” as the family name.
Expiry date error - the expiration date is missing or not in the correct format (e.g., 2024-05-15).
end of process