Table of Contents |
---|
Export formats
ConfiForms provides a way to export data in 4 different formats (or in 6 if you count flattened views as separate types)
...
Exported as XML
Code Block |
---|
<?xml version="1.0" encoding="UTF-8"?>
<list>
<entry>
<id>f4ea4796-0dd2-455c-a1b4-926209260a02</id>
<recordId>1</recordId>
<ownedBy>sash</ownedBy>
<createdBy>sash</createdBy>
<created>1465197019719</created>
<deleted>0</deleted>
<fields class="fields">
<mytf>hello export</mytf>
<mydf>1</mydf>
<mydate>1465012800000</mydate>
</fields>
</entry>
<entry>
<id>66cee179-2f33-4fd1-b8b8-bb889043e06f</id>
<recordId>2</recordId>
<ownedBy>sash</ownedBy>
<createdBy>sash</createdBy>
<created>1465197038331</created>
<deleted>0</deleted>
<fields class="fields">
<mytf>confiforms tutorial</mytf>
<mydf>3</mydf>
<mydate>1465272000000</mydate>
</fields>
</entry>
</list> |
...
See last 2 rows, they are practically identical with one exception, last field: each selection for multi-select field is on on it's own row
What if I need internal or transformed data in CSV/Excel format?
This is also possible, but will require a bit of custom work
Consider how the link to export data is constructed in form AdminUI (but also in other views where export is enabled)
Code Block |
---|
Version 2.18.15 and later
https://wiki.vertuna.com/plugins/servlet/confiform/export?t=csv&pageId=8159450&fd=f:8159450&fields=&filter=
Version 2.18.14 and older
https://wiki.vertuna.com/ajax/confiforms/export.action?t=csv&pageId=8159450&fd=f:8159450&fields=&filter= |
...
Parameter name | Value | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
t | Could be:
| ||||||||||||
pageId | Page Id of the page where ConfiForms is configured | ||||||||||||
fd | form name and again page ID where form is defined (some backward compatibility parameter, but still is required). It sould be given in a format formname:pageId In the example above we have a form named "f" and it is located on the page with id "8159450" | ||||||||||||
fields | Field names to export. This is interesting, as you can limit the fields in your export and also use the techniques from Accessing field values and properties to customize the export. For example: to export just user-defined fields, without metadata fields
result:
to export date field as timestamp in CSV format and dropdown field's ID (not label)
result:
| ||||||||||||
filter | Same as ConfiForms Filters. To limit the exported dataset | ||||||||||||
headers | Since ConfiForms version 2.15.3 you can supply the "headers" parameter as comma separated list of names to use for headers in exported CSV/Excel file Quick example:
| ||||||||||||
sort
| Sorting in ConfiForms | ||||||||||||
limit
| Numeric value to limit the number of records returned. Missing parameter or limit=0 sets the limit to "no limit" |
Customising exports via ConfiForms Views
Same customizations as explained in the table above for "fields" parameter could be managed/configured on ConfiForms views (TableView, CardView, ListView, etc) macros using
Exports are not working for some users
Excerpt |
---|
For form non-admin users (see here who is form administrator and who is not - Confluence page permissions and ConfiForms) you need to explicitly allow data exports. This is a security measure to prevent forms data from being exported by anyone when you dont't want to. To enable exports for non admin users you need to allow exports in the Form Definition for your form And then you can enable the option to export the data in the corresponding views For example, this is how you do it for the ConfiForms TableView |