database1Add my vote for this tag forms1Add my vote for this tag create new tag
, view all tags

Form Pivot Plugin

Statistics of values in a TWiki Form


Basic analysis of topics with TWiki Forms in a web. The analysis is done on form field values of topics that share a specific TWiki Form.

Syntax rules

%FORMPIVOT{ form="..." fields="..." type="grid|count" }%

Parameter Description Default
form Name of topic containing the form. Can be a "TopicName" or a "Web.TopicName". (required)
fields Name of fields to use, comma-space delimited. If fields is not specified, all fields in the form are used. (all form fields)
type="count" For each field, gives a break down of occurrence of values in sortable tables. type="count"
type="grid" There should be two fields, each square in the grid produced will be the count of those topics containing the two values e.g. Bug and High Priority. type="count"

Known Issues

This is a fairly simple initial implementation and probably doesn't yet deserve the designation of pivot.

Plugin Settings

Plugin settings are stored as preferences variables. To reference a plugin setting write %<plugin>_<setting>%, i.e. %FORMPIVOTPLUGIN_SHORTDESCRIPTION%

  • One line description, shown in the TextFormattingRules topic:
    • Set SHORTDESCRIPTION = Statistics of values in a TWiki Form

  • Set DEBUG to 1 to get debug messages in data/debug.txt. Default: 0
    • Set DEBUG = 0

Plugin Installation Instructions

  • Download the ZIP file from the Plugins web (see below)
  • Unzip FormPivotPlugin.zip in your twiki installation directory. Content:
    File: Description:
    data/TWiki/FormPivotPlugin.txt Plugin topic
    data/Sandbox/FormPivotTest*.txt Form pivot test topics
    lib/TWiki/Plugins/FormPivotPlugin.pm Plugin Perl module
  • Visit configure in your TWiki installation, and enable the plugin in the {Plugins} section.
  • Test if the plugin is correctly installed:

Plugin Info

Plugin Author: TWiki:Main.JohnTalintyre
Copyright: © 2002 TWiki:Main.JohnTalintyre
© 2007-2011 TWiki:TWiki.TWikiContributor
License: GPL (GNU General Public License)
Plugin Version: 2011-02-01
Change History:  
2011-02-01: TWikibug:Item6638: Fix for TWiki-5.0; many doc improvements; changing TWIKIWEBT to SYSTEMWEB -- TWiki:Main.PeterThoeny
2002-04-15: Initial version
TWiki Dependency: $TWiki::Plugins::VERSION 1.1
CPAN Dependencies: none
Other Dependencies: none
Perl Version: 5.005
TWiki:Plugins.Benchmark: GoodStyle nn%, FormattedSearch nn%, FormPivotPlugin nn%
Plugin Home: http://TWiki.org/cgi-bin/view/Plugins/FormPivotPlugin
Feedback: http://TWiki.org/cgi-bin/view/Plugins/FormPivotPluginDev
Appraisal: http://TWiki.org/cgi-bin/view/Plugins/FormPivotPluginAppraisal

Related Topics: FormPivotTest, FormPivotTestForm, TWikiPreferences, TWikiPlugins

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatmd5 FormPivotPlugin.md5 r5 r4 r3 r2 r1 manage 0.2 K 2011-02-02 - 06:50 PeterThoeny  
Compressed Zip archivetgz FormPivotPlugin.tgz r5 r4 r3 r2 r1 manage 6.5 K 2011-02-02 - 06:50 PeterThoeny  
Compressed Zip archivezip FormPivotPlugin.zip r6 r5 r4 r3 r2 manage 9.8 K 2011-02-02 - 06:50 PeterThoeny  
Unknown file formatEXT FormPivotPlugin_installer r3 r2 r1 manage 3.6 K 2011-02-02 - 06:50 PeterThoeny  
Edit | Attach | Watch | Print version | History: r12 < r11 < r10 < r9 < r8 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r12 - 2013-10-16 - PeterThoeny
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2018 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.