Using One Stop Order Processing with Secure FTP (FTPS and SFTP)

Setting up One Stop Order Processing to import files using secure FTP

You will need to install WinSCP in the default location, C:\Program Files (x86)\WinSCP. From https://winscp.net/eng/index.php

1 Setup your import file as normal

2 Change the Order file to include the following line

{SFTP}{"C:\Program Files (x86)\WinSCP\WinSCP.exe" /log="C:\OSOP\SFTPLog.txt" /ini=nul /script="|SCRIPT|"}{C:\OSOP\Download.txt}{orders.txt}

NOTE: the last field, {orders.txt} is the file to download from the remote server

3 You need to create c:\OSOP\Download.txt file. This contains the script to run on the remote server. You need to add in the necessary security details.

An example of an FTPS server

open ftps://[LOGINNAME]:[LOGINPW]@[SERVER] -explicit -certificate="04:3f:0a:24:b3:2e:cc:bc::78:b9:1a:53:34:da:f1:5d:ac:49:70:6a:85:ff:a8:35:fa:23:cd:32:de:ca:63"
put [LOCALFILE]
exit

An example of a SFTP server

open ftps://[LOGINNAME]:[LOGINPW]@[SERVER] -hostkey="ssh-rsa 2048 WhjMMLWz0SRojjshf8LOKS64lX5h7efw1SX+K9a4="
put [LOCALFILE]
exit

NOTE: You should leave the [LOGINNAME], [LOGINPW], [SERVER] and [LOCALFILE] values as these are filled in by OSOP.

When this is run, the file C:\OSOP\SFTPLog.txt , is created. This contains the replies from the remote FTP server. This can be used to resolve any issues found.

Setting up One Stop Order Processing to export files using secure FTP

You will need to install WinSCP in teh default location, C:\Program Files (x86)\WinSCP. From https://winscp.net/eng/index.php

1 Setup a new export or amend an existing export.

2 At the bottom of the export dialog click on the Server Settings... button.

3 Add in the file to export to include the {SFTP} code. This will instruct OSOP to use an external program to use SFTP or FTPS. For example,

{SFTP}{"C:\Program Files (x86)\WinSCP\WinSCP.exe" /log="C:\OSOP\SFTPLog.txt" /ini=nul /script="|SCRIPT|"}{C:\OSOP\Upload.txt}{customers.csv}

NOTE: the last field, {customers.csv} is the file to upload to the remote server

4 You need to create c:\OSOP\Upload.txt file. This contains the script to run on the remote server. You need to add in the necessary security details.

An example of an FTPS server

open ftps://[LOGINNAME]:[LOGINPW]@[SERVER] -explicit -certificate="04:0f:0a:95:e9:2e:cc:bc:8b:5a:b9:1a:53:cb:da:ff:5d:ac:49:70:6a:98:2a:a8:35:fa:23:cd:52:de:ca:63"
put [LOCALFILE]
exit

An example of a SFTP server

open ftps://[LOGINNAME]:[LOGINPW]@[SERVER] -hostkey="ssh-rsa 2048 WhD3FWz0SRo8kj*umjv+x3qdS64lX5h7efw1SX+Kzas="
put [LOCALFILE]
exit

NOTE: You should leave the [LOGINNAME], [LOGINPW], [SERVER] and [LOCALFILE] values as these are filled in by OSOP.

When this is run, the file C:\OSOP\SFTPLog.txt , is created. This contains the replies from the remote FTP server. This can be used to resolve any issues found.