If there is an actual version of the download file, it is offered as a download link. Otherwise, the button Create appears and the file will be created.
The file is an Excel workbook saved in XML format. It contains two worksheets: Invited with invited Visitors and Invitation with the Invitation Text.
The Invited worksheet contains columns with the Visitors' ID, Name, Mail, Language, formatted Mail address and a personalized Enquette link.
The Invitation worksheet contains the ID and all language versions of the Invitation Layer Text (see Enquette Layers) set in the Invite part.
You can use this data to send personalized invitations by other means than the Enquette's Invite mechanism. And even if there are no invited Visitors and no Invitation text selected, the empty file is a good template for uploading.
The upload file has to be an Excel Xml file (Office Open XML). A previously downloaded one is a suitable template.
The file may contain a list of invited visitors in the worksheet named Invited and / or the Invitation Text in the worksheet named Invitation. Any other worksheet is ignored.
The Invited worksheet, if present, has to contain field names in the first row. Only following fields (in any order) take effect, any other column is ignored:
- visitor_name: obligatory
- visitor_mail: obligatory
- visitor_language: optional. The ISO code of one of installed languages (e.g. "en-GB", "de-DE" etc., case insensitive). This is the language the Visitor will receive his invitation in. If there is no language set or the language isn't installed, the invitation comes through in the admin's language.
- visitor_id: optional. If the visitor_id is set, the corresponding Visitor will be invited (if exists) and the rest of data is ignored. In other cases, the Visitor is searched for by visitor_mail. If not found, a new Visitor with visitor_name is created.
Beware using sheets with visitor_id from other sites, as it denominates foreign Visitors. Delete or clear the column in such case.
The Invitation worksheet, if present, has to contain following names in the first row and following data in the second row:
- ttext_id: optional. If the file originates in the same site and in the same Enquette and ttext_id in the second row is set, the corresponding Layer Text (if exists) is taken. In other cases, a new Layer Text is created.
- ISO language codes in the first row and corresponding text language versions in the second row.
Note: the uploaded data takes effect only after the Enquette is saved. Do not Invite Visitor before saving it, as there are no valid links for new Visitors yet.
You can discard the upload any time selecting Cancel on the Enquette's Tool bar.