feature request: esport project list in csv

[GoogleCodeExporter]

This is a request for a simple feature that I believe all
projects with a large number of submissions would find useful.

At least in the initial filtering of our 100+ applications, we need to
sort them in multiple ways (e.g. by title because there are multiple
applications for the same project; by name, because several people
submitted multiple applications; by average score, because the number
of votes for each project differs, and the web tool only computes
the total).

I understand that you don't have the time to modify the mentor
application to do all the above, but as an interim solution
it would be great if you could export the project list in CSV or
some other easy format so
we can do our initial processing with more comfortable tools.
It would be enough to have just the URL to the full proposal
(so we can use that to run the discussion), and then the author
name and proposal title.

---

Original issue reported on code.google.com by rizzo-...@prova.iet.unipi.it on 26 Mar 2007 at 7:40

[GoogleCodeExporter]

Thanks for the feature request.

Original comment by LHospo@gmail.com on 26 Mar 2007 at 11:52

• Added labels: Priority-Low, Milestone-2008
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Yes please, me too etc.

We had to do this by hand, before uploading the result to Google Spreadsheets. 
This
would be a great alternative to implementing all the requests which basically 
say
"make the web app more like a spreadsheet" (sorts, filters etc.)

We needed this because we wanted to categorise and group applications for the 
same
idea, and add "initial evaluators" (people expert in an area who take a first 
look to
say either 'let's consider this' or 'rubbish').

Original comment by gerv.mar...@gmail.com on 27 Mar 2007 at 3:21

[GoogleCodeExporter]

I don't hold out a lot of hope, but I'm seeing if we can get engineering 
resources to
implement this sooner rather than later.  Stay tuned.

Original comment by LHospo@gmail.com on 28 Mar 2007 at 2:46

[GoogleCodeExporter]

for those interested, attached is a small awk script to do the filtering.
I manually saved the source for the various submissions (25 per page) into
separate html files, then run something like
   awk -f filter.awk  soc-page* > /tmp/sc.html
to produce an html page, or
    awk -f filter.awk -v txt=1 soc-page* > /tmp/sc.csv
to produce a CSV file.
I don't know if the links extracted from the page are good outside my
own session but that's all i have...

Original comment by rizzo-...@prova.iet.unipi.it on 29 Mar 2007 at 5:52

Attachments:

• filter.awk

[GoogleCodeExporter]

FWIW, here's the script I used. I guess it does less than Luigi's mail, but it's
still useful if you want to organize your list of applications by topic.

Just save the source of the pages listing the applications (so
http://code.google.com/soc/yourproject/open.html,
http://code.google.com/soc/yourproject/open.html?page=25, etc.) and run

  python gsoc.py open*.html

Original comment by vincent....@gmail.com on 29 Mar 2007 at 7:46

Attachments:

• gsoc.py

[GoogleCodeExporter]

I've written my own scripts for such things. It's a bit more sophisticated, and
outputs a plain text list. It gives a list of all projects for an org, as well 
as the
willing mentors, and who's given how many points to a project (if started with 
-v
points=1). It uses curl, and you'll need curl, and a cookies.txt file from a 
firefox
profile that's logged into your google account in the same directory.

You'll have to start makelist with the argument '0' or the offset that you want 
it to
start at. Also, I find this useful (it could be more sophisticated):

awk '/^[a-zA-Z]/{proj=$0};/^\tmentor:/{sub(/^[^:]+: /,"");m[$0]=m[$0] "\n\t"
proj}END{for(i in m)print i m[i] "\n"}' list.txt

awk '/^[a-zA-Z]/{proj=$0};/^\twilling:/{sub(/^[^:]+: /,"");m[$0]=m[$0] "\n\t"
proj}END{for(i in m)print i m[i] "\n"}' list2.txt

Original comment by fbsdae...@gmail.com on 30 Mar 2007 at 6:25

Attachments:

• makelist
• getmentors

[GoogleCodeExporter]

I've made the aforeposted awk scripts more intricate. It now list the mentors,
followed by their assigned apps, prefixed with a '+', then the apps they're 
willing
to mentor. One might write similar scripts for other types or sorting.

Original comment by fbsdae...@gmail.com on 30 Mar 2007 at 7:17

Attachments:

• mentors

[GoogleCodeExporter]

Original comment by LHospo@gmail.com on 2 Apr 2007 at 9:57

• Added labels: Type-Enhancement
• Removed labels: Type-Defect

[GoogleCodeExporter]

This actually already exists! It's very well hidden, though. It appears in the
sidebar, only when you are viewing your organisation profile.

The URL is of the form:
http://code.google.com/soc/mozilla/app_export.csv

Gerv

Original comment by gerv.mar...@gmail.com on 3 Apr 2007 at 2:38

[GoogleCodeExporter]

Works for me too; if made a bit more prominent, this seems done.

Original comment by j...@joshtriplett.org on 11 Apr 2007 at 9:11

[GoogleCodeExporter]

I couldn't find it, but I'm just a mentor, not an admin.  If that makes a 
difference, it adds a manual copying step (unless only the admins do these 
checks).

If it involves downloading, that might not be unreasonable; online sorts would 
be 
used by many more people.  

Original comment by JimJJew...@gmail.com on 12 Apr 2007 at 1:38

[GoogleCodeExporter]

Hmm. This feature doesn't seem to be there in the 2008 web app, even though the 
link
is still there in the sidebar :-((

Original comment by gerv.mar...@gmail.com on 8 Apr 2008 at 9:34

[GoogleCodeExporter]

"Export Application List as CSV" link is now available at the bottom of the
Application List (open.html) page.

Original comment by todd.larsen on 17 Apr 2008 at 7:26

• Changed state: Fixed