The spreadsheet must have an initial header row identifying the
columns. Casing of the header labels does not matter. Ordering
of the columns does not matter. Columns may be omitted, except
as noted below. Any column with a blank header is ignored.
Columns from a DragonForce user export spreadsheet not used by
the QR generator are ignored.
Each subsequent row provides the data for generating one
card. Any given row may have a value for all or a subset of the
columns.
Available data columns are:
Server
The DragonForce instance's domain
name. "Hostname" and "Host Name" are also accepted. This
column is required and all rows must have a value if a
default server is not provided in the form above.
Username
An account identifier. "User Name" is
also accepted.
Password
An account secret. A username is
required for the row if a password is set.
Department
Purely informational organizational
label to display on the card. There is not necessarily a
connection between the label shown on the card and the user's
active department once logged in. "Team" is also
accepted.
Alias
Purely informational human-oriented name to
display on the card. There is not necessarily a connection
between the label shown on the card and the user's alias once
logged in. "Display Name" is also accepted.
First Name
Purely informational human-oriented
name to display on the card. There is not necessarily a
connection between the label shown on the card and the user's
first name in their profile once logged in.
Last Name
Purely informational human-oriented
name to display on the card. There is not necessarily a
connection between the label shown on the card and the user's
first name in their profile once logged in.
Email
Purely informational human-oriented email
address for the user. This is not shown on the generated QR
cards but is included in the CSV output.
If Alias is not set, then the display name is constructed from
either or both of First Name and Last Name if present. If none
of those are provided then the username, if present, is taken as
the display name.