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.

Attribute	Type	Description
mode	optional	Defines the source of the data to be converted in Excel file: sql: the data are extracted from a DB though an SQL statement xml: the data are extracted from an XML document contained into GVBuffer.object field Default to sql.

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.

Attribute	Type	Description
fields	optional	Useful only for XML mode, defines the list of (row) element's attributes (and their order) to be shown in the Excel sheet.

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	Must be Excel Sheet: insert|update|callsp. The attribute's admitted values are: select insert update callsp
id	optional	prep-statement Id.