DGTLMS & LMSDISPATCHER Guide

Administration

Variables for Word and RTF templates

The full list of placeholders to put in a Word (.docx) or RTF template — certificate, account record, statistics — with a ready-to-copy example for each template.

Administrator~10 minutesIntermediate

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 formatPlaceholder syntaxExample
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

TemplateWord .docxRTF .rtfOne document per…
Certificate (certificate of attendance) and its copiesyesyeslearner
Account record (administrative record)noyeslearner
Login statisticsnoyesexport
Training time statisticsnoyesexport
Email statisticsnoyesexport

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 .docx or .rtf.
  • For custom fields: their number (1 to 20 for accounts), shown in Administration → Custom fields.

Steps

  1. Open the templates

    Analysis → Templates, Downloadable section.

  2. Duplicate the certificate

    click Duplicate next to the supplied certificate: you work on a copy, and the original stays intact.

  3. Download the Word sample

    open the copy with Edit, then click Download a sample Word template: it is a .docx that already contains all the placeholders.

  4. Lay it out in Word

    logo, colours, text, signature. Keep the ${…} placeholders where the data should appear.

  5. Upload the file

    go back to Edit, choose your .docx (or .rtf) in Template file (RTF or Word .docx), then Confirm.

  6. 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

PlaceholderReplaced byExample output
${nom}Learner's last nameMartin
${prenom}First nameClaire
${email}Email addressclaire.martin@example.com
${service}DepartmentHuman resources
${cpmb1} … ${cpmb20}Account custom field no. 1 to 20Employee ID 40127
${photo}Profile photo, as an image (empty if there is no photo)(image)
${date}Date of the export10/11/2026

Summary — calculated over all the sessions, courses or activities covered by the certificate.

PlaceholderReplaced byExample output
${temps}Total time spent12h 35min
${passages}Total number of attempts18
${avancement}Overall status: Not started, Ongoing, Completed, not validated or ValidatedValidated
${premiere_connexion}First login — course certificate only02/09/2026
${derniere_connexion}Last login — course certificate only28/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.

PlaceholderReplaced byExample output
${ligne}Title, indented to the right according to its levelExcel — the basics
${type}Session, Training course or ActivityTraining course
${score}Best score (a dash if none)85 %
${temps_ligne}Time spent on this item2h 05
${debut}Start date — session rows only01/09/2026
${fin}End date — session rows only31/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.

Body of the certificate (Word)
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:

Document produced
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.

VariableReplaced 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:

BlockRepeated 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

RTF template (text typed in Word, saved as .rtf)
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.
Document produced
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.

VariableReplaced 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)
Example account record
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.

VariableReplaced 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.

VariableReplaced 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
Example: login statistics
@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.

See also