CSV via FTP: Difference between revisions
Jkuehlthau (talk | contribs) |
Jkuehlthau (talk | contribs) |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 7: | Line 7: | ||
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 | |||
< | ===CSV via SFTP=== | ||
Use the CSV via FTP Connector and put the following into the Connection String Parameters:<br> | |||
sshclientcert=D:\inetpub\wwwroot\MemberEngine\InstanceName\Files\pemfilename.pem;sshclientcerttype=pemkey_file;sshauthmode=public_key;timeout=0 | |||
You will have to ask Starfish Support to put the pem file on the server for you. Please be sure to share the file with a secure method. | |||
Latest revision as of 17:22, 16 April 2026
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
CSV via SFTP
Use the CSV via FTP Connector and put the following into the Connection String Parameters:
sshclientcert=D:\inetpub\wwwroot\MemberEngine\InstanceName\Files\pemfilename.pem;sshclientcerttype=pemkey_file;sshauthmode=public_key;timeout=0
You will have to ask Starfish Support to put the pem file on the server for you. Please be sure to share the file with a secure method.