Andreas Schuldei dijo [Thu, Dec 22, 2005 at 06:16:26PM +0100]: > i went through all accepted proposals and checked them as > "accepted". going through them again shows still status "new". is > this a problem in the frontend only? Nope, it's for real - I have one proposal marked as 'details requested' (Debian's Debugging Debacle: the Debrief), all others are new. ... Spotted the problem and fixed it - Gah, why is Debconf such an atypical conference? It worked fine on my other two actually running conferences ;-) Anyway... If I got it fine, the following 17 proposals (more listed as co-authors appear in a new row): id | title | ?column? ----+--------------------------------------------------------------------------------------+--------------------------- 36 | Cheap Thrills - Instant inspiration for the masses | Reichle Meike 29 | Codes of Value: An Anthropological Analysis of Hacker Values | Coleman Gabriella 32 | Debian Installer internals | Pop Frans 51 | Debian: A Forced To Be Reckoned With | Hill Benjamin Mako 24 | Debtags one year later | Zini Enrico 40 | Experiences with large CDD-installations | Yrvin Knut 42 | GPLv3 and Debian | Armstrong Don 41 | Let's port together. Debian fun for everyone | De Schrijver Peter 41 | Let's port together. Debian fun for everyone | Langasek Steve 37 | Lightning Talks | Hess Joey 25 | Nobody expects the Finnish Inquisition, or: confessions of a Debian package torturer | Wirzenius Lars 48 | OpenSolaris and Debian: Can we be friends? | Phipps Simon 48 | OpenSolaris and Debian: Can we be friends? | Lopez Ortega Alvaro 27 | Packaging shared libraries | Mouette Josselin 60 | Security Enhanced Linux UML instances --- an Introduction and recipe | Srivastava Manoj 14 | State of the art for Debian i18n/l10n | Perrier Christian 14 | State of the art for Debian i18n/l10n | Fernandez-Sanguino Javier 50 | WTFM part 2: Avoiding Tears and Loss Of Hair | Wirzenius Lars 20 | Weeding out security bugs | Fernandez-Sanguino Javier 18 | releasing in time - etch in December 06 | Barth Andi 18 | releasing in time - etch in December 06 | Langasek Steve (21 rows) I'm marking them all as accepted, but please check if it is a complete list and if I didn't mess anything up. Of course, I'm not notifying them. > currently it looks like i would need a smart dump from the > database giving me all talk titles and email addresses attached, > so i could do a mass-mailing. I know :( That's a feature that has been often requested, but... Well, you know the excuse - which is nothing but an excuse. Well, at least I know you have access to the server, so here it is - It's better than nothing, at least: SELECT pr.id, pr.title, pe.famname||' '||pe.firstname AS name, pe.email, s.descr AS status, t.descr AS type FROM proposal pr JOIN authors au ON au.proposal_id=pr.id JOIN person pe ON au.person_id=pe.id JOIN prop_status s ON pr._prop_status_id=s.id JOIN prop_type t ON pr.prop_type_id=t.id ORDER BY status, title, au.mention_order; > i would also request a new feature: > be able to select proposals by status (and perhaps other > filtering criteria like "not a bof") and then mass-mail a text > field to all selected proposals. > > perhaps even mass-change all selected proposals to a given status > (rejected...). Will work on that - but after my [VAC] - For those who don't read -private, I'll be away starting tomorrow and until Dec28 (will be online Dec29). I'll try to connect and keep up with the mail, but cannot assure much - And I won't be maintaining things, just answering mail. > and while we ask for stuff: could those late submissions in my > mail plus the "ubuntu annual report" by mark shuttelworth be > added to the proposals? Of course, just add them (as a regular user) as BoFs and, from the administrative interface, move them to whatever talk type it should be. If you don't want the user to have to re-submit the talk, you can do it from your personal account, and re-assign them -again- from the DB itself - The proposal is related to the author via the 'authors' table, so just get the ID of the proposal in question and of the person, and do an "UPDATE authors SET person_id=<whatever> WHERE proposal_id=<something>". -- Gunnar Wolf - gwolf@gwolf.org - (+52-55)1451-2244 / 5623-0154 PGP key 1024D/8BB527AF 2001-10-23 Fingerprint: 0C79 D2D1 2C4E 9CE4 5973 F800 D80E F35A 8BB5 27AF
Attachment:
signature.asc
Description: Digital signature