[Logic] How do I integrate a membership database?

2003年10月15日 20:33:35 -0500

Gil, W0MN http://webpages.charter.net/gbaron
44.08N 92.512835W 1050'
Hierro Candente, Batir de repente
> -----Original Message-----
> From: [email protected] [mailto:[email protected]]On
> Behalf Of Bill VanAlstyne
> Sent: Wednesday, October 15, 2003 7:33 PM
> To: [email protected]
> Subject: Re: Re: [Logic] How do I integrate a membership database?
>>> 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.
>
Ayy, enough said :-) It reminds me of ALGOL :-)
> 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
> > [email protected]
> > http://mailman.qth.net/mailman/listinfo/logic
> _______________________________________________
> LOGic mailing list
> [email protected]
> http://mailman.qth.net/mailman/listinfo/logic
>