|
MoonDawg
|
 |
« Reply #60 on: May 07, 2005, 10:06:57 am » |
|
OK Jim. I just added my zip code to my profile. If everybody who is current does this, then the only zip codes you will have will be current members, right? Could this reduce the size of the list ?
|
|
|
|
|
Logged
|
Glen
|
|
|
keithm
5 Cent Member
 Offline
Posts: 78
|
|
« Reply #61 on: May 07, 2005, 11:00:36 am » |
|
Is there a spot for zip code ? Where did you put it ?
|
|
|
|
|
Logged
|
|
|
|
|
MoonDawg
|
|
« Reply #62 on: May 07, 2005, 12:18:24 pm » |
|
He asked that it be put on the same line as City and State
|
|
|
|
|
Logged
|
Glen
|
|
|
|
BryanH
|
|
« Reply #63 on: May 07, 2005, 12:28:46 pm » |
|
| Quote (Creighton @ May 06 2005,8:16) | | PS, Bryan thanks! Can't figure out the 439 joke. Course 38 is a high estimate of my IQ on any given day :-) |
Nothing to do with IQ... was just being silly. The number seemed like it was an age or ranking... so "537 (but I feel like a 439)", was an attempt at a joke. I won't quit my day job  '> |
|
|
|
|
Logged
|
Thanks, Bryan
Cavalier USS-96: unrestored, working on the back patio
CV VUB/C 8-91: a fantasy restoration?
GE Cooler: in pieces, my next project
|
|
|
|
Jim
|
|
« Reply #64 on: May 07, 2005, 01:03:10 pm » |
|
I'm looking into this as we speak.
The database stores the last activity any member has on the board, but it's stored in unix timestamp format. I have posted a question at Ikonboard's Site in the hopes of limiting the records returned based on last activity timestamp... Say, the last thirty days.
|
|
|
|
|
Logged
|
My six cents, Jim  |
|
|
|
Jim
|
|
« Reply #65 on: May 07, 2005, 05:01:01 pm » |
|
I have a way to filter the records based on a member's "Last Activity"...
If everyone that is going to participate in being included in Creighton's database, we can set a time for all profile updates to be completed within a week, two weeks, etc, etc... Just let me know.
Creighton,
Here are the fields I was going to pull from the DB:
MEMBER_NAME: (Member's User Name)
MEMBER_NAME_R: (Member's Real Name)
LOCATION: (Updated address)
LAST_ACTIVITY: (used to filter list)
We'll need to have the member's Real Name entered as well as their complete address so records will be accurate. Once this database has been compiled, everyone that doesn't want this information to be available, can then go back to their profile and edit the data as needed...
On another note, if you would like more participants, I can send an email message explaining our intentions to all receiving members and invite them to subscribe... Just a thought...
Hopefully helpful...
|
|
|
|
|
Logged
|
My six cents, Jim |
|
|
|
Pat Pixley
Guest
|
|
« Reply #66 on: May 07, 2005, 09:03:22 pm » |
|
Ok here my post. Just a note I belong to wwwfancollectors.org
and we have to use our real name's, There is no handle's and email
must be valid at all time . I think this is a plus .
Pat  '>
|
|
|
|
|
Logged
|
|
|
|
|
Creighton
|
|
« Reply #67 on: May 08, 2005, 01:53:26 am » |
|
Jim,
You are the man!! I really didn't want to burden you with any more work. Thanks for helping out!!
I've added SJ zip to my profile as a test. If you could send a DB dump in whatever format I'll start working on getting this to fly.
How about I get this working for the folks that have joined so far and then send out an invite to others once the DB format is sorted?
My college work was in Geographical Information Systems (GIS). Which is basically who, what and where. I need to update some job skills so this not work at all, it's fun.
Looks like rain tomorrow so will try and get a temp update posted.
Thanks again Jim,
Creighton
|
|
|
|
|
Logged
|
|
|
|
|
Jim
|
|
« Reply #68 on: May 08, 2005, 07:29:23 am » |
|
Creighton,
I'll get on this tonight since it's Mother's Day and I have a few visits planned for today...
How far back would you like me to cut the Last Activity off... Everyone that has been here in the last 24 hours, 36 hours, a week, etc... I was thinking on keeping the window narrow since anyone that has been reading would have responded either by posting or modifying their profile to include the accurate info...
I will say this, the longer the time, the more inaccurate data you will have to sort through...
As a last suggestion, I can create an Access Database rather quickly and include the data...
|
|
|
|
|
Logged
|
My six cents, Jim |
|
|
|
MoonDawg
|
|
« Reply #69 on: May 08, 2005, 09:48:52 am » |
|
Hey Jim. Do you need the complete address on that 1 line?
And, did you get my pic of the Glasco?
|
|
|
|
|
Logged
|
Glen
|
|
|
|
