View Issue Details

IDProjectCategoryView StatusLast Update
00004863 - Current Dev ListEnhancementpublic2020-08-04 07:13
ReporterWA9PIEAssigned ToWILL 
PrioritynormalSeverityfeatureReproducibilityN/A
Status assignedResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary0000486: Enable Counties Award (formatting problem with County field)
DescriptionBecause the County field does not conform to the ADIF standard (county,state), then we need to find a way to combine county and state for the purpose of creating this very popular award report.
Additional InformationPer the ADIF standards (https://www.adif.org/310/ADIF_310.htm#Secondary_Administrative_Subdivision), the US county is "<Two-letter state abbr.>COMMA<county name>" (with no spaces on either side of the comma).

The ADIF standard is an "interchange" standard. It doesn't mean that the State and County both need to be stored in the County field. However, it seems logical that we would do that.

The problem is - State and County are presently two separate fields; both potentially populated.

The proper ADIF 'tag' for this data is "CNTY". So we probably would use COL_CNTY for this purpose.

The question is - how do we get the data there without making a mess?

This will require some thought and planning.
TagsParityGap
ModuleLogbook
Sub-Module(select)
TestingNot Started

Activities

WA9PIE

2018-06-11 23:36

administrator   ~0005240

This has come up at every hamfest since the management change on 1/1/2018.

WA9PIE

2020-08-01 11:43

administrator   ~0009841

Personally, I think we should write a conversion utility that grabs the State and the County and populates it into the COL_CNTY column.

WA9PIE

2020-08-04 07:13

administrator   ~0009851

I'm attaching a CSV that has all 3,077 counties in it (per the award) in the proper format as specified by the ADIF standard: "<Two-letter state abbr.>COMMA<county name>"

For example, "TX,Colin"

We should probably put these in a drop-down list:
- when DXCC = 6, 110, or 291 (this is Alaska, Hawaii, and United States)
- limit State to the list of 50 US States (where this sometimes comes from the callsign lookup) and
- limit the County to the values contained in this file (where this sometimes comes from the callsign lookup)

(this prevents people from entering the data incorrectly)

We will need a data conversion utility to get the existing data into the correct format.

US_Counties (abbreviations only).csv (42,659 bytes)

Issue History

Date Modified Username Field Change
2013-12-21 18:56 W4PC New Issue
2013-12-21 18:58 W4PC Project 2 - Next Dev List (Holding Area) => @5@
2013-12-24 22:39 WA9PIE Project @5@ => @6@
2014-02-02 10:02 WA9PIE Release => (select)
2014-02-02 10:02 WA9PIE Module => (select)
2014-02-02 10:02 WA9PIE Sub-Module => (select)
2014-02-02 10:02 WA9PIE Report Build => (select)
2014-02-02 10:02 WA9PIE Summary Enable Counties Award (formating problem with County field) => Enhancement: Enable Counties Award (formating problem with County field)
2014-02-02 10:08 WA9PIE Status new => confirmed
2014-03-18 22:45 WA9PIE Project @6@ => 2 - Next Dev List (Holding Area)
2014-05-27 14:40 WA9PIE Project 2 - Next Dev List (Holding Area) => 3 - Current Dev List
2014-09-09 15:28 WA9PIE Project 3 - Current Dev List => 2 - Next Dev List (Holding Area)
2015-09-17 13:02 WA9PIE Module (select) => Logbook
2015-09-17 13:40 WA9PIE Category Logbook => Enhancement
2015-09-22 23:33 WA9PIE Fix Build => (select)
2015-09-22 23:33 WA9PIE Proposed Release => TBD
2015-09-22 23:33 WA9PIE Summary Enhancement: Enable Counties Award (formating problem with County field) => Enable Counties Award (formatting problem with County field)
2015-10-01 15:20 WA9PIE Summary Enable Counties Award (formatting problem with County field) => STFU: Enable Counties Award (formatting problem with County field)
2015-10-12 18:04 WA9PIE Project 2 - Next Dev List (Holding Area) => 3 - Current Dev List
2017-03-08 00:07 WA9PIE Project 3 - Current Dev List => 1 - Backlog
2017-05-23 15:23 WA9PIE Severity minor => feature
2017-08-17 11:28 WA9PIE Tag Attached: ParityGap
2017-08-17 11:30 WA9PIE Summary STFU: Enable Counties Award (formatting problem with County field) => Enable Counties Award (formatting problem with County field)
2017-08-17 11:30 WA9PIE Testing => Alpha Failed
2017-08-17 12:50 WA9PIE Testing Alpha Failed => Not Started
2017-09-22 23:22 WA9PIE Project 1 - Backlog => 3 - Current Dev List
2018-03-04 00:59 WA9PIE Project 3 - Current Dev List => 2 - Next Dev List (Holding Area)
2018-06-11 23:36 WA9PIE Note Added: 0005240
2019-06-15 11:30 WA9PIE Project 2 - Next Dev List (Holding Area) => 1 - Backlog
2020-08-01 11:13 WA9PIE Assigned To => WILL
2020-08-01 11:13 WA9PIE Status confirmed => assigned
2020-08-01 11:13 WA9PIE Project 1 - Backlog => 3 - Current Dev List
2020-08-01 11:22 WA9PIE Additional Information Updated View Revisions
2020-08-01 11:22 WA9PIE Testing Not Started => Not Started
2020-08-01 11:22 WA9PIE Project 3 - Current Dev List => 2 - Next Dev List (Holding Area)
2020-08-01 11:43 WA9PIE Note Added: 0009841
2020-08-03 08:39 WA9PIE Project 2 - Next Dev List (Holding Area) => 3 - Current Dev List
2020-08-04 07:13 WA9PIE File Added: US_Counties (abbreviations only).csv
2020-08-04 07:13 WA9PIE Note Added: 0009851