Difference between revisions of "Excelreader-call"

From GreenVulcano Wiki
Jump to: navigation, search
(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:
  
* User open Vulcon system section and his channel
+
* You open Vulcon system section and his channel
* User clicks the right mouse button and select "insert before" label --> excelreader-call
+
* You clicks the right mouse button and select "insert before" label --> excelreader-call
* In layout user fill in fields name "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''.
  
  
To use an excelreader-call in a GreenVulcano service, user perfom the following step:
+
To use an ''excelreader-call'' in a GreenVulcano ESB service, you need to perfom the following steps:
  
* User open services Section and his services
+
* 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

File:CreateOperationExcelReader.png
Vulcon system excel-reader 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.

File:Service-GVvcl-excel.png
Vulcon service excel-reader configuration

In section service it's possible configure a GvOperationNode, with operation-name equal at system configuration.

Example use

  1. 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

  2. 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