File System Connector Properties
The following table defines the properties for the Connector for File System.
Token |
Name/Description |
Type |
---|---|---|
LCTOKEN_DATABASE |
Database Path to the directories (C:\files\somefiles or /unix/usr/files). Required. |
Text |
LCTOKEN_METADATA |
Metadata The subdirectory name (mydirectory or somedir/mydir). This subdirectory contains the files you want to access. |
Text |
LCTOKEN_MAP_NAME |
MapByName Whether to map by name or position when transferring data between data source and target. |
Boolean |
LCTOKEN_WRITEBACK |
Writeback Whether to perform writeback or non-writeback operations. |
Boolean |
LCTOKEN_FIELDNAMES |
FieldNames Multi-value text list of fields to select - used for Select operations |
Text List |
LCTOKEN_ORDERNAMES |
OrderNames Multi-value text list of fields to order results by - used for Select operations |
Text List |
LCTOKEN_CONDITION |
Condition The file specification for the files to include. The specification can include the standard wildcard characters: * to match any character string; ? to match any single character. |
Text |
LCTOKEN_STAMPFIELD |
StampField Field name of timestamp field -- used for Select operations |
Text |
LCTOKEN_BASESTAMP |
BaseStamp Minimum timestamp value to include in results -- used for Select operations |
Datetime |
LCTOKEN_MAXSTAMP |
MaxStamp During a Select operations, set by the connector to the current timestamp value -- set by Select operations |
Datetime |
1.00 |
Binary Whether file contents should be treated as binary (BLOB) data rather than the default (native TEXT). |
Boolean |
2.00 |
Sort Defines the sort order in the case of ordering by filename (0 = binary, 1 = case sensitive, 2 = case insensitive). |
Integer |
File System Metadata
File system metadata is defined as follows:
Filename -- Text
Contents -- Text
Timestamp -- Datetime
Size -- Int