CSV via FTP: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
No edit summary
Tag: Reverted
No edit summary
Tag: Manual revert
 
Line 4: Line 4:


==Additional Connection String Parameters==
==Additional Connection String Parameters==
*Use a semi-colon, ";", between parameters.
Use a semi-colon, ";", between parameters.


*I've had some ftp sites that require that I include the password in the Additional Connection String Parameters:<br>
I've had some ftp sites that require that I include the password in the Additional Connection String Parameters:<br>
: password=abc
: password=abc


*If you don't want the connector to parse the CSV file and try to guess the field type, include:<br>
If you don't want the connector to parse the CSV file and try to guess the field type, include:<br>
: typedetectionscheme=None
: typedetectionscheme=None


*If your job is timing out, you can disable timeouts by adding this to the Additional Connection String Parameters:<br>
If your job is timing out, you can disable timeouts by adding this to the Additional Connection String Parameters:<br>
: timeout=0
: timeout=0


'''Example:'''
'''Example:'''
: password=abc;typedetectionscheme=None;timeout=0
: password=abc;typedetectionscheme=None;timeout=0

Latest revision as of 15:45, 21 November 2025

Connection

URI

URI can be FTP or sFTP. Example: sftp://abc.exavault.com:22/

Additional Connection String Parameters

Use a semi-colon, ";", between parameters.

I've had some ftp sites that require that I include the password in the Additional Connection String Parameters:

password=abc

If you don't want the connector to parse the CSV file and try to guess the field type, include:

typedetectionscheme=None

If your job is timing out, you can disable timeouts by adding this to the Additional Connection String Parameters:

timeout=0

Example:

password=abc;typedetectionscheme=None;timeout=0