credential-sheets - Account Credential Sheets Tool
[ [options] <CSV-file-1> [<CSV-file-2> [...]]
After mass import of user accounts (e.g. into LDAP) or mass creation of WiFi
voucher codes, most site administrators have to create information sheets (or
snippets) containing those new credentials (like username, password, policy of
With this tiny tool, providing these pieces of information to multiple users,
becomes really simple. Account data is taken from a CSV file and the sheets
are output as PDF using easily configurable LaTeX template files.
command accepts the following command line options:
- Display a help with all available command line options and
- Name of the template to use.
- Render <x> columns per sheet.
- Render <y> rows per sheet.
- Do create a ZIP file at the end.
- Alternative ZIP file name (default: name of parent
- Don't remove temporary files.
tool can handle any sort of column arrangement in
given CSV file(s). It expects the CSV file(s) to have column names in their
The given column names have to map to the "VAR-<column-name>"
placeholders in credential-sheets
's LaTeX templates.
The shipped-with templates "students" and "teachers" can
handle these column names:
-- The user account's login id (uid)
-- The user's last name(s)
-- The user's first name(s)
-- The user's password
-- The form name/ID (student template only)
-- Subjects taught by a teacher (teachers template only)
The shipped-with template "wifivouchers" can handle these column
-- The WiFi network's ESSID (network name)
-- The voucher´s login id (if any)
-- The voucher´s login code
-- The validity period of a voucher code
If you create your own templates, you can be very flexible in using your own
column names and template names. Only make sure that the column names provided
in the CSV file(s)'s first line match the variables used in the customized
LaTeX template. See below for details.
The shipped-with credential sheets templates are expected to be installed in
``/usr/share/credential-sheets/`` for system-wide installations. When
customizing templates, simply place a modified copy of any of those files into
``~/.credential-sheets/`` or ``/etc/credential-sheets/``. For further details,
tool uses these *configuration* files:
(LaTeX file header)
"teachers" and "wifivouchers" are provided on default
is extensible by defining your own template files, see below).
(LaTeX file footer)
Search paths for configuration files (in listed order):
You can easily customize the resulting PDF files generated with this tool by
placing your own template files, header and footer where appropriate.
This manual and the credential-sheets
tool itself has been written for
the Debian Edu project by Mike Gabriel