This process is used to import student data into Identicam for student cards.
Last updated: 2024-04-30 (dk)
Pre-requisites & Rules:
Every import will automatically remove all previously imported student records; therefore, any student eligible for an identity card must be listed in the spreadsheet.
The spreadsheet is imported daily at 10 AM and 10 PM.
Once the spreadsheet has been successfully imported, it will be moved into the Imported files folder.
Email notifications will be sent to GLLC@royalroads.ca to confirm a successful or unsuccessful import.
Staff must be a member of the rru.apps.is.identicam.gllc security group to upload the spreadsheet
The import file must be in Excel format (.xlsx) and have the following columns: Student ID; First Name; Family Name; Program code; Year (yyyy); Expiration date (yyyy-mm-dd)
The Identicam import folder is \\appdata.royalroads.ca\prod\Agresso\Import\GLLC-IDCARDS
Process Steps:
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 if there were 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.
end of process