Repository Connection Configuration
All of these fields will appear in a Job Specification where the CSV connector is the repository.
CSV File Info
- CSV File Path: Path to the CSV file
- CSV Type: CSV Type. Will be prepended to all properties. If blank, the type will be the (filename)_csv
- Separator Character: The character that separates each field value, also called a delimiter. Default is comma (,)
- Escape Character: The value used to escape values such as slashes and quotes. Default is backslash (\)
- Quote Character: The character used to denote fields. Default is double quotes (“)
- Document Type: Sets the base type for the migrated files to either documents or folders
- Maximum number of rows: Including the header. Set to 0 or leave blank to read the entire csv
File Field Mapping
- Path Field: The header under which file paths are stored
- Path Includes Files: If checked, Federation Services will extract the filename from the value found in the Path Field. Only checked if Path Field is populated
- File Field: The header under which file names are stored
- Id Field: Field which contains the source document Id. If blank, the id will be (csvfilepath):(row)
- Created Date Field: The field that stores the date the file was created
- File Length Field: The field that stores the file length
- Modified Date Field: The field that stores the date the file was modified
- Path to Files: If set, the connector will prepend this to the file path and search for a file at that location. Include Binaries must also be checked