Difference between revisions of "Excelreader-call"

Revision as of 20:50, 29 September 2011

Definition

Many IT applications, within their business process, need to read an Excel file. Gvvcl-excelreader plug-in helps IT organizations integrating applications that use Excel format to execute their business. Gvvcl-excelreader plug-in is compatible with all Excel formats up to version 2003, and it is very simple to configure. It receives in input a binary stream containing the Excel file, and returns in output a corresponding XML structure. At the output of Gvvcl-excelreader plug-in is possible to apply a ChangeGvBufferNode operation (with OGNL script or an XSL transformation) to retrieve all interested data.

GreenVulcano^® ESB provides two different tools, GV Console^® and VulCon^®, to configure all supported plug-ins in GV services.

VulCon Configuration

excelreader-call is the operation that must be configured into VulCon^® System section (VulCon), to convert an Excel file in GVBuffer.object field, in an XML document.

File:CreateOperationExcelReader.png

VulCon^® system excel-reader configuration

In order to add an operation excelreader-call you must perform the following operation:

Open VulCon^® System section (VulCon)
Then click right mouse button and select "insert before" label --> excelreader-call
In layout fill in field name, i.e. the name of operation that will be used in VulCon^® Service section (VulCon)
Other fields class, onlyData and type will be ignored

At this point, you have configured an operation of type excelreader-call.

To use an excelreader-call in a GreenVulcano^® ESB service, you need to perfom the following steps:

File:Service-GVvcl-excel.png

Vulcon service excel-reader configuration

In VulCon^® Service section (VulCon) select the services that you want modify or you can create a new Services
On flow tag, click the right mouse button and select "insert before"
On the list of GreenVulcano node select GvOperationNode
On the template that appears, select from drop down list, input field, next-node-id and as operation-name the operation configured in the system. Fill in fields id and output.
Use VulCon^® function Export in compressed file
Reload configuration (GV Console) from GV Console^®

At this point you have inserted an excelreader-call operation within a GreenVulcano^® ESB service.

GV Console Configuration

excelreader-call is the operation that must be configured into GV Console^® System section (GV Console), to convert an Excel file in GVBuffer.object field, in a XML document.

File:CreateOperationExcelReaderGVConsole.png

Gv Console system excel-reader configuration

To add an operation excelreader-call you must perform the following operation:

Open GV Console^® System section (GV Console)
Click button "insert before" and select label --> excelreader-call
In layout fill in field name, i.e. the name of operation that will be used in VulCon^® Service section (VulCon)
Other fields class, onlyData and type will be ignored

At this point, you have configured an operation of type excelreader-call in GV Console^®.

To use an excelreader-call in a GreenVulcano^® ESB service, you need to perfom the following steps:

File:Service-GVvcl-excelGvConsole.png

GV Console service excel-reader configuration

In GV Console^® Service section (GV Console) select the services that you want to modify or, alternatively, you can create a new Services
On flow tag, click the add operation node button and select "insert before"
On the list of GreenVulcano node select GvOperationNode
On the template that appear, select from drop down list, input field, next-node-id and as operation-name the operation configured in the system. Fill in fields id and output.
Click save button and terminate editing
Reload configuration (GV Console) from GV Console^®

At this point you have configured a service with an excelreader operation.

Example

This example shows an XML document generated by a simple Excel sheet (without cols and rows grouping). Given an Excel sheet with the following structure:

ID1	ID2	ID3	ID4	ID5	ID6	ID7
23	23232	23	23333	1	2	3
24	24444	23	23332	1	2	3

excelreader-call generates the following XML:

<?xml version="1.0" encoding="UTF-8"?>
<workbook>
    <sheet number="0">
        <name><![CDATA[Foglio1]]></name>
        <row number="0">
            <col number="0">
                <data><![CDATA[ID1]]></data>
            </col>
            <col number="1">
                <data><![CDATA[ID2]]></data>
            </col>
            <col number="2">
                <data><![CDATA[ID3]]></data>
            </col>
            <col number="3">
                <data><![CDATA[ID4]]></data>
            </col>
            <col number="4">
                <data><![CDATA[ID5]]></data>
            </col>
            <col number="5">
                <data><![CDATA[ID6]]></data>
            </col>
            <col number="6">
                <data><![CDATA[ID7]]></data>
            </col>
        </row>
        <row number="1">
            <col number="0">
                <data><![CDATA[23]]></data>
            </col>
            <col number="1">
                <data><![CDATA[23232]]></data>
            </col>
            <col number="2">
                <data><![CDATA[23]]></data>
            </col>
            <col number="3">
                <data><![CDATA[711]]></data>
            </col>
            <col number="4">
                <data><![CDATA[1]]></data>
            </col>
            <col number="5">
                <data><![CDATA[1]]></data>
            </col>
            <col number="6">
                <data><![CDATA[1]]></data>
            </col>
        </row>
        <row number="2">
            <col number="0">
                <data><![CDATA[23]]></data>
            </col>
            <col number="1">
                <data><![CDATA[711]]></data>
            </col>
            <col number="2">
                <data><![CDATA[23]]></data>
            </col>
            <col number="3">
                <data><![CDATA[23232]]></data>
            </col>
            <col number="4">
                <data><![CDATA[1]]></data>
            </col>
            <col number="5">
                <data><![CDATA[1]]></data>
            </col>
            <col number="6">
                <data><![CDATA[1]]></data>
            </col>
        </row>
    </sheet>
</workbook>

With a ChangeGvBufferNode is possible parsing XML and retrieve any tag and value.

@@ Line 3: / Line 3: @@
 ''Gvvcl-excelreader'' plug-in is compatible with all Excel formats up to version 2003, and it is very simple to configure. It receives in input a binary stream containing the Excel file, and returns in output a corresponding XML structure. At the output of ''Gvvcl-excelreader'' plug-in is possible to apply a [[ChangeGvBufferNode]] operation (with [http://en.wikipedia.org/wiki/OGNL OGNL] script or an [http://en.wikipedia.org/wiki/XSL XSL] transformation) to retrieve all interested data.
-{{GVESB}} provides two different tools, {{GVCONSOLE}} and {{VULCON}}, to configure all supported plug-ins in GV services.
+{{GVESB}} provides two different tools, {{L_GVCONSOLE}} and {{L_VULCON}}, to configure all supported plug-ins in GV services.
 =={{VULCON}} Configuration==
-''excelreader-call'' is the operation that must be configured into {{VULCON}} [[System section ({{VULCON}})]], to convert an Excel file in GVBuffer.object field, in an XML document.
+''excelreader-call'' is the operation that must be configured into {{L_VULCON}} [[System section ({{VULCON}})]], to convert an Excel file in GVBuffer.object field, in an XML document.
 [[Image:CreateOperationExcelReader.png|right|thumb|VulCon<sup>&reg;</sup> system excel-reader configuration ]]
 In order to add an operation ''excelreader-call'' you must perform the following operation:
-* Open {{VULCON}} [[System section ({{VULCON}})]]
+* Open {{L_VULCON}} [[System section ({{VULCON}})]]
 * Then click right mouse button and select "insert before" label --> excelreader-call
-* In layout fill in field name, i.e. the name of operation that will be used in {{VULCON}} [[Service section ({{VULCON}})]]
+* In layout fill in field name, i.e. the name of operation that will be used in {{L_VULCON}} [[Service section ({{VULCON}})]]
 * Other fields ''class'', ''onlyData'' and ''type'' will be ignored
@@ Line 18: / Line 18: @@
 To use an ''excelreader-call'' in a {{GVESB}} service, you need to perfom the following steps:
 [[File:Service-GVvcl-excel.png|right|thumb|Vulcon service excel-reader configuration ]]
-* In {{VULCON}} [[Service section ({{VULCON}})]] select the services that you want modify or you can create a new Services
+* In {{L_VULCON}} [[Service section ({{VULCON}})]] select the services that you want modify or you can create a new Services
 * On flow tag, click the right mouse button and select "insert before"
 * On the list of GreenVulcano node select ''GvOperationNode''
 * On the template that appears, select from drop down list, input field, next-node-id and as operation-name the operation configured in the system. Fill in fields id and output.
-* Use {{VULCON}} function [[Export in compressed file]]
+* Use {{L_VULCON}} function [[Export in compressed file]]
-* [[Reload configuration]] from {{GVCONSOLE}}
+* [[Reload configuration ({{GVCONSOLE}})]] from {{L_GVCONSOLE}}
 At this point you have inserted an ''excelreader-call'' operation within a {{GVESB}} service.
 =={{GVCONSOLE}} Configuration==
-''excelreader-call'' is the operation that must be configured into {{GVCONSOLE}} [[System section ({{GVCONSOLE}})]], to convert an Excel file in GVBuffer.object field, in a XML document.
+''excelreader-call'' is the operation that must be configured into {{L_GVCONSOLE}} [[System section ({{GVCONSOLE}})]], to convert an Excel file in GVBuffer.object field, in a XML document.
 [[Image:CreateOperationExcelReaderGVConsole.png|right|thumb|Gv Console system excel-reader configuration ]]
 To  add an operation ''excelreader-call'' you must perform the following operation:
-* Open {{GVCONSOLE}} [[System section ({{GVCONSOLE}})]]
+* Open {{L_GVCONSOLE}} [[System section ({{GVCONSOLE}})]]
 * Click button "insert before" and select label --> excelreader-call
-* In layout fill in field ''name'', i.e. the name of operation that will be used in {{VULCON}} [[Service section ({{VULCON}})]]
+* In layout fill in field ''name'', i.e. the name of operation that will be used in {{L_VULCON}} [[Service section ({{VULCON}})]]
 * Other fields ''class'', ''onlyData'' and ''type'' will be ignored
-At this point, you have configured an operation of type ''excelreader-call'' in {{GVCONSOLE}}.
+At this point, you have configured an operation of type ''excelreader-call'' in {{L_GVCONSOLE}}.
 To use an ''excelreader-call'' in a {{GVESB}} service, you need to perfom the following steps:
 [[File:Service-GVvcl-excelGvConsole.png|right|thumb|GV Console service excel-reader configuration ]]
-* In {{GVCONSOLE}} [[Service section ({{GVCONSOLE}})]] select the services that you want to modify or, alternatively, you can create a new Services
+* In {{L_GVCONSOLE}} [[Service section ({{GVCONSOLE}})]] select the services that you want to modify or, alternatively, you can create a new Services
 * On flow tag, click the add operation node button and select "insert before"
 * On the list of GreenVulcano node select ''GvOperationNode''
 * On the template that appear, select from drop down list, ''input'' field, ''next-node-id'' and as ''operation-name'' the operation configured in the system. Fill in fields id and output.
 * Click ''save button and terminate editing''
-* [[Reload configuration]] from {{GVCONSOLE}}
+* [[Reload configuration ({{GVCONSOLE}})]] from {{L_GVCONSOLE}}
 At this point you have configured a service with an ''excelreader'' operation.

Difference between revisions of "Excelreader-call"

Revision as of 20:50, 29 September 2011

Contents

Definition

VulCon Configuration

GV Console Configuration

Example

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools

see also