How it works
A downloadable template is a document you lay out yourself in Word (or in any word processor that can save as RTF). You type placeholders where a piece of data should appear; at export time, the platform replaces them with the actual values and produces one file per learner (bundled in a .zip when there are several).
Two syntaxes coexist, depending on the format of the uploaded file:
| Template format | Placeholder syntax | Example |
|---|---|---|
Word (.docx) | dollar sign and braces | ${prenom} ${nom} |
RTF (.rtf) | wrapped in @ signs | @prenom@ @nom@ |
The two syntaxes do not mix: in a .docx, @nom@ stays as it is, and vice versa.
> Custom PDF templates use a third family of variables (@m_user_name@…), described in Report templates. This article only covers downloadable Word and RTF templates.
Which template accepts what
| Template | Word .docx | RTF .rtf | One document per… |
|---|---|---|---|
| Certificate (certificate of attendance) and its copies | yes | yes | learner |
| Account record (administrative record) | no | yes | learner |
| Login statistics | no | yes | export |
| Training time statistics | no | yes | export |
| Email statistics | no | yes | export |
In Analysis → Templates, these templates are listed under Downloadable. A certificate whose file is a .docx shows the WORD badge.
- An account that can edit report templates (administrator).
- Word, LibreOffice or any word processor that can save as
.docxor.rtf. - For custom fields: their number (1 to 20 for accounts), shown in Administration → Custom fields.
Steps
Open the templates
Analysis → Templates, Downloadable section.
Duplicate the certificate
click Duplicate next to the supplied certificate: you work on a copy, and the original stays intact.
Download the Word sample
open the copy with Edit, then click Download a sample Word template: it is a
.docxthat already contains all the placeholders.Lay it out in Word
logo, colours, text, signature. Keep the
${…}placeholders where the data should appear.Upload the file
go back to Edit, choose your
.docx(or.rtf) in Template file (RTF or Word .docx), then Confirm.Test on one learner
run the certificate export for a single learner and open the resulting file before distributing more widely.
Word certificate: the placeholders
Learner
| Placeholder | Replaced by | Example output |
|---|---|---|
${nom} | Learner's last name | Martin |
${prenom} | First name | Claire |
${email} | Email address | claire.martin@example.com |
${service} | Department | Human resources |
${cpmb1} … ${cpmb20} | Account custom field no. 1 to 20 | Employee ID 40127 |
${photo} | Profile photo, as an image (empty if there is no photo) | (image) |
${date} | Date of the export | 10/11/2026 |
Summary — calculated over all the sessions, courses or activities covered by the certificate.
| Placeholder | Replaced by | Example output |
|---|---|---|
${temps} | Total time spent | 12h 35min |
${passages} | Total number of attempts | 18 |
${avancement} | Overall status: Not started, Ongoing, Completed, not validated or Validated | Validated |
${premiere_connexion} | First login — course certificate only | 02/09/2026 |
${derniere_connexion} | Last login — course certificate only | 28/10/2026 |
Rows of the detail table — to be placed in a table row in Word. The row containing ${ligne} is copied as many times as needed: once per session, then for each of its courses, then for each of their activities.
| Placeholder | Replaced by | Example output |
|---|---|---|
${ligne} | Title, indented to the right according to its level | Excel — the basics |
${type} | Session, Training course or Activity | Training course |
${score} | Best score (a dash if none) | 85 % |
${temps_ligne} | Time spent on this item | 2h 05 |
${debut} | Start date — session rows only | 01/09/2026 |
${fin} | End date — session rows only | 31/12/2026 |
Example: a Word certificate
The text as you type it in Word; the square brackets represent a four-column table, the second row being the repeated row.
TRAINING CERTIFICATE OF ATTENDANCE
I, the undersigned, training manager, certify that
${prenom} ${nom} (${email}), ${service} department,
has followed the programme below.
Total time: ${temps} Attempts: ${passages} Status: ${avancement}
[ Title | Type | Score | Time ]
[ ${ligne} | ${type} | ${score} | ${temps_ligne} ]
Issued on ${date}.Output for a learner enrolled in a session with two courses:
TRAINING CERTIFICATE OF ATTENDANCE I, the undersigned, training manager, certify that Claire Martin (claire.martin@example.com), Human resources department, has followed the programme below. Total time: 12h 35min Attempts: 18 Status: Validated [ Title | Type | Score | Time ] [ Office software 2026 | Session | 82 % | 12h 35 ] [ Excel — the basics | Training course | 85 % | 7h 10 ] [ Final quiz | Activity | 90 % | 0h 25 ] [ Word — advanced | Training course | 78 % | 5h 25 ] Issued on 10/11/2026.
RTF certificate: the variables
Global variables — usable anywhere in the document.
| Variable | Replaced by |
|---|---|
@nom@, @prenom@, @email@, @service@ | Learner's identity |
@cpmb1@ … @cpmb20@ | Account custom field no. 1 to 20 |
@photo@ | Profile photo (35 × 45 mm), or nothing |
@temps@ | Total time spent, for example "12h 35min" |
@pres@ | Total number of attempts |
@avancement@ | Overall status |
@first_connexion_date@, @last_connexion_date@ | First and last login — course certificate only |
Repeated zone — the detail goes between @debut_champs@ and @fin_champs@. Inside it, each level has its own block, which the platform copies for each item:
| Block | Repeated for each… | Block variables |
|---|---|---|
@debut_champ_session@ … @fin_champ_session@ | session | @Session@ (name), @S%@ (score), @Sh@ (time), @Sdebut@, @Sfin@ (dates), @cpse1@ … @cpse10@ (session custom fields) |
@debut_champ_parcours@ … @fin_champ_parcours@ | course in the session | @Parcours@ (title), @P%@, @Ph@, @cppa1@ … @cppa10@ (course custom fields) |
@debut_champ_UA@ … @fin_champ_UA@ | activity in the course | @UA@ (title), @u%@, @uh@ |
The output order follows the tree: a session, its courses, the activities of each course, then the next session.
Example: an RTF certificate
CERTIFICATE — @prenom@ @nom@ (@service@) Total time: @temps@ — @pres@ attempts — @avancement@ @debut_champs@ @debut_champ_session@Session @Session@ from @Sdebut@ to @Sfin@: @S%@ in @Sh@ @fin_champ_session@ @debut_champ_parcours@ Course @Parcours@: @P%@ in @Ph@ @fin_champ_parcours@ @debut_champ_UA@ Activity @UA@: @u%@ in @uh@ @fin_champ_UA@ @fin_champs@ This document is issued for all legal purposes.
CERTIFICATE — Claire Martin (Human resources)
Total time: 12h 35min — 18 attempts — Validated
Session Office software 2026 from 01/09/2026 to 31/12/2026: 82 % in 12h 35
Course Excel — the basics: 85 % in 7h 10
Activity Final quiz: 90 % in 0h 25
Course Word — advanced: 78 % in 5h 25
This document is issued for all legal purposes.Account record (RTF)
One record per learner, showing their identity and their training plan.
| Variable | Replaced by |
|---|---|
@nom@, @prenom@, @email@, @service@, @cpmb1@ … @cpmb20@, @photo@ | As for the certificate |
@xx/xx/xx@ | Start date of the account's validity |
@yy/yy/yy@ | End date of the account's validity |
@VARIABLES_ADMIN@ | All the account's visible custom fields, one per line: "Label: value" |
@PLAN_FORMATION@ | The training plan: each session, its courses and their activities (with the scheduled date when there is one) |
TRAINEE RECORD @prenom@ @nom@ — @email@ Account open from @xx/xx/xx@ to @yy/yy/yy@ Additional information: @VARIABLES_ADMIN@ Training plan: @PLAN_FORMATION@
Login and training time statistics (RTF)
A single document per export, covering the users in the filter.
Table by period — the columns are numbered 1 to 6: today, yesterday, last 7 days, this month, this year, total.
| Variable | Replaced by |
|---|---|
@titre_doc@, @titre_periode@ | Document title, "Period" header |
@periode_1@ … @periode_6@ | Label of each period (Today… Total) |
@titre_nombre_1@, @titre_nombre_2@ | "Number of logins" and "Time spent" headers |
@nombre_1_N@ | Number of logins (or attempts) for period N |
@nombre_2_N@ | Time spent for period N, in the format 12:05:33 |
@titre_nombre_3@ … @titre_nombre_6@ | Logins — learner headers, then trainer headers |
@nombre_3_N@, @nombre_4_N@ | Logins — number and time for learners |
@nombre_5_N@, @nombre_6_N@ | Logins — number and time for trainers |
Detailed history — the row placed between @debut_champs_detail@ and @fin_champs_detail@ is repeated for each login (or each attempt), over the period chosen at export.
| Variable | Replaced by |
|---|---|
@titre_detail@, @titre_nom@, @titre_date@, @titre_duree@ | Table headers |
@titre_ua@ | "LU" (learning unit) header — training time only |
@nom@ | Last and first name |
@ua@ | Activity followed — training time only |
@date@ | Date and time, for example 28/10/2026 14:32 |
@duree@ | Duration, in the format 0:42:10 |
@titre_doc@ | @titre_periode@ | @titre_nombre_1@ | @titre_nombre_2@ | | @periode_1@ | @nombre_1_1@ | @nombre_2_1@ | | @periode_3@ | @nombre_1_3@ | @nombre_2_3@ | | @periode_6@ | @nombre_1_6@ | @nombre_2_6@ | @titre_detail@ | @titre_nom@ | @titre_date@ | @titre_duree@ | @debut_champs_detail@| @nom@ | @date@ | @duree@ | @fin_champs_detail@
You do not have to use every period: a variable missing from the template is simply ignored.
Email statistics (RTF)
The same table by period as above, without the detailed history: @titre_doc@, @titre_periode@, @periode_1@ … @periode_6@, @titre_nombre_1@ (total messages), @titre_nombre_2@ (appointment messages), @nombre_1_N@ and @nombre_2_N@.
- Type each placeholder in one go, without correcting it letter by letter or changing the font halfway through. Word sometimes splits an edited word into several invisible pieces, and the placeholder is then no longer recognised. If in doubt, delete it and type it again in full — or copy it from this article.
- Respect upper and lower case:
@Session@and@session@are not the same variable;${Nom}is not recognised. - RTF: nothing between
@debut_champs@and the first block is kept. Put the column headers before@debut_champs@, otherwise they disappear from the document. - Word:
${ligne}must be in a table row. Placed outside a table, it makes the certificate export fail. If you do not want any detail, simply remove${ligne}and the placeholders in its row. - A misspelt placeholder stays displayed as it is in the document: that is the best clue to a typo.
- Dates come out in dd/mm/yyyy format; a dash replaces a missing score or date.
- The time of a row is shown in hours and minutes ("2h 05"), the total time with its unit ("12h 35min").
- An
&or a<in a name does not break the Word document: values are escaped automatically. - The 2483 tax return appears in the list of RTF templates, but the platform does not reliably generate it: use a CSV export to prepare it instead.
- A Word or RTF certificate can also be sent by an automation ("Send a report" action); the account record and the statistics are only generated on demand.