Difference between revisions of "Excelreader-call"
(→Vulcon Configuration) |
(→Vulcon Configuration) |
||
| Line 13: | Line 13: | ||
''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: | ||
| − | * | + | * You open Vulcon system section and his channel |
| − | * | + | * You clicks the right mouse button and select "insert before" label --> excelreader-call |
| − | * In layout | + | * In layout you fill in field name, i.e. the name of operation that will be used in Vulcon Service section |
| − | * Other fields | + | * 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''. | ||
| − | To use an excelreader-call in a GreenVulcano service, | + | To use an ''excelreader-call'' in a GreenVulcano ESB service, you need to perfom the following steps: |
| − | * | + | * You in services Section the services that will be modified or can create a new Services |
Revision as of 11:17, 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:
- You in services Section the services that will be modified or can create a new Services
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
