Update

Operation name

Update

Function overview

Transfers the specified files in HULFT Square Storage to FTP server.

Data model

The data model of this component is XML type.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter a name that is used on the script canvas.

Required settings

Item name	Required/Optional	Use of variables	Description	Remarks
Destination	Required	Not available	Select a connection resource. Add A new connection resource can be added. Edit list Connection resource settings can be edited in > HULFT INTEGRATE > Connections.
Path	Required	-	Specify paths. Each row can be operated with the following buttons: Up Moves the selected row upward by one row. Down Moves the selected row downward by one row. Add Adds a row. Delete Deletes the row.
Path/Remote path	Required	Available	Enter the file/directory in the FTP server with an absolute path starting with "/".	When the wildcard (""/"?") is used in Local path*, enter the directory name. Case-sensitive.
Path/Local path	Required	Available	Enter a directory path of HULFT Square Storage.	Wildcards ("" and "?") can be used in file names. Example /upload/.csv It corresponds to the file with the csv extension which exists directly under the /upload directory. Example /upload/sales_data??.xls It corresponds to the file with the xls extension, starting with "sales_data" followed by two characters, which exists directly under the /upload directory. Case-insensitive. Note Specify an absolute path of HULFT Square Storage for the file path. With the exception of the path separator "/" and wildcards ("*","?"), the Restricted characters of HULFT Square Storage can't be used.
Path/Data type	Required	Not available	Select a data type. ASCII BINARY (Default)

Update settings

Item name	Required/Optional	Use of variables	Description	Remarks
Directory option	Required	Not available	Select how to handle directories when updating data. Ignore (Default) Ignore directories and don't transfer them. Further, the directory information won't be included in the result list. Recursive Upload files/directories under the specified directory recursively.
Date option	Required	Not available	Select whether or not to include date information. Exclude (Default) Date information won't be included in the results. Include Date information will be included in the result.
Append	Optional	Not available	Select whether or not to append the file contents when the file exists. Selected When the file exists in the path on the FTP server side, the contents of the file on the HULFT Square Storage side will be appended to the end of the file on the FTP server side. The file will be newly created when the file doesn't exist in the path on the FTP server side. Not selected (Default) When the file exists in the path on the FTP server side, the file on the FTP server side will be overwritten with the file on the HULFT Square Storage side. The file will be newly created when the file doesn't exist in the path on the FTP server side.	When selected, the file will be transferred using APPE command. Note When Existence is selected in Criteria for updating, appending isn't performed.
Check for update when transferring file	Optional	Not available	Select whether or not to check for updates of remote files when transferring files. Selected (Default) Transfer files only when the criteria specified in Criteria for updating are satisfied. Not selected Transfer files forcibly.
Criteria for updating	Required	Not available	Select criteria for updating files. Updated time (Default) Compare the updated time of the file on the FTP server side with that on the HULFT Square Storage side, and transfer when the one in HULFT Square Storage is newer. Note The FTP server must support MDTM command. Existence Transfer the file/directory when it doesn't exist in the FTP server side path.	Enabled when Check for update when transferring file is selected.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this connector.

Schemas

Input schema

None.

Output schema

<?xml version="1.0"?>
<ftpserver name="" port="" user="">
  <pathnames>
    <pathname date="" filetype="" local="" remote="" size="" status="" type=""/>
  </pathnames>
</ftpserver>

Element name	Attribute name	Description	Remarks
ftpserver	-
	name	Outputs the host name of the connected FTP server.
	port	Outputs the port number of the connected FTP server.
	user	Outputs the user name used when connecting to FTP server.
pathnames	-
pathname	-	Appears once for each file/directory to be updated.
	date	Outputs the last updated date and time of the file to be updated in yyyyMMddHHmmss format. Example: "20071016131522" shows October 16, 2007 13:15:22.	Note It's gotten only when Date option is Include. It's empty data in the case of directory.
	filetype	Outputs the file type of the file/directory to be updated. File File Directory Directory
	local	Outputs the absolute path in the HULFT Square Storage of the file/directory to be updated.
	remote	Outputs the absolute path in the FTP server of the file/directory to be updated.
	size	Outputs the file size of the file to be updated. The unit is byte.	Note It's empty data in the case of directory.
	status	Outputs the upload status. Updated The file has been uploaded and the file on FTP server has been updated. Uptodated The file hasn't been uploaded. This is output, when Updated time is selected in Criteria for updating and the file in HULFT Square Storage isn't newer than the file in the FTP server. Exists The file hasn't been uploaded. This is output When Existence is selected in Criteria for updating and the file in HULFT Square Storage exists in the FTP server. NG The file hasn't been uploaded due to some error.
	type	Outputs the data type. ASCII Outputs when uploaded in ASCII format. BINARY Outputs when uploaded in BINARY format.	Note It's empty data in the case of directory.

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Mass data processing

Mass data processing isn't supported.

Transaction

Transaction isn't supported.

Parallel Stream Processing

PSP isn't supported.

Available component variables

Component variable name	Description	Remarks
count	The number of files/directories to be updated is stored.	The default value is null. The sum of "directory_count" and "file_count".
directory_count	The number of directories to be updated is stored.	The default value is null.
file_count	The number of files to be updated is stored.	The default value is null.
message_category	When an error occurs, the category of the message code corresponding to the error is stored.	The default value is null.
message_code	When an error occurs, the code of the message code corresponding to the error is stored.	The default value is null.
message_level	When an error occurs, the severity of the message code corresponding to the error is stored.	The default value is null.
error_type	When an error occurs, the error type is stored.	The default value is null. The format of the error type is as follows. Example: java.io.FileNotFoundException
error_message	When an error occurs, the error message is stored.	The default value is null.
error_trace	When an error occurs, the trace information for the error is stored.	The default value is null.

Message codes, exception messages, and limitations

Connector	Message code	Exception message	Limitations
Messages and limitations of the FTP connector