Lake O uses old batch hand helds for row location inventory because newer ones are not cold tolerant. We do not have source for the programs, they have worked as they do for a very long time. No changes are ever made to the programs, but the ROUTE.INI controls the upload. The ini file is attached.
It uploads to VAP01. NOTE: I am unable to be sure of all the locations. The SSIS package looks to AP02, with no override found. Depending on the ROUTE.INI file, it may send to AP02 or to VAP01. If it goes to VAP01, I don't see how it could post. Looks suspiciously like it posts to AP02, it is processed there and the "posted" file is saved to VAP01. I have requested a ROUTE.INI file from Jerry P in Lake O, who is one of the key users.
FTPAlertsCommand=ProcessHandHeld.cmd
FTPPassword=Be@ns4you
FTPUser=lakeoftp
FTPHostName=vap01
FTPCommand=ProcessHandHeld.cmd
FTPDirectory=Upload02
The above ini is not in use. It is the one here in use: It is in the HHTRANS folder. This should be changed as time permits
UploadDirectory=C:\Route
DownloadDirectory=C:\Route
TFTPDirectory=C:\Route\HHtrans
BackupDirectory=C:\Route\DATA
;
RemoteCommandProgram=RMTCMD
AS400Name=192.168.9.3
DownAS400Command=
UpAS400Command=CALL TCFUSER/IN0500XT3
UploadParameterName=C:\ROUTE\Data\MovementtoAS400.dtt
UpFileName=movement.txt
UploadProgramName=rfrompcb
SocketPort=1001
ServerPort=6000
ClientPort=6001
BewtweenTransmit=90
AfterTransmit=30
DataFileName=movement.dat
MasterFileName=detail.txt
WindowsNT=Y
SendTime=N
HostAddr=COM1
;[FTPSection]
UploadMethod=F
FTPAlertsCommand=ProcessHandHeld.cmd
FTPPassword=FTPIN
FTPUser=FTPIN
FTPHostName=ap02
FTPCommand=ProcessHandHeld.cmd
FTPDirectory=Upload02
it puts information into \\vap01\einterface\Upload02.
A scheduled job (Process Hand Helds) will post the contents of this file.
The SSIS package is ProcessHandHelds.dtsx
Within Information Services is a standard folder Route, with all the necessary components, although I suggest copying from Jerry P's PC in Lake O to be sure you get the right settings.
There is NO technical support for this process so exercise extreme caution when making changes. Always best to make copies!