ConfiForms

Page tree

Versions Compared

Old Version 6

changes.mady.by.user Alex Medved

Saved on

compared with

New Version 7

changes.mady.by.user Alex Medved

Saved on

Key

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

...

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

...

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
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:

Code Block
headers=My ID,Column2

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 

Image Added 


Exports are not working for some users

...