Delete

Operation name

Delete

Function overview

Delete the specified files on the FTP server.

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.  
Required settings
Item name Required / Optional Use of Variables Description Remarks
Destination Required Not Available Select Global Resources.
Refer to "the global resource properties" to set up a global resource.
  • [Add]:
    Adds new global resource.
  • [Edit list]:
    Global resource settings can be edited with "Edit Resource list".
 
Path Required - The path.

Each column can be operated with the following buttons.
  • [Add]:
    Adds the column.
  • [Up]:
    Moves the order of the selected column upwards by one.
  • [Down]:
    Moves the order of the selected column downwards by one.
  • [Delete]:
    Deletes the column.
 
Path/Remote path Required Available Enter the absolute path name beginning with "/" (slash) on the FTP server.
  • The file name can use wildcard ("*","?").
    • Example: /upload/*.csv
      • Files which with csv extension is under /upload directory correspond.
    • Example: /upload/sales data??.xls
      • Xls files which begins with "sales data" followed by two characters under /upload directory correspond.
  • Case-sensitive.
Deletion settings
Item name Required / Optional Use of Variables Description Remarks
Directory option Required Not Available Select how to deal with the directory when updating data.
  • [Ignore]: (Default)
    Ignores directory and does not delete. Also, directory information will not be included to the result data.
  • [Recursive]:
    Deletes file/directory in the specified hierarchy recursively.
 
Comment
Item name Required / Optional Use of Variables Description Remarks
Comment Optional Not Available Able to write a short description of this adapter.
Description will be reflected in the specifications.
 

Schema

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 Host name of connected FTP server  
port Port number of connected FTP server  
user User name to connect to the server  
pathnames -    
pathname - Emerges according to the delete targeted file/directory.  
date Always empty data  
filetype Outputs the file type of the delete targeted file/directory.
  • File:File
  • Directory:Directory
 
local Always empty data  
remote Outputs the absolute path on the FTP server of delete targeted file/directory.  
size Outputs the delete targeted file size. The unit is byte.
  • The data of directory is empty.
 
status Delete status
  • [Deleted]: Removed from FTP server
  • [NG]: Not removed because of some reason.
 
type Data is always empty  

Loading schema in Mapper

Schema is loaded automatically.
See "Edit Schema" for details with regards to defining a schema.

Mass Data Processing

Mass data processing is not supported.

Transaction

Transaction is not supported.

PSP Usage

PSP is not supported.

Available component variables

Component variable name Description Remarks
count Stores the numbers of delete targeted file/directory.
  • The value defaults to null.
  • This value is the sum of "directory_count" and "file_count".
directory_count Stores the numbers of delete targeted directory.
  • The value defaults to null.
file_count Stores the numbers of delete targeted file.
  • The value defaults to null.
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 Returns the error type when error occurred.
  • 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 Return the error message when error occurred.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version.
error_trace Return trace information when error occurred.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version or the client application used.

Specification Limits

Main exception

Exception name Causes Solution
ResourceNotFoundException
Resource definition could not be found.Name: []
[Destination] is not specified. Please specify [Destination] .
ResourceNotFoundException
Resource definition could not be found.Name: [<name of Global Resources>]
Resource definition selected in [Destination] is not found. Please check the global resource specified in [Destination]
RemoteFileListParseException
Failed analyze the list of remote files. The encoding specified may be incorrect.
Failed analyze the list of remote files. Ensure the [Encoding] specified in [Destination] and the FTP server settings are correct.
FTPException Exception if any error returned by the FTP server. Check the contents of the message.
com.enterprisedt.net.ftp.FTPException Exception if any error returned by the FTP server. Check the contents of the message.
java.net.UnknownHostException Exception if FTP server is not found. Please check your FTP server configuration.
java.net.ConnectException Exception if can not Connect to FTP Server. Check if port number or FTP is running.

Notes