
- upload an Excel file with header and data rows
- validate each row against the form's validation rules
- import all valid data rows into the persistence layer
The feature is documented on the Orbeon Forms wiki and is currently available in nightly builds of Orbeon Forms.
For the curious programmer, the implementation is pretty neat and makes use of:
- Orbeon Forms's XSLT/XPL support to extract the Excel workbook data
- asynchronous XForms service calls to validate and extract data in the background
- background XForms to validate and import the data
- XForms for the user interface
What about csv import? That would have higher compatibility...
ReplyDeleteCSV import would be good as well, yes. Waiting for a sponsor at this point.
ReplyDelete