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

Notification

Icon
Error

Lists for Award tracking
vk4iu
#1 Posted : Monday, December 10, 2012 5:56:07 AM(UTC)
VK4IU

Rank: Advanced Member

Groups: Moderator, Registered, Administrators
Posts: 404
Man
Location: Hodgleigh QLD

Thanks: 6 times
Was thanked: 77 time(s) in 68 post(s)
G'Day All.

Attached are files that represent Lists of "valid values" for my use in Logic. I use Logic 9.

JCC.DBF, JCG.DBF and KU.DBF - Japanese cities, guns, Ku list. See http://www.jarl.or.jp/English/4_Library/A-4-5_jcc-jcg/jcc-list.txt and http://www.jarl.or.jp/English/4_Library/A-4-2_Awards/Award_Main.htm

EAP.DBF - Spanish Provinces. See http://www.ure.es/awards...rd-english-version.html

SPPA.DBF - Polish counties or powiat. See http://awards.pzk.org.pl...skie-dyplomy/sp-pa.html

SPW.DBF - Polish regions or wojewodztwo. http://awards.pzk.org.pl...kie-dyplomy/polska.html

DD.DBF - German Districts. Initial letter of the DOK code.

DOK.DBF - German DOK. Data extracted from several sources. See http://www.darc.de/referate/dx/dok/

OKD.DBF - Czech districts. Note that because of the "non-english characters" some characters will appear as ?.

OKC.DBF - Czech counties. Note that because of the "non-english characters" some characters will appear as ?.

VKS.DBF - Australian Shires. There have been big changes to this list in the past few years. The list is from the Worked All VK Shires contest - VK works the world.

RBA.DBF - Russian Baltic Award. See http://www.rz1cwc.qrz.ru...g/awards/cca/cca_e.html

The list names are short so as not to consume too much space in the limited space of USERFIEDS - a 254 character limit

Some of these lists are provided with Logic. I have rebuilt these lists for my needs and to reflect the latest updates. My lists sometimes include data in the description fields of each record for cross check purposes. One can see the material in the dropdown box for the field on a log form when processing a QSL card.

The lists are ready to be imported into Logic.

Open the Lists form from Awards, Setup, Awards lists--DXCC, etc

If you want to save your exiting list, double click on its CODE in the list to the right of the Lists form, and export the list to a file of your choice. Or, rename the list, using the buttons provided. If you rename the list, think about whether nor not you need to rename the associated USERFIELD as well.

Download the attached file to a folder of your choice on your PC.

To import an attached list, click "Import list", and navigate to the file you downloaded above.

You should now have an updated or perhaps new list.

Please see the Logic Help for detailed instructions on what to do next. In the Help Contents look for Awards Tracking and Progress.

If you have already setup JCC/JCG for example, the new data, for new QSL cards, will appear automatically.

Special Note: My JCC list contains LEADING ZEROS - what usually appears on QSL cards. The original JCC list has no leading zero for numbers below 1000 - 102 as compared to my list 0102 SAPPORO (HOKKAIDO)). If you import my list, your data will still be in UESRFIELDS, but will not be shown in a JCC field on the LOG form as you browse your QSOs. You can use Data Commands, Mass Change, Replace User-defined field contents to add the leading zero to old data.

For those less familiar with what to do next, in summary, you will need to the following.

In Awards, Setup, User-defined fields setup, create a user-defined field, with the same name as the list, to hold the data you enter from your QSL cards, and mark this new field as "Edit using list table".

On the Awards panel, mark the field - "Track Awards for this field", and other boxes as appropriate.

On a log form of your choice, click the "butler", and add this new user field to the form.

Update at least ONE QSO record from your QSL cards with the indicated value from the list, using the userfield dropdown you placed on the log form.

Then use Awards, Update Awards Progress Info.

Then, open Awards, Progress List, select the award (list name and USERFIELD name) . Click NEXT.

For JCC ... you should see that there are 812 total JCC entries and your progress listed below. There are actually 909 JCC entries in the list, but 97 are actually "deleted" entries. 812+97 = 909.

If you find any mistakes that I have made, if you know where to find a good explanation of JCCs, JCGs, Kus, Prefectures, JA call areas, and their relationships, please post a reply. I am curious why some JAs nominate a JCC, some a JCG, still others a KU, on the their cards. Yet all the numbers seem related.

I appreciate any contribution to my efforts.

Peter VK4IU
File Attachment(s):
JCC.DBF (418kb) downloaded 37 time(s).
JCG.DBF (287kb) downloaded 35 time(s).
KU.DBF (85kb) downloaded 32 time(s).
EAP.DBF (25kb) downloaded 28 time(s).
sppa.DBF (175kb) downloaded 36 time(s).
Peter VK4IU
You can help by posting images of any errors and including your Logic version.
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
vk4iu
#2 Posted : Monday, December 10, 2012 6:00:11 AM(UTC)
VK4IU

Rank: Advanced Member

Groups: Moderator, Registered, Administrators
Posts: 404
Man
Location: Hodgleigh QLD

Thanks: 6 times
Was thanked: 77 time(s) in 68 post(s)
... it seems we are limited in size and/or the number of files.

File Attachment(s):
SPW.DBF (8kb) downloaded 37 time(s).
dd.DBF (13kb) downloaded 34 time(s).
DOK.DBF (539kb) downloaded 33 time(s).
SPW.DBF (8kb) downloaded 34 time(s).
OKC.DBF (7kb) downloaded 34 time(s).
Peter VK4IU
You can help by posting images of any errors and including your Logic version.
vk4iu
#3 Posted : Monday, December 10, 2012 6:06:07 AM(UTC)
VK4IU

Rank: Advanced Member

Groups: Moderator, Registered, Administrators
Posts: 404
Man
Location: Hodgleigh QLD

Thanks: 6 times
Was thanked: 77 time(s) in 68 post(s)
... and 5 more ...
File Attachment(s):
OKD.DBF (41kb) downloaded 32 time(s).
VKS.DBF (261kb) downloaded 32 time(s).
RBA.DBF (15kb) downloaded 36 time(s).
Peter VK4IU
You can help by posting images of any errors and including your Logic version.
WN4AZY
#4 Posted : Monday, December 10, 2012 10:07:20 AM(UTC)
admin

Rank: Administration

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

Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
Thanks Peter! That was a lot of work!

We have some Japanese customers who are not on the Forum. I will email and ask about JCG, JCC, and KU.

I guess you know about this
http://www.jarl.or.jp/En...4-5_jcc-jcg/jcc-jcg.htm
The link to Kus is broken. There is also "Shicho", also broken.

Reading between the lines, JCC is City, JCG is Gun. Which I was guessing is about equialent to US Cities and Counties. Wikipedia confirms, except that it says Guns are no longer in use. However, the article is not well-written. http://en.wikipedia.org/wiki/Districts_of_Japan

As for Ku, it is a subdivision of a city. http://en.wikipedia.org/wiki/Wards_of_Japan

So I'm thinking a JA station could have either a JCG# or JCC#, but not both. A station with a JCC# could also have a KU????

It's a complicated hobby!

Tnx again & 73,

Dennis WN4AZY
WN4AZY
#5 Posted : Monday, December 10, 2012 10:20:01 AM(UTC)
admin

Rank: Administration

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

Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
Ok, I found a small problem with at least some of your lists. The FIELD_TYPE field contents are lower-case in at least some cases. They need to be upper case.

The fix is simple. Just import all the lists you want, then go to tools/advanced/database commands. Type:

use lists
replace all field_type with upper(field_type)

may as well do FIELD_NAME to be safe.
replace all field_name with upper(field_name)

No need to update & reupload your lists. It would be a good idea for me to add this to our import code anyway. I am working on another update and will add it.

Tnx & 73,

Dennis WN4AZY
vk4iu
#6 Posted : Monday, December 10, 2012 3:29:30 PM(UTC)
VK4IU

Rank: Advanced Member

Groups: Moderator, Registered, Administrators
Posts: 404
Man
Location: Hodgleigh QLD

Thanks: 6 times
Was thanked: 77 time(s) in 68 post(s)
G'Day,

This is a lot trickier than it looks.

You are correct the field_type is in lower case ... but it looks upper case on my spreadsheets. I did not notice.

I did not find that link for JCC/JCG/Ku list. I started here JCC/JCG/KU and the KU list is actually an Excel spreadsheet. The JCC and JCG leads to the same place I used.

Peter VK4IU
Peter VK4IU
You can help by posting images of any errors and including your Logic version.
vk4iu
#7 Posted : Monday, December 10, 2012 4:15:23 PM(UTC)
VK4IU

Rank: Advanced Member

Groups: Moderator, Registered, Administrators
Posts: 404
Man
Location: Hodgleigh QLD

Thanks: 6 times
Was thanked: 77 time(s) in 68 post(s)
G'Day,

I started at JA Prefecture on Wikipedia. Never found the JA Districts item.

The Districts link, towards the bottom, in the External Links, has a reference to a PDF file, with a graphic on Page 7 of the document. That diagram and the rest of the article told me more than I had found elsewhere.

All that history is one thing. What is actaully on the JA QSL cards is the key to success.

I now see why some put JCC, some put JCG, some reference a Ku, etc etc.

Peter VK4IU
Peter VK4IU
You can help by posting images of any errors and including your Logic version.
Users browsing this topic
Guest (5)
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.072 seconds.