[Logic] How do I integrate a membership database?

[Bill VanAlstyne]

All,

OK, here's where I've gotten to with this project:

First, I added the log field SMIRK as a character-based field in User6, and
enabled its visibility on the log screen (since User6 thru User20 are hidden by
default) by dragging it out of the trashcan icon. (That's just SO INTUITIVE...
not! Spent an hour first trying to figure this out, and then trying to find it
in the Help. Finally found it.)

Next, Art showed me how to turn my comma-delimited list (in the form
<callsign>,<number>) into a DBF file. The DBF file was then imported via Tools
>> Setup >> Lists of valid values.

Next, Art showed me how to create the automatic lookup function by adding the
entry
            MAKE_TAG("SMIRK:",GETLISTVALUE("SMIRK",LOG.CALL))
to the "Copy from prefix table" dialog in the MAIN log setup screen.

I also enabled SMIRK in the Awards section as a tracked field.

It works! Now when I enter a callsign in the log screen and press TAB to get a
QRZ.com lookup, I also get a SMIRK lookup. The SMIRK number, if any, appears in
the new field on my log screen right next to the call. To restrict the lookup
function to 6M only, I will probably just keep 6M as a separate log. (If there
is a way to modify the lookup expression to check 6M QSOs only -- like adding
some kind of IF statement at the beginning of it -- somebody please let me
know!)

Finally, just to clear up a misconception that was floating around here, I am
>>not<< the "official keeper" of the SMIRK roster. I'm just a member. I got the
roster off of their website by capturing it from their HTML pages one section of
1,000 calls at a time, and then reformatting each section as I captured it into
a single text list. I filtered out SKs and other invalid calls that were
indicated as such on the HTML pages, so the list is only good calls, so far as I
know. I'd be happy to provide the DBF file to anybody who wants it, once I get
it finished. The current file I'm using is North America only; I need to add
back the foreign call part of the original database. I should be able to do this
tonight.

Bill


w2fca@capital.net wrote:
> Hi all
> If you're going to do it, it should probably be in the order of the
> fields in the database. So if yoy have fields -
>
> Field_name, value, description
>
> your file would be (for example)
>
> SMIRK, 6040, W2FCA
> SMIRK, 2835, AB4RL
>
> and so forth.
>
> Frank
> W2FCA
>
> Quoting Arthur Tan <ab4rl@lomag.net>:
>>
>> Importing text files such as member lists with callsign and member
>> number would be a great feature but I think the text file itself
>> would still need to be in a set format that Dennis specifies:
>> something along the lines of callsign, member #, or vice versa.
>>
>
>
> ----------------------------------------------------
> "Visit Logical.NET online at http://www.logical.net"
> _______________________________________________
> LOGic mailing list
> LOGic@mailman.qth.net
> http://mailman.qth.net/mailman/listinfo/logic