Free Precipio SFTP Data Export and File Transfer Application

 
If you need to integrate Dynamics GP with BlackLine, Coupa, IQ BackOffice, or any other provider or service that requires upload or download of files with an SFTP server, this application can help automate that process.
 
The application can also be used to upload Safe Pay / Positive Pay or other files to a bank SFTP site.
 

The application can export data from Dynamics GP, save it to a CSV file, and upload it to an SFTP server. It can also download files from an SFTP server. The application is fully automated, can be scheduled using Windows Task Scheduler, and it includes file archiving, logging, and email notification in case of errors.
 

The free Precipio SFTP application provides the following features:
 

1. Export data from a SQL Server to delimited text files

2. Upload files to an SFTP server
3. Download files from an SFTP server
4. Automatic archive of all exported and downloaded files
5. Full activity logging
6. Error notification emails
 

The application is a command line executable that can be run on demand or on a scheduled basis using Windows Task Scheduler.
 
 

Limitations

The application only supports the SFTP protocol (SSH File Transfer). FTP and FTPS are not supported.
The application supports username / password SFTP authentication. SSH Key authentication is not supported.
The application does not support passing in parameters to stored procedures. Procedures must be able to run without any external parameter values.
 

Download
 
     Download version 2.00 – 10/31/2019 – Add support for file naming with custom date time formats. Update to use ChilkatDotNet45.dll version 9.5.0.80 (NOTE: Requires updates to .exe.config file)
 
     Download version 1.50 – 6/21/2019 – Update to use ChilkatDotNet45.dll version 9.5.0.78
 
 

Questions
 
Q1: I have a question or need assistance? Who do I contact?
A: Go to the Contact page and submit your question or issue. Please allow at least 1 business day for a response.
 
Q2: When the SFTP application runs, which tasks in the config file will be processed?
A: All enabled tasks in the config file will be processed every time the application is run. To disable a task, add “DISABLED” to the beginning of the task name, or make the task name blank.
 
Q3: How do I schedule some tasks to run hourly and other tasks to run once per day?
A: Setup 2 copies of the SFTP application in 2 different directories. In the Copy 1 directory, setup the config file for the hourly tasks. In the Copy 2 directory, setup the config file for the daily tasks. Create 2 different tasks in Windows Task Scheduler–one to run Copy 1 hourly, and the other to run Copy 2 once per day.
 
Q4: I don’t need to export–I only want to upload files. How do I do that?
A: Set TaskDirection to Upload and leave the TaskProcStart value blank so that no stored procedure is run (no export will occur). Then set the TaskLocalDir value in the config file to point to the directory where the local files will be saved/generated. Next, set the TaskFilePrefix to the file naming convention of the files to be uploaded. For instance, if the files are named “safepay_yyyymmdd.csv”, you can set TaskFilePrefix to “safepay_”. The SFTP application assumes that the files have a .CSV extension. If the files have a different extension, you can specify a custom extension after the prefix. For instance, if the files are named “safepay_yyyymmdd.txt”, you can set TaskFilePrefix to “safepay_.txt”.
 
 
 
 
 
Dynamics GP BlackLine Integration Upload
Dynamics GP Coupa Integration Upload
Dynamics GP IQ BackOffice Integration Upload
Dynamics GP SafePay SFTP Upload
Dynamics GP SFTP Integration Upload
Dynamics GP SFTP File Transfer Upload