Difference between revisions of "Excelreader-call"
| Line 1: | Line 1: | ||
==Definition== | ==Definition== | ||
| − | Many IT applications in their business process needs read an | + | Many IT applications in their business process needs to read an Excel file. GreenVulcano Gvvcl-excelreader plug-in helps IT organizations integrating applications that use Excel format to execute their business. |
| − | GreenVulcano Gvvcl- | + | 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 stream of Excel file and returns in output an XML structure. At the output of Gvvcl-excelreader plug-in is possible to apply a [[changeGvBuffer]] operation (with [[ognl script]] or an [[xsl stylesheet]]) to retrieve all interested data. |
| − | Gvvcl- | ||
| − | GreenVulcano ESB provides two tools, [[GVConsole]] and [[Vulcon]], to configure all GreenVulcano supported | + | GreenVulcano ESB provides two tools, [[GVConsole]] and [[Vulcon]], to configure all GreenVulcano supported plug-ins in GV services. |
==Vulcon Configuration== | ==Vulcon Configuration== | ||
| − | ''excelreader-call'' is the operation that must be configured into Vulcon ''system'' section, to convert a Excel file, in GVBuffer.object field, in | + | ''excelreader-call'' is the operation that must be configured into Vulcon ''system'' section, to convert a 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 ]] | ||
To add an operation excelreader-call user must perform the following operation: | To add an operation excelreader-call user must perform the following operation: | ||
* You open [[Vulcon system section]] | * You open [[Vulcon system section]] | ||
| − | * | + | * Then you click right mouse button and select "insert before" label --> excelreader-call |
* In layout you fill in field name, i.e. the name of operation that will be used in [[Vulcon service section]] | * In layout you 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 | * Other fields ''class'', ''onlyData'' and ''type'' will be ignored | ||
| − | |||
At this point, you have configured an operation of type ''excelreader-call''. | At this point, you have configured an operation of type ''excelreader-call''. | ||
| Line 26: | Line 24: | ||
* Use Vulcon function [[Export in compressed file]] | * Use Vulcon function [[Export in compressed file]] | ||
* [[Reload Configuration from GvConsole]] | * [[Reload Configuration from GvConsole]] | ||
| − | |||
At this point you have use ''excelreader-call'' operation in a GreenVulcano service. | At this point you have use ''excelreader-call'' operation in a GreenVulcano service. | ||
| Line 50: | Line 47: | ||
At this point you have configured a service with an ''excelreader'' operation. | At this point you have configured a service with an ''excelreader'' operation. | ||
| − | |||
==Example== | ==Example== | ||
Revision as of 15:42, 26 September 2011
Definition
Many IT applications in their business process needs to read an Excel file. GreenVulcano 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 stream of Excel file and returns in output an XML structure. At the output of Gvvcl-excelreader plug-in is possible to apply a changeGvBuffer operation (with ognl script or an xsl stylesheet) to retrieve all interested data.
GreenVulcano ESB provides two tools, GVConsole and Vulcon, to configure all GreenVulcano supported plug-ins in GV services.
Vulcon Configuration
excelreader-call is the operation that must be configured into Vulcon system section, to convert a Excel file, in GVBuffer.object field, in an XML document.
To add an operation excelreader-call user must perform the following operation:
- You open Vulcon system section
- Then you click right mouse button and select "insert before" label --> excelreader-call
- In layout you 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, you clicks the right mouse button and select "insert before"
- On the list of GreenVulcano node select GvOperationNode
- On the template that appear, you must select from drop down list, input fiel, 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 GvConsole
At this point you have use excelreader-call operation in a GreenVulcano service.
GVconsole Configuration
excelreader-call is the operation that must be configured into GvConsole system section, to convert a Excel file, in GVBuffer.object field, in a XML document.
To add an operation excelreader-call user must perform the following operation:
- You open GVconsole system section
- You clicks button "insert before" and select label --> excelreader-call
- In layout you 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 a GvConsole.
To use an excelreader-call in a GreenVulcano ESB service, you need to perfom the following steps:
- In GvConsole services section select the services that you want modify or you can create a new Services
- On flow tag, you clicks the add operation node button and select "insert before"
- On the list of GreenVulcano node select GvOperationNode
- On the template that appear, you must 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
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[SOURCE_RNCID]]></data>
</col>
<col number="1">
<data><![CDATA[SOURCE_CELLID]]></data>
</col>
<col number="2">
<data><![CDATA[TARGET_RNCID]]></data>
</col>
<col number="3">
<data><![CDATA[TARGET_CELLID]]></data>
</col>
<col number="4">
<data><![CDATA[selectionPriority]]></data>
</col>
<col number="5">
<data><![CDATA[qOffset1sn]]></data>
</col>
<col number="6">
<data><![CDATA[qOffset2sn]]></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 ChangeGVBuffer node is possible parsing XML and retrieve any tag and value.
--A.sicignano 15:29, 26 September 2011 (CEST)
