Hello,

Is there any way to incorporated the CWops membership list in Logic 8 ?

What about the FISTS list, it will not download?

Thanks,

Charlie NP3K

I've been trying to post this Msg and it comes up with error, sorry if it created multiples.

G'Day,

While waiting for the family to wakeup and for breakfast to cook, I did a quick Google search and found http://www.cwops.org/roster.html.

Later, I looked at the structure of the MEMBERSHIPS table with Tools, Advanced, Database commands like this

use MEMBERSHIPS
modify structure

and noted the order of the fields that count as ...

call, field_name, value, name

I then used the usual Windows select, copy and paste, and copied the relevant text from the web page into an Excel spreadsheet, and after a few minutes with Excel I created a list of the required data in columns in the same order as the fields of the table. I saved the sheet as a CSV file, and imported it into LOGic 8 with Tools, Advanced, Database Commands by using ...

use MEMBERSHIPS
append from C:\Users\peter\Documents\Logic9-Data\cwop.csv delimited with ","

The resulting list is attached and can be used in LOGic8 or LOGic9. You can import it from the Tools,Setup,Memberships Lists dialogue using Import List.

The above can be used as a general scheme of how to import ANY membership list. Just assemble the data in a CSV text file in the same field order, separated by commas. The records can be in any order, LOGic will do all the sorting and indexing.

The current FISTS# list from LOGic9 is also included. It worked for me in LOGic8.

G'Day,

Putting CWOPS membership in Tools,Internet would require programming changes to LOGic itself. Only Dennis can do that. And I am sure he is not too keen on adding yet another maintenance task into LOGic 9, let alone LOGic 8.

The real problem lies not with LOGic, but with the various organisations. There is no standard "file type", there is no "standard" format for the data, there is no standard "membership secretary" - despite the IT industry creating such tools long ago. XML data comes to mind, as in QRZ Subscriptions, Clublog, LOTW, eQSL etc etc.

To incorporate any given membership list into Tools,Internet Dennis needs to write a separate, specific program for each one. The larger organisations are fairly stable. But the smaller groups ... seem to change with the next volunteer for "membership secretary".

CWOPS has been around for a long time, and would most likely be fairly stable. But ... I am still waiting for the list of LOGic Forum members to be incorporated. Given that the Forum list is "in house", one would expect that to be fairly easy.

Time is the problem. I too want more of it. We need a lot more of us to stay awake longer, modify the gene pool, breed more, need less sleep, so we can do more amateur radio. Alas, I wont live long enough to benefit.

On second thoughts, we need more amateur radio LOGic forum members to volunteer as membership secretaries for more amateur radio related organisations.

And a third thought. We need more Forum members to volunteer to maintain any given membership list, and post the changed URLs, DBF files, to the Forum, for others to download.

If you want other membership lists, just ask on the Forum.

Hi Charlie,

The moment you do the "append", LOGic will load the data into the MEMBERSHIP table. You do NOT have to import any DBF files.

After you "append" the CSV, go to the MEMBERSHIP table (Tools, Setup, Membership lists, and check your work. If it is not what you wanted/expected, delete the CWOPS# list and try again.

When the CWOPS# membership is correct, use the button on the MEMBERSHIPS table dialogue to EXPORT the CWOPS# membership list - it will be saved to your hard disk as a DBF file.

Now you can add a post to the forum, appending the DBF file to your post. Others can take advantage of your efforts.

G'Day Charlie,

It is fantastic you are having a go.

A backup copy of the Membership database is a good thing to be doing. It takes a little while to gain experience.

Briefly explain how you did the work in EXCEL to produce the CSV file.

Do a re-index with Tools, Database Maintenance. Look through the CWOPS# membership list to see if there are any "strange values" for the call signs.

Attach the CSV file and I will have a look - as time permits.

I do it like this ...

Select the table in the web page.
Paste the table into Excel.
Arrange the data columns to the required order for the LOGic table.
Delete any rows not relevant.
Select all the columns with the data.
Copy and "paste values" into a clean sheet
Save the sheet as a CSV file.