File System: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(Created page with "The File System Connector reads all files from a folder specified in the Directory field. The Username and Password fields are not used. I'm unsure if the Filter field can b...")
 
No edit summary
Line 1: Line 1:
The File System Connector reads all files from a folder specified in the Directory field.  The Username and Password fields are not used.  I'm unsure if the Filter field can be used.
The File System Connector reads all files from a folder specified in the Directory field.  The Username and Password fields are not used.  Filter can be used to filter for certain file names/extensions.  To search for all files with an extension of "txt, use the filter "*.txt". To search for all files with "Work" anywhere in the filename, use the filter "*Work*"


The Connector returns standard data in the first 12 fields returned:
The Connector returns standard data in the first 12 fields returned:

Revision as of 16:59, 29 May 2015

The File System Connector reads all files from a folder specified in the Directory field. The Username and Password fields are not used. Filter can be used to filter for certain file names/extensions. To search for all files with an extension of "txt, use the filter "*.txt". To search for all files with "Work" anywhere in the filename, use the filter "*Work*"

The Connector returns standard data in the first 12 fields returned:

  • CreationTime
  • FullDirectoryName
  • DirectoryRelative
  • DirectoryName
  • Extension
  • FullName
  • IsReadOnly
  • LastAccessTime
  • LastWriteTime
  • Length
  • Name
  • LastWriteTime

The Connector returns all information available for the File in json format in the ExtendedProperties field.