This provider exports instructor-lead training data from the BlendedX.

Available columns

Name Type Description
activityDuration int Duration of the activity.
activityID int Id of the activity.
activityName string Name of the activity.
activityPoints int Points of the activity.
candidateCustomFieldGuid string(250) Data for one of the learner's possible custom fields (GUID of the custom field needs to be specified, please check the examples).
candidateEmail string The learner's e-mail address.
candidateEntityName string The learner's entity name.
candidateFirstname string The learner's first name.
candidateGuid string(40) The learner's GUID.
candidateId int The database ID used to identify the learner.
candidateLogin string The learner's login.
candidateName string The learner's name (family name/surname).
candidateRefNumber string The learner's reference number.
catalogVisibility enum(Y, N) "Y" if the training course associated with the current context is visible in the public catalogue, "N" otherwise.
constantValue string Return the constant value specified in this column's child elements.
eventAllDay enum(true, false) 'true' if the event lasts the whole day, false otherwise.
eventEndDate date The end date of the event.
eventEndTime time The end time of the event.
eventFacilitator string The full name of the facilitator of the event (back-office user).
eventFacilitatorGuid string(40) The GUID of the facilitator of the event (back-office user).
eventID int The ID of the event.
eventLocation string The location of the event.
eventLocationID int The ID of the location of the event.
eventRoom string The room of the event.
eventRoomGuid string(40) The guid of the room of the event.
eventStartDate date The start date of the event.
eventStartTime time The start time of the event.
eventTimeZone string(50) The timezone of the event.
eventVirtualMeetingURL url Link to the virtual meeting of the event.
foFacilitatorEmail string Email address of the front-office facilitor of the event.
foFacilitatorFirstname string First name of the front-office facilitor of the event.
foFacilitatorName string Name of the front-office facilitor of the event.
pointsGained int Points gained on the content.
registrationDate datetime The date of the registration.
registrationGuid string(40) The GUID of the registration.
sessionEndDate date The end date of the session.
sessionGuid string(40) The GUID of the session.
sessionId int The database ID used to identify the session.
sessionStartDate date The start date of the session.
sessionTitle string The title of the session.
status enum
  • For the providers related to tracking: the progress status of the content referenced by the tracking row. The returned values can be overriden thanks to option 'statusFormat'.
    Type: enum(completed, incomplete, not attempted)
  • For the provider 'Platform Candidates Access': the status of the of connection attempt (0 = failed, 1 = successful).
    Type: enum(0, 1)
timeSpent timeGlobalFormat
  • If the current context is a Registration: the total time the learner spent on the registration.
    timeSpent = timeGlobal + timeSpentCBT + timeSpentDigital
    If the options timeFrames and timeFramesScale are specified in the provider, then this value is filtered to only the time spent during the chosen period.
  • If the current context is an Activity: the time the learner spent on the activity.
trainingChapters longtext The chapter hierarchy of the training course.
trainingDuration string The duration of the training course.
trainingGuid string(40) The GUID of the training course.
trainingId int The database ID used to identify the training course.
trainingPathCode string The reference number of the training course.
trainingPublisher string The publisher of the training course.
trainingTitle string The title of the training course.

Filters and parameters

Name Type Description
activityNames string Filter on the name of activities. Can contain several values separated by commas.
attendanceStatus enum(present, absent, absent but excused, no information, event not started, not applicable) Filter on the learner's attendance status (only available for classroom activities).
dateFormat string Format for dates in the exported data. When not specified, the default date format is `YYYY-MM-DD`.
dateTimeFormat string Format for dates in the exported data. When not specified, the default value is `YYYY-MM-DD hh:ii:ss`.
entityIds string A comma-separated list of the entity ids to filter on. If multiple entity IDs are provided, then the export will return data about learners who belong to at least one of those entities.
eventStarted yesNoElement Whether the classroom event's date is in the past.
facilitatorGuids string Filter on the GUID of back-office facilitators. Can contain several values separated by commas.
foFacilitatorIds string Filter on the database ID of front-office facilitators. Can contain several values separated by commas.
locationIds string Filter on the database ID of one or several location (column eventLocationID). Can contain several values separated by commas.
onlyFromImportedRegistrations yesNoElement Only export tracking data related to registrations that were imported.
onlyFromImportedSessions yesNoElement Only export tracking data related to sessions that were imported.
onlyFromImportedTraining yesNoElement Only export tracking data related to trainings that were imported.
preferredLocales string The comma-separated list of preferred locales.
publishers string Only export tracking data on content issued by the given publishers GUID. Multiple publishers may be specified in a comma-separated list.
roomGuids string Filter on the GUID of one or several rooms. Can contain several values separated by commas.
sessionGuid string(40) Only export data related to a training session that has the specified GUID.
timeFrames timeFrameScale Once a learner has completed a learning object or activity, a completion date will be saved in the associated tracking row. This parameter is used to the provider to only export tracking data where the completion date is in a certain time span. Must be used with `timeFramesScale.`
timeFramesScale timeFrameScale Once a learner has completed a learning object or activity, a completion date will be saved in the associated tracking row. This parameter is used to the provider to only export tracking data where the completion date is in a certain time span. Must be used with `timeFrames`.
trainingGuid string(40) Only export data related to a training course that has the specified GUID.
trainingPathCode string Only export data related to a training course that has the specified code.

Example

		<providers>
			<instructorLedTrainingActivityProvider>
				<columns>
					<activityID />
					<activityDuration />
					<activityPoints />
					<eventID />
					<eventStartDate />
					<eventEndDate />
					<eventStartTime />
					<eventEndTime />
					<eventTimeZone />
					<eventAllDay />
					<eventFacilitator />
					<eventLocation />
					<eventLocationID />
					<eventVirtualMeetingURL />
					<status />
					<timeSpent />
					<pointsGained />
					<candidateId/>
					<candidateName />
					<candidateFirstname />
					<candidateLogin />
					<candidateEmail />
					<candidateRefNumber />
					<candidateGuid />
					<candidateCustomFieldGuid />
					<registrationDate />
					<registrationGuid />
					<sessionId />
					<sessionTitle />
					<sessionGuid />
					<sessionStartDate  />
					<sessionEndDate />
					<trainingId />
					<trainingTitle />
					<trainingPathCode />
					<trainingGuid />
					<catalogVisibility />
					<trainingStatus />
					<trainingModality />
					<trainingPublisher />
					<trainingChapters />
					<trainingDuration />
				</columns>
				<parameters>
					<dateTimeFormat></dateTimeFormat>
					<timeGlobalFormat>paddedhh</timeGlobalFormat>
				</parameters>
			</instructorLedTrainingActivityProvider>
		</providers>