Orbeon Forms
  • Getting started
  • Installation
    • Logging
    • Configuration banner
    • Docker
    • Azure
    • Tomcat
    • WildFly
    • WebSphere
    • WebLogic
    • GlassFish
    • Caches
    • Replication
    • Upgrading
  • Configuration
    • Properties
      • General
        • HTTP client
      • Form Runner
        • Detail page
          • Attachments
          • Email
          • PDF
          • Table of contents
        • Persistence
        • Summary page
      • Form Builder
      • XForms
    • Advanced
      • Workflows
      • Session management
      • State handling
      • Client-side error handling
      • Clustering and High Availability
      • Configuring a Form Runner eXist database
      • Creating a production WAR
      • Environments
      • JavaScript and CSS assets
      • Limiter filter
      • Run modes
      • Security
        • Content-Security-Policy header
      • SAP Hybris Module
      • XForms logging
    • Troubleshooting
      • Troubleshooting with the orbeon.log
      • Memory and threads
      • Relational database logging
      • Misc
  • Form Builder
    • Form settings
      • Time window
    • Form editor
      • Form area
      • Toolbox
      • Buttons bar
      • Control settings
      • Dependent fields and sections
      • Validation
      • Choices editor
      • Publishing
      • Cut, copy and paste
      • Section and grid settings
      • Section settings
      • Grid settings
      • Quick control search
      • Repeat settings
      • Repeated grids
      • Undo and redo
      • Keyboard shortcuts
    • Formulas
      • Examples of formulas
      • Formulas inspector
      • Formulas console
    • Summary page
    • Form localization
    • Advanced
      • Edit source
      • Services and actions
        • HTTP services
        • Database services
        • Simple Actions
        • Action Syntax
        • Action Syntax examples
        • Synchronizing repeated content
      • Testing a form in web mode
      • Testing PDF production
      • Testing offline functionality
      • Email settings
      • Field-level encryption
      • Messages
      • Section templates
      • Template syntax
      • XML Schemas support
      • Extensibility
        • Extension API
        • Integration
        • Toolbox component metadata
  • Form Runner
    • Overview
      • Terminology
    • Pages
      • Landing page
      • Published Forms page
      • Forms Admin page
      • Summary page
    • Components
      • Alert dialog
      • Attachment
      • Autocomplete
      • Captcha
      • Character counter
      • Checkbox input
      • Currency
      • Date
      • Dropdown date
      • Static and dynamic dropdown
      • Error summary
      • Grid
      • Handwritten signature
      • Hidden field
      • Image
      • Image annotation
      • Image attachment
      • Number
      • Open selection
      • Repeater
      • Formatted Text / Rich Text Editor
      • Section
      • Single-selection tree
      • Source code editor
      • Time
      • US phone
      • US state
      • Video
      • Video attachment
      • Wizard
      • XForms inspector
      • Yes/No answer
    • Features
      • Automatic calculations dependencies
      • Datasets
      • Excel and XML import
      • Excel and XML export
      • Summary page Excel Export
      • Form definitions and form data Zip Export
      • Purging historical data
      • Lease
      • Localization
      • Supported languages
      • Mobile support
      • Multitenancy
      • Form Runner navigation bar
      • PDF production
        • Automatic PDF
        • Automatic PDF header and footer configuration
        • PDF templates
      • Responsive design
      • Revision history
      • S3 storage
      • Simple data migration
      • TIFF production
      • Versioning
      • Wizard view
      • Workflow stage
    • Persistence
      • Using a relational database
      • Relational database schema
      • Purging old data using SQL
      • Auditing
      • Autosave
      • Database support
      • Flat view
    • Linking and embedding
      • Linking
      • Java Embedding API
      • JavaScript Embedding API
      • Liferay full portlet
      • Liferay proxy portlet
      • Securing Form Runner access
      • Form Runner offline embedding API
      • Angular component
      • React component
    • Access control and permissions
      • Users
      • Login & Logout
      • Deployed forms
      • Form fields
      • Editing forms
      • Owner and group member
      • Organizations
      • Scenarios
      • Token-based permissions
    • Styling
      • CSS
      • Grids CSS
      • Automatic PDF styling and CSS
    • APIs
      • Authentication of server-side service APIs
      • Persistence API
        • CRUD API
        • Search API
        • List form data attachments API
        • Form Metadata API
        • Lease API
        • Reindexing API
        • Caching
        • Versioning
        • Revision History API
        • Zip Export API
        • Custom persistence providers
      • Other APIs
        • Connection context API
        • Duplicate form data API
        • File scan API
        • Form Runner JavaScript API
        • Generate XML Schema API
        • PDF API
        • Publish form definition API
        • Run form in the background API
      • Data formats
        • Form data
        • Date and time
        • Form definition
    • Architecture and integration
      • Architecture
      • Access form data
      • Integration
    • Advanced
      • Buttons and processes
        • Simple process syntax
        • Core actions
        • Form Runner actions
          • Save action
          • Send action
          • Email action
        • XForms actions
        • Predefined buttons, processes and dialogs
        • Summary page buttons and processes
      • Custom dialogs/model logic
      • Services
      • Singleton form
      • Monitoring HTTP requests
  • XForms
    • Core
      • Attribute Value Templates (AVTs)
      • Binds
      • Validation
      • Variables
      • Keyboard focus
      • XForms JavaScript API
      • Error handling
        • Detailed behavior
      • Model-Bind variables
      • XForms 2.0 support
    • Events
      • Standard support
      • UI refresh events
      • Keyboard events
      • Extension events
      • Extension context information
      • Other event extensions
    • Actions
      • Repeat, insert and delete
      • Scripting actions
      • Extensions
    • Controls
      • Label, hint, help
      • Input
      • Output
      • Text area
      • Button
      • Upload
      • Dialog
    • Submission
      • Standard support
      • JSON support
      • Asynchronous submissions
      • Caching extension
      • Other submission extensions
    • XPath
      • Type annotations
      • Expression analysis
      • Tips
      • Compatibility
      • Standard functions
      • Maps and arrays Functions
      • Extension functions
        • Core functions
        • Utility functions
        • Model functions
        • Controls functions
        • XML functions
        • JSON functions
        • HTTP functions
        • Form Runner functions
        • Other functions
        • Deprecated functions
    • XBL components
      • FAQ
      • Guide
        • XBL Tutorial
        • Bindings
        • XForms models
        • Including content
        • Event handling
        • Conventions
        • Map XBL example
        • Learning from existing components
      • Advanced topics
        • XBL Modes
        • JavaScript companion classes
        • XBL library
        • Extensions
        • Attachment controls
    • XForms tutorial
      • Introduction
      • Installation
      • The Hello application
      • The Bookcast application
        • The basic app
        • Database access
        • Polishing the app
        • Adding a feed
    • Using XForms from Java apps
  • XML Platform
    • Page Flow Controller
      • Basics
      • XML submission
      • Navigating between pages
      • Paths and matchers
      • Other configuration elements
      • Typical combinations of page model and page view
      • Examples
      • Authorizing pages and services
    • Processors
      • URL generator
      • Request generator
      • PDF to image converter
    • Resources
      • Resource managers
      • Setting up an external resources directory
    • Other
      • Binary and text documents
  • FAQ
    • Licensing
    • PE and Dev Support
    • Form Builder and Form Runner
    • Resources and support
    • Other technical questions
  • Contributors
    • Automated tests
    • Building Orbeon Forms
    • Localizing Orbeon Forms
    • Validation functions
    • Contributor License Agreement
  • Release notes
    • Orbeon Forms 2022.1.9
    • Orbeon Forms 2024.1.1
    • Orbeon Forms 2023.1.7
    • Orbeon Forms 2024.1
    • Orbeon Forms 2023.1.6
    • Orbeon Forms 2023.1.5
    • Orbeon Forms 2021.1.11
    • Orbeon Forms 2022.1.8
    • Orbeon Forms 2023.1.4
    • Orbeon Forms 2023.1.3
    • Orbeon Forms 2023.1.2
    • Orbeon Forms 2022.1.7
    • Orbeon Forms 2023.1.1
    • Orbeon Forms 2023.1
    • Orbeon Forms 2022.1.6
    • Orbeon Forms 2021.1.10
    • Orbeon Forms 2022.1.5
    • Orbeon Forms 2021.1.9
    • Orbeon Forms 2022.1.4
    • Orbeon Forms 2022.1.3
    • Orbeon Forms 2021.1.8
    • Orbeon Forms 2022.1.2
    • Orbeon Forms 2022.1.1
    • Orbeon Forms 2022.1
    • Orbeon Forms 2021.1.7
    • Orbeon Forms 2021.1.6
    • Orbeon Forms 2021.1.5
    • Orbeon Forms 2021.1.4
    • Orbeon Forms 2021.1.3
    • Orbeon Forms 2021.1.2
    • Orbeon Forms 2021.1.1
    • Orbeon Forms 2021.1
    • Orbeon Forms 2020.1.6
    • Orbeon Forms 2019.2.4
    • Orbeon Forms 2019.1.2
    • Orbeon Forms 2018.2.5
    • Orbeon Forms 2018.1.4
    • Orbeon Forms 2020.1.5
    • Orbeon Forms 2020.1.4
    • Orbeon Forms 2020.1.3
    • Orbeon Forms 2020.1.2
    • Orbeon Forms 2019.2.3
    • Orbeon Forms 2020.1.1
    • Orbeon Forms 2020.1
    • Orbeon Forms 2019.2.2
    • Orbeon Forms 2019.2.1
    • Orbeon Forms 2019.1.1
    • Orbeon Forms 2019.2
    • Orbeon Forms 2019.1
    • Orbeon Forms 2018.2.4
  • Release history
  • Use cases
  • Product roadmap
  • Index of features
Powered by GitBook
On this page
  • Availability
  • Context
  • How to use the feature
  • Locations
  • Exporting from the Form Builder Detail page
  • Exporting from the Form Runner Summary and Detail pages
  • Formats
  • Excel with named ranges format
  • Introduction
  • Named ranges
  • Repeated content
  • Lists of choices
  • Limitations
  • XML with form structure and data format
  • Introduction
  • Format of the XML document
  • Exporting through a service call
  • See also
  1. Form Runner
  2. Features

Excel and XML export

PreviousExcel and XML importNextSummary page Excel Export

Last updated 8 months ago

Availability

This is an Orbeon Forms PE feature.

Context

Orbeon Forms includes a few ways to export form definitions and form data. This page documents a very specific capability: exporting a form definition, optionally alongside a single piece of form data, in Excel or XML format, appropriate for the data into Orbeon Forms at a later time.

For a different type of export, see also .

How to use the feature

Locations

You can export using an "Excel Export" or "XML Export" button from the following locations:

Page
Data Included

Form Builder

No

Yes

Form Runner Detail page

Yes

Exporting from the Form Builder Detail page

With Form Builder, the Excel Export button is available by default. You can control its availability with the following property, by adding the excel-export button token. We show here the default value of this property for Orbeon Forms 2023.1:

<property as="xs:string"  name="oxf.fr.detail.buttons.orbeon.builder">
    home
    summary
    new
    form-definition-xhtml-export|excel-export|xml-export
    test|test-pdf|test-offline|test-formulas
    publish
    save
</property>

Note the | which denotes combined buttons.

Exporting from the Form Runner Summary and Detail pages

<property as="xs:string"  name="oxf.fr.summary.buttons.*.*">
    home review pdf delete duplicate excel-export new
</property>

Detail page:

<property as="xs:string"  name="oxf.fr.detail.buttons.*.*">
    summary clear pdf excel-export wizard-toc wizard-prev wizard-next save-final review
</property>

In addition, you must set the following property to enable export with data on the Summary and Detail pages:

<property
    as="xs:boolean"
    name="oxf.fr.export.page.enable.*.*"
    value="true"/>

The reason for this extra setting is that, even if the user has read access to the form, exporting a form in Excel or XML format can reveal some hidden data.

Formats

Form Runner can export in two formats:

  • excel-named-ranges : Excel document containing the structure of the form, using named ranges (see below) to map form controls to cells

  • xml-form-structure-and-data: XML document with indications about the form structure, alongside XML data

In each case, when form data is requested, the export is done on the basis of a single document.

Excel with named ranges format

Introduction

The Excel document contains all the fields of the form, attempting to mirror the layout of the original form. This includes section titles and field labels.

The export feature produces an Excel document that look like this:

Named ranges

Orbeon Forms includes, in the generated Excel document, so-called named ranges which match the control names assigned in Form Builder. This allows reimporting data in those cells during a subsequent import.

Excel names do not support all the characters supported in Form Runner names. In addition, Excel has some very specific and poorly documented rules for name ranges for names that look like cell references. Such names are modified by Orbeon Forms when needed with an _ prefix. The following shows some modification that are performed by Orbeon Forms:

Original Name
Modified Name

C

_C

c

_c

R

_R

r

_r

B1

_B1

C1_FOO

_C1_FOO

C123456

_C123456

AA1

_AA1

AAA1

_AAA1

Excel allows you to see the name of a given cell or range:

Repeated content

In the case of repeated grids, groups of cells share the same name.

Repeated grids, or repeated sections containing only non-repeated grids, are "flattened". That is, all form controls are presented in a single Excel row, with one row for each repetition.

Lists of choices

Lists of choices are exported as text, showing the value of the choice between parentheses, and the label next to it.

When importing, the cell value must contain the value of the choice, not the label.

Multiple-selection controls require entering the values as a space-separated list of tokens.

Limitations

As available in Orbeon Forms 2021.1, the new Excel export feature has the following limitations:

  • The 24-column mode is not supported.

  • Dynamic list of choices (for example dynamic dropdowns) are not supported.

  • Nested repeats are not supported.

  • Repeated grids or sections are always flattened.

  • Section templates are not supported.

  • Some form controls are not supported, including:

    • Formatted Text

    • Handwritten Signature

    • Attachments

  • No calculations or validations are exported.

XML with form structure and data format

Introduction

This format exports an XML document with the form structure and the data.

Format of the XML document

The XML document is structured as follows (with ... indicating omitted content).

<orbeon-export
    export-date="2024-04-26T23:50:35.423Z"
    export-lang="en"
    export-format-version="2021.1">
  <form-metadata>
    <application-name>acme</application-name>
    <form-name>contact</form-name>
    <title>ACME Contact Form</title>
    <description>The Contact form is a simple form which can be created in a few minutes with Form Builder.</description>
  </form-metadata>
  <form-structure>
    <section name="contact">
      <label>Contact Information</label>
      <grid name="grid-1">
        <control name="first-name" required="true" datatype="string" control-type="xf:input">
          <label>First Name</label>
          <hint>Your first or given name</hint>
        </control>
        <control name="last-name" required="true" datatype="string" control-type="xf:input">
          <label>Last Name</label>
          <hint>Your last name</hint>
        </control>
        ...
      </grid>
    </section>
    ...
  </form-structure>
  <form-data>
    <form xmlns:fr="http://orbeon.org/oxf/xml/form-runner"
          fr:data-format-version="2019.1.0">
      <contact>
        <grid-1>
          <first-name/>
          <last-name/>
          <email/>
          <phone/>
        </grid-1>
      </contact>
      <message>
        <grid-2>
          <order-number/>
          <topic/>
        </grid-2>
        <grid-3>
          <comments/>
        </grid-3>
      </message>
    </form>
  </form-data>
</orbeon-export>

The XML document contains the following sections:

  • orbeon-export: root element

    • export-date attribute: date and time of the export

    • export-lang attribute: language of the form at the time of the export

    • export-format-version attribute: version of the export format

    • form-metadata: enclosing element for form metadata

      • application-name: application name

      • form-name: form name

      • title: form title

      • description: form description

    • form-structure: enclosing element for the structure of the form

      • section: form section

        • label: section label

        • grid: grid in the section

          • control: control in the grid

            • label: control label

            • hint: control hint

    • form-data: enclosing element for the form data

Exporting through a service call

See also

Form Runner

With Form Runner, you can enable the export button with the following properties, by including the same excel-export button token. :

The Excel export feature is aimed at organizations whose users are familiar with Excel spreadsheets. Users can export a form to a spreadsheet and fill it out on their computers. They can pass the spreadsheet around for other users to complete it. When they are done, they can the resulting spreadsheet back to Orbeon Forms, where the data is captured, validated, shown to the user for review, and then saved to the Orbeon Forms database.

For more about the import feature, see .

The purpose of this export is to allow you to save the form data in a format that can be reimported into Orbeon Forms at a later time. The form structure is included to provide context for the data. It doesn't replace the form definition as you can seen in Form Builder's Edit Source as well as .

The form-data section contains the form data in the version indicated by the fr:data-format-version attribute, see .

You can also export to Excel and XML .

Blog post:

[SINCE Orbeon Forms 2021.1]
importing
Form definitions and form data Zip Export
Summary page
import
Excel and XML Import
Form Definition Format
Form data format
Excel export and import
Excel and XML Import
Summary page Excel Export
Form definitions and form data Zip Export
Service calls
Summary page
through a service call
Example of Excel export
Named ranges in Excel
Repeated grid in Excel