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