Touchnet eRefund file
Problem Description :
How to send the Touchnet eRefund file
Resolution :
eRefund Processing
After you have completed all of your processes and are ready to pull the file to be sent to the check writers do the following.
Go to N:\BO\sqls\TN Refund Processing
Run the batch file refund.bat
A file will be created in the data folder called refund_fileYYYYMMDDHHMM.csv – This is the file to be sent to TN for processing. � Please spot check the file to be sure the people you expect to get refunds are on there and check the amounts of a few. � Check and be sure the date is the date you ran it and the time.
A second file is also created called refund_file_total.txt – This file is for you to check the total of the refund file.
Once you are ready to send the file to TN – call Laura or Troy so that we can ftp the encrypted file.
A second copy of these files are also placed in the archived folder.
To Upload to Touchnet
1. Go to vulture through vshpere - D Drive Batch Folder.
2. Edit touchnet.bat and change the filename variable at the top to match the csv file that the Business Office has generated under N:\BO\sqls\TN Refund Processing\data\. Save
3. Double-click on touchnet.bat to run
a. Batch will ask for a passphrase to sign and encrypt the file. Enter the Server admin password.
b. Type y enter in command prompt when it asks to verify file
4. File is now encrypted and sent to touchnet sftp server
5. Notify the BO
Download PDF of checks from Touchnet
1. Go to vulture through vshpere
2. Open SSH Secure File Client from desktop
3. Under Profiles click on 'Touchnet' (this is predefined connection to touchnet sftp server using information below under Touchnet sftp server details)
4. Login with password provided to us by Touchnet
5. Double-click on checkspickup folder and download encyrpted PDF file to local drive.
6. Close SSH Secure Client and navigate to location that you saved file
7. Right-click on file and choose 'Decrypt' under More GpgEX options.
8. On Decrypt/Veify Files dialog box choose Decrypt/Verify button
9. Enter same passphrase used to upload the refund file which is for our signed certificate (Server admin password).
10. File should now be unencyrpted in the same directory. Copy to location for BO to access.
Touchnet sftp server details
Host: ft.touchnet.com
User: 20805
Revision Date : 6/24/2013