A) In Legacy Executrax
- Check DUR report for version info
Minimum version required for SFTP to work in Executrax is v 11.16.0194. Executrax licenses are updated annually for customers to continue using the software so existing customers should already be on the most recent version.
2. Get SFTP credentials
Development team will generate new credentials and provide a password protected csv file per client. This step should already be completed for most customers. Contact Johnny to confirm SFTP username & password for hostname “-Executrax”. If Johnny is unavailable, contact Helpdesk. FYI; On-prem customers hostname format=ClientName+license number (exp HONDA30978-EXECUTRAX). Cloud customers hostname format= ClientName-Executrax (exp REGIONALFCU-EXECUTRAX).
3. Test SFTP credentials in FileZilla
Use FileZilla or any FTP client such as (WinSCP) to test SFTP connection using the credentials provided to ensure it works before meeting with customer. Make sure the ‘SendToDMX’ path & folder is in place. To create folder, right click & select “Create Directory”:
4. Create ‘app.config’ file and place it in Executrax root folder
This step should already be completed for most customers. If setting up a new customer, go back to step 2 and open an RFP to request DevOps generate SFTP creds for the new customer. Once you receive creds from DevOps, then create the app.config file using the format below:
Example of app.config:
*Separate Key Value pairs with a single space*
FTPCLIENT_URL sftp-use1.cloudmarquis.com
SFTPCLIENT_LOGIN HONDA30978-EXECUTRAX
SFTPCLIENT_PASSWORD XXXXXXXXXXXXX
NOTE: You can also test SFTP credentials provided above with FileZilla.
5. Test SFTP connection in TriggerPro (Executrax > Processors > TriggerPro)
Go to Settings, then click FTP Settings. Change the radio button to SFTP and click Save.
Next, click on Test Connection to make sure it says PASSED:
NOTE: If sftp test fails, a firewall change may be required to allow SFTP traffic inbound & outbound from URL sftp-use1.cloudmarquis.com on their local firewall. Check with customers to confirm if they use an alternate server for FTP. SFTP test should pass successfully if Executrax & FTP are hosted on the same server.
6. Remove the contents of Trigger folder
Go to Executrax\Export\Trigger folder and Executrax\Export\MQCreative folder to remove all outdated trigger files. Best practice is to create an alternate folder to move the old files into.
7. Customer IT Support Staff Requirement
Remind customer that their local IT Support will need to setup or update the .bat file that is required to copy & remove the files (30993_*.csv) from the SFTP delivery folder (Executrax\Export\Trigger) and send to Marquis via SFTP.
B) In MDP
- Follow steps 1 – 2 as listed for Legacy Executrax.
- DUR report for version info
Minimum version required for SFTP to work in Next is v1.17. If client is using Journeys or Triggers, they will need to be upgraded to the most recent version to utilize current features. Best practice is to upgrade to most recent version when possible.
- Get SFTP credentials
Development team will generate new credentials and provide a password protected csv file per client. This step should already be completed for existing customers. Contact Johnny to confirm SFTP username & password for hostname “-NEXT”. If Johnny is unavailable, contact Helpdesk. Update web & API config with the secret\encrypted pswd.
2. Check SFTP settings in MDP
Go to Administration > Settings > Integrations and select the ‘SFTP’ tab:
NOTE: SFTP settings are configured in the WEB config. Best practice is to update FTP settings in both the Web & API config. The parameters highlighted in screenshot below are required fields. Always use the encrypted password for NEXT:
3. Test SFTP
Click the “Test SFTP Connection”. Test will be successful once web config settings are correct.