Shouldn't be a problem.

Kevin Crowston

On 8-Aug-08, at 2:19 PM, Greg Madey <gmadey@nd.edu> wrote:

Kevin,

No sure what months you're looking for, but we're behind 2 months uploading the dumps to the ND server (SRDA). The last month online is May 2008. We have June & July 2008, but are rebuilding a server. Hope to have those months online next week.

Greg Madey



On Aug 8, 2008, at 4:26 PM, Kevin Crowston wrote:

Ah, that explains the omission. I'll have a look at the ND data to see  
what I can get there.

On 8 Aug 2008, at 4:11 PM, Megan Squire Conklin wrote:

I wrote an all time stats collector, but the stats server has been  
down
for months. ETA was August. Still not up, though they sent an email a
few days ago talking about the migration and stuff.

Perhaps there is some way to make a data mart style table of the
pertinent information from the large table?

Say, split out datasources into subtables, run summary stats on those
and then sum them? Or is that more trouble than just grabbing the  
stuff
from ND?

Kevin Crowston wrote:
Hi all,

I'm trying to use FLOSSmole data to recreate an older paper that
analyzed SourceForge and need some help tracking down a few of the
variables.

The paper used (among other things) pageviews, downloads and  
activity in
a regression, but I can't seem to locate a good source for those.  
There
is a table, project_alltime_statistics, but it apparently has data  
only
for 2007-04-15. There's also project_statistics, but it looks like it
has data only from datasource 4, which is also old. Then there's
project_statistics_60, which has the daily statistics rather than all
time. That'll be okay for activity--I can just use the most recent  
date.
But the table is so big that it's practically impossible to run  
queries
on it, so summing across for all time downloads and pageviews doesn't
seem like a good idea even if the table were complete, which it's  
not.

There are a couple other variables I know I'll need to get from the  
ND
dataset, so if it's not easy to get all time downloads and  
pageviews, I
can look there.


Kevin Crowston
Syracuse University                                    Phone:  +1  
(315)
443-1676
School of Information Studies            Fax:    +1 (866) 265-7407
348 Hinds Hall                        Web:    http://
crowston.syr.edu/
Syracuse, NY   13244-4100   USA

*PS: The attachment named "PGP.sig" of type "application/pgp-
signature"
is an electronic signature that may be used to verify that this email
came from me if you have PGP or GPG. Otherwise, you may safely ignore
the attachment.


------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's  
challenge
Build the coolest Linux based applications with Moblin SDK & win  
great prizes
Grand prize is a trip for two to an Open Source event anywhere in  
the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/


------------------------------------------------------------------------

_______________________________________________
Ossmole-discuss mailing list
Ossmole-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ossmole-discuss

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's  
challenge
Build the coolest Linux based applications with Moblin SDK & win  
great prizes
Grand prize is a trip for two to an Open Source event anywhere in  
the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Ossmole-discuss mailing list
Ossmole-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ossmole-discuss


Kevin Crowston
Syracuse University                             Phone:  +1 (315)  
443-1676
School of Information Studies Fax:    +1 (866) 265-7407
348 Hinds Hall Web:    http://crowston.syr.edu/
Syracuse, NY   13244-4100   USA

*PS: The attachment named "PGP.sig" of type "application/pgp-
signature" is an electronic signature that may be used to verify that  
this email came from me if you have PGP or GPG. Otherwise, you may  
safely ignore the attachment.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Ossmole-discuss mailing list
Ossmole-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ossmole-discuss

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Ossmole-discuss mailing list
Ossmole-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ossmole-discuss