Execute Datalizer

Operation Name

Execute Datalizer

Function overview

Reads summary result data of Dr.Sum EA Datalizer.

Data Model

Data model of this component is XML type.

Properties

For information about using variables, refer to "variables".
Basic settings
Item name Required/Optional Use of Variables Description Remarks
Name Required Not available Enter the name on the script canvas.  
Input data Optional Not available Select the component on the script canvas.
  • When [Extraction criteria] is not specified, it is not necessary to specify [Input data].
Required settings
Item name Required/Optional Use of Variables Description Remarks
Destination Required Not available Select Global Resources.
Refer to " Global Resource Properties "for global resource settings .
  • [Add]:
    Adds new global resource.
  • [Edit list]:
    Global resource settings can be edited by [Edit Resource list].
  
Definition file name Required Available Select or enter the definition file title name.
  • Corresponding definition file title names are listed when [Destination] is selected.
Download file type Required Available Select or enter the output type of files to download (e.g. "EXCEL", "CSV", "PDF"... ).
  • Corresponding download file types are listed when [Definition file name] is selected.
  • If you enter a value or specify a variable, please use the below values according to each file type.

    File type Value
    CSV file CSV
    PDF file PDF
    Excel file(Excel 2007 Book) XLSX
    Excel file(Excel 2003/XP/2000Book) XLS

  • List differs by version of Dr.Sum EA Datalizer or by definition file specified at [Definition file name].
Download file name Required Available Enter the name of the downloaded file.

Click [Browse] button to activate the file Selectr and Select the file.
Extraction criteria Required - Specify the extraction criteria.
  • Corresponding download file types are listed when [Definition file name] is selected.
  • Schema can be edited when variables are used in [Definition file name].
Extraction criteria / Required Required Not available Shows whether required.  
Extraction criteria / Title Required Not available Shows the title.
  • It is editable if a script variable is used for [Definition file name]. Variables are also applicable for use.
Extraction criteria / Evaluation Required Not available Shows the evaluation method.  
Extraction criteria / Initial value Optional Available Enter the initial value.
  • [Input data] is prior when [Input data] is specified.
Items for adjusting aggregation condition
Only available in Datalizer 3.0 or later.
Item name Required/Optional Use of Variables Description Remarks
Column Optional - Select item of column to output.
  • Can not be specified when variables are used in [Definition file name].
Column / Item - Not available Shows item to output.  
Column / Required - Not available Shows whether the item is required for the output.  
Column / Output Optional Not available Select whether to output the item.
  • [Checked]:
    The item will be output.
  • [Not Checked]:
    The item will not be output.
  • When [Required] is checked, the item is output even when [Output] is not checked.
Row Optional - Select item of column to output.
  • Can not be specified when variables are used in [Definition file name].
Row / Item - Not available Shows item to output.  
Row / Required - Not available Shows whether the item is required for the output.  
Row / Output Optional Not available Select whether to output the item.
  • [Checked]:
    The item will be output.
  • [Not Checked]:
    The item will not be output.
  • When [Required] is checked, the item is output even when [Output] is not checked.
Summary Optional - Select item of aggregation to output.
  • Can not be specified when variables are used in [Definition file name].
Summary / Item - Not available Shows item to output.  
Summary / Required - Not available Shows whether the item is required for the output.  
Summary / Output Optional Not available Select whether to output the item.
  • [Checked]:
    The item will be output.
  • [Not Checked]:
    The item will not be output.
  • When [Required] is checked, the item is output even when [Output] is not checked.
Comment
Item name Required/Optional Use of Variables Description Remarks
Comment Optional Not available You can write a short description of this adapter.
The description will be reflected in the specifications.		  

Schema

Input Schema

<?xml version="1.0" encoding="UTF-8"?>
<request>
 <query/>
<request>

Output Schema

None.

Loading schema in Mapper

Schema is loaded automatically.
See "Edit Schema"for any details .

Mass data processing

Mass data processing is not supported.

PSP Usage

PSP is not supported.

Available Component variables

Component variable name Description Remarks
message_category Stroes the category to which corresponding message code belongs to, when an error occurs.
  • The value defaults to null.
message_code Stores its corresponding message code of occured error.
  • The value defaults to null.
message_level Stores the severity of the corresponding message code of the occured error.
  • The value defaults to null.
error_type Stores the type of the occured error.
  • The value defaults to null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The message may vary depending on DataSpider Servista version.
error_message Stores the error message for the occured error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version.
error_trace Stores stack trace of the occurred error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version or the client application used.

Specification Limits

About specifications, please refer to the following page.

Main exceptions

Exception name Cause Solution
ResourceNotFoundException
Resource definition could not be found.Name: []		 [Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition could not be found.Name: [<name of Global Resources>]		 Resource definition selected in [Destination] is not found. Check the global resource specified in [Destination].
InvalidPropertyConfigurationException
<Property name> is not specified.		 [<Property name>] is not specified. Specify the [<Property name>].
DatalizerException:
No corresponding data.		 No data corresponding to [Extraction Criteria]. Check [Extraction criteria].

Notes

About specifications, please refer to the following page.