OpenWater ➔ Engagefully (COMMON)

Source System: OpenWater
Destination System: Engagefully
Version: 1.0.2026.10140

Description

Imports sessions, speakers and handouts from the OpenWater Application Gallery report. Each scheduled application becomes one session; OpenWater sessions are not used.
Give the Engagefully event one external key per OpenWater program ID.
Only applications with the configured decisions (default Accepted) and a time slot are imported. Unscheduled ones are listed in the job's session errors.
The primary speaker comes from the configured name and email fields, co-presenters from the configured table. Speakers are matched across sessions by email. Company, job title, biography and photo are only imported when switched on.
Tags, description sections, the category tag and handouts are each configured by field alias and are off until set.

Mapping Information

OpenWater		Engagefully
Application	➔	Session
id	➔	ExternalKey
name	➔	Name
scheduler.sessionStartTimeUtc	➔	StartTime
scheduler.sessionEndTimeUtc	➔	EndTime
scheduler.roomName	➔	Location
winning submission's submissionFieldValues (description alias)	➔	AboutContent
winning submission's submissionFieldValues (description section aliases)	➔	AboutContent (headed sections after the description)
categoryName	➔	Tags (category tag group, when configured)
winning submission's submissionFieldValues (tag aliases)	➔	Tags (configured tag groups)
winning submission's winnerTypes	➔	(filter: configured decisions only)

Application (primary speaker fields)	➔	Speaker
submissionFieldValues (email alias, lower-cased)	➔	ExternalKey
submissionFieldValues (first name, last name, email aliases)	➔	FirstName, LastName, Email
submissionFieldValues (company, job title, biography aliases)	➔	Company, Title, AboutContent (when speaker profiles are imported)
submissionFieldValues (photo alias) -> Media/{id}	➔	PhotoUrl (when speaker profiles are imported)
id	➔	SpeakerSessionRefs[*].ExternalKey
primary speaker designation (config)	➔	SpeakerSessionRefs[*].Designation

Application (co-presenter table rows)	➔	Speaker
rows[*] email column (lower-cased)	➔	ExternalKey
rows[*] first name, last name, email columns	➔	FirstName, LastName, Email
id	➔	SpeakerSessionRefs[*].ExternalKey
rows[*].sortOrder	➔	SpeakerSessionRefs[*].SortOrder (after the primary speaker)
co-presenter designation (config)	➔	SpeakerSessionRefs[*].Designation

Application (handout upload fields)	➔	Handout
submissionFieldValues (handout alias) mediaId	➔	ExternalKey
Media/{id} url	➔	HandoutUrl
configured handout name, else Media/{id} fileName	➔	Name
id	➔	ItemRef.ExternalKey (the session)