ConfiForms

Page tree

Versions Compared

Old Version 2

changes.mady.by.user Alex Medved

Saved on

compared with

New Version 3

changes.mady.by.user Alex Medved

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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)

...

Parameter nameValue
t

Could be:

  • csv
  • flatten.csv
  • xml
  • json
  • xls
  • text
  • flatten.xls


pageIdPage 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

Code Block
https://wiki.vertuna.com/ajax/confiforms/export.action?t=csv&pageId=8159450&fd=f:8159450&fields=mytf,mydf,mydate,mymf&filter=

result:

Code Block
My text field,My Dropdown Field,My date field,My multi field
hello export,one,"Jun 04, 2016",select B
confiforms tutorial,three,"Jun 07,2016",select A select C


to export date field as timestamp in CSV format and dropdown field's ID (not label)

Code Block
https://wiki.vertuna.com/ajax/confiforms/export.action?t=csv&pageId=8159450&fd=f:8159450&fields=mydf.id,mydate.timestamp&filter=

result:

Code Block
mydf.id,mydate.timestamp 
1,146501
3,146527
Info

For fields, you can use Virtual functions and format or transform the values as needed!

filterSame as ConfiForms Filters. To limit the exported dataset


Exports are not working for some users

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

Image Added

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

Image Added