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

Notification

Icon
Error

RUSSIAN DISTRICTS AWARD LIST
TF5B
#1 Posted : Tuesday, March 26, 2013 11:05:43 AM(UTC)
Billi

Rank: Advanced Member

Groups: Registered
Posts: 36
Location: Akureyri Iceland

Was thanked: 4 time(s) in 4 post(s)
Is there in LOgic 9 a list for "RUSSIAN DISTRICTS AWARD LIST" and if so where can I find it and if not is it awailable to import in to LOgic 9?
73 Billi TF5B
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 : Tuesday, March 26, 2013 8:45:56 PM(UTC)
admin

Rank: Administration

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

Thanks: 971 times
Was thanked: 484 time(s) in 399 post(s)
I checked and we don't have it and no one else has uploaded it here.

Here is the URL: http://rdaward.org/rda_eng.txt

I will add it to the to-do list!

Tnx & 73,

Dennis WN4AZY
TF5B
#3 Posted : Wednesday, March 27, 2013 9:04:20 AM(UTC)
Billi

Rank: Advanced Member

Groups: Registered
Posts: 36
Location: Akureyri Iceland

Was thanked: 4 time(s) in 4 post(s)
Thank you Dennis. It looks like an interesting Award.
73 Billi TF5B
vk4iu
#4 Posted : Thursday, April 18, 2013 9:53:49 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,

Attached is my "Russian District Award List" for Logic 9. Just import the attached DBF file using Tools, Setup, List of valid values, and Import List.

To creare the list, I took the WWW reference that Dennis posted, wrote a small AWK script to process the file like this ...

Quote:
gawk -f parse.awk <"Russian District Award rda_eng.txt" >rda.txt


... and imported the output into Logic using Tools, Advanced, Database Commands like this ...

Quote:
use lists
append from C:\Users\peter\Documents\Logic9-Data\rda.txt delimited with TAB
replace deleted with .T. for 'DELETED'$DESCR AND FIELD_NAME='RDA'


To actually use this list in Logic, one needs to create a user-defined field called "RDA", and associate it with the "RDA List of valid values", and add the ser defined field to a Log form.

For those interested in doing similar things, here is my AWK/GAWK program ...

Quote:

/.*\s*\([A-Z][A-Z]\)\s*.*$/ { # District header line?
line=$0;
sub(/^ */, "", line);
match(line,/^\s*(.*)\s*\(([A-Z][A-Z])\)\s*(.*)$/,arr); # Break out the data - remember some for code lines
prefix = toupper(arr [2]);
call = toupper(arr[3]);
sub(/^[\t ]*/, "", call); # Remove leading spaces
sub(/[\t ]*$/, "", call); # Remove trailing spaces
descr = toupper(arr[1]);
sub(/^[\t ]*/, "", descr); # Remove leading spaces
sub(/[\t ]*$/, "", descr); # Remove trailing spaces
district = "^(" prefix "-[0-9]*)\\s*(.*)$"; # Remember code prefix
}
$0 ~ district { # district code line
match($0,district,arr); # Break out the data
print "RDA\t" toupper(arr[1]) "\t" toupper(arr[2]) " (" descr " - " call ")"; # Create CSV line for Logic
}


... and you can find information on using AWK/GAWK at AWK/GAWK Tools for Windows. This material also includes explanations of the "regular expressions" used in the program to assemble the "codes" from the text in the file.

Lists published on the Internet of this sort are usually created by hand, and contain all the usual human errors and ommissions. To process this file, I had to remove various lines with nothing but spaces, edit some lines with dozens of trailing spaces, and remove the surpurflous header lines at the start of the file. No changes were made to the actual data. My raw data file is attached for those who want to process the file themselves using AWK/GAWK.

Peter VK4IU

File Attachment(s):
RDA.DBF (1,298kb) downloaded 72 time(s).
rda.txt (163kb) downloaded 72 time(s).
Peter VK4IU
You can help by posting images of any errors and including your Logic version.
vk4iu
#5 Posted : Sunday, April 21, 2013 3:13:50 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,

I updated my script to include "field_type" and "deleted" status. New List for import into Logic attached.

Quote:

# Russian District Codes
# Create file for import into Logic

/.*\s*\([A-Z][A-Z]\)\s*.*$/ { # District header line?
line=$0;
sub(/^ */, "", line);
match(line,/^\s*(.*)\s*\(([A-Z][A-Z])\)\s*(.*)$/,arr); # Break out the data - remember some for code lines
prefix = toupper(arr [2]);
call = toupper(arr[3]);
sub(/^[\t ]*/, "", call); # Remove leading spaces
sub(/[\t ]*$/, "", call); # Remove trailing spaces
descr = toupper(arr[1]);
sub(/^[\t ]*/, "", descr); # Remove leading spaces
sub(/[\t ]*$/, "", descr); # Remove trailing spaces
district = "^(" prefix "-[0-9]*)\\s*(.*)$"; # Remember code prefix
}
$0 ~ district { # district code line
match($0,district,arr); # Break out the data
status = "\tC\t\tF"
if (match(toupper(arr[2]),"DELETED")) { status = "\tC\t\tT"}
print "RDA\t" toupper(arr[1]) "\t" toupper(arr[2]) " (" descr " - " call ")" status; # Create CSV line for Logic
}



Peter VK4IU
File Attachment(s):
RDA.DBF (1,298kb) downloaded 79 time(s).
Peter VK4IU
You can help by posting images of any errors and including your Logic version.
TF5B
#6 Posted : Sunday, May 5, 2013 5:36:59 AM(UTC)
Billi

Rank: Advanced Member

Groups: Registered
Posts: 36
Location: Akureyri Iceland

Was thanked: 4 time(s) in 4 post(s)
Hello Peter.
Thank you for your rda.dbf it is working ok.
I did instal it per your instruction and all is ok.
Thank you.
73 Billi TF5B
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.036 seconds.