[Logic] How do I integrate a membership database?

[Bill VanAlstyne]

Jim Brannigan wrote:
> 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.

Got it to work! The correct syntax is:
   IIF(LOG.BAND="6M",MAKE_TAG("SMIRK:",GETLISTVALUE("SMIRK",LOG.CALL)),"")
Thanks for the idea!  :-)

Bill / W5WVO

>> 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
> 
> _______________________________________________
> LOGic mailing list
> LOGic@mailman.qth.net
> http://mailman.qth.net/mailman/listinfo/logic