Skip to content
Bilderladen Help Center Florian & AnniContact support

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.

All articles in this topic