[Logic] How do I integrate a membership database?

[Jim Brannigan]

Congratulations! I'm glad you got it to work.

In your "Copy from prefix table" dialog in the MAIN log setup screen, Try
IIF(BAND=6M) in front of MAKE_TAG("SMIRK:",GETLISTVALUE("SMIRK",LOG.CALL))

I can't test it, so you will have to play around with the syntax to get it
to work properly.

>


> 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