Difference between revisions of "Excel-call"

From GreenVulcano Wiki
Jump to: navigation, search
(→‎Sheet)
(→‎{{VULCON}} / {{GVCONSOLE}} Configuration)
Line 6: Line 6:
  
 
The excel-call Element is used by [[Channel]] and [[routed-call]]. It has the following attributes:
 
The excel-call Element is used by [[Channel]] and [[routed-call]]. It has the following attributes:
−
* ''type'': call.
+
{|class="gvtable"
−
* ''class'': it.greenvulcano.gvesb.virtual.excel.GVExcelCallOperation.
+
! Attribute !! Type !! Description
−
* ''name'': Operation name. Used in the [[Flow]] section to associate workflow nodes to VCL operations.
+
|-
−
* ''group'': Reports group name.
+
| type || fixed || This attribute must assume the value '''call'''.
−
* ''report'': Report name.
+
|-
 +
| class || fixed || This attribute must assume the value '''it.greenvulcano.gvesb.virtual.excel.GVExcelCallOperation'''.
 +
|-
 +
| name || required || Operation name. Used in the [[Flow]] section to associate workflow nodes to VCL operations.
 +
|-
 +
| group || optional || Reports group name.
 +
|-
 +
| report || optional || Report name.
 +
|}
  
 
and the subelements:
 
and the subelements:
Line 19: Line 27:
  
 
Defines the configuration elements of an Excel report. It is used by '''excel-call''' and [[excelreader-call]] and has the following attributes:
 
Defines the configuration elements of an Excel report. It is used by '''excel-call''' and [[excelreader-call]] and has the following attributes:
−
* ''name'': Report name
+
{|class="gvtable"
−
* ''group'': Report group. Default Generic.
+
! Attribute !! Type !! Description
−
* ''jdbc-connection'': JNDI name of a DataSource.
+
|-
−
* ''format'': Name of the style of the report. Default ''default''.
+
| name || required ||Report name
 +
|-
 +
| group || optional || Report group. Default Generic.
 +
|-
 +
| jdbc-connection || required || JNDI name of a DataSource.
 +
|-
 +
| format || optional || Name of the style of the report. Default ''default''.
 +
|}
  
 
Its subelements are:
 
Its subelements are:
Line 31: Line 46:
  
 
This element defines the configuration of each sheet of the Report.
 
This element defines the configuration of each sheet of the Report.
−
 
−
CompositeLabel: @id-@name
 
  
 
The Sheet Element is used by '''GVExcelReport'''. Its attributes are:
 
The Sheet Element is used by '''GVExcelReport'''. Its attributes are:
−
* ''id'': Sheet id.
+
{|class="gvtable"
−
* ''name'': Sheet name.
+
! Attribute !! Type !! Description
−
* ''title'': Sheet title.
+
|-
−
* ''jdbc-connection'': JNDI name of a DataSource. Default to Report connection.
+
| id || required || Sheet id.
 +
|-
 +
| name || required || Sheet name.
 +
|-
 +
| title || optional || Sheet title.
 +
|-
 +
| jdbc-connection || optional || JNDI name of a DataSource. Default to Report connection.
 +
|}
  
 
and its subelements:
 
and its subelements:
Line 50: Line 70:
  
 
Its attributes are:
 
Its attributes are:
−
* ''type'': Must be "Excel Sheet : insert|update|callsp". The attribute's admitted values are:
+
{|class="gvtable"
−
** select
+
! Attribute !! Type !! Description
−
** insert
+
|-
−
** update
+
| type || required || Must be "Excel Sheet : insert|update|callsp". The attribute's admitted values are:
−
** callsp
+
* select
−
* ''id'': prep-statement Id.
+
* insert
 +
* update
 +
* callsp
 +
|-
 +
| id || optional || prep-statement Id.
 +
|}

Revision as of 16:58, 9 February 2012

Description

The GreenVulcano® ESB plugin excell-call allows you to define the information needed to generate Excel reports from a select on the DB.

VulCon / GV Console Configuration

The excel-call Element is used by Channel and routed-call. It has the following attributes:

Attribute Type Description
type fixed This attribute must assume the value call.
class fixed This attribute must assume the value it.greenvulcano.gvesb.virtual.excel.GVExcelCallOperation.
name required Operation name. Used in the Flow section to associate workflow nodes to VCL operations.
group optional Reports group name.
report optional Report name.

and the subelements:

  • Description
  • GVExcelReport

GVExcelReport

Defines the configuration elements of an Excel report. It is used by excel-call and excelreader-call and has the following attributes:

Attribute Type Description
name required Report name
group optional Report group. Default Generic.
jdbc-connection required JNDI name of a DataSource.
format optional Name of the style of the report. Default default.

Its subelements are:

  • Description
  • Sheet(s)

Sheet

This element defines the configuration of each sheet of the Report.

The Sheet Element is used by GVExcelReport. Its attributes are:

Attribute Type Description
id required Sheet id.
name required Sheet name.
title optional Sheet title.
jdbc-connection optional JNDI name of a DataSource. Default to Report connection.

and its subelements:

prep-statement

Preparation statement for Excel report generation. Are executed after the report statement. Can contains placeholders.

Its attributes are:

Attribute Type Description
type required update|callsp". The attribute's admitted values are:
  • select
  • insert
  • update
  • callsp
id optional prep-statement Id.
Retrieved from "https://gvwiki.greenvulcano.com/gvwiki/index.php?title=Excel-call&oldid=1799"