Setting Up Reports with SFTP - Revision history

GMalcom: /* Troubleshooting */

2025-01-20T17:05:14Z

Troubleshooting

← Older revision		Revision as of 17:05, 20 January 2025
Line 46:		Line 46:

	= Troubleshooting =		= Troubleshooting =
	<p>If ~~you~~ are ~~having issues~~ after setup</p>		<p>If issues reporting are still present after setup:</p>
	#Ensure the DNS settings are correct. Check if the IPs in the DNS file can be successfully pinged.		#Ensure the DNS settings are correct. Check if the IPs in the DNS file can be successfully pinged.
	#Check filenames and match them with the parameters.		#Check filenames and match them with the parameters.
	#Ensure a full reboot has been performed.		#Ensure a full reboot has been performed.
	#Check the passwords in the SFTP file.		#Check the passwords in the SFTP file.

GMalcom: /* Changing the Parameters */

2025-01-20T17:04:33Z

Changing the Parameters

GMalcom: /* Uploading the Files */

2025-01-20T13:45:52Z

Uploading the Files

← Older revision		Revision as of 13:45, 20 January 2025
Line 26:		Line 26:
	#Using <zrec>, upload all of the edited .ACC and .BAT files.		#Using <zrec>, upload all of the edited .ACC and .BAT files.
	#After the files have been uploaded, check if they are present using the <dir> command. To do so, enter <dir [filename]>, replacing filename with the appropriate .ACC or .BAT filename.		#After the files have been uploaded, check if they are present using the <dir> command. To do so, enter <dir [filename]>, replacing filename with the appropriate .ACC or .BAT filename.

	##For example, <dir CCSXFTP.ACC> would search for the CCSXFTP.ACC file.		##For example, <dir CCSXFTP.ACC> would search for the CCSXFTP.ACC file.

GMalcom at 20:59, 17 January 2025

2025-01-17T20:59:59Z

← Older revision		Revision as of 20:59, 17 January 2025
Line 1:		Line 1:
	<p>The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used is to send reports from the APU. Configuration is available on the APU to support both consist reports and maintenance reports. </p>		<p>The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used is to send reports from the APU. Configuration is available on the APU to support both consist reports and maintenance reports. </p>
	= Preparation =		= Preparation =
	#SFTP can be setup and deployed by Comet Support if we have access to the site.		SFTP can be setup and deployed by Comet Support if we have access to the site.
	##In the case that we don’t have access to the site:		#In the case that we don’t have access to the site:
	###A Telnet session that supports Zmodem(Hyper Terminal, Tera Term, Secure CRT) will be used.		##A Telnet session that supports Zmodem(Hyper Terminal, Tera Term, Secure CRT) will be used.
	###Files used in the process will be sent with a .txt extension as most email firewalls will block .ACC and .BAT files. Download these files and change the extensions back to .ACC and .BAT as directed.		##Files used in the process will be sent with a .txt extension as most email firewalls will block .ACC and .BAT files. Download these files and change the extensions back to .ACC and .BAT as directed.
	##Two different files, an .ACC and a .BAT, will be needed. The .ACC file will point to the .BAT file. Both can be obtained by contacting Comet Support. If setting up for Consist ''and'' Maintenance Reporting via SFTP, four different files will be needed.		##Two different files, an .ACC and a .BAT, will be needed. The .ACC file will point to the .BAT file. Both can be obtained by contacting Comet Support. If setting up for Consist ''and'' Maintenance Reporting via SFTP, four different files will be needed.
	##For SFTP to be setup, the following information Is needed:		#For SFTP to be setup, the following information Is needed:
	###Username		##Username
	###Password		##Password
	###URL		##URL
	<p style="margin-left: ~~100px~~;" >Send this information to Comet Support if Support will be setting up SFTP.</p>		<p style="margin-left: 50px;" >Send this information to Comet Support if Support will be setting up SFTP.</p>
	#We highly recommend using names for the files that indicate Consist or Maintenance. It is recommended to name these files based on the name of the railroad the site belongs to, as well. Using a unique name is important, as the same file name being used elsewhere can cause issues.		We highly recommend using names for the files that indicate Consist or Maintenance. It is recommended to name these files based on the name of the railroad the site belongs to, as well. Using a unique name is important, as the same file name being used elsewhere can cause issues.
	##For example, if the railroad is CSX:<br>When naming a consist file, the name “CCSXSFTP.ACC/.BAT” would be used.<br>When naming a maintenance file, the name “MCSXSFTP.ACC/.BAT” would be used.		#For example, if the railroad is CSX:<br>When naming a consist file, the name “CCSXSFTP.ACC/.BAT” would be used.<br>When naming a maintenance file, the name “MCSXSFTP.ACC/.BAT” would be used.

	= Editing The Files =		= Editing The Files =

GMalcom at 20:58, 17 January 2025

2025-01-17T20:58:11Z

← Older revision		Revision as of 20:58, 17 January 2025
Line 12:		Line 12:
	<p style="margin-left: 100px;" >Send this information to Comet Support if Support will be setting up SFTP.</p>		<p style="margin-left: 100px;" >Send this information to Comet Support if Support will be setting up SFTP.</p>
	#We highly recommend using names for the files that indicate Consist or Maintenance. It is recommended to name these files based on the name of the railroad the site belongs to, as well. Using a unique name is important, as the same file name being used elsewhere can cause issues.		#We highly recommend using names for the files that indicate Consist or Maintenance. It is recommended to name these files based on the name of the railroad the site belongs to, as well. Using a unique name is important, as the same file name being used elsewhere can cause issues.
	###For example, if the railroad is CSX:<br>When naming a consist file, the name “CCSXSFTP.ACC/.BAT” would be used.<br>When naming a maintenance file, the name “MCSXSFTP.ACC/.BAT” would be used.		##For example, if the railroad is CSX:<br>When naming a consist file, the name “CCSXSFTP.ACC/.BAT” would be used.<br>When naming a maintenance file, the name “MCSXSFTP.ACC/.BAT” would be used.

	= Editing The Files =		= Editing The Files =

GMalcom at 20:55, 17 January 2025

2025-01-17T20:55:31Z

← Older revision		Revision as of 20:55, 17 January 2025
Line 1:		Line 1:
	<p>The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used is to send reports from the APU. ~~</p><p><br>~~</p>		<p>The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used is to send reports from the APU. Configuration is available on the APU to support both consist reports and maintenance reports. </p>
	= Preparation =		= Preparation =
	#SFTP can be setup and deployed by Comet Support if we have access to the site.		#SFTP can be setup and deployed by Comet Support if we have access to the site.

GMalcom at 20:54, 17 January 2025

2025-01-17T20:54:07Z

← Older revision		Revision as of 20:54, 17 January 2025
Line 1:		Line 1:
	<p>The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used is to send reports from the APU. </p><p><br></p>~~<p><br></p>~~		<p>The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used is to send reports from the APU. </p><p><br></p>
			= Preparation =
	#SFTP can be setup and deployed by Comet Support if we have access to the site.		#SFTP can be setup and deployed by Comet Support if we have access to the site.
	##In the case that we don’t have access to the site:		##In the case that we don’t have access to the site:

GMalcom at 20:47, 17 January 2025

2025-01-17T20:47:55Z

← Older revision		Revision as of 20:47, 17 January 2025
Line 1:		Line 1:
	<p>The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used </p><p><br></p><p><br></p>		<p>The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used is to send reports from the APU. </p><p><br></p><p><br></p>
	#SFTP can be setup and deployed by Comet Support if we have access to the site.		#SFTP can be setup and deployed by Comet Support if we have access to the site.
	##In the case that we don’t have access to the site:		##In the case that we don’t have access to the site:

GMalcom: Created page with "
The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used

#SFTP can be setup and deployed by Comet Support if we have access to the site. ##In the case that we don’t have access to the site: ###A Telnet session that supports Zmodem(Hyper Terminal, Tera Term, Secure CRT) will be used. ###Files used in the process will be sent with a .txt extension as most email firewalls w..."

2025-01-17T20:47:33Z

Created page with "The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used #SFTP can be setup and deployed by Comet Support if we have access to the site. ##In the case that we don’t have access to the site: ###A Telnet session that supports Zmodem(Hyper Terminal, Tera Term, Secure CRT) will be used. ###Files used in the process will be sent with a .txt extension as most email firewalls w..."

New page

The Secure File Transfer Protocol (SFTP) is used to manage files over a remote connection. At Comet, one way SFTP is used  
#SFTP can be setup and deployed by Comet Support if we have access to the site.
##In the case that we don’t have access to the site:
###A Telnet session that supports Zmodem(Hyper Terminal, Tera Term, Secure CRT) will be used.
###Files used in the process will be sent with a .txt extension as most email firewalls will block .ACC and .BAT files. Download these files and change the extensions back to .ACC and .BAT as directed.
##Two different files, an .ACC and a .BAT, will be needed. The .ACC file will point to the .BAT file. Both can be obtained by contacting Comet Support. If setting up for Consist ''and'' Maintenance Reporting via SFTP, four different files will be needed.
##For SFTP to be setup, the following information Is needed:
###Username
###Password
###URL
Send this information to Comet Support if Support will be setting up SFTP.
#We highly recommend using names for the files that indicate Consist or Maintenance. It is recommended to name these files based on the name of the railroad the site belongs to, as well. Using a unique name is important, as the same file name being used elsewhere can cause issues.
###For example, if the railroad is CSX: When naming a consist file, the name “CCSXSFTP.ACC/.BAT” would be used. When naming a maintenance file, the name “MCSXSFTP.ACC/.BAT” would be used.

= Editing The Files =
Be very careful when editing the files. A simple deletion of a symbol like % or = could result in SFTP failure. The only files that will need editing are the .BAT files. The .ACC files should not be edited.
#To edit the .BAT file, simply right-click on the file and select Edit from the right-click menu.
#There will be a section that lists the username, password, and URL to be used. Change these values to match the information noted previously. 
#Make sure to save the file after any changes have been made when editing.

= Uploading the Files =

#Login to the supervisory menu of the APU.
#Enter the <zrec> command, this should prompt a pop-up to begin the file transfer. What the pop-up looks like depending on what Telnet terminal is being used. Some require you to type the file and location of the file.
#Using <zrec>, upload all of the edited .ACC and .BAT files.
#After the files have been uploaded, check if they are present using the <dir> command. To do so, enter <dir [filename]>, replacing filename with the appropriate .ACC or .BAT filename.

##For example, <dir CCSXFTP.ACC> would search for the CCSXFTP.ACC file.

= Changing the Parameters =

#Login to the supervisory menu of the APU.
#Enter the <ep> command to open the edit parameters menu.
#Navigate to Session 1 in the edit parameters menu.
#Enter "3" to access AEI Report Connect. This submenu contains the information required to establish an SFTP connection is stored. This allows the APU to send consist reports. See below for an example of what this menu looks like. [A picture of the AEI Report Connect menu.]
#Enter the filename of the .ACC file used for consist reports created earlier in the AccessFilename parameter.
#Navigate back to Session 1 by pressing <esc> or <x>.
#Enter “2” to access AEI Report Opts. This submenu configures how the APU reports its data. See below for an example of what this menu looks like. [A picture of the AEI Report Opts menu.]
#Set the HostReportingOption parameter to 1 to enable reporting.
#If setting up Maintenance reports, repeat this process for the Maintenance Reports. Option 4 will access the Maintenance Report Options submenu, and option 5 will access the Maintenance Report Connect submenu. 
#Once all the files and parameters have been changed, perform a full reboot using the <r> command. This will ensure the changes made will take effect.
#To test the SFTP setup for consist reports, type in, HR,NOW at the supervisory menu. This will force the APU to send consist reports.
#To test the maintenance reports, enter the <sm> command to simulate maintenance. Wait a few minutes for everything to send.
#At the Supervisory menu, enter <sys> to access the system log. Select 101 for reporting and c for continuous. To check if the report settings are correct, the filename chosen previously for the .ACC file(s) should now be reflected in the log. The file transfer log should also report messages similar to the following:
 This indicates that the files have been successfully reported.
= Troubleshooting =
If you are having issues after setup
#Ensure the DNS settings are correct. Check if the IPs in the DNS file can be successfully pinged.
#Check filenames and match them with the parameters.
#Ensure a full reboot has been performed.
#Check the passwords in the SFTP file.

← Older revision		Revision as of 17:04, 20 January 2025
Line 33:		Line 33:
	#Enter the <ep> command to open the edit parameters menu.		#Enter the <ep> command to open the edit parameters menu.
	#Navigate to Session 1 in the edit parameters menu.		#Navigate to Session 1 in the edit parameters menu.
	#Enter "3" to access AEI Report Connect. This submenu contains the information required to establish an SFTP connection is stored. This allows the APU to send consist reports. See below for an example of what this menu looks like.<br>[~~A picture of the AEI Report Connect menu~~.]		#Enter "3" to access AEI Report Connect. This submenu contains the information required to establish an SFTP connection is stored. This allows the APU to send consist reports. See below for an example of what this menu looks like.<br>[[image:img1737423083070.png\|287px\|center\|frameless]]<br>
	#Enter the filename of the .ACC file used for consist reports created earlier in the AccessFilename parameter.		#Enter the filename of the .ACC file used for consist reports created earlier in the AccessFilename parameter.
	#Navigate back to Session 1 by pressing <esc> or <x>.		#Navigate back to Session 1 by pressing <esc> or <x>.
	#Enter “2” to access AEI Report Opts. This submenu configures how the APU reports its data. See below for an example of what this menu looks like.<br>[~~A picture of the AEI Report Opts menu~~.]		#Enter “2” to access AEI Report Opts. This submenu configures how the APU reports its data. See below for an example of what this menu looks like.<br>[[image:img1737464403104.png\|289px\|center\|frameless]]<br>
	#Set the HostReportingOption parameter to 1 to enable reporting.		#Set the HostReportingOption parameter to 1 to enable reporting.
	#If setting up Maintenance reports, repeat this process for the Maintenance Reports. Option 4 will access the Maintenance Report Options submenu, and option 5 will access the Maintenance Report Connect submenu.<br>		#If setting up Maintenance reports, repeat this process for the Maintenance Reports. Option 4 will access the Maintenance Report Options submenu, and option 5 will access the Maintenance Report Connect submenu.<br>
Line 42:		Line 42:
	#To test the SFTP setup for consist reports, type in, HR,NOW at the supervisory menu. This will force the APU to send consist reports.		#To test the SFTP setup for consist reports, type in, HR,NOW at the supervisory menu. This will force the APU to send consist reports.
	#To test the maintenance reports, enter the <sm> command to simulate maintenance. Wait a few minutes for everything to send.		#To test the maintenance reports, enter the <sm> command to simulate maintenance. Wait a few minutes for everything to send.
	#At the Supervisory menu, enter <sys> to access the system log. Select 101 for reporting and c for continuous. To check if the report settings are correct, the filename chosen previously for the .ACC file(s) should now be reflected in the log. The file transfer log should also report messages similar to the following:		#At the Supervisory menu, enter <sys> to access the system log. Select 101 for reporting and c for continuous. To check if the report settings are correct, the filename chosen previously for the .ACC file(s) should now be reflected in the log. The file transfer log should also report messages similar to the following:<br>[[image:img1737465999134.png\|448px\|center\|frameless]]<br>
	<p><br>~~</p>~~<p>This indicates that the files have been successfully reported.</p>		<p>This indicates that the files have been successfully reported.</p>

	= Troubleshooting =		= Troubleshooting =
	<p>If you are having issues after setup</p>		<p>If you are having issues after setup</p>