Re: table view wnpp page now on wnpp.debian.net

2008-03-23 Thread Sebastian Pipping
Tim Cutts wrote: Still not free, but the following web site probably helps you do what you want: http://wellstyled.com/tools/colorscheme2/index-en.html Very cool tool. I guess they changed the license, it reads Creative Commons BY-NC-SA 2.0 now. Click on its "triad" button, and it automatic

Re: table view wnpp page now on wnpp.debian.net

2008-03-16 Thread Sebastian Pipping
Tim Cutts wrote: Hm, can you help with creating a good set of colors? There are a number of programs around which can help with this. I use Color Oracle: http://colororacle.cartography.ch/ It sits in a Gnome panel, and will temporarily change your entire display's colours to simulate thr

Re: table view wnpp page now on wnpp.debian.net

2008-03-13 Thread Sebastian Pipping
Sebastian Pipping wrote: thanks to lucas nussbaum the address http://debian.binera.de/wnpp/ is now accessible through http://wnpp.debian.net/ . I moved the WNPP table page to a host where I can modify the Apache config. Therefore http://wnpp.debian.net/ is no longer a HTTP redirect

Re: table view wnpp page now on wnpp.debian.net

2008-03-13 Thread Sebastian Pipping
Tim Cutts wrote: A minor niggle, but the colours you have chosen are not good for the 5% of your male viewers who have deuteranopia or protanopia, the two most common forms of colour-blindness. I don't have either condition myself, but I've been bitten by this before in web pages I've created.

Re: wnpp.debian.net sources released, security review wanted, plans for the future

2008-02-01 Thread Sebastian Pipping
Holger Levsen wrote: Lucas offered that to me but the host the site runs on cannot handle a new IP for free. It doesnt need a new IP. Just point wnpp.d.n to the current IP of your server. Sorry for me imprecision. I think I cannot make that server accept requests for wnpp.debian.net . Seba

Re: The 30 most popular packages missing in Debian

2008-01-30 Thread Sebastian Pipping
Sebastian Pipping wrote: * A mapping to current ITPs might be interesting. (Integration into http://wnpp.debian.net/) I just added that. Currently about 500 RFPs and ITPs show more than 0 installs: http://wnpp.debian.net/?type%5B%5D=ITP&type%5B%5D=RFP&sort=installs;desc Sebastian

Re: wnpp.debian.net sources released, security review wanted, plans for the future

2008-01-30 Thread Sebastian Pipping
Paul Wise wrote: Not sure what you had in mind for a "feed". If you mean RDF/RSS of DSAs, there are two here: http://www.debian.org/security/ Is there a way to get notified of new security bugs right when they are opened? Sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subj

Re: wnpp.debian.net sources released, security review wanted, plans for the future

2008-01-30 Thread Sebastian Pipping
Paul Wise wrote: Ah, I see. Perhaps lucas (according to [1]) could be convinced to change the IP to yours. What do you think about that lucas? Why only a redirect in the first place? 1. http://people.debian.org/~nion/net-domains.html Lucas offered that to me but the host the site runs on cann

Re: wnpp.debian.net sources released, security review wanted, plans for the future

2008-01-30 Thread Sebastian Pipping
Paul Wise wrote: Sorry, but I don't think this will change as long it's maintainer is not a Debian developer. This way or the other. Why not? If it is good enough for a redirector domain, why not a real one? What I was trying to say is that I don't think I will get necessary permissions to ru

Re: wnpp.debian.net sources released, security review wanted, plans for the future

2008-01-30 Thread Sebastian Pipping
Paul Wise wrote: -- wnpp.debian.net sources Be nice if that wasn't just a redirect domain. Sorry, but I don't think this will change as long it's maintainer is not a Debian developer. This way or the other. Might want to also ask on debian-security (list or IRC) Will do, good idea. Se

wnpp.debian.net sources released, security review wanted, plans for the future

2008-01-29 Thread Sebastian Pipping
Hello! -- wnpp.debian.net sources The source code running http://wnpp.debian.net/ is now hosted in the subversion repository of collab-qa. The current license is GPL 2 or later, the code requires PHP >=5 and MySQL >=4.1 to run. http://svn.debian.org/viewsvn/collab-qa/ (As the concrete locat

Re: The 30 most popular packages missing in Debian

2008-01-29 Thread Sebastian Pipping
* Would non-free be an option to all or some of them? Do we have binary only packages in Debian? * A mapping to current ITPs might be interesting. (Integration into http://wnpp.debian.net/) Sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble?

Re: table view wnpp page now on wnpp.debian.net

2008-01-28 Thread Sebastian Pipping
Holger Levsen wrote: It doesnt mean "age in days" but "days since last activity on the bug". The bugs I checked first, were indeed filed today, but then I saw #456640, which was filed in December but had activity today, so the dust was 0. Dust Number of days without changes (i.e. amount o

Re: table view wnpp page now on wnpp.debian.net

2008-01-28 Thread Sebastian Pipping
Holger Levsen wrote: Could you add an explaination of "dust" on the page, too? I have it in the tooltips ('title' attribute) but I agree that a detailed legend would help. Any ideas where to put it best? At the very bottom of the page? In an extra page/window? I'm pretty sure it means "age i

Re: [rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-27 Thread Sebastian Pipping
Andreas Tille wrote: A further enhancement would be to not list merged bugs because both bugs are mentioned on your page. fixed. a project with two bugs now is shown as project [1][2] instead of project project before. try this query to see it in action: http://wnpp.debian.net/?pro

Re: [rfc] wnpp feed

2008-01-26 Thread Sebastian Pipping
I just finished a RSS 2.0 feed for WNPP. It is located here: http://debian.binera.de/wnpp/news.php5 The cron job feeding it currently runs every 30 minutes. Please take that into account when configuring the query interval. Further details on its usage below... Configuration: data= (defa

table view wnpp page now on wnpp.debian.net

2008-01-25 Thread Sebastian Pipping
thanks to lucas nussbaum the address http://debian.binera.de/wnpp/ is now accessible through http://wnpp.debian.net/ . sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Re: Future Debian package candidate web pages: present and future

2008-01-22 Thread Sebastian Pipping
David Bremner wrote: [..] I would really like some (approximate) popcon data myself, especially for orphaned packages. [..] added! it was a left join that i needed here. yeha! :-) this should list orphaned packages in decending order of minimum number of people using them: http://debian.bi

Re: Future Debian package candidate web pages: present and future

2008-01-22 Thread Sebastian Pipping
Raphael Geissert wrote: You could simply download it from http://popcon.debian.org/ and parse it... Or read it from http://qa.debian.org/data/popcon/ which AFAIR is updated daily. I see two problems with the latter: I'd have to either choose between the one column file (too little data) or th

Re: [rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-22 Thread Sebastian Pipping
Andreas Tille wrote: A further enhancement would be to not list merged bugs because both bugs are mentioned on your page. Right. I'm not sure about the best way yet. I think MySQL can help me with that but not sure yet how exactly. Sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] w

Re: [rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-21 Thread Sebastian Pipping
Sebastian Pipping wrote: this query shows some very old ITA/ITP bugs: http://debian.binera.de/wnpp/?type%5B%5D=ITA&type%5B%5D=ITP&sort=dust;desc should i create a retitle command list from that? sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of &quo

[rfc] wnpp feed

2008-01-21 Thread Sebastian Pipping
i plan to add a feed to [1] in the future. the current set of questions to answer is "what new/existing bugs became type O/RFA/RFH" == "what existing packages need help" what i want to know: * what would your questions be? * should i go for atom 1.0 or rss 2.0? thanks for your thoughts,

Re: [rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-21 Thread Sebastian Pipping
Andreas Tille wrote: So I do not mind that I'm listed responsible for this bug but to make the page really effective it might be better to dive even more into the details of the bug history. Actually I misread this the first time. What exactly do you have in mind? Sebastian -- To UNSUBSCRI

Re: [rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-21 Thread Sebastian Pipping
Sebastian Pipping wrote: [..] i plan to add the owner column later today. added, will take some time for the cron to feed in the data though. sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Re: [rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-21 Thread Sebastian Pipping
Andreas Tille wrote: Very interesting page. I tried to find out for ITPs I'm "guilty" for and found that I'm listed behind #186958. It is right that I originally issued the bug but as RFP. It was later on retitled to ITP by Thomas Huriaux and it was also merged with #389876. actually that co

Re: [rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-20 Thread Sebastian Pipping
Luk Claes wrote: There is already a process that does that, though it takes into account any follow-up on the bug report to reset the timer which you clearly don't... hm, if we have ITA/ITPs with more than 300 days of no activity than we need a fix here i guess :-) i added a "dust" column show

Re: [rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-20 Thread Sebastian Pipping
Rafael Laboissiere wrote: This web page is great. It would be good to also show the submitter of the bug in a column. added. sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Re: Removal of xmms and its reverse-dependancies - what is the status?

2008-01-20 Thread Sebastian Pipping
Luk Claes wrote: xmms removal was decided some time ago. i am working on a project partly depending on parts of xmms. in case it is removed i will need at least backups of all related package sources so i can still have the packages at my place. where can i find more information about this?

Re: Future Debian package candidate web pages: present and future

2008-01-19 Thread Sebastian Pipping
found someone. sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Re: Future Debian package candidate web pages: present and future

2008-01-19 Thread Sebastian Pipping
can anybody provide a HTTP request cron job for me? what i need is a call to http://debian.binera.de/wnpp/cron_sync_list.php5 every 30 minutes. the way i could set this with my current ISP would require 48 single cron jobs and that's too much. so i'm asking for help. please contact me if you

Re: [rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-19 Thread Sebastian Pipping
Rafael Laboissiere wrote: http://debian.binera.de/wnpp/?type%5B%5D=ITA&type%5B%5D=ITP&sort=age;desc This web page is great. It would be good to also show the submitter of the bug in a column. noted for todo. sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsu

Re: [rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-19 Thread Sebastian Pipping
Luk Claes wrote: i noticed that there exist many ita/itp bugs that are much older than two month. would it make sense to set them back to rfa/rfp? if so how many days would be good to be the "too old" edge value? There is already a process that does that, though it takes into account any follow

[rfc] mass-mod old ita/itp bugs back to rfa/rfp?

2008-01-19 Thread Sebastian Pipping
i noticed that there exist many ita/itp bugs that are much older than two month. would it make sense to set them back to rfa/rfp? if so how many days would be good to be the "too old" edge value? click this to get a quick overview: :-D http://debian.binera.de/wnpp/?type%5B%5D=ITA&type%5B%5D=ITP&s

Re: Future Debian package candidate web pages: present and future

2008-01-17 Thread Sebastian Pipping
Sebastian Pipping wrote: PS: sorting is not cool yet. i plan to address this next. i think sorting is smooth now. check it out :-) sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Re: Future Debian package candidate web pages: present and future

2008-01-17 Thread Sebastian Pipping
Don Armstrong wrote: You should actually be able to generate this page with two requests: my @bugs = @{$soap->get_bugs(package=>'wnpp')->results()}; my $status_hash = $soap->get_status(@bugs)->results(); i plan to give this a try later. what do you think: up to what number of bugs should i que

Re: Future Debian package candidate web pages: present and future

2008-01-17 Thread Sebastian Pipping
David Bremner wrote: Sebastian> http://debian.binera.de/wnpp/ Looking better all the time. thanks! I would really like some (approximate) popcon data myself, especially for orphaned packages. would be cool, yes. i don't have any clue to do this yet. if you do please share your thou

Re: Future Debian package candidate web pages: present and future

2008-01-16 Thread Sebastian Pipping
Neil Williams wrote: It could do with some sub-divisions, separating ITP from RFP etc. turning on/off each type is now possible. One very useful addition would be an internal search [..] Filtering by project name and/or description is now possible. An example filter would be "unicode -

Re: wnpp tags "ita" and "rm"

2008-01-15 Thread Sebastian Pipping
Nico Golde wrote: i noticed the "intent to adopt" tag is not mentioned on [2] though used frequently. is this on purpose? I guess yes since this part is about adding a new wnpp bug. And adding a bug with ITA as tag does not make much sense. It is documented on http://www.debian.org/devel/wnpp

wnpp tags "ita" and "rm"

2008-01-15 Thread Sebastian Pipping
-- rm i noticed this bug [1] is the only wnpp bug using the type "rm" for removal. is this an official type that scripts talking to BTS should support? is it documented somewhere? is it a bug in the bug report? -- ita i noticed the "intent to adopt" tag is not mentioned on [2] though used frequen

Re: Future Debian package candidate web pages: present and future

2008-01-14 Thread Sebastian Pipping
Neil Williams wrote: Have you thought about not relying on a cron job but doing the whole thing via the PHP SOAP interface? I'm using PHP and SOAP to query the BTS for Emdebian. http://www.emdebian.org/bugs.php (code available in the Emdebian SVN repo) http://buildd.emdebian.org/svn/browser/curre

Re: Future Debian package candidate web pages: present and future

2008-01-14 Thread Sebastian Pipping
Don Armstrong wrote: There's no SQL to talk to. If you want actual accurate data, the SOAP service is the thing to talk to. [Anything else has various delay lengths in it before you actually see the data reported.] i started working on this project and i have reached the point where it makes se

Re: Future Debian package candidate web pages: present and future

2008-01-05 Thread Sebastian Pipping
Nico Golde wrote: http://bugs.debian.org:80/cgi-bin/soap.cgi Have a look at: http://wiki.debian.org/DebbugsSoapInterface I guess you misunderstood my question. Again: Where does SOAP (itself) get the data from? Sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "uns

Re: Future Debian package candidate web pages: present and future

2008-01-05 Thread Sebastian Pipping
Don Armstrong wrote: There's no SQL to talk to. If you want actual accurate data, the SOAP service is the thing to talk to. [Anything else has various delay lengths in it before you actually see the data reported.] Where does SOAP get the data from? Sebastian -- To UNSUBSCRIBE, email to [E

Re: Future Debian package candidate web pages: present and future

2008-01-05 Thread Sebastian Pipping
Lucas Nussbaum wrote: Another solution is to use the BTS dump available at http://qa.debian.org/data/bts2ldap/ It's very easy to parse (and import in an SQL DB, if you want) Interesting. Thank you! Sebastian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Tro

Re: Future Debian package candidate web pages: present and future

2008-01-05 Thread Sebastian Pipping
Raphael Geissert wrote: AFAIR the SOAP interface can provide you with such information (refer to the wiki page). I'd rather talk to SQL if possible. It's faster and much easier to me. popcon data is available at popcon.d.o, importance can be extracted from the Packages files. Good idea.

Re: Future Debian package candidate web pages: present and future

2008-01-04 Thread Sebastian Pipping
Lucas Nussbaum wrote: The two web pages "Packages being worked on" [1] and "Requested packages" [2] have several shortcomings: The same shortcomings exist for the orphaned packages. Do I understand right that orphaned packages are packages already left unmaintained while up-for-adoption means

Future Debian package candidate web pages: present and future

2008-01-03 Thread Sebastian Pipping
Hello! The two web pages "Packages being worked on" [1] and "Requested packages" [2] have several shortcomings: * No sorting by age * No importance/popularity tag of packages * No combined requested-or-worked-on (== not packaged) view * No easy status indicator, e.g. "license issues", "upstrea