Difference between revisions of "Excelreader-call"
(→Vulcon Configuration) |
(→Vulcon Configuration) |
||
| Line 8: | Line 8: | ||
== 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 a XML document. To add an operation excelreader-call user must perform the following operation: | ''excelreader-call'' is the operation that must be configured into Vulcon ''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: | ||
| + | [[Image:CreateOperationExcelReader.png|right|thumb|Vulcon system excel-reader configuration ]] | ||
* You open Vulcon system section and his channel | * You open Vulcon system section and his channel | ||
| Line 22: | Line 22: | ||
To use an ''excelreader-call'' in a GreenVulcano ESB service, you need to perfom the following steps: | To use an ''excelreader-call'' in a GreenVulcano ESB service, you need to perfom the following steps: | ||
| − | * | + | [[File:Service-GVvcl-excel.png|right|thumb|Vulcon service excel-reader configuration ]] |
| − | + | * In 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. | ||
Next step in a GreenVulcano service will be configured a node that use this operation. | Next step in a GreenVulcano service will be configured a node that use this operation. | ||
| − | |||
In section service it's possible configure a GvOperationNode, with operation-name equal at system configuration. | In section service it's possible configure a GvOperationNode, with operation-name equal at system configuration. | ||
Revision as of 12:27, 26 September 2011
Definition
Many IT applications in their business process needs read an excel file. GreenVulcano Gvvcl-excel-reader Plug-in helps IT organizations integrate applications that utilize excel format to execute their business. Gvvcl-excel-reader Plug-in is compatible with all Excel format up to 2003, and is very simple to configure. It receive in input a stream of excel file and give in output an XML structure. At the output of Gvvcl-excel-reader Plug-in is possible apply a changeGvBuffer operation (with ognl script or a xsl stylesheet) to retrieve all interest 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 a XML document. To add an operation excelreader-call user must perform the following operation:
- You open Vulcon system section and his channel
- You clicks the 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 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.
Next step in a GreenVulcano service will be configured a node that use this operation. In section service it's possible configure a GvOperationNode, with operation-name equal at system configuration.
Example use
- Gvvcl-excel with a simple excel
blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla
Input File:InputSimpleExcel.jpg Output File:OutputSimpleExcel.xml
- Gvvcl-excel with a complex excel
blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla blabla
Input File:InputComplexExcel.jpg Output File:OutputComplexExcel.jpg
