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

Introduction

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 Action Size Date Who Comment
Unknown file formatmd5 FormPivotPlugin.md5 manage 0.2 K 2011-02-02 - 06:50 PeterThoeny  
Compressed Zip archivetgz FormPivotPlugin.tgz manage 6.5 K 2011-02-02 - 06:50 PeterThoeny  
Compressed Zip archivezip FormPivotPlugin.zip manage 9.8 K 2011-02-02 - 06:50 PeterThoeny  
Unknown file formatEXT FormPivotPlugin_installer manage 3.6 K 2011-02-02 - 06:50 PeterThoeny  
Topic revision: r11 - 2011-08-23 - PeterThoeny
 
Twitter Delicious Facebook Digg Google Bookmarks E-mail LinkedIn Reddit StumbleUpon    
  • Download TWiki
TWiki logo Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2012 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.