Look up CSV fields and export access data
CSV fields for import and download
The table lists the German and English headers. Only the first three fields are required. Optional columns may be omitted. When updating existing accounts, an empty cell can clear a value; check the preview. Blank photo selection fields keep the existing selection.
| German header | English header | Required | Description |
|---|---|---|---|
Gruppe* |
Group* |
Yes | Person’s group or class; up to 200 characters. |
Vorname* |
Firstname* |
Yes | First name of the photographed person; up to 100 characters. |
Nachname* |
Lastname* |
Yes | Last name of the photographed person; up to 100 characters. |
Geburtsdatum |
Birthdate |
No | Date of birth, e.g. 2018-05-23 or 23.05.2018; must not be in the future. |
ID |
ID |
No | Your own identifier, e.g. a student number; up to 50 characters. Must be unique among new accounts in the file. Existing accounts are matched by access code. |
Typ |
Type |
No | student or teacher; German values Schüler and Lehrer are also accepted. |
Einzelbild |
Individual-photo |
No | Individual photo selection: Yes/No. |
Gruppenbild |
Group-photo |
No | Group photo selection: Yes/No. |
Geschwisterbild |
Sibling-photo |
No | Sibling photo selection: Yes/No. |
Sonstiges-Bild |
Custom-photo |
No | Other photo selection, e.g. photos with friends: Yes/No. |
Eltern-Vorname |
Parent-firstname |
No | Primary contact’s first name; up to 100 characters. |
Eltern-Nachname |
Parent-lastname |
No | Primary contact’s last name; up to 100 characters. |
Eltern-E-Mail |
Parent-email |
No | Valid email address of the primary contact; up to 255 characters. |
Weiterer-Vorname |
Secondary-firstname |
No | Additional contact’s first name; up to 100 characters. Requires Secondary-email. |
Weiterer-Nachname |
Secondary-lastname |
No | Additional contact’s last name; up to 100 characters. Requires Secondary-email. |
Weitere-E-Mail |
Secondary-email |
No | Valid email address of an additional contact; up to 255 characters, different from the primary contact. |
Zugangscode |
Account-code |
No | Keep the existing code for updates; leave blank for new accounts. |
Aktiv |
Enabled |
No | Yes enables the account, No disables it. Blank or omitted: keep the current status. |
Beschreibung |
Description |
No | Free-text note about the account. |
Download access data as CSV
In the account overview, use Download CSV to export all access codes for the job, including jobs without a previous CSV import. The download is also available in the imported name list.
The CSV includes the existing person, parent and access fields plus all linked contact names and email addresses. Multiple contacts appear on separate lines within each cell; matching lines in the name and email columns describe the same contact. Additional columns contain order count, gross product revenue and currency, login count, last login (UTC) and photo count. Product revenue matches the account overview, excluding shipping and order discounts; test orders and backend previews are excluded. Disabled accounts are included.
On reimport, the additional contact and statistics columns are ignored. Existing parent columns contain the account’s current primary contact. Separate secondary-contact columns allow you to import an additional contact.
Additional download fields
These columns are included in the account download and ignored when importing it again.
| Field | Description |
|---|---|
| All contact names | Names of all linked contacts, one contact per line within the cell. |
| All contact emails | Email addresses in the same order as the contact names. |
| Orders | Number of qualifying orders for this account. |
| Product revenue gross | Gross product revenue for this account, excluding shipping and order discounts. |
| Currency | Currency of the product revenue, e.g. EUR. |
| Logins | Number of recorded shop logins; backend previews are excluded. |
| Last login (UTC) | Time of the last login in UTC; blank if there has been no login. |
| Photo count | Number of photos assigned to the account, excluding hidden, deleted or trashed photos. |
Secondary contact through CSV
Use the optional secondary-email, secondary-firstname and secondary-lastname columns to import another contact per access code. German headers (Weitere-E-Mail, Weiterer-Vorname, Weiterer-Nachname) are also accepted. The email must differ from the primary contact. Reimporting the same email updates that contact; empty values preserve existing contacts. A different email adds another contact. Use the contact editor to replace or delete contacts. The export includes one secondary contact, sorted by email when several exist; the statistics export continues to show all contacts. The example files include the new columns.