This release - eliminates an errorlog.txt entry caused when generating an outgoing spot via a PacketCluster (tnx to Phil GU0SUP) - if the USA callsign-to-gridsquare database USAP.mdb is present in DXView's or SpotCollector's Databases folder, uses this database to determine the location of callsigns in the United States, Hawaii, Alaska, Puerto Rico, US Virgin Islands, Guam, Marianas Islands, and American Samoa - replaces the "Extract Spotter Gridsquare" option with "Capture location info from notes" (see description below) - replaces the "Convey DX Gridsquare" option with "Lookup missing location info" (see description below) - adds Azimuth, CQ, ITU, IOTA, Primary, and Region items to each Spot Database Entry (these will appear as the right-most columns in the Spot Database Display; you can move them if desired) - provides the ability to sort the Spot Database Display by Azimuth (tnx to Laurent F1JKJ) - extracts IOTA tags from spot notes if "Capture location info from note" is enabled (tnx to Juergen DL8LE) - provides the ability to specify the current sunrise and sunset times on the Band Filter window and reference these times in specifying Start and End times for each band - automatically update the sunrise and sunset times from DXView (version 2.8.9 or later) - enables other DXLab applications to determine whether SpotCollector is configured to generate outgoing cluster spots (tnx to Danny N7DC) - provides the ability to specify the names of folders containing .wav files for entities, bands,and modes, .wav files for alphanumerics, and .wav files for phonetics (tnx to Jack N5KDV) - updates the CollectingSpots.htm, Configuration.htm, ConfigurationAudio.htm, ConfigurationGeneral.htm, index.htm, SourceConnection.htm, and SpotDatabase.htm online documentation files The USAP (for USA and Possessions) database contains a record for each of the ~700K active callsigns issued by the FCC to stations in the USA, Hawaii, Alaska, Puerto Rico, US Virgin Islands, Guam, American Samoa, and the Marianas Islands. Each record contains a callsign, a gridsquare, and a two-character location identifier, which is either a US state abbreviation, PR, VI, GU, AS, or MP. When directed to determine a callsign’s location, SpotCollector uses the DXCC database to determine the callsign's DXCC entity. If the file USAP.mdb was present in DXView's or SpotCollector's Databases folder at startup and the callsign’s DXCC entity is in the above list, then SpotCollector queries the USAP database. If there's a match, then SpotCollector changes the DXCC entity if necessary, and uses the more accurate location data (region name, CQ zone, ITU zone, local time, lat/lon, and gridsquare) provided by this database. The USAP database is constructed by a program that traverses a commercial zipcode-to-location database and two FCC-supplied databases: one that provides a zipcode and unique ID for each FCC-issued callsign, and another that indicates which unique IDs are active (as opposed to expired). The FCC updates its database each month, but I’ll be regenerating and distributing USAP less frequently than that. Archived in a self-extracting executable, USAP is 12 mb in size. Since its both big and optional, I am not including it in either full or development releases of SpotCollector. You can obtain the current version from http://www.dxlabsuite.com/dxview/USAP.exe After downloading, direct the self-extracting executable to place USAP.mdb into DXView's Databases folder. The current USAP database can always be obtained via the DXView entry in the "Available DXLab Releases" table in http://www.dxlabsuite.com/download.htm If USAP.mdb isn’t present in either DXView’s or SpotCollector's Databases folder, then SpotCollector will use the DXCC database alone to determine callsign location. When the "Capture location info from notes" option is enabled, SpotCollector attempts to recover location information for an entry's DX station [grid square, IOTA tag] and spotting station [grid square] from its spot notes; if successful, this information is used in preference to location information provided by the cluster software When the "Lookup missing location info" option is enabled, SpotCollector attempts to obtain location information for an entry's DX station (grid square, IOTA tag, CQ zone, ITU zone, continent, primary administrative subdivision, region) and spotting station (grid square) via DXCC or USAP database lookup if this information has not been extracted from spot notes or provided by the cluster software. When you double-click on a Spot Database Entry, SpotCollector will send the new location information (IOTA tag, CQ zone, Primary administrative entity, etc.) to both WinWarbler and DXKeeper along with the callsign, DXCC entity, band, and mode; however, the currently-available releases of these applications will ignore this information. Forthcoming releases of WinWarbler and DXKeeper will accept this information. Tnx to Jamie W2QO, Rich W3ZJ, Joe W4TV, and Art W2NRA for their help in testing this release. SpotCollector 4.2.3 is available via the DXLab Launcher, and via http://www.dxlabsuite.com/download.htm . 73, Dave, AA6YQ