Parker Gun Collectors Association Forums

Parker Gun Collectors Association Forums (https://parkerguns.org/forums/index.php)
-   Website & Forum - Help & Assistance (https://parkerguns.org/forums/forumdisplay.php?f=5)
-   -   PGCA Member GEO map feature (https://parkerguns.org/forums/showthread.php?t=23109)

Dean Romig 07-10-2018 01:21 PM

An Excel file would need to be set up with name and member number which can be formatted to allow a search by either name or number..... NO - I am NOT suggesting Robin take this on... He has done way more than enough and given more than enough of his personal time to tasks that are not his responsibility... After all, he doesn’t get paid for what he does for the organization.





.

keavin nelson 07-10-2018 04:20 PM

Dean,
If the listing is available digitally, I will take a shot at converting it to a suitable file.

keavin nelson 07-10-2018 04:21 PM

Sortable

Dean Romig 07-10-2018 04:59 PM

Keavin, that would be an enormous task to create such a file from scratch.

The thing is, it would need to be a fluid file that should be periodically altered to allow for new members being included and members who have dropped out scrubbed from the file.

Further, such a file must only be made available in the Members Only section of our forum.

I'll present the possibility to our BOD





.

Michael Meeks 07-10-2018 10:02 PM

An MS Access contacts management database would be the way to go. The database would give the functionality of adding/removing members via forms, tracking membership status, searchability with pre-determined queries, and various reporting features such as telephone/email rosters etc. A locked down version could be made available to all members for viewing/searching.

A membership database might be better served if it were emailed to current members on an annual basis rather than residing on this forum.

Michael Meeks 07-10-2018 10:04 PM

And, I am not suggesting Robin take this on either. This is something I could assist with if the BOD is interested.

Dean Romig 07-10-2018 10:16 PM

Thanks Michael. But we don't want to get ahead of ourselves on this.

Granted, an electronic file would save us printing costs if the BOD determined this is the way to go. It could be the same Membership Roster we receive with the Fall Issue of Parker Pages and there is nothing especially sensitive about that one.... and it is derived from an Excel spread sheet... so we already have one. All we have to do is tweak it the way we want it. Problem is - not all of our members are online... probably 15% are not.





.

Michael Meeks 07-10-2018 10:31 PM

If it's already in Excel, the hardest part of tbe task is already done.

Dean Romig 07-10-2018 10:43 PM

Exactly!





.

David Gehman 07-14-2018 02:35 PM

Nice feature for sure, way to go.


All times are GMT -4. The time now is 07:45 AM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 1998 - 2023, Parkerguns.org