LMS Reporting – Setting up remote SFTP report drop off (Default vs. Report Specific)

Actions:

The steps involved in this process are:

1. Login in to LMS instance.
2. Navigate to System Admin -> Configuration -> System Configuration -> REPORT_SYSTEM

3. Navigate down and put in the sftp server settings (if for default report location) Example:

#This section is used for configuring an FTP server to receive report output
#In environments where access to root level directory is denied, path can be configured as relative path.
#Relative path should be in the format - <directory in user home directory>/<sub directory>/<sub directory> where <sub directory> are optional.

# The timeout is in milliseconds. Default is 1 minute. Setting it to low value will cause issues during establishing connection.
# To enable local passive mode . Please set enablePassiveMode = true

remoteFtpEnabled=true                                --Must be enabled to true for remote file to appear
defaultReportFtpConfig.protocol=sftp                       --sftp is the usual protocol
defaultReportFtpConfig.server=sftp012.successfactors.eu    --your sftp server address
defaultReportFtpConfig.port=22                             --default ftp port
defaultReportFtpConfig.path=outgoing/reports/              --folder for default reports to be placed in
defaultReportFtpConfig.userID=testuser                     --sftp server userid
defaultReportFtpConfig.password=testuser123                --sftp server userid's password
defaultReportFtpConfig.timeout=60000                       --default setting
defaultReportFtpConfig.enablePassiveMode=false             --default setting

4. You will apply these settings to your config file and test a report to make sure it completes and         leaves the file in the correct location

5. For specific reports to go to a specific folder navigate to the same report system configuration        and below it update the settings like in this example.

In this example the report name is UserLearningHistoryCSV and the folder it is to be dropped in SH-IMPORT/Specific

reportFtpConfig.UserLearningHistoryCSV.protocol=sftp
reportFtpConfig.UserLearningHistoryCSV.server=ftp.vpftp.com
reportFtpConfig.UserLearningHistoryCSV.port=22
reportFtpConfig.UserLearningHistoryCSV.path=SH-IMPORT/Specific
reportFtpConfig.UserLearningHistoryCSV.userID=dwayne
reportFtpConfig.UserLearningHistoryCSV.password=sample55
reportFtpConfig.UserLearningHistoryCSV.timeout=60000
reportFtpConfig.UserLearningHistoryCSV.enablePassiveMode=false

** – Note you can change the location for each specific report you want and leave in the default location to capture the other reports in one remote location

I have created a youtube video with examples of both default and specific report settings.  I recommend you look through it to see how remote file drop off works in the LMS.  I also go through a few other settings in the config file you may find useful as well in the video.

Conclusion:

Often time customers want to separate out remote files from reports for things such as exports and other customer specific tasks.  Whether it is one location for all files or a combination of a default remote location and specific locations for other reports for other groups, the LMS allows for the solution to both of these configuration requirements.

I encourage you to leave comments and feedback if you have questions or suggestions.

Thanks for your attention and feedback,
Dwayne Phillips – Veritas Prime

http://veritasprime.com

http://helpmycloud.com