Difference between revisions of "Excelreader-call"
| 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. | ''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, [[GV Console]]® and [[VulCon]]®, to configure all supported plug-ins in GV services. | + | {{GVESB}} provides two different tools, [[GV Console]]<sup>®</sup> and [[VulCon]]<sup>®</sup>, to configure all supported plug-ins in GV services. |
==VulCon® Configuration== | ==VulCon® Configuration== | ||
| − | ''excelreader-call'' is the operation that must be configured into [[ | + | ''excelreader-call'' is the operation that must be configured into [[VulCon]]<sup>®</sup> [[System section]], to convert an Excel file in GVBuffer.object field, in an XML document. |
[[Image:CreateOperationExcelReader.png|right|thumb|VulCon® 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 [[VulCon | + | * open [[VulCon]]<sup>®</sup> [[System section]] |
* Then click right mouse button and select "insert before" label --> excelreader-call | * 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 | + | * In layout fill in field name, i.e. the name of operation that will be used in [[VulCon]]<sup>®</sup> [[Service section]] |
* Other fields ''class'', ''onlyData'' and ''type'' will be ignored | * Other fields ''class'', ''onlyData'' and ''type'' will be ignored | ||
| Line 31: | Line 31: | ||
[[Image:CreateOperationExcelReaderGVConsole.png|right|thumb|Gv Console system excel-reader configuration ]] | [[Image:CreateOperationExcelReaderGVConsole.png|right|thumb|Gv Console system excel-reader configuration ]] | ||
To add an operation ''excelreader-call'' you must perform the following operation: | To add an operation ''excelreader-call'' you must perform the following operation: | ||
| − | * Open [[GV Console | + | * Open [[GV Console]]<sup>®</sup> [[System section]] |
* Click button "insert before" and select label --> excelreader-call | * 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 | + | * In layout fill in field ''name'', i.e. the name of operation that will be used in [[VulCon]]<sup>®</sup> [[Service section]] |
* Other fields ''class'', ''onlyData'' and ''type'' will be ignored | * Other fields ''class'', ''onlyData'' and ''type'' will be ignored | ||
Revision as of 15:43, 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, to convert an Excel file in GVBuffer.object field, in an XML document.
In order to add an operation excelreader-call you must perform the following operation:
- open VulCon® System section
- 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
- 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:
- In VulCon:Services section 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 from GV Console Reload 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, to convert an Excel file in GVBuffer.object field, in a XML document.
To add an operation excelreader-call you must perform the following operation:
- Open GV Console® System section
- 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
- 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:
- In GV Console services section 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 GV Console Reload configuration
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.
