[Trac] Help! Need simple report to show 'Active tickets that haven't been updated/modified in the past 7 days
Hi Steve [EMAIL PROTECTED]
This works for us on Trac 0.10.4:
===
Title:
Active, Visible Tickets Unchanged for More Than 30 Days, oredered by Time
Unchanged
Description:
List tickets that haven't been changed in the last 30 days, sorted by length
of time unchanged.
SQL:
SELECT DISTINCT p.value AS __color__,
id AS ticket,
summary, component, milestone, t.type AS type,
owner, reporter, time AS created,
changetime AS modified, description AS _description,
priority,
round(julianday('now') - julianday(changetime, 'unixepoch')) as days
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE ((julianday('now') - julianday(changetime, 'unixepoch')) 30)
AND status = 'assigned'
ORDER BY changetime, p.value, owner
=
Cheers
Steve McCusker
-Original Message-
From: trac-users group [mailto:[EMAIL PROTECTED]
Sent: Monday, 31 March 2008 19:37
To: trac-users digest subscribers
Subject: 3 new messages in 2 topics - digest
Trac Users
http://groups.google.com/group/trac-users?hl=en
trac-users@googlegroups.com
Today's topics:
* Help! Need simple report to show 'Active tickets that haven't
been updated/
modified in the past 7 days' - 1 messages, 1 author
http://groups.google.com/group/trac-users/browse_thread/thread/81f
e9f49f8bc78c1?hl=en
* does trac support to send notificaton when a change set in the svn - 2
messages, 2 authors
http://groups.google.com/group/trac-users/browse_thread/thread/6e4
d09af10fd76de?hl=en
==
TOPIC: Help! Need simple report to show 'Active tickets that haven't been
updated/modified in the past 7 days'
http://groups.google.com/group/trac-users/browse_thread/thread/81f
e9f49f8bc78c1?hl=en
==
== 1 of 1 ==
Date: Sun, Mar 30 2008 1:26 am
From: 胡争辉
Do you have a look at the link below:
http://trac.edgewall.org/wiki/TracReports#CreatingCustomReports
2008/3/29, Steve [EMAIL PROTECTED]:
Can someone give me the query for this report?
I just want to show all active tickets that no-one has updated/modifed
in the past 7 days.
thanks in advance!
Steve
--
MSN: Contact me by other methods first.
QQ: 443089607
QQ mail: [EMAIL PROTECTED]
Skype: huzhenghui
Gtalk: huzhengh
GMail: [EMAIL PROTECTED]
==
TOPIC: does trac support to send notificaton when a change set in the svn
http://groups.google.com/group/trac-users/browse_thread/thread/6e4
d09af10fd76de?hl=en
==
== 1 of 2 ==
Date: Sun, Mar 30 2008 2:51 am
From: Xinhao Zheng
hi all,
if you got some clue for my situation,pls share me with your idea:
i want to everyone who is involved in the project get a
notification(email) when changes happened to the svn,.Is that possible?
or maybe we can try to generate a ticket when user do some changes to
svn.
thanks!
georgezheng
== 2 of 2 ==
Date: Sun, Mar 30 2008 3:21 am
From: Emmanuel Blot
Check out the SVN 'commit hook' scripts in the contrib/ directory.
Cheers
Manu
On Sun, Mar 30, 2008 at 10:51 AM, Xinhao Zheng
[EMAIL PROTECTED] wrote:
hi all,
if you got some clue for my situation,pls share me with your idea:
i want to everyone who is involved in the project get a
notification(email) when changes happened to the svn,.Is that possible?
or maybe we can try to generate a ticket when user do some changes to
svn.
thanks!
georgezheng
--
Manu
==
You received this message because you are subscribed to the
Google Groups Trac Users
group.
To post to this group, send email to trac-users@googlegroups.com
or visit http://groups.google.com/group/trac-users?hl=en
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
To change the way you get mail from this group, visit:
http://groups.google.com/group/trac-users/subscribe?hl=en
To report abuse, send email explaining the problem to
[EMAIL PROTECTED]
==
Google Groups: http://groups.google.com?hl=en
--
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1349 - Release Date:
29/03/2008 5:02 PM
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1349 - Release Date:
29/03/2008 17:02
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1349 - Release Date: 29/03/2008
17:02
[Trac] TOPIC: Notification when assigned
Pierre I don't know about Trac 0.11, I've only used 0.10.4. I don't think the owner of the component gets notified in 0.10.4, only the updater, reporter and owner of the ticket or ticket change, and then only if the corresponding entries in trac.ini are set to true. I think the owner of a new ticket is the assignee as far as notification is concerned. Cheers Steve No virus found in this outgoing message. Checked by AVG. Version: 7.5.516 / Virus Database: 269.20.9/1293 - Release Date: 22/02/2008 09:21 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] TOPIC: Notification when assigned
Pierre There is a bug in Trac 0.10.4 that prevents notification of a new ticket. See ticket #3654. The second patch mentioned in the ticklet cured the problem for me. Cheers Steve McCusker Date: Thurs, Feb 14 2008 4:21 am From: [EMAIL PROTECTED] Hi, I've configured notification in my trac.ini. Emails are correctly sent to the owner, reporter since I've set : always_notify_owner = true always_notify_reporter = true However, one of the typicall use cases is to assign a ticket to somebody. I would have expected Trac to send an email to the assignee to warn him that a dew defect|task|enhancement was assigned to him and nothing happened. Further changes to the ticket are well sent by email since somebody is now the owner but the first assignment is not emailed... Is it normal ? Do I missed something in the Trac ini file ? Thanks a lot for your help ! Pierre No virus found in this outgoing message. Checked by AVG. Version: 7.5.516 / Virus Database: 269.20.5/1278 - Release Date: 14/02/2008 10:28 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] How to rename users?
Marcus
Here are the two Python scripts for changing user names throughout a Trac
0.10.4 database and for changing the Apache digest file. If you are using
Basic authorisation instead of digest, the script would need modifying.
I have used the scripts on my Windows 2000 Trac 0.10.4 installation and it
looks OK.
Hope this is of some help.
Steve McCusker
PS I did send these to you direct earlier but maybe they didn't get through.
generate_user_change_digest.py
--
# Generate a new Apache digest file with old users names replaced by new
ones
# and new users names added. The program can replace old passwords as well,
and
# for new users it will generate a password if none is supplied.
# The program reads a text file with lines that contain:
# a single letter code (O for Old users or N for new users)
# the old user name if the code='O' or the digest realm for the new user
if code='N'
# the new user name
# a password
# These parameters are separated by white space and must not contain white
space.
#
# This is the same file format as used by generate_user_change_sql.py
#
# Entries in the old digest file for users not listed in the user_names_file
# are copied to the new digest file without change.
#
# Usage:
# python generate_user_change_digest.py user_names_file_name
old_digest_file new_digest_file
#
# Tested using Python 2.3.5 Apache 2.0.59
#
# (c) 2007 Steve McCusker, Granmac Pty Ltd ([EMAIL PROTECTED])
#
# This program is not guaranteed to be correct, any use is at the user's
risk.
# The author does not restrict the use of this program in any way.
import sys
from string import *
import os.path
from random import sample
import md5
if len(sys.argv) != 4:
print('There must be three command line parameters.')
print('Usage:')
print(' python generate_user_change_digest.py user_names_file_name
old_digest_file new_digest_file')
exit(2)
inputFile = open(sys.argv[1],'r')
user_names = inputFile.readlines()
inputFile.close()
new_users = []
name_mapping = {}
for user in user_names:
words = split(user)
code = upper(words[0])
if (len(words) 3) or (len(words) 4):
print(ERROR: Incorrrect format in + user)
if code == 'N':
new_user = [rstrip(words[2]), rstrip(words[1])]
if len(words) == 4:
new_user.append(rstrip(words[3]))
new_users.append(new_user)
else:
old_user = [rstrip(words[2])]
if len(words) == 4:
old_user.append(rstrip(words[3]))
name_mapping[rstrip(words[1])] = old_user
inputFile = open(sys.argv[2],'r')
old_digest_lines = inputFile.readlines()
inputFile.close()
outputFile = open(sys.argv[3],'wb')
for line in old_digest_lines:
digest_entry = split(line,':')
old_user = digest_entry[0]
if name_mapping.has_key(digest_entry[0]):
new_user = name_mapping[old_user]
if len(new_user) == 1:
password = rstrip(digest_entry[2])
else:
password = new_user[1]
realm = digest_entry[1]
print('Changing old user '+old_user+' to new user '+new_user[0]+'
with password '+password)
prefix = '%s:%s:' % (new_user[0], realm)
unenc = prefix + password
digest = md5.new(unenc).hexdigest()
new_entry = prefix + digest
outputFile.write(new_entry +'\n')
else:
print(Copying unchanged user '+old_user+\
' to new digest file.)
outputFile.write(line)
for new_user in new_users:
if len(new_user) == 2:
new_pass = ''.join(sample(lowercase,2)+sample(digits,2)+\
sample(uppercase,2)+sample(lowercase,2))
else:
new_pass = new_user[2]
realm = new_user[1]
print('Adding new user '+new_user[0]+' with password '+new_pass)
prefix = '%s:%s:' % (new_user[0], realm)
unenc = prefix + new_pass
digest = md5.new(unenc).hexdigest()
new_entry = prefix + digest
outputFile.write(new_entry +'\n')
outputFile.close()
generate_user_change_sql.py
---
# Generate the SQL needed to change the Trac 0.10.4 database to change a
user name.
# The program reads a text file with lines that contain:
# a single letter code (O for Old users or N for new users)
# the old user name if the code='O' or the digest realm for the new user
if code='N'
# the new user name
# a password
# These parameters are separated by white space and must not contain white
space.
#
# This is the same file format as used by generate_user_change_digest.py
# This program does not use the password field and ignores lines starting
# with a code of 'N'.
#
# Usage:
# python generate_user_change_sql.py user_names_file_name new_sql_file
#
# Tested using Python 2.3.5
#
# (c) 2007 Steve McCusker, Granmac Pty Ltd ([EMAIL PROTECTED])
#
# This program is not guaranteed to be correct, any use is at the user's
risk.
# The author does not restrict the use of this program in any way.
import sys
from string import
[Trac] How to rename users?
Hi Marcus I have the same problem. The user names appear in lots of tables in the database. These fields hold the actual user name strings not just foreign keys into the session_attribute table where user names and email addresses are stored. So if you change a user name you have to find all the occurrences of the user name in the database and change it there too. I have written a piece of SQL to do this, and because I have quite a few users to change, I wrote a python script to generate the SQL for all the user names in a text file (with each line having the old user name and the new user name for one user). The other part of the problem I had was to change the user names in the Apache digest file I use for authentication. I wrote another python script to change these. This uses the same text file as input as the first python script described above. I can let you have copies of these if you like BUT all of these scripts are untested as I haven't got to the point when I want to make the changes. So you might prefer not to use the scripts or to wait until I have tested them, probably in a week or two. Cheers Steve McCusker PS I am using Trac 0.10.4 No virus found in this outgoing message. Checked by AVG. Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date: 27/09/2007 11:06 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] TandE plugin Sql errors
Hi Andy Just using trac-admin upgrade should be enough. Before you do it make sure you have the plugin enabled in trac.ini. After you have enabled the plugin in trac.ini you need to restart Apache or tracd or whatever web server you are using. Then trac-admin upgrade should work. If the database has been upgraded with the plugin tables and fields, there should also be a row in the system table with the name column = TimingAndEstimationplugin_Db_Version, and the value column = 3. I guess this is how the plugin nows whether the database has been upgraded or not. So inspect this table using sqlite3 and see if it has been upgraded. If not then it looks to me like the plugin is not installed or not enabled. Having said all that, remember that I am not very expert in Trac. However I amusing Trac 0.10.4 on Windows XP and 2000 and am installing it on Linux (SME Server). The plugin is being used on all of these and seems to work. Hope that helps. Cheers Steve No virus found in this outgoing message. Checked by AVG. Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date: 27/09/2007 11:06 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] TandE plugin Sql errors
Hi Andy Yes the database should have those two tables, and four custom fields should have been added to tickets. These should have been added to the [ticket-custom] section of the trac.ini file by the plugin (or the database upgrade? I am not sure). Once tickets have used them, rows with these fields will appear in the ticket_custom table. So it sounds like you need to do the database update again. Cheers Steve No virus found in this outgoing message. Checked by AVG. Version: 7.5.488 / Virus Database: 269.13.30/1030 - Release Date: 25/09/2007 08:02 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] TOPIC: TandE plugin Sql errors
Andy Are you running the report from the View tickets page or from the Management page? They only work from the management page. Steve McCusker No virus found in this outgoing message. Checked by AVG. Version: 7.5.488 / Virus Database: 269.13.28/1021 - Release Date: 21/09/2007 14:02 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] TOPIC: Queries that include custom fields
Jen
Maybe the problem with your SQL is that you have used as a column name
(c.value AS Workflow State)
and as a text string (AND c.name = Workflow State).
Maybe it will work if you change the column name to something slightly
different.
But I am no SQL expert.
Cheers
Steve McCusker
Jen wrote:
---
SELECT p.value AS __color__,
c.value AS Workflow State,
id AS ticket, summary, component, version,
milestone, priority, t.type AS type,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS
owner,
time AS created,
changetime AS _changetime, description AS _description,
reporter AS _reporter
FROM ticket t, enum p
LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name =
Workflow State)
WHERE status IN ('new', 'assigned', 'reopened')
AND p.name = t.priority AND p.type = 'priority'
ORDER BY p.value, milestone, t.type, time
--
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.476 / Virus Database: 269.10.16/914 - Release Date: 23/07/2007
19:45
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Trac
Users group.
To post to this group, send email to trac-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~--~~~~--~~--~--~---
