Location: The Wikis By Wetpaint Top 100

Discussion: CuriousReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 6 posts
FrostIce1
FrostIce1
Curious
Feb 18 2011, 4:31 PM EST | Post edited: Feb 18 2011, 4:31 PM EST
I see a few sites only have a few yet active members

I'm just wondering because I know a site like that which didn't make the cut

IDK I'm curious Do you find this valuable?    
Keyword tags: None (edit keyword tags)
Losa78
Losa78
1. RE: Curious
Feb 18 2011, 5:28 PM EST | Post edited: Feb 18 2011, 5:28 PM EST
"I see a few sites only have a few yet active members

I'm just wondering because I know a site like that which didn't make the cut

IDK I'm curious"
Maybe those few active members are enough for real lots of activity.
I really don't see what is there to be wondering or so curious just about that... Do you find this valuable?    

Posted Anonymously
2. RE: Curious
Feb 18 2011, 6:45 PM EST | Post edited: Feb 18 2011, 6:45 PM EST
If you look at the top, it shows the date of when the list was made.
It says January 22nd, so it's...really off. It isn't up to date.

They mentioned that they might be stopping the list again for awhile. o: Do you find this valuable?    
Naru2008
Naru2008
3. RE: Curious
Feb 19 2011, 12:01 AM EST | Post edited: Feb 19 2011, 12:01 AM EST
I doubt it will be continued again either, to be honest. It would mean Wetpaint staff taking time to get the information, then giving it to Jeremy, who would give it to Kevin, who would then give it to one of us Moderators. They don't have time to do it, it seems. Do you find this valuable?    

Maxwilly
4. RE: Curious
Feb 19 2011, 12:48 PM EST | Post edited: Feb 19 2011, 12:48 PM EST
It takes five minutes. They can't be bothered, there's nothing else to it.

FrostIce1 and Anonymous, don't expect another list. It's highly unlikely. Do you find this valuable?    
CryingDove
CryingDove
5. RE: Curious
Feb 20 2011, 11:06 AM EST | Post edited: Feb 21 2011, 1:09 PM EST
"I doubt it will be continued again either, to be honest. It would mean Wetpaint staff taking time to get the information, then giving it to Jeremy, who would give it to Kevin, who would then give it to one of us Moderators. They don't have time to do it, it seems.
"
That is "close but no cigar", as far as the sequence of events of getting the list posted. The problem lies with not having the raw Excel data that Jeremy draws from the master database. Once that data has been made availiable, it was attached to the Top 100 list page. Then I took that raw data and ran macros I set up to format the list as it is seen on that page. Then I copied my resultant HTML list to the page. My work only cost me 5 minutes each week. I have no idea what Jeremy's time is in extracting the raw data.

As I see a rudimentary process for getting the raw data would be as follows:

Create a temp table

Select the cells that need to be added to the temp table records e,g, category, wikiname, thread count, page edits, URL.

Query the main database to create records in the Temp table.

Sort accending, the temp table by adding thread count plus page edits

Select the first 100 records

Export the selected records to Excell

This could be set up in a SQL Query macro (if KimberlyB had not already done so)

If the list is not to come back, it will be Jeremy's decision, not Kevin's nor Cryingdove's.
 Do you find this valuable?