logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Fixing an Import of QSO Party ADIF with invalid CNTY Data
w5gai
#1 Posted : Tuesday, October 18, 2011 10:28:30 PM(UTC)
Rank: Member

Groups: Registered
Posts: 10
Location: Austin, TX

Was thanked: 2 time(s) in 2 post(s)
I imported an ADIF of a TX QSO PARTY log that contained 3 and 4 letter county codes rather than the LOGic ST,COUNTY NAME
Now when I run UPDATE AWARDS PROGRESS I get errors for all those short codes.
Is there any way to convert them to the proper format using the county table at
http://www.txqp.net/forms/TX_county_abbrevs.doc
I am not skilled at DB commands or macros.
Skip W5GAI
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
WN4AZY
#2 Posted : Wednesday, October 19, 2011 7:47:58 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,057
Man
Location: Auburn, GA

Thanks: 969 times
Was thanked: 484 time(s) in 399 post(s)
Wow, and I thouht Georgia was county-happy.

What would need to be done is to type these abbreviations in the MISC field of the LISTS table, then write code to update the log.

If you enter the abbreviations, I'll write the code! Actually, it won't be that difficult -- I can prepopulate the MISC field with the first four letters of the county, then all you need to do is fix any exceptions.

Attached is the county list and list of ones that need looking at. Pse send the list back to me and then I will write the code.

Tnx & 73,

DH
File Attachment(s):
Capture.PNG (22kb) downloaded 87 time(s).
CNTY.DBF (1,413kb) downloaded 79 time(s).
w5gai
#3 Posted : Wednesday, October 19, 2011 1:29:55 PM(UTC)
Rank: Member

Groups: Registered
Posts: 10
Location: Austin, TX

Was thanked: 2 time(s) in 2 post(s)
Dennis:
I typed the TX County abbreviations in the MISC field of the LISTS table of my LOGic 7 program.
Your CNTY.DBF needs some changes. With my DBF viewer, I can view it but cannot change it. Here's the revisions.
Brazoria BZIA
Brazos BZOS
Cameron CMRN
Collin COLN
Collingsworth COLW
Comal COML
Dallam DALM
Dallas DALS
Deaf Smith DSMI
Dewitt DEWI
El Paso EPAS
Fort Bend FBEN
Grasyson GRSN
Herdeman HDMN
Hardin HRDN
Harrison HRSN
Jackson JKSN
Jeff Davis JDAV
Jim Hogg JHOG
Jim Wells JWEL
Kenedy KENY
La Salle LSAL
Live Oak LIVO
McCulloch MCUL
McLennnan MLEN
McMullen MMUL
Montgomery MGMY
Palo Pinto PPIN
Red River RRIV
Robertson RBSN
San Augustine SAUG
San Jacinto SJAC
San Patricio SPAT
San Saba SSAB
Sherman SHMN
Terrell TERL
Terry TERY
Tom Green TGRE
Val Verde VVER
Van Zandt VZAN
Willacy WILY
Williamson WMSN
Wilson WLSN

Skip W5GAI
WN4AZY
#4 Posted : Thursday, October 20, 2011 7:00:44 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,057
Man
Location: Auburn, GA

Thanks: 969 times
Was thanked: 484 time(s) in 399 post(s)
Ok, you don't need any dbase utility or anything. Just import the DBF file into LOGic and edit it there. Go to tools/setup/list of valid values and click IMPORT. There is an export button here also.

Tnx & 73,

DH
w5gai
#5 Posted : Saturday, October 22, 2011 5:19:19 PM(UTC)
Rank: Member

Groups: Registered
Posts: 10
Location: Austin, TX

Was thanked: 2 time(s) in 2 post(s)
Dennis:
I am learning....slowly Smile
I found a DBF manager (free trial program) and fixed all the county abbreviations and saved it.
Here's what I see:
In the CNTY.dbf file there is a column with Field_Name and CNTY in every row.
The data in the column VALUE has the correct county name listed as ST,CountyName, the field type is C, and for the TX counties there is the 3 or 4 letter abbreviation in the MISC column.

Before I import it to LOGic, I'd like to understand what the import will do.

In logic I have many entries from imported ADIF logs that placed those 3/4 letter county abbreviations in the CNTY field.

1. Will importing this CNTY.DBF change them from the abbreviation to the proper TX,county for that abbreviation?
(I'd like this for county awards tracking)

2. If the import needs to be undone, how do I do that?

3. For future TX QSO party ADIF imports, what happens when ADIF contains the CNTY field with the abbeviations?

Skip W5GAI

WN4AZY
#6 Posted : Saturday, October 22, 2011 8:09:14 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,057
Man
Location: Auburn, GA

Thanks: 969 times
Was thanked: 484 time(s) in 399 post(s)
It's a complicated hobby hihi.

What I sent you was merely a copy of the CNTY fields that I made myself by exporting the CNTY list using the Export button on Tools/setup/list of valid values. Before making this I entered a few commands into the database command window in LOGic to copy the first four characters of the county for the state of TX to the MISC field.

So, to answer your questions,

1. All it will do is replace the CNTY list with the one you modified. It will not affect your log data. I can use that to map the contest 4-letter county to the full name in your log which AFAIK is what MARAC wants. As for using the four-letter abbreviation for county tracking, it would have to be done for all states, and, the big question, is that what the county hunter people want?

2. Just make a copy of the county list using the EXPORT button before you import, or reimport the one I sent -- the only difference is that it has the first four characters of the county in the MISC field. Not hurting a thing, and easily removed with a couple of commands. You should be OK unless your utility screwed up the file somehow. As I said, there is no reason to use it -- you can do all this in LOGic. But since you've done it already I wouldn't start over.

3. I will write a utility to convert this using the table that will exist when all the MISC fields are right. You will have to run it after the ADIF import. Unless we really want to go to the 4-letter abbrecviations for general county tracking as mentioned in #1.

Tnx & 73,

DH
w5gai
#7 Posted : Saturday, October 22, 2011 10:53:13 PM(UTC)
Rank: Member

Groups: Registered
Posts: 10
Location: Austin, TX

Was thanked: 2 time(s) in 2 post(s)
Dennis:
OK
I think we shojld keep the original county information in the CNTY field.
I imported the CNTY.DBF with the new MISC field, adjusted with the changes I noted in a previous message.
The new CNTY table in my LOGic is now in place.
I will email you that DBF in case you need it to write the utility to convert the 3/4 letter abreviations in the log's CNTY field to the full TX,CountyName
Thanks,
Skip W5GAI
1 user thanked w5gai for this useful post.
WN4AZY on 10/24/2011(UTC)
WN4AZY
#8 Posted : Monday, October 24, 2011 8:42:48 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,057
Man
Location: Auburn, GA

Thanks: 969 times
Was thanked: 484 time(s) in 399 post(s)
Thanks--

Yes, please send it to me. Also a backup of your log. You can email ir or you should be able to upload it here too.

Tnx & 73,

Dennis WN4AZY
w5gai
#9 Posted : Monday, October 24, 2011 11:53:45 AM(UTC)
Rank: Member

Groups: Registered
Posts: 10
Location: Austin, TX

Was thanked: 2 time(s) in 2 post(s)
Here is the LOGDATA and the DBF files
File Attachment(s):
CNTY TX ABBREV.DBF (1,413kb) downloaded 82 time(s).
w5gai
#10 Posted : Monday, October 24, 2011 12:03:22 PM(UTC)
Rank: Member

Groups: Registered
Posts: 10
Location: Austin, TX

Was thanked: 2 time(s) in 2 post(s)
I cannot upload LOGBACKUP5.PDABACKUP on this site (file type not allowed), so will email it to you at pdainc@hosenose.com
Skip
WN4AZY
#11 Posted : Tuesday, October 25, 2011 8:02:30 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,057
Man
Location: Auburn, GA

Thanks: 969 times
Was thanked: 484 time(s) in 399 post(s)
Thanks, I got it. Will work on it this weekend.

73,

DH
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.055 seconds.