Members List

oscar51

Thread Starter
Joined
Nov 13, 1999
Messages
521
I’ve been trying to make some sense out of the TSG Members List but something seems to have changed since I last analyzed it two years ago. When I looked at it a few weeks ago, the Members List showed no members with fewer than 50 posts. The next time I looked a few days later, it showed no members with fewer than 20 posts. Now, today, it’s still stuck at 20 or more posts. And to make matters more interesting, when I search the list for known members with fewer than 20 posts, I get no matches. I know such members exist but they do not show on the list. So, either I’m doing something wrong or the site’s search facility has some new built-in limits. Does anyone have any ideas on how I can see the entire list?
 
Joined
Oct 26, 2001
Messages
57,793
PM techguy and see if he will change the limits on that and maybe other things so you can get your data that I know he like to see also.
 

TechGuy

Mike
Administrator
Joined
Feb 12, 1999
Messages
14,700
Howdy Oscar,

As you know, it does take quite a bit of database processing to go through all of our members. I just modified your account so that you can use the search in Member List for any member, not just those with 20 or more posts. However, the full list will only show those with 20 or more posts.

I'm about to head out to my in-laws for Christmas, but drop me an email when you get a chance and I can send you an Excel sheet with a list of all users if that would be helpful. :)

Happy Holidays!
 

oscar51

Thread Starter
Joined
Nov 13, 1999
Messages
521
Thanks, TechGuy. If that Excel list contains user name, join date, and number of posts, I'll certainly consider using it for those members with less than 20 posts. For members with 20 or more posts, I'll just download the Member List as it currently displays itself. I can tolerate the small changes in number of posts for low-rate posters (like me :)) over a period of a week, but for the high-rate posters, I need to catch the data as soon as possible after 0000 GMT 1 Jan 2011.
 

Ent

Josiah
Trusted Advisor
Joined
Apr 11, 2009
Messages
5,467
I need to catch the data as soon as possible after 0000 GMT 1 Jan 2011.
I know a lot of people have a lot of reasons for staying up to greet the new year, but that's probably the most work-devoted I've come across. Are these going to be really interesting statistics?

Out of curiosity is that 0000 your time or techguy time (3 hours ahead of you)? Or some other arbitrary time (GMT, moon, mars, etc)?
 
Joined
Sep 7, 2005
Messages
1,498
Quote:
I need to catch the data as soon as possible after 0000 GMT 1 Jan 2011.
I know a lot of people have a lot of reasons for staying up to greet the new year, but that's probably the most work-devoted I've come across. Are these going to be really interesting statistics?

Out of curiosity is that 0000 your time or techguy time (3 hours ahead of you)? Or some other arbitrary time (GMT, moon, mars, etc)?
__________________


Looks like someone over there in the U.K. has been partaking of the "egg nog" already!!!
 

TechGuy

Mike
Administrator
Joined
Feb 12, 1999
Messages
14,700
Oscar - did you get my email with the file? If that looks like what you need, I'd have no problem creating something similar closer to New Years... but I'll probably need a reminder! ;)
 

oscar51

Thread Starter
Joined
Nov 13, 1999
Messages
521
Mike: Yes, I got your email with the file. Looking at it now. I will continue this discussion via email so this thread will not get cluttered up.

Ent: As a convenience to help me keep my times straight, I routinely keep my TSG time set to GMT as if I were sitting on the Prime Meridian at the Greenwich Observatory with a laptop. Of course, I'm not sitting there (I'm sitting in the Mojave Desert in bankrupt California) and I don't have a laptop (and if I did, it would be an Apple). But if I were .... ;)
 

oscar51

Thread Starter
Joined
Nov 13, 1999
Messages
521
Sorry, hewee. I did an unkind thing to shut everyone out. Here's what's going on: Mike sent me the URL of the Members List as an Excel file. I downloaded the file and finally got it open in OpenOffice.org Calc after downloaded and installing the latest version of Calc. The previous version could only handle 65,536 lines; the newer version, 1-million lines. The file had 577,591 lines (34MB), one line per member. Then I removed the info I don't need and saved the file, now 15MB. Mike's gracious assistance has saved me hours of downloading and saving the Members List as an html file. So I won't hit exactly the 0000 GMT 1Jan2011 time stamp target. Too bad. I'll just put an asterisk on the December 2010 data and call it a near-miss. :) Happy New Year everyone.

P.S.: It will take me a few weeks to get my report #4 updated, so don't hold your breath.
 
Joined
Oct 13, 2003
Messages
3,033
there is no hurry, but I like to look at them, thanks for doing it.
 
Joined
Oct 26, 2001
Messages
57,793
Sorry, hewee. I did an unkind thing to shut everyone out. Here's what's going on: Mike sent me the URL of the Members List as an Excel file. I downloaded the file and finally got it open in OpenOffice.org Calc after downloaded and installing the latest version of Calc. The previous version could only handle 65,536 lines; the newer version, 1-million lines. The file had 577,591 lines (34MB), one line per member. Then I removed the info I don't need and saved the file, now 15MB. Mike's gracious assistance has saved me hours of downloading and saving the Members List as an html file. So I won't hit exactly the 0000 GMT 1Jan2011 time stamp target. Too bad. I'll just put an asterisk on the December 2010 data and call it a near-miss. :) Happy New Year everyone.

P.S.: It will take me a few weeks to get my report #4 updated, so don't hold your breath.
Was only joking with you. :p When your all done I know the report will be great as also. (y)
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top