No more double entry! Your training data is automatically synchronized between Aurion and Edusign. 🥰
When using a connection between an ERP and Edusign, it is discouraged to create or modify elements directly on Edusign.
If you do, you might risk deletion or duplication of your data.
Synchronization from Aurion to Edusign
Integration allows Edusign to retrieve data related to trainings from Aurion.
This information helps generate an attendance sheet on Edusign.
Then, you (or your instructors) can have learners sign in.
The sheet is ready and signed!
Finally, attendance and absence information is optionally sent to Aurion.
The connector syncs twice daily
Between 11:00 and 13:00 - Paris Time
Between 18:00 and 21:00 - Paris Time
During a synchronization, information is retrieved from Aurion to Edusign and attendance and absences are sent from Edusign to Aurion.
The next 7 calendar days are retrieved from Aurion
A course more than 7 days in the future in Aurion will not yet be visible on Edusign. You'll have to wait.
Installation
To install the integration between Edusign and Aurion, the following information needs to be provided to your Edusign contact.
Prerequisite Information
URL (mandatory)
API access URL:
https://MYDOMAIN.COM/ws/services/executeFavori
Username (mandatory)
API access Username:
Edusign
Database (mandatory)
Client base name (linked to favorite):
production
Password (mandatory)
API access Password:
xxxxxxxxxxxxx
URL Import (mandatory)
URL for sending attendance states to Aurion:
https://MYDOMAIN.COM/ws/services/import
Edusign Token (mandatory)
Edusign API Token of client:
xxxxxxxxxxxxx--> The API Token is retrieved from your Edusign account.
defaultAbsenceCode (mandatory)
Default Aurion code for absence reason that will be sent to Aurion API when processing unjustified absences of learners
fallbackCodeForJustifiedAbsence (mandatory)
Default Aurion code for absence reason that will be sent to Aurion API when processing justified absences of learners but only if the absence reason on Edusign is not found by the connector (case of a reason added manually on Edusign instead of an API reason for example).
sendStudentDelay (optional)
Allows sending student delays to the Aurion API. The learner must be marked as present and late on the Edusign attendance sheet.
teacherPresence (optional)
Allows sending instructor's presence to the course to Aurion API.
sendTeacherValidation (optional)
If this option is enabled, two things happen:
During Aurion to Edusign synchronization (import of resources): the ID of the Aurion course intervention is added to the Edusign course description.
During Edusign to Aurion synchronization (sending of absences): the synchronization date will also be raised as the validation date by the instructor for the Aurion intervention. This triggers billing for the stakeholders.
dataGroups - Favorite of groups (optional but mandatory for point 9. and 10.)
The favorite's identifier allowing to retrieve information about the groups, see the structure below.
dataStudentsGroups - Favorite of the link between groups and learners (optional)
The favorite's identifier allowing to retrieve pairs of identifiers making the link between groups and learners, see the structure below
dataCoursesGroups - Favorite of the link between groups and attendance sheets (optional)
The favorite's identifier allowing to retrieve pairs of identifiers making the link between the groups and attendance sheets, see the structure below
dataExternalMasterApprenticeship (optional) - Favorite of the link between learners in Master program and their apprenticeship master. See the structure below
dataExternalTutor (optional) - Favorite of the link between learners in alternation and their business tutor or external company. See the structure below
Additionally, we will ask you to provide a screenshot of the absence reasons to ensure consistency between the two systems.
"Data" favorite structure
Parameter 2 "Data" results in creating a favorite with the following data (see table)
Field name | Example of typical field content | Additional comment |
id.Intervention | 115849 |
|
id.Event | 115848 |
|
Start | 2021-12-15T08:30:00 | The date format must be exactly like the example. See the Aurion request to be set. |
End | 2021-12-15T11:30:00 | The date format must be exactly like the example. See the Aurion request to be set. |
Description | Session from 08:30 to 11:30: English 3rd year S5 | The description actually corresponds to the session name (this will be the name of the attendance sheet on Edusign) |
session.Description | Personal computer required - ... | This field corresponds to the session description, this field is not mandatory, it allows adding information related to the session. |
Resource | Classroom 210 | Name of the training location, if several, possible to separate with commas |
id.Learner | 110241 |
|
Name.Learner | DURAND |
|
FirstName.Learner | Margaux |
|
email.Learner |
| |
Instructors | 16026415/GRIMAUD/Karole/k.grimaud@gmail.com|13456/Smith/John/john@gmail.com | Information separated by /, if several instructors, separate them by pipe (|) |
dataGroups favorite structure
Parameter 13 "dataGroups - Favorite of groups" results in creating a favorite with the following data (see table)
Field name | Example of typical field content | Additional comment |
id | 95101654 | Unique Aurion group ID |
Label | Group TD 1 | Group name that will appear on Edusign |
Structure of the dataStudentsGroups favorite
Parameter 14 "dataStudentsGroups - Favorite of the link between groups and learners" results in creating a favorite with the following data (see table)
Field name | Example of typical field content | Additional comment |
id | 95101654 | Unique Aurion learner ID |
Learner email | ||
Groups | 95101777 | Unique Aurion group ID |
Structure of the dataCoursesGroups favorite
Parameter 15 "dataCoursesGroups - Favorite of the link between groups and attendance sheets" results in creating a favorite with the following data (see table)
Field name | Example of typical field content | Additional comment |
id.Group | 95101777 | Unique Aurion group ID |
id.Event | 115848 | Event ID rising as attendance sheet on Edusign |
Label.Group | Group TD 1 | Optional: group name (used only for support purposes) |
It is imperative not to have duplicate lines
dataExternalMasterApprenticeship structure
Field name | Example of typical field content | Additional comment |
id.Tutor | 957 | Unique Aurion contact ID |
Name.Tutor | Dupont | Tutor name |
Label.Group | Etienne | Tutor's first name |
email.Tutor | Tutor's Email | |
id.Student | 10043 | Unique ID of the linked student |
Structure for favorite dataExternalTutor
Field Name | Example content type of the field | Additional Comment |
id.Tutor | 957 | Unique Aurion ID of the contact |
Name.Tutor | Dupont | Tutor's Name |
Label.Group | Etienne | Tutor's First Name |
email.Tutor | Tutor's Email | |
id.Student | 10043 | Unique ID of the linked student |
Additional Options Available
Please indicate the desired options to your Edusign contact.
Automatic sending of credentials to instructors and students when they are added to Edusign
Sending student attendance data back to Aurion
Sending student delay data back to Aurion
Sending instructor attendance data back to Aurion
Synchronization of absence reasons - For absence justifications
Synchronization of master mentors and tutors/companies of the student. For follow-up of absence records.
If you wish to activate absence reasons, it will be necessary to communicate the reasons to us in the following format:
[ { "ID": 101, "CODE": "ABS_DECLAREE", "NAME": "Absence" } ],Your connector is already installed and you want to activate an option?
Let us know via chat.
Exclusions are not synchronized between Edusign and Aurion at this time.
IP Addresses to Whitelist
52.47.74.210
Email addresses to whitelist
To avoid, among other things, emails being marked as spam, we suggest whitelisting the following addresses:
edusign.fr
*.edusign.fr
*.*.edusign.fr
edusign.app
*.edusign.app
edusign.com
*.edusign.com
*.*.edusign.com
Downstream Information to Edusign
📖 Attendance Sheets
When you create or modify sessions/classes/courses on Aurion, all their associated information will descend to Edusign as attendance sheets. This information will only be transferred during synchronization to automatically create or modify attendance sheets featuring:
Their Name.
Their Date.
Start and End Time.
Training Room (Resource).
The Instructor(s).
The Student(s).
Note: it is only when attendance sheets linked to an individual (student or instructor) will they be created on Edusign. In other words, don't worry if you don't see all your student and instructor profiles on Edusign. They will only exist on the application when they have a scheduled training session within the week.
👨🎓 Students.
Once synchronization is completed, the student with a scheduled course on Edusign for the day will be automatically created. You will then find all your students' profiles from the Students menu which will show:
Their Name (mandatory).
Their First Name (mandatory).
Their Email (mandatory).
Their Phone Number (optional).
👨🏫 Instructors.
Similar to students, once synchronization is completed, instructors with a scheduled course on Edusign for the day will be automatically created. You will then find all your instructors' profiles from the Instructors menu which will show:
Their Name (mandatory).
Their First Name (mandatory).
Their Email (mandatory).
Groups.
If the option to lift groups is enabled, once synchronization is completed, groups will be automatically created. You will then find all the groups in the Groups menu, showing:
Their Name (mandatory)
Attached students (mandatory)
Downstream synchronization FAQ.
If you still have questions about downstream synchronization, a FAQ created by us can provide more answers. 😉
Upstream synchronization of attendance data 🛫.
Standard upstream synchronization from Edusign to Aurion allows sending:
Student attendance data
Instructor attendance data
This upward synchronization occurs:
Every day during synchronizations
Only for attendance sheets archived on that day.
Note: During synchronization, if the student is linked to a course, they will be marked absent by default if they did not sign the attendance sheet. Those who are only in a student group without being linked to the course (even if the group is linked to the course) will not be listed.
Only students with an API_ID will be included in the absence report.
Unarchiving a sheet after its first synchronization may cause errors. It's recommended not to unarchive a sheet that's already synchronized.
Upstream synchronization FAQ
Frequently Asked Questions
How to format dates from Aurion to match ISO 8601 format?
To enable Edusign to process event dates received from Aurion, here is an example query calculation to set up on your ERP:
1. Create a calculated field to format the start date (or end date)
2. Create a "start time" field to extract only that part of the date
3. Concatenate the 2 previously calculated fields with "T" in between:
How to filter your interventions on a rolling 15-day window?
To reduce processing of your Aurion server on interventions to be sent back, you must apply filters to your Data query - Interventions.
1. Apply a filter on the attribute Start.event -> Greater than or equal to Today:
2. Create a calculated field Event.Start - Today
3. On this last calculated field, Apply a filter -> less than or equal to 15
⏱️ Maximize time savings with your account settings. ⏱️
To go further, visit our help center.
💬 If you don't find what you're looking for, contact us via chat. 💬