HTML Builder

HTML builder

HTML builder is editor for editing Velocity template on HTML adapter.

HTML Builder provides the following functions.

Inserts variable reference to Velocity template by mouse operation.

Inserts reference result data of process component to Velocity template by mouse operation.

Support the input of Conditional Branch process or loop process defined by Velocity template language(VTL).

Start and end HTML Builder

Start HTML builder

Double-click the HTML adapter icon, HTML builder edition screen starts as tab screen.

End HTML builder

Click button "×" on HTML builder edition screen to end.

Screen structure of HTML builder

Numbering in the figure	Name	Description	Remarks
(1)	Input source	Schema of input source, script variable, component variable are shown.	For information regarding how to edit a schema of input data, refer to "Edit Schema" in the Mapper section. Unlike Mapper, it is not possible to save the schema you edited in the HTML builder when saving a project.
(2)	Template area	Describe Velocity template. Syntax of reference of variable/input data and loop process/conditional branch process is changed to color and shown.
(3)	Tool palette	Tool related to "add input data" and "insert loop process" "Insert condition branch process" is shown. It is possible to start each tool by dragging&dropping to template area.

Developing procedures

Here introduces HTML builder development manual by example which uses "HTML file generation process".

Align HTML file generation process icon to campus.

Double click icon to open HTML builder edition screen.
Refer to "Start and end HTML Builder"

In HTML builder edition screen, add variable reference to Velocity template.
Refer to "Using variables"

In HTML builder edition screen, add input data.
Refer to "Add/delete input data"

In case of adapter in which schema is not generated automatically, set schema.
Refer to "Edit Schema"

In HTML builder edition screen, add loop process which used input data to Velocity template.
Refer to "Insert loop process using input data"

In HTML builder edition screen, add condition branch process using variable or input data to Velocity template.
For conditional branch process using variable: Refer to "Usage of variables"
Conditional branch process using input data: Refer to " Insert conditional branch process using input data "

After insertion of conditional branch processing

After modification of conditional branch processing

Finally, align HTML and finish.

Usage of input data

With the following notation, the reference of results data used in DataSpider can be passed to Velocity context.

Notation	Description
$component.{ProcessingComponentName}	Returns the object corresponding to the result data of Processing Component in [Processing Component Name].

Difference according to input data type

Depending on if the input data is of table model type of XML type, the object passed to Velocity context is different.Therefore, depending on the type of input data, descriptions of Loop and Conditional Branch differs.

XML type data

For XML type input data, JDOM is converted to document$component.JDOM document root element can be retrieved by writing in "$component.component name".

For JDOM, please refer to "jdom.org"(http://www.jdom.org/).

Table Model Type data

If the type of input data table model,can get Collection object related to row by writing in "$component.component name.rows"format.

Method Name	Arguments	Return type	Description
rows	None	Collection	Collection for object to access to each row.

Also, the following methods are implemented in the row object.

Method Name	Arguments	Return type	Description
getColumnValue	int	Column	Get the column object with the specified index.
getColumnCount	None	int	Returns the number of columns in the row.
getColumnData	None	Column[]	Returns an array of column objects included in row object.

Also, the following methods are implemented in the row object.
In addition, column object itself returns string equal to getStringValue.

Method Name	Arguments	Return type	Description
getData	None	Object	Return column input value unchanged.
getStringValue	None	String	Value as String type
getIntegerValue	None	Integer	Value as Integer type
getLongValue	None	Long	Value as Long type
getShortValue	None	Short	value as Short type
getFloatValue	None	Float	Value as Float type
getDoubleValue	None	Double	Value as Double type
getBigDecimalValue	None	BigDecimal	value as BigDecimal type
getBooleanValue	None	Boolean	value as Boolean type

Input data Add/Delete

HTML builder input data

In HTML builder, different from other writing process adapter or Mapper, base on Velocity template content to add/delete input data dynamically.

Add input data

Add input data.

Execute one of the processes below and open the "Add input data" screen.
- Drag & drop [Basic]-[Input data]-[Add input data] in the tool palette to the template area.
- From right click menu of template area, select [Add input data].
Select data you add to [Input data] in the "Add input data" screen, and click the [Finish] button.

By clicking [Next] button, you can also insert loop process which use the added data to insert Conditional branch or loop.

"$component.{component name}" is written in the template area and input data will be added.
Velocity templates in the template shown in the area "$component.Component Name", by writing and will be added to the original input data is the result of the tree component.

With the process above, input data is added and data flow of designer and input source tree are updated automatically.

Delete input data

From the template "$component.By deleting all description of "$component.component name"from template, input data will be deleted and data flow of designer and input source tree are updated automatically.

Insert loop using input data

Insert loop using input data.

Execute one of the processes below and open the "Insert loop" screen.
- drag&drop node which is target of loop process from "Input data"tree of input-from to template area from the shown dialog, select "Insert loop"menu.
- Drag & drop [Basic]-[Input data]-[Insert loop] in the tool palette to the template area.
- from right click menu of template area, select [Insert loop].
Select data for loop processing from [target data] in the "Insert loop" screen, and click [Next].

This process is not required if you open the "Insert loop" screen by drag & drop the nord of data for the loop processing from the "Input data" tree.

Select the type for loop processing in the "Input data" screen, and click [Finish].

Insert Conditional Branch using input data

Insert Conditional Branch using input data.

Execute one of the processes below and open the "Insert conditional branch" screen.
- Drag & drop [Basic]-[Logic]-[Insert conditional branch] in the tool palette to the template area.
- From right click menu of template area, select [Insert conditional branch].
Select data for the conditional branch processing from [Target variable/data] in the "Insert conditional branch" screen, and click [Finish].

You can also add a conditional branch by drag & drop the nord of data for the conditional branch processing from the source "Input data" tree, and select [Insert conditional branch] in the menu.

Usage of variables

With the following notation, the reference of results data used in DataSpider can be passed to Velocity context.

Type	Notation	Description
Script Variable	$script.<script variable name>	Returns the string representation of the value dereferenced by the <script variable name>.
	$start.<XML script input variable name>	Return XML data of the script variable shown as <XML script input variable name>. For more details, refer to "XML type data".
	$component.<XML script input variable name>
Component variable	$property.{component name}.{component variable name}	Return string representation of component number indicated by <processing component name> and <component variable name>.

Environment variables cannot be used.

For variables, refer to "variable".

Component variable

Component variable are variables that can be gotten with each component.
They are used to alter the succeeding processing with the results of the adapter.

Values you can obtain vary depending on the component. For more details, refer to the Help page of each adapter.

In HTML builder edit screen, for Velocity template, it is possible to execute "Insert script variable"or"Insert condition branch process which targets script variable".

Insert Component Variable

Insert component variable.

From right click menu of template area, select [Insert script variable].

Select the variable to insert to [Component variable] in the "Insert component variable" screen, and click [Finish].

You can also insert a component variable by drag & drop the component variable you insert from the source "Component variable" tree to the template area, and select [Insert component variable].

Insert Conditional Branch using component variables

Insert conditional branch using component variables.

Execute one of the processes below to open the "Insert conditional branch" screen.
- Drag & drop [Basic]-[Logic]-[Insert conditional branch] in the tool palette to the template area.
- From right click menu of template area, select [Insert conditional branch].
Select the component variable for a conditional branch to [Target variable/data] in the "Insert conditional branch" screen, and click [Finish].

You can also insert a conditional branch by drag & drop the component variable you insert from the source "Component variable" tree, and select [Insert conditional branch] in the menu.

Script Variable

Script variables are variables that can be created by the designer.
Store data temporarily, then use when we want to use in the process after.

In HTML builder edit screen, for Velocity template, it is possible to execute "Insert script variable" or "Insert condition branch process which targets script variable".

Insert script variable

Insert script variable.

Select [Insert script variable] from the right-click menu of the template area, and open the "Insert script variable" screen.

Select the variable to insert to [Script variable] in the "Insert script variable" screen, and click [Finish].

You can also insert a script variable by drag & drop the script variable you insert from the source "Script variable" tree, and select [Insert script variable] in the menu.

Insert Conditional Branch using component variables

Insert conditional branch using component variables.

Execute one of the processes below and open the "Insert conditional branch" screen.
- Drag & drop [Basic]-[Logic]-[Insert conditional branch] in the tool palette to the template area.
- From right click menu of template area, select [Insert conditional branch].
Select the script variable for a conditional branch to [Target variable/data] in the "Insert conditional branch" screen, and click [Finish].

You can also insert a script variable by drag & drop the script variable you insert from the source "Script variable" tree, and select [Insert script variable] in the menu.

Specification Limits

Retrieval of XML type data.
- Schema edited from the input source tree of HTML builder will not be saved/read.
Obtain XML type data
- If you obtain XML type data by using the JDOM method, the escaped characters are obtained as not escaped.
  You can avoid this by enclosing the target data in XML with "CDATA".

Restrictions on the usage of characters in component or variable names.

The following characters cannot be used in component or variable names.

Characters	Description
	space
!	Exclamation mark
?	Question mark
\	Backslash
$	Dollar sign
@	at symbol
%	percent symbol
&	ampersand
#	hash mark
*	asterisk
^	hut
~	tilde
,	comma
.	period
+	plus sign
/	forward slash
\|	vertical bar
:	colon
;	semi colon
<	less than sign
=	equal sing
>	greater than sing
-	hyphen
'	single quote
"	double quote
`	back quote
(	parentheses(left)
)	parentheses(right)
{	braces(left)
}	braces(right)
[	bracket(left)
]	bracket(right)
「	double-byte parenthesis(left)
」	double-byte parenthesis(right)
・	double-byte bullet point

Notes

Names of the variables enclosed in {}.
- Although variable names enclosed in {} are valid syntax used in Velocity template(such as ${var} $!{var}), these are regarded as "DataSpider variable usage" and expanded before the template is parsed.
  Therefore, usages of syntax such as ${script.ScriptVariableName} and ${property.ComponentName.ComponentVariableName} are not allowed.
- Where component variable needs to be enclosed in {}, such as concatenating the variable with some prefix string, use the equivalents available in DataSpider.
  Example: Total${script.ScriptVariableName} -> Total${ScriptVariableName}
- In a template area, where . period is appended to $script.ScriptName, may cause compilation error of during the build process of the script.
  To prevent this issue, enclose the script variable in {}.
  Example:$script.ScriptVariableName.csv -> ${ScriptVariableName}.csv
Use of multi-byte characters in component variables.
- In Velocity template language, cannot use variable name including double-byte character, but in HTML builder, can use double-byte character for variable name.
None existing variables
- If script variables dereferenced in syntax does not exist, error will occur when the script is compiled.
- Non-existing component variables dereferenced in syntax will be 'null'.
Components renamed
- If components used in the template area are renamed, error will occur at runtime.
  The component names used in the template area needs to be renamed accordingly.
Any component whose name contains either '(' or ')' cannot be specified as an input data.
Example: "mapping(1)".