Difference between revisions of "Excelreader-call"

From GreenVulcano Wiki
Jump to: navigation, search
Line 7: Line 7:
 
=={{VULCON}} Configuration==
 
=={{VULCON}} Configuration==
 
''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.  
 
''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 ]]
+
[[Image:CreateOperationExcelReader.png|right|thumb|{{VULCON}} system excel-reader configuration ]]
 
In order to add an operation ''excelreader-call'' you must perform the following operation:
 
In order to add an operation ''excelreader-call'' you must perform the following operation:
 
* Open {{L_VULCON}} [[System section ({{VULCON}})]]
 
* Open {{L_VULCON}} [[System section ({{VULCON}})]]
Line 17: Line 17:
  
 
To use an ''excelreader-call'' in a {{GVESB}} service, you need to perfom the following steps:
 
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 ]]
+
[[File:Service-GVvcl-excel.png|right|thumb|{{VULCON}}service excel-reader configuration ]]
 
* In {{L_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 flow tag, click the right mouse button and select "insert before"  

Revision as of 20:52, 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:

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
VulConservice excel-reader configuration

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:

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.