Excel-call

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

• Description
• prep-statement
• statement

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.