Aller au contenu principal
Fil d'Ariane
Accueil
Administration
Structure
Webforms
Order 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
Votre nom et prénom
Votre nom et prénom
your_first_and_last_name
textfield
Mon email
Mon email
my_email
email
Votre référence devis
Votre référence devis
your_quote_reference
textfield
N° de devis
N° de devis
quote_number
textfield
Référence de commande
Référence de commande
order_reference
textfield
Order Number
Order Number
order_number
number
Ancienne commande
Ancienne commande
old_order
textfield
Quantité
Quantité
quantity
textfield
Votre référence en interne
Votre référence en interne
your_internal_reference
textfield
Votre commande est un réassort ?
Votre commande est un réassort ?
is_your_order_a_restock
textfield
Conditions d'emballage spéciales
Conditions d'emballage spéciales
special_packaging_conditions
textfield
Product Reference ID
Product Reference ID
product_reference_id
hidden
Commentaire
Commentaire
free_text_field
textarea
IMPORTER VOS FICHIERS
IMPORTER VOS FICHIERS
import_your_files
managed_file
J'enverrai mes fichiers plus tard
J'enverrai mes fichiers plus tard
my_files
checkbox
Un doute sur la compatibilité de votre fichier de personnalisation ? Pour 5 euros de plus, faites vérifier vos fichiers par notre Studio Design.
Un doute sur la compatibilité de votre fichier de personnalisation ? Pour 5 euros de plus, faites vérifier vos fichiers par notre Studio Design.
your_customization_file
checkbox
Address
Address
address
hidden
URL alias
URL alias
url_alias
hidden
User id
User id
user_id
hidden
Article
Article
article
hidden
Delivery mode
Delivery mode
delivery_mode
hidden
Estimated delivery date
Estimated delivery date
estimated_delivery_date
hidden
Production time
Production time
production_time
hidden
Follow my bags
Follow my bags
follow_my_bags
hidden
Reorder text
Reorder text
reorder_text
hidden
Created Date
Created Date
created_date
hidden
Status
Status
status
select
mproduct name
mproduct name
mproduct_name
hidden
tracking url
tracking url
tracking_url
hidden
total paid
total paid
total_paid
hidden
SF Retirement number
SF Retirement number
sf_retirement_number
hidden
SF Order ID
SF Order ID
sf_order_id
hidden
Order PDF Track
Order PDF Track
order_pdf_track
hidden
Order PDF
Order PDF
order_pdf
hidden
order uuid
order uuid
order_uuid
hidden
Date_imp_rative_de_livraison
Date_imp_rative_de_livraison
date_imp_rative_de_livraison
hidden
Order Type
Order Type
order_type
hidden
Payment Terms
Payment Terms
payment_terms
textfield
Delivery Address
Delivery Address
delivery_address
textarea
Manual Retirement Number
Manual Retirement Number
sf_manual_retirement_number
hidden
Supplier Name
Supplier Name
supplier_name
textfield
Margin Amount
Margin Amount
margin_amount
number
Margin Percentage
Margin Percentage
margin_percentage
number
Pricebook Name
Pricebook Name
pricebook_name
hidden
Transporter Info
Transporter Info
transporter_info
textfield
Prestashop Order ID
Prestashop Order ID
prestashop_order_id
hidden
num_ro_de_la_commande
num_ro_de_la_commande
num_ro_de_la_commande
hidden
file_upload_page_link
file_upload_page_link
file_upload_page_link
hidden
price_book
price_book
price_book
hidden
prix_price_book
prix_price_book
prix_price_book
hidden
standard_price_book
standard_price_book
standard_price_book
hidden
Bat PDF Url
Bat PDF Url
bat_pdf_url
hidden
Invoice PDF Download
Invoice PDF Download
invoice_pdf_download
hidden
Download options
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.