Tags:
automation2Add my vote for this tag graphing2Add my vote for this tag tables2Add my vote for this tag twiki_application2Add my vote for this tag create new tag
, view all tags

FluidPivotsPlugin

Create pivot and datapilot tables from TWiki tables

Introduction

This plugin create a table (pivot, datapilot) that show information in a usefully way. It will generate a new table from an origin table with the correlate data of two of his columns. It's work similar to DataPilot on OpenCalc.

Syntax Rules

  • The %FLUIDPIVOTS{...}% variable gets expanded to a table.
    %FLUIDPIVOTS% Parameter Comment Default
    name The name of the new table created. "pivot"
    table Name of the source table. None; is required for all the tables
    web The web in which to find topic (specified below) in which to find the TWiki tables The current web
    topic The topic in which to find the TWiki tables The current topic
    rows Name of the column in the source table that it will represents the rows of the new table None; is required for all the tables
    columns Name of the column in the source table that it will represents the columns of the new table None; is required for all the tables
    data Name of the column in the source table that it will represents the data of the new table None; is required for all the tables
    operation Define the operation to process the data. (count,sum,average,max,min,var,dev) "count"
    visible Define what portion of the table should be visible.(data,col,row,all) "all"
    maxcol Define the maximum number of columns, grouping the less significant data in an unique column. "0"
    maxrow Define the maximum number of rows, grouping the less significant data in an unique row. "0"
    order Set how will be ordered the data (max,min,off) "max"
    cachetime Set the time in seconds that it will reside the cache. "0"
    ignorecache Set a maximum time to cache, after this time the table is regenerated even if data is unchanged. "1209600"

Plugin Settings

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

  • One line description, is shown in the TextFormattingRules topic:
    • Set SHORTDESCRIPTION = Create pivot and datapilot tables from TWiki tables

  • Debug plugin: (See output in data/debug.txt)
    • Set DEBUG = 0

Plugin Installation Instructions

Note: You do not need to install anything on the browser to use this plugin. The following instructions are for the administrator who installs the plugin on the TWiki server.

You do not need to install anything in the browser to use this extension. The following instructions are for the administrator who installs the extension on the server where TWiki is running.

Like many other TWiki extensions, this module is shipped with a fully automatic installer script written using the BuildContrib.

  • If you have TWiki 4.2 or later, you can install from the configure interface (Go to Plugins->Find More Extensions)
  • If you have any problems, then you can still install manually from the command-line:
    1. Download one of the .zip or .tgz archives
    2. Unpack the archive in the root directory of your TWiki installation.
    3. Run the installer script ( perl <module>_installer )
    4. Run configure and enable the module, if it is a plugin.
    5. Repeat for any missing dependencies.
  • If you are still having problems, then instead of running the installer script:
    1. Make sure that the file permissions allow the webserver user to access all files.
    2. Check in any installed files that have existing ,v files in your existing install (take care not to lock the files when you check in)
    3. Manually edit LocalSite.cfg to set any configuration variables.

  • To correctly integrate this plugin with tables and charts, you need to change the order of plugins. In configure, change the order like this: SpreadSheetPlugin,FluidPivotsPlugin,ChartPlugin.

Plugin Info

Plugin Author: TWiki:Main.MariaDelCarmenHuertas
Copyright: © 2007, Fluidsignal Group S.A.
© 2007-2011 TWiki:TWiki.TWikiContributor
License: GPL (GNU General Public License)
Plugin Version: 2011-01-17
Change History:  
2011-01-17: TWikibug:Item6636: Fixing plugin for TWiki-5.0; fixing warnings; doc improvements; changing TWIKIWEB to SYSTEMWEB -- TWiki:Main.PeterThoeny
10 Apr 2008: Fixed reference to Table.pm and Parameters.pm
16 Oct 2007: Initial version
TWiki Dependency: $TWiki::Plugins::VERSION 1.1
CPAN Dependencies: libstring-crc32-perl library (CPAN:String::CRC32) and CPAN:Math::Round
Other Dependencies: none
Perl Version: 5.005
Benchmarks: GoodStyle nn%, FormattedSearch nn%, FluidPivotsPlugin nn%
Plugin Home: http://TWiki.org/cgi-bin/view/Plugins/FluidPivotsPlugin
Feedback: http://TWiki.org/cgi-bin/view/Plugins/FluidPivotsPluginDev
Appraisal: http://TWiki.org/cgi-bin/view/Plugins/FluidPivotsPluginAppraisal

Related Topics: FluidPivotsPluginExtern, FluidPivotsPluginTestCasesOff, FluidPivotsPluginTestCases, TWikiPlugins, DeveloperDocumentationCategory, AdminDocumentationCategory, TWikiPreferences

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatmd5 FluidPivotsPlugin.md5 r2 r1 manage 0.2 K 2011-01-18 - 06:35 PeterThoeny  
Compressed Zip archivetgz FluidPivotsPlugin.tgz r2 r1 manage 17.8 K 2011-01-18 - 06:34 PeterThoeny  
Compressed Zip archivezip FluidPivotsPlugin.zip r5 r4 r3 r2 r1 manage 23.8 K 2011-01-18 - 06:34 PeterThoeny  
Unknown file formatEXT FluidPivotsPlugin_installer r1 manage 3.8 K 2011-01-18 - 06:34 PeterThoeny  
Edit | Attach | Watch | Print version | History: r9 < r8 < r7 < r6 < r5 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r9 - 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-2015 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.