LastCall is a Windows program that shows the last time a set of WinRVM sites has called in to the FTP and SFTP servers.

Installation info:

Naugatuck employees:
Run w:\LastCall\chilkatax-9.5.0-win32.msi once to install the Active-X component used to access the SFTP server.
C
reate a shortcut to w:\LastCall\LastCall.exe and double-click the shortcut to run. Sites.txt has already been set up in this folder.
For maximum speed, you should go to the Lastcall options and change the “Unzip program” field to the path\filename on your C: drive such as “c:\Program Files\7za.exe”.
Fix: download and install 7zip from
here.

Other users:
LastCall doesn't have an installer program. You'll need to manually create the folder c:\program files\LastCall and unzip LastCall.zip  there and make a shortcut to LastCall.exe.
Also, the PC must have the VB6 run-time files (if LastCall displays an error when running such as "comdlg32.dll missing", install WinRVM which will install the VB6 run-time files).
Install chilkatax-9.5.0-win32.msi before running LastCall.
Create a file called Sites.txt and place into the same folder as the LastCall program.

Program Description:  Sites.txt contains a list of all the site IDs you want to monitor such as: 
280430 
260829 
999999 
999997
...



Format of sites.txt:

[location]
site id,site name,supervisor,tech,2-way calling (Y/N),# of RVMs, offline (Y/N),cellular (Y/N)

Note: everything after the site ID is optional. The "offline" field indicates the site is new and doesn't have a phone line hooked up yet.

Note: as of LastCall ver 2.2.3 the "# of RVMs" is obtained from the edas database automatically and will supersede any value entered in sites.txt unless the site ID couldn't be located in the database, in which case the value in sites.txt will be used instead.

Included with the zip file is a sample sites.txt file that you can edit. It should be located in the same folder as LastCall.exe.

Sample sites.txt file:

;format: site id,site name,supervisor,tech,2-way calling (Y/N),# of RVMs, offline (Y/N),cellular (Y/N),iPAQ/netbook (iPAQ/netbook)

[CA]
271736,Lucky's 736, CA, Oakland, Y, 1,,,NETBOOK
271999,Nexcycle Lab Machine, CA, Hayward, Y, 1,,,NETBOOK
270639,Safeway 639, CA, San Mateo, Y, 1,,,NETBOOK
272270,Von's Market 2270, CA, Los Angeles, Y, 1,,,NETBOOK

[OR]

101772,WM 1772, OR, Klamath Falls, Y, 7,,,IPAQ
285143,TJ 143, OR, Portland, Y, 2,,,NETBOOK
105994,WM 5994, OR, W. Linn, Y, 3,,,NETBOOK
252501,Ray's 44, OR, Waldport, N, 4,,,IPAQ

[NE]

226901,Online Wine, TV, M-CN, N, 1,,,IPAQ
279001,Sodaman, NM, C-W, N, 1,,,iPAQ
283201,South Side Liquors, TV, M-CE, N, 3,,,IPAQ
802403,Stop & Shop 2403, TV, M-Cape, N, 2,,,IPAQ


[MI]

292424,Wal-Mart 4424, MS, M, Y, 7,,,U-48
900526,Kroger 526, KK, M, Y, 5,,,IPAQ
569115,Family Fare 115, KK, M, Y, 5,,,NETBOOK

[TECH]

[IA]

401764,Walmart 1764, BJ, I-S, Y, 4,,,NETBOOK

;
;-------------------------------
;Tech files consisting of 77+PIN
;-------------------------------
;
;format: site id,site name,supervisor,tech,2-way calling (Y/N),# of RVMs
771108,Neil Minto
771352,Joe Buckley
771355,Bob Beguerie
771786,Tony Clarizio

[REIMAGINE]

;-------------------------------
;Reimagine sites
;-------------------------------

500001,Reimagine Arlington,TX,Arlington,N,0,,,PC
500011,Reimagine Mobile,TX,mobile,N,0,,,PC
500021,Reimagine Garland,TX,Garland,N,0,,,PC
500031,Reimagine Plano,TX,Plano,N,0,,,PC
500041,Reimagine Irving,TX,Irving,N,0,,,PC
500051,Reimagine Little Elm,TX,Little Elm,N,0,,,PC
599992,Reimagine Naugatuck,CT,Naugatuck,N,0,,,PC

;-----------------------------------------------------------------------------
;List of supervisor's email addresses for emailing supervisor-specific reports
;separate multiple addresses with a ";"
;-----------------------------------------------------------------------------

SUPERVISOR EMAIL:NM=neilm@envipco.com
;SUPERVISOR EMAIL:OR=someone@somewhere.com
SUPERVISOR EMAIL:RM=medasrts@gmail.com;
SUPERVISOR EMAIL:JB=joegrynd23@aol.com
SUPERVISOR EMAIL:TS=sepola@yahoo.com;cypers187@hotmail.com;2034371351@vtext.com
SUPERVISOR EMAIL:TV=tonyc.envipco@gmail.com
SUPERVISOR EMAIL:KK=kennyk@envipco.com
SUPERVISOR EMAIL:MS=marks@envipco.com
;SUPERVISOR EMAIL:ALL=someone@somewhere.com
;The "ALL" email will receive a single email with data from all supervisors

[IGNORED]
000300,Greece
000302,Greece
000303,Greece
000304,Greece
000305,Greece
000306,Greece
000307,Greece

600001,Sweden Quantum
600002,Sweden Quantum
600003,Sweden Quantum
 



Program Operation:
The first time you run LastCall it will ask you to input the folder where incoming zip files are saved...browse to whatever network path you use such as "g:\files from bridge program" or W:\.



If you check the "automatically show last call times on startup" checkbox in the Options the program will automatically show the times without you having to click the "show times" button.
The program will automatically re-read the data and refresh the screen every 5 minutes. You can change this setting in the Options via the "Refresh time (minutes)" option (set to 0 to disable this feature).
Click the "open folder" icon to launch Windows Explorer in the bridge folder.

Double-click an entry to show all the times the site called in. From this new window, double-click a specific entry to open the zip file.
Right-clicking an entry in the "last call" list pops up a menu with choices:
    - print selected
    - unzip file
    - call site with MUSTATUS or RVMStatus
    - Download zip file from server (if zip file present on server)
    - show last time a "store visit test" was performed
    - Show all times this site called in
    - Show complete event log for this site

The location check boxes can be used to selectively display sites in different geographic locations such as: IA, OR, NE, MI or the technician files

The print button prints a report to the default printer containing the Site IDs and last call times followed by the missing site info. It prints to the default printer in a two-column format; to select a different printer, click Options, then enable "Show printer window before printing".

The "email missing today" button sends a unique email (MS Outlook only) to each supervisor that indicates just the sites pertaining to that supervisor as defined by the "SUPERVISOR EMAIL:" lines in sites.txt (you can send the email to multiple recipients, just separate the email addresses with ";"). After clicking you may to approve the email from a second pop-up window (see troubleshooting section below for how to disable this).
The email subject indicates the supervisor's initials such as:
"[RM] WinRVM sites that haven't called in 04/06/11"
The title of the emailed report indicates the supervisor such as:
"WinRVM sites for supervisor NM that haven't called in the last 24 hours (as of 4/6/2011 8:58:43 AM)"
The "ALL" email will receive a single email with data from all supervisors, but this feature is disabled by default.
Right-clicking this button puts the report in the copy/paste buffer w/o emailing.
The “sites missing downloads” section of the report refers to sites that are missing Q file the last time that site called in, even if it hadn’t called in for weeks.

The "Rvms" column indicates the number of RVMs at the site.

The "Q file?" column will have a "Q" if the zip file is large enough to contain a Q file, otherwise it is blank. This is controlled by the "File size threshold to assume Q file was included in zip file" setting (default is 4200).

The "missing" column indicates the number of RVM Q files missing from the last zip file sent by the site that contained a Q file.

The "days" column indicates how many days it has been since the site called in with all the Q files expected.

The "FTP file?" column indicates which server the SITEID.ZIP file is on. Previously, it indicated "Z" when there was a file on the FTP server, it now indicates "F" for FTP server, "S" for SFTP server, or "B" if on both servers and it can't be determined which server the site is using.
The actual server that each site last sent data to is taken into account. For example, if you use Site Zip Copier to send a file to both servers, but a site uses the SFTP server, it will indicate "S". Once the site retrieves the zip file and deletes it from the SFTP server, the "FTP File" column will be blank, even though there is a corresponding zip file on the FTP server.
If LastCall doesn't yet know what server a particular site last sent data to, it will indicate a "?" after the server designation such as "F?".
To enable this feature, check "Indicate which sites haven't picked up their zip file from the FTP server's tosite folder" in the Options.
The "last server used" feature relies on FTPBridge ver 1.1.0 (or later), which creates the file (W:\ServerUsedBySite.csv) containing a list of all sites and which server (FTP or SFTP) each site last sent data to.

The "calls this day" column shows how many times the site has called in on the last day it called in.

The "cell" column indicates if a cellular modem is installed on site.

Click any column header to sort the list by that column. Click again to reverse sort.

A "+ N unrecognized" button will be displayed after "Total sites:" if LastCall finds sites not listed in sites.txt.

LastCall will automatically delete zip files older than 90 days from the "incoming zip file folder". You can change this setting in the Options ("Purge files older than X days"). The program makes sure this setting is at least 60. Note: it uses the date embedded in the filename. If the date is older than 12/31/05 the file WON'T be deleted as files older than this indicates WinRVM's clock must be set incorrectly.
The options also contains a "purge files less than Y days old" setting which defaults to 180 days.  This prevents zip files from pocket PCs with incorrect dates from being deleted.
Note: if all files from a site are older than the "purge days" setting, the last file called in will be saved.

If "Highlight previously selected site ID on refresh" or "Highlight previously selected site ID on startup" is enabled in the Options, after clicking the "Show times (refresh)" button / automatic refresh / startup, the previously selected site will remain highlighted. The window will scroll so the selected site is in the center. If disabled, the first entry in the list will be highlighted.

The program's window size and position and restored on startup. The current sort column, sort order, and sort key are remembered.


 

Show complete event log for a site

Right click a site and select "Show complete event log for this site". When selected, one giant log file is created from all existing log files called in by this site. The following window will be displayed showing the progress:

When done, the log file such as "280606 Log.txt" will be opened.

This log file is saved in the "Logs" subfolder of the "Incoming zip file folder" specified in the Options such as W:\Logs.

Click the folder icon to open the log folder to view previously created logs from other sites.


You can use this feature instead of manually sending a command file such as (sendfile \my documents\cf1500\WinRVMlog Month nn.txt) to a site to retrieve the the monthly log file.
  



Q file harvesting

Click the "Q file harvest" button to display a window to let you select between harvesting all sites displayed on the main screen or Stop and Shop files only. If choosing Stop and Shop you must also select the state(s), the states only apply when selecting Stop & Shop.
Once you make a selection, additional fields (2 thru 4 below) will be displayed in the window:

Click on the desired start date, it defaults to the current day. You can select a previous month if needed. The harvesting feature works when spanning across a month.

Enter the number of days to look for Q files, which defaults to the previous value.
Example: if you select the 15th of today's month and one or more Q files aren't available from the zip file called in on the 15th, LastCall will attempt to find the file on the 14th, the 13th, etc, for up to 5 days.
If two RVMs at different sites have the same serial number, a warning will be displayed.

Enter the folder to unzip the Q files to, which defaults to the previous value.

If you select to harvest Stop & Shop Q files only, LastCall determines which sites are Stop & Shops by searching the eDAS database, not sites.txt.
However, sites.txt is still used by LastCall; this file needs to be maintained until the program is changed over to use eDAS completely.

When harvesting is complete, a window will display the results such as:



If you click "yes", "Q file harvest report.txt" is displayed (saved in the LastCall.exe program folder), which indicates which sites are missing Q files. Sample report:

Run time: 9/18/2009 2:36:49 PM
Processed all Q files from 09/15/09 for 5 days prior

Site 192001: 1 Q file missing out of 1
Site 205012: 2 Q files missing out of 2 for 4 days
Site 213001: 1 Q file missing out of 3
Site 219501: 5 Q files missing out of 19 for 8 days
Site 228125: 2 Q files missing out of 5
Site 280407: 5 Q files missing out of 5 for 3 days
Site 280451: 1 Q file missing out of 5
Site 280639: 2 Q files missing out of 12

11 Q files missing from 8 sites

Total sites: 317
Total RVMs: 1385
1374 Q files unzipped to C:\temp\Unzip test

Duplicate Q files found:
Q040258 at sites 219501 and 135103
Q050222 at sites 219501 and 135103
Q030315 at sites 219501 and 135103
Q031719 at sites 219501 and 135103
Q040150 at sites 219501 and 135103

Click the "Reshow report" button to show the report again, the report ("Q file harvest report.txt") isn't deleted, it's just overwritten the next time you perform a harvest.

Running LastCall with a command-line argument of "harvest" will cause LastCall to perform a harvest then exit.

Technician files (beginning with 77) are NOT processed.

The Q file dates used for comparison are taken from the zip filename itself (such as 280543_02-18-09_050905.ZIP), not the timestamp of the actual Q file.
The harvesting process no longer deletes Q files in the "unzip folder" before starting, so you must remember to delete these files manually.



Q File Search

Click the "Q File Search" button to prompt you for an RVM serial number (enter 5 or 6 digits):
 

The eDAS database is searched for the site ID where this RVM is located. The corresponding zip files on the Bridge Archive (W:\) and technician-sent Q files (W:\TechSearchFiles) for this site are then searched and then a list is presented indicating the times a Q file for this RVM exists such as:

Double-click a date to the open the Q file. The Q file is automatically saved to the folder specified under "Folder to unzip Q files to" in the Q File Harvest window.


 

Options:

 


Troubleshooting:

The following window pops up when you run LastCall:

Fix: download and install 7zip from here. Go to the Lastcall options and change the “Unzip program” field to the path\filename on your C: drive such as “c:\Program Files\7za.exe”.
If there's a checkbox that says "Don't show this message again", check it.

The following window pops up when you try to email a report:

Fix: in Outlook's Tools menu, click Trust Center then Programmatic Access then select "Never warn me about suspicious activity".

After initial installation if the Windows firewall blocks the program, make sure to allow LastCall to have network access. Go to the options to make sure all the fields aren't blank or set to 0 (it should look similar to the above screenshot), otherwise, click the "Use default registry settings" button to fix this.

If you start LastCall and the "Total files" field increments very slowly:
- Make sure your PC is using a CAT6 Ethernet cable to connect to the network
- Make sure you don't have any other copies of LastCall running by holding ctrl-alt-del, select "task manager", then "applications". Click LastCall then click "end task". Repeat for all copies of LastCall. Rerun LastCall, it should work normally.

If nothing seems to happen on startup, enable the "Automatically show last call times on startup" in the options.

When you run the program this window pops up: "The publisher could not be verified. Are you sure you want to run this software?"
Fix:
From Internet Explorer click "Tools | Internet Options"
Click the Security tab
Select 'Local Intranet' icon
Click 'Sites', which opens a 'Local Intranet' window
Click 'Advanced'
Enter network share where SiteZipCopier is run from such as "\\isis\" then click "Add".
Click 'Close, then 'OK' twice.
Restart Internet Explorer

If it has trouble logging into the server, run LastCall directly from the W: drive and if you get a Windows Firewall pop up window asking if you want to keep blocking this program, choose to unblock it.

If you get the error "The version of this file is not compatible with the version of Windows you're running." and you're running a 64-bit version of Windows, upgrade to WinRVM 2.0.0 which uses 7-zip.


FAQ:

Unzipping files from the network is very slow (such as the harvesting feature).
For maximum speed, you should go to the Lastcall options and change the “Unzip program” field to the path\filename on your C: drive such as “c:\Program Files\7za.exe”.

I changed a supervisor in an area and now that when a report is sent to that supervisor it lists no sites.
You must rename the supervisor entries in sites.txt to match the new supervisor's initials.

How do you determine an RVM's software version?
Double-click the site that has this RVM and double-click the latest zip file that has a correspond Q file. The 7th line of the Q file indicates the RVM version such as "May15'08" in this example:
HI RVM 1500 May15'08 10:12 (A,C,031452)

(currently down)

         word = Microsoft Word document (download free viewer from Microsoft)
          floppy = downloadable software
          Need translation? Try Google translate
          page last updated: 12/20/16 12:39 PM