Aller au contenu principal
Fil d'Ariane
Accueil
Administration
Structure
Webforms
Registration Form
Onglets principaux
Voir
Tester
Results
Build
Paramètres
References
Onglets secondaires
Submissions
Téléchargement
Clear
The
Download
page allows a webform's submissions to be exported into a customizable CSV (Comma Separated Values) file and other common data formats.
Format options
Export format
?
Delimited text
HTML Table
JSON documents
YAML documents
Delimited textExports results as delimited text file.HTML TableExports results as an HTML table.JSON documentsExports results as JSON documents.YAML documentsExports results as YAML documents.
Message d'avertissement
Warning:
Opening
Delimited text
files with spreadsheet applications may expose you to
formula injection
or other security vulnerabilities. When the submissions contain data from untrusted users and the downloaded file will be used with Microsoft Excel, use the
Webform XLSX export
module.
Delimiter text format
?
Comma (,)
Tab (\t)
Semicolon (;)
Colon (:)
Pipe (|)
Period (.)
Space ( )
This is the delimiter used in the CSV/TSV file when downloading webform results. Using tabs in the export is the most reliable method for preserving non-latin characters. You may want to change this to another character depending on the program with which you anticipate importing results.
Generate Excel compatible file
?
If checked, the generated file's carriage returns will be compatible with Excel and a marker flagging the data as UTF-8 will be added at the beginning.
Message d'avertissement
Warning:
Opening
HTML Table
files with spreadsheet applications may expose you to
formula injection
or other security vulnerabilities. When the submissions contain data from untrusted users and the downloaded file will be used with Microsoft Excel, use the
Webform XLSX export
module.
Open HTML table in Excel
?
If checked, the download file extension will be change from .html to .xls.
Nom du fichier
?
Used to create unique file names for exported submissions.
Nom du fichier
?
Used to create unique file names for exported submissions.
Element options
Element multiple values delimiter
?
Semicolon (;)
Comma (,)
Pipe (|)
Period (.)
Space ()
The delimiter used when an element has multiple values.
Header options
Column header format
?
Element titles (label)
Element keys (key)
Choose whether to show the element label or element key in each column header.
Include an element's title with all sub elements and values in each column header
Column header label delimiter
Column header key delimiter
Select menu, radio buttons, and checkboxes options
Options single value format
?
Compact, with the option values delimited by commas in one column.
?
Separate, with each possible option value in its own column.
?
Elements that collect a single option value include select menus, radios, and buttons.
Options multiple values format
?
Compact, with the option values delimited by commas in one column.
?
Separate, with each possible option value in its own column.
?
Elements that collect multiple option values include multi-select, checkboxes, and toggles.
Options item format
Option labels, the human-readable value (label)
Option values, the raw value stored in the database (key)
Entity reference options
Entity reference format
ID, an entity's unique identified
Title, an entity's title/label
URL, an entity's URL
Column options
?
The selected columns will be included in the export.
Titre
Nom
Date type/Element type
Serial number
Serial number
serial
integer
Submission ID
Submission ID
sid
integer
Submission UUID
Submission UUID
uuid
uuid
Jeton (token)
Jeton (token)
token
string
Submission URI
Submission URI
uri
string
Créé
Créé
created
created
Terminé
Terminé
completed
timestamp
Modifié
Modifié
changed
changed
Is draft
Is draft
in_draft
boolean
Page courante
Page courante
current_page
string
Remote IP address
Remote IP address
remote_addr
string
Submitted by
Submitted by
uid
entity_reference
Langue
Langue
langcode
language
Webform
Webform
webform_id
entity_reference
Submitted to: Entity type
Submitted to: Entity type
entity_type
string
Submitted to: Entity ID
Submitted to: Entity ID
entity_id
string
Verrouillé
Verrouillé
locked
boolean
Sticky
Sticky
sticky
boolean
Notes
Notes
notes
string_long
Metatags (Hidden field for JSON support)
Metatags (Hidden field for JSON support)
metatag
metatag_computed
Email professionnel
Email professionnel
professional_email
email
J’accepte de recevoir des informations au sujet des produits et services AHK (vous pouvez vous désinscrire à tout moment).
J’accepte de recevoir des informations au sujet des produits et services AHK (vous pouvez vous désinscrire à tout moment).
terms_checkbox
checkbox
Prénom
Prénom
first_name
textfield
Nom
Nom
name
textfield
Société
Société
company
textfield
Numéro de téléphone
Numéro de téléphone
phone_number
tel
Effectif société
Effectif société
company_workflow
select
Fonction
Fonction
department_value
select
Pays
Pays
country
select
Message
Message
message
textarea
Ajouter une pièce jointe
Ajouter une pièce jointe
add_some_files_info
hidden
Ajouter une pièce jointe
Ajouter une pièce jointe
file_upload
managed_file
Password
Password
password
hidden
user_sid
user_sid
user_sid
hidden
User id
User id
user_id
hidden
GTC Accept Value
GTC Accept Value
gtc_accept_value
hidden
GTC Content Version
GTC Content Version
gtc_content_version
hidden
GTC Accept IP Address
GTC Accept IP Address
gtc_accept_ip_address
hidden
GTC Accept Timestamp
GTC Accept Timestamp
gtc_accept_timestamp
hidden
Précédent
Précédent
preview
hidden
Suivant
Suivant
next
hidden
N° de TVA
N° de TVA
vat_n
hidden
Téléphone Portable
Téléphone Portable
mobile_phone
hidden
Adresse 1
Adresse 1
address_1
hidden
Adresse 2
Adresse 2
address_2
hidden
Code postal
Code postal
zip_code
hidden
Ville
Ville
city
hidden
Customer Discount
Customer Discount
customer_discount
hidden
Owner Name
Owner Name
owner_name
hidden
Owner Phone
Owner Phone
owner_phone
hidden
Owner email
Owner email
owner_email
hidden
ERP Customer ID
ERP Customer ID
erp_customer_id
hidden
SF Account ID
SF Account ID
sf_account_id
hidden
SF Contact ID
SF Contact ID
sf_contact_id
hidden
AHK personalized Url
AHK personalized Url
ahk_personalized_url
hidden
PS Customer ID
PS Customer ID
ps_customer_id
hidden
siret
siret
siret
hidden
pricebook
pricebook
pricebook
hidden
pricebookId
pricebookId
pricebookid
hidden
payment_days
payment_days
payment_days
hidden
distributor_gateway_company_name
distributor_gateway_company_name
distributor_gateway_c
hidden
Account Source
Account Source
account_source
hidden
SF Account Name
SF Account Name
sf_account_name
hidden
Delivery conditions
Delivery conditions
delivery_conditions
hidden
User Status
User Status
user_status
hidden
Download options
Download export file
?
If checked, the export file will be automatically download to your local machine. If unchecked, the export file will be displayed as plain text within your browser.
Download uploaded files
?
If checked, the exported file and any submission file uploads will be download in the archive file.
Limit to
Tout
Latest
Submitted by
Langue
Submission number
Submission ID
Date de création
Completed date
Date de modification
Number of submissions
Utilisateur
Chargement...
Langue
- Sélectionner -
Anglais
French
German
A partir de
À
A partir de
À
A partir de
À
A partir de
À
A partir de
À
Ordre
?
Trier par ordre croissant
Trier par ordre décroissant
Order submissions by ascending (oldest first) or descending (newest first).
Starred/flagged submissions
?
If checked, only starred/flagged submissions will be downloaded. If unchecked, all submissions will downloaded.