[Trac] Re: trac-hacks.org going read-only
Hi all. As you might have heard lately, trac-hacks.org is going to move to a new server. Things have been prepared as much as possible, and the actual move will start in about 24 hours. The move is finished, trac-hacks.org is now up and running on the new server. Thanks for your patience, everyone. In case you come across any issues with the website, please let me know. For those who are interested, [1] contains background information about the move and a first (but very vague) insight in future plans. Bye, Mike [1] http://trac-hacks.org/wiki/news/2009-02-04-trac-hacks-org-moved-to-new-server --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: How to format a URL in Trac in a custom field
Looks like this might work: [changeset:?new...@readme.txtold...@readme.txt 23] This produces a clickable link with the text 23. On Feb 3, 12:39 pm, Stodge sto...@gmail.com wrote: I've added a custom ticket field called Changes to my Trac environment and I hacked Trac to support Wiki formatting in custom fields. I had to copy/paste code from a patch, as the patch wouldn't apply for me. I've also modified the post-commit hook to write change set details to this field, for example: test.py 20,21,22 (19-22) README.TXT 20,21,22 (19-22) It shows the path that was modified, the versions created under the current ticket and the version numbers for the base and last modified. If that makes sense. What I want to do is make these clickable links so that when you click on the '20' for test.py, it'll show you a diff for test.py versions 19 vs 20. Likewise clicking '19-20' will take you to a diff of the overall changes for this file under this particular ticket. What do I use, or how do I format these links to point to something like: http://localhost/trac/support/changeset?new...@codereviewstruct.pyold...@test.py Is there a standard method of doing this? I could modify the ticket template but I'm not sure how to format it relative to the site's URL. Any suggestions appreciated. Thanks --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Custom formatting for custom ticket field?
I have a custom ticket field that I populate/update in the Subversion post-commit hook script. I basically dump in pure text (file revisions). I want to perform some custom formatting of this field when it is rendered. However, I would probably need to run some Python code to convert the field contents to something like this: [changeset:25 Changeset 25] * [browser:/README.TXT?rev=25 README.TXT] [changeset:? new...@readme.txtold...@readme.txt 23] [changeset:? new...@readme.txtold...@readme.txt 24] [changeset:? new...@readme.txtold...@readme.txt 25] [changeset:? new...@readme.txtold...@readme.txt (Diff with base)] Is this possible? Can I run Python code in the template? Thanks --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Custom formatting for custom ticket field?
One option might be http://trac.edgewall.org/wiki/WikiProcessors. On Feb 4, 8:28 am, Stodge sto...@gmail.com wrote: I have a custom ticket field that I populate/update in the Subversion post-commit hook script. I basically dump in pure text (file revisions). I want to perform some custom formatting of this field when it is rendered. However, I would probably need to run some Python code to convert the field contents to something like this: [changeset:25 Changeset 25] * [browser:/README.TXT?rev=25 README.TXT] [changeset:? new...@readme.txtold...@readme.txt 23] [changeset:? new...@readme.txtold...@readme.txt 24] [changeset:? new...@readme.txtold...@readme.txt 25] [changeset:? new...@readme.txtold...@readme.txt (Diff with base)] Is this possible? Can I run Python code in the template? Thanks --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Multiple projects and permissions
On Tue, Feb 3, 2009 at 5:58 PM, cambo_frog cambo_f...@yahoo.com wrote: Hi All, I am new to trac and svn, but have both setup and working OK with Apache. I have Apache setup on Windows XP to use multiple projects( trac environments) using the following in httpd.conf: Location /trac-projects SetHandler mod_python PythonInterpreter main_interpreter PythonHandler trac.web.modpython_frontend PythonOption TracEnvParentDir E:/trac-projects PythonOption TracUriRoot /trac-projects PythonDebug On AuthType Basic AuthName Trac projects AuthUserFile passwd Require valid-user /Location The line: PythonOption TracEnvParentDir E:/trac-projects ...enablaling multiple project browsing. I can add a permission for a single project, e.g. trac-admin E:/trac-projects/trac-test permission add admin TRAC_ADMIN I cannot add permissions to the trac projects parent directory (E:/ trac-projects). I guess that's because the parent directory doesn't contain a trac environment, but is there any way of adding permissions to all projects under TracEnvParentDir (E:/trac-projects) or do all permissions have to be set per project? Thanks in advance for your help. Not that I'm aware of Trac-Admin needs an environment passed to it, you could probably right a script that wraps your environments in a loop and iterate through them. Matt P. --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Adding attachments doesn't work
On Wed, Feb 4, 2009 at 12:45 AM, Victor Star t...@victorstar.com wrote: Hi guys, I'm new to Trac, this is my first installation. So far I was able to configure everything but one thing: Attachments don't work. The button is there, I select the file, submit the form. I see the page with the same button. No files attached to ticket, no files on the disk, no erro messages anywhere. I'm running Trac standalone as tracd on Open Suse. The project directory permissions are fine (wwwrun:www) including attachments directory. I've followed all the steps for stand-alone installation and it worked like a charm. Except attachments. I've done my search - google, newsgroups, docs, wikis, track-hacks. I found couple unanswered messages in this very group 2 months ago and that's it. I would appreciate any help here. At least an error message anywhere would be nice! But - nothing Thanks in advance guys! Victor Try turning debug on if it's not on and see if anything shows up in trac.log Matt P. --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Sub-contractors to view only tickets relevant to them -
On Wed, Feb 4, 2009 at 1:02 AM, i...@calyx.net.au wrote: Hi, My first question... How can we set up TRAC so that each sub-contractor only sees the tickets that are relevant to them? Directly or via CC. It would be best that all tickets are not viewable by all our sub- contractors. Version: Trac 0.10.3 Hope this makes sense. Thank you for your help. Irma look on trac-hacks.org for the privateTicket plugin Matt P. --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Question on TracHours plugin
Hi, I have not seen this issue (at least recently). Please ticket at http://trac-hacks.org/newticket?component=TracHoursPluginowner=k0s Thanks for reporting this issue. I'm not sure how long it will be before I can work on it, as most of my time is scheduled by my employer, but I will get to it when I can. I apologize for any delay at looking at the issue. Jeff On Tue, Feb 03, 2009 at 02:33:17AM -0800, soma wrote: Hi, We have Trac0.11 and Agilo7.2.5 in our system. We are trying to install TracHours plugin. I am able to see the Hours tab and the custom fields, Estimated hours and Total Hours are getting created. But the problem is it is not visible while creating tickets. Hence I went to the Admin tab and added these custom fields to be visible in the Task ticket type. But the Total Hours instead of non-editable field is showing up as text field and in the View Tickets tab, Total hours are not displayed as link. Any ideas? Is there any patch available? Thanks, Soma. --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Insert the ticket owner in the subject of notification
Flatfender wrote: I would like to add the ticket owner (at the time of notifying). What file should I hack in order to do so? Try adding $ticket.owner to the ticket_subject_template line in trac.ini I finally found: subject = self.ticket['owner']+' '+self.format_subj(summary) in trac/ticket/notification.py Then restart Apache The restart is mandatory... -- Chef de projet chez Vectoris http://www.google.com/search?q=mihamina+rakotomandimby System: xUbuntu 8.10 with almost all from package install --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Custom formatting for custom ticket field?
I wrote a tiny macro to test this out. I created /usr/lib/python2.4/ site-packages/Trac-0.11.2.1-py2.4.egg/trac/mimeview/ucm.py, which contains: def execute(hdf, txt, env): return #1 I added ucm to mimeview/api.py. My custom field contains: {{{ #!ucm [changeset:25 Changeset 25] * [browser:/README.TXT?rev=25 README.TXT] [changeset:? new...@readme.txtold...@readme.txt 23] [changeset:? new...@readme.txtold...@readme.txt 24] [changeset:? new...@readme.txtold...@readme.txt 25] [changeset:? new...@readme.txtold...@readme.txt (Diff with base)] }}} When I view the ticket with the custom field, the field is rendered inside a box so it looks like something is working, but my processor isn't being used. Nothing in the logs. Any ideas? Thanks --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Custom formatting for custom ticket field?
Oh yes, ucm.pyc isn't created so my macro isn't being executed. On Feb 4, 10:41 am, Stodge sto...@gmail.com wrote: I wrote a tiny macro to test this out. I created /usr/lib/python2.4/ site-packages/Trac-0.11.2.1-py2.4.egg/trac/mimeview/ucm.py, which contains: def execute(hdf, txt, env): return #1 I added ucm to mimeview/api.py. My custom field contains: {{{ #!ucm [changeset:25 Changeset 25] * [browser:/README.TXT?rev=25 README.TXT] [changeset:? new...@readme.txtold...@readme.txt 23] [changeset:? new...@readme.txtold...@readme.txt 24] [changeset:? new...@readme.txtold...@readme.txt 25] [changeset:? new...@readme.txtold...@readme.txt (Diff with base)] }}} When I view the ticket with the custom field, the field is rendered inside a box so it looks like something is working, but my processor isn't being used. Nothing in the logs. Any ideas? Thanks --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Adding attachments doesn't work
Hi Matt, On Wed, Feb 4, 2009 at 12:45 AM, Victor Star t...@victorstar.com wrote: Hi guys, I'm new to Trac, this is my first installation. So far I was able to configure everything but one thing: Attachments don't work. The button is there, I select the file, submit the form. I see the page with the same button. No files attached to ticket, no files on the disk, no erro messages anywhere. I'm running Trac standalone as tracd on Open Suse. The project directory permissions are fine (wwwrun:www) including attachments directory. I've followed all the steps for stand-alone installation and it worked like a charm. Except attachments. I've done my search - google, newsgroups, docs, wikis, track-hacks. I found couple unanswered messages in this very group 2 months ago and that's it. I would appreciate any help here. At least an error message anywhere would be nice! But - nothing Thanks in advance guys! Victor Try turning debug on if it's not on and see if anything shows up in trac.log This is what I see in the log when sending an attachment: ==- 8 - 2009-02-04 10:38:52,826 Trac[main] DEBUG: Dispatching Request POST u'/attachment/ticket/49/' 2009-02-04 10:38:52,855 Trac[chrome] DEBUG: Prepare chrome data for request 2009-02-04 10:38:52,864 Trac[session] DEBUG: Retrieving session for ID u'victor' 2009-02-04 10:38:52,940 Trac[main] DEBUG: 471 unreachable objects found. ==- 8 - All permissions seem to be set properly as far as I can tell: ==- 8 - /srv/trac/project # ls -l total 44 -rw-r--r-- 1 wwwrun www 83 Feb 2 00:29 .htpasswd -rw-r--r-- 1 wwwrun www 41 Jan 17 22:02 .htpasswd.copy -rw-r--r-- 1 wwwrun www 98 Jan 17 15:47 README -rw-r--r-- 1 wwwrun www 27 Jan 17 15:47 VERSION drwxr-xr-x 2 wwwrun www 4096 Feb 4 10:35 attachments drwxr-xr-x 2 wwwrun www 4096 Feb 4 10:03 conf drwxr-xr-x 2 wwwrun www 4096 Feb 4 01:25 db drwxr-xr-x 2 wwwrun www 4096 Jan 18 01:08 htdocs drwxr-xr-x 2 wwwrun www 4096 Jan 17 22:11 log drwxr-xr-x 2 wwwrun www 4096 Jan 17 15:47 plugins drwxr-xr-x 2 wwwrun www 4096 Jan 17 15:47 templates /srv/trac/project # ==- 8 - tracd is running under wwwrun: ==- 8 - wwwrun 26174 0.0 0.9 230576 36008 ?SJan18 8:03 /usr/bin/python /usr/bin/tracd -d --port 8000 -e /srv/trac --basic-auth=*,/srv/trac/project/.htpasswd, ==- 8 - Any clues? Thanks, Victor --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Custom formatting for custom ticket field?
On Wed, Feb 4, 2009 at 10:42 AM, Stodge sto...@gmail.com wrote: Oh yes, ucm.pyc isn't created so my macro isn't being executed. Try putting your ucm.py in the plugins folder for your trac instance --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Adding attachments doesn't work
On Wed, Feb 4, 2009 at 10:47 AM, Victor Star t...@victorstar.com wrote: Hi Matt, On Wed, Feb 4, 2009 at 12:45 AM, Victor Star t...@victorstar.com wrote: Hi guys, I'm new to Trac, this is my first installation. So far I was able to configure everything but one thing: Attachments don't work. The button is there, I select the file, submit the form. I see the page with the same button. No files attached to ticket, no files on the disk, no erro messages anywhere. I'm running Trac standalone as tracd on Open Suse. The project directory permissions are fine (wwwrun:www) including attachments directory. I've followed all the steps for stand-alone installation and it worked like a charm. Except attachments. I've done my search - google, newsgroups, docs, wikis, track-hacks. I found couple unanswered messages in this very group 2 months ago and that's it. I would appreciate any help here. At least an error message anywhere would be nice! But - nothing Thanks in advance guys! Victor Try turning debug on if it's not on and see if anything shows up in trac.log This is what I see in the log when sending an attachment: ==- 8 - 2009-02-04 10:38:52,826 Trac[main] DEBUG: Dispatching Request POST u'/attachment/ticket/49/' 2009-02-04 10:38:52,855 Trac[chrome] DEBUG: Prepare chrome data for request 2009-02-04 10:38:52,864 Trac[session] DEBUG: Retrieving session for ID u'victor' 2009-02-04 10:38:52,940 Trac[main] DEBUG: 471 unreachable objects found. ==- 8 - All permissions seem to be set properly as far as I can tell: ==- 8 - /srv/trac/project # ls -l total 44 -rw-r--r-- 1 wwwrun www 83 Feb 2 00:29 .htpasswd -rw-r--r-- 1 wwwrun www 41 Jan 17 22:02 .htpasswd.copy -rw-r--r-- 1 wwwrun www 98 Jan 17 15:47 README -rw-r--r-- 1 wwwrun www 27 Jan 17 15:47 VERSION drwxr-xr-x 2 wwwrun www 4096 Feb 4 10:35 attachments drwxr-xr-x 2 wwwrun www 4096 Feb 4 10:03 conf drwxr-xr-x 2 wwwrun www 4096 Feb 4 01:25 db drwxr-xr-x 2 wwwrun www 4096 Jan 18 01:08 htdocs drwxr-xr-x 2 wwwrun www 4096 Jan 17 22:11 log drwxr-xr-x 2 wwwrun www 4096 Jan 17 15:47 plugins drwxr-xr-x 2 wwwrun www 4096 Jan 17 15:47 templates /srv/trac/project # ==- 8 - tracd is running under wwwrun: ==- 8 - wwwrun 26174 0.0 0.9 230576 36008 ?SJan18 8:03 /usr/bin/python /usr/bin/tracd -d --port 8000 -e /srv/trac --basic-auth=*,/srv/trac/project/.htpasswd, ==- 8 - Any clues? Thanks, Victor What are the perms inside the attachments directory? Matt P. --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Adding attachments doesn't work
Hi Matt, All permissions seem to be set properly as far as I can tell: ==- 8 - /srv/trac/project # ls -l total 44 -rw-r--r-- 1 wwwrun www 83 Feb 2 00:29 .htpasswd -rw-r--r-- 1 wwwrun www 41 Jan 17 22:02 .htpasswd.copy -rw-r--r-- 1 wwwrun www 98 Jan 17 15:47 README -rw-r--r-- 1 wwwrun www 27 Jan 17 15:47 VERSION drwxr-xr-x 2 wwwrun www 4096 Feb 4 10:35 attachments drwxr-xr-x 2 wwwrun www 4096 Feb 4 10:03 conf drwxr-xr-x 2 wwwrun www 4096 Feb 4 01:25 db drwxr-xr-x 2 wwwrun www 4096 Jan 18 01:08 htdocs drwxr-xr-x 2 wwwrun www 4096 Jan 17 22:11 log drwxr-xr-x 2 wwwrun www 4096 Jan 17 15:47 plugins drwxr-xr-x 2 wwwrun www 4096 Jan 17 15:47 templates /srv/trac/project # ==- 8 - tracd is running under wwwrun: ==- 8 - wwwrun 26174 0.0 0.9 230576 36008 ?SJan18 8:03 /usr/bin/python /usr/bin/tracd -d --port 8000 -e /srv/trac --basic-auth=*,/srv/trac/project/.htpasswd, ==- 8 - Any clues? Thanks, Victor What are the perms inside the attachments directory? It's empty, so it's up to tracd (under wwwrun) to create anything in there. Should there be any special directory structure under attachments? Thanks, Victor --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Custom formatting for custom ticket field?
I just tried that and it works. Except if I return formatted text that includes say wiki formatting, it's displayed as plain text, so my concept won't work I think. On Feb 4, 11:06 am, Flatfender flatfen...@gmail.com wrote: On Wed, Feb 4, 2009 at 10:42 AM, Stodge sto...@gmail.com wrote: Oh yes, ucm.pyc isn't created so my macro isn't being executed. Try putting your ucm.py in the plugins folder for your trac instance --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Adding attachments doesn't work
What are the perms inside the attachments directory? Which version of Python are you (is he) using? I had to downgrade to 2.5 in order to get them to work. 2.6 broke something in HTTP handling. -- Gary Chambers /* Nothing fancy and nothing Microsoft! */ --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Insert the ticket owner in the subject of notification
On Tue, Feb 3, 2009 at 11:49 AM, Mihamina Rakotomandimby miham...@lab.vectoris.fr wrote: Hi, In the notification's subject, there is already: - ticket id - ticket summary I would like to add the ticket owner (at the time of notifying). What file should I hack in order to do so? I use Trac 0.11. Thank you. Try adding $ticket.owner to the ticket_subject_template line in trac.ini Matt P. --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Adding attachments doesn't work
Hi Gary, What are the perms inside the attachments directory? Which version of Python are you (is he) using? I had to downgrade to 2.5 in order to get them to work. 2.6 broke something in HTTP handling. 2.6 it is. I'll try downgrading to 2.5 later tonight and report back if it makes a difference. Thanks! Victor --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: looking for SQL for canned report All Tickets By Milestone (Including closed)
Use this, actually this is one of my most usefull report SELECT t.milestone AS __group__, id AS ticket, summary, status, priority, resolution, version, t.type AS type, owner, changetime AS modified, time AS _reported, reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE EXISTS(SELECT 1 FROM permission where username=$USER and action='root') and status'closed' ORDER BY (milestone IS NULL), milestone DESC, priority Enjoy -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of EddieO Sent: Tuesday, February 03, 2009 6:14 PM To: Trac Users Subject: [Trac] looking for SQL for canned report All Tickets By Milestone (Including closed) I just modified this report and screwed it up, and didn't keep the raw SQL beforehand. Does anyone have the SQL for this report? Thanks, EddieO --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Interception of notification workflow
Hi, I would like to do some additional actions on top of email notification for every creation/update of the ticket? How can I intercept the workflow in this case? For example, I want to trigger a program (not necessary python code). Please guide me. TIA, Dave --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Custom formatting for custom ticket field?
Got it: out = StringIO() Formatter(self.env, context).format(content, out) return Markup(out.getvalue()) On Feb 4, 11:18 am, Stodge sto...@gmail.com wrote: I just tried that and it works. Except if I return formatted text that includes say wiki formatting, it's displayed as plain text, so my concept won't work I think. On Feb 4, 11:06 am, Flatfender flatfen...@gmail.com wrote: On Wed, Feb 4, 2009 at 10:42 AM, Stodge sto...@gmail.com wrote: Oh yes, ucm.pyc isn't created so my macro isn't being executed. Try putting your ucm.py in the plugins folder for your trac instance --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Adding attachments doesn't work
Victor Star wrote: 2.6 it is. I'll try downgrading to 2.5 later tonight and report back if it makes a difference. 2.6 support is already added to 0.11-stable, and should be released shortly (about mid-February) in 0.11.3. -- Remy signature.asc Description: OpenPGP digital signature
[Trac] Re: Adding attachments doesn't work
Victor Star wrote: 2.6 it is. I'll try downgrading to 2.5 later tonight and report back if it makes a difference. 2.6 support is already added to 0.11-stable, and should be released shortly (about mid-February) in 0.11.3. Oh, that's a good news then! Thanks for the info Remy! --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Viewing Visio files in Trac
I'd like to link to (or better, embed) Visio files in a Trac wiki page. Is there a way to do that? -- Christopher Nelson ___ SIXNET - Innovative. Open. Industrial Data Products. 331 Ushers Road, Ballston Lake, NY 12065 Phone: +1(518)877-5173, Facsimile: +1(518)877-8346 E-mail: mailto:chr...@sixnetio.com Get product details at http://www.sixnetio.com --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Viewing Visio files in Trac
On 2009-02-04 14:37, Chris Nelson wrote: I'd like to link to (or better, embed) Visio files in a Trac wiki page. Is there a way to do that? Try the DiaVisPlugin. (I've tested only with Dia files, but it seems to support Visio as well. On a side note: You really should give Dia a try — it is a great free software Visio replacement for Linux and Windows.) --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Viewing Visio files in Trac
W. Martin Borgert wrote: On 2009-02-04 14:37, Chris Nelson wrote: I'd like to link to (or better, embed) Visio files in a Trac wiki page. Is there a way to do that? Try the DiaVisPlugin. (I've tested only with Dia files, but it seems to support Visio as well. On a side note: You really should give Dia a try - it is a great free software Visio replacement for Linux and Windows.) Oh, I love Dia but not everyone here is that progressive. ;-) --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: looking for SQL for canned report All Tickets By Milestone (Including closed)
Thanks! On Feb 4, 7:44 am, Jorge Churio jorge.chu...@cheffsolutions.com wrote: Use this, actually this is one of my most usefull report SELECT t.milestone AS __group__, id AS ticket, summary, status, priority, resolution, version, t.type AS type, owner, changetime AS modified, time AS _reported, reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE EXISTS(SELECT 1 FROM permission where username=$USER and action='root') and status'closed' ORDER BY (milestone IS NULL), milestone DESC, priority Enjoy -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of EddieO Sent: Tuesday, February 03, 2009 6:14 PM To: Trac Users Subject: [Trac] looking for SQL for canned report All Tickets By Milestone (Including closed) I just modified this report and screwed it up, and didn't keep the raw SQL beforehand. Does anyone have the SQL for this report? Thanks, EddieO --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Multiple projects and permissions
On Wed, Feb 4, 2009 at 9:50 AM, Flatfender flatfen...@gmail.com wrote: On Tue, Feb 3, 2009 at 5:58 PM, cambo_frog cambo_f...@yahoo.com wrote: Hi All, Hello ... I cannot add permissions to the trac projects parent directory (E:/ trac-projects). No ... I guess that's because the parent directory doesn't contain a trac environment, ;) but is there any way of adding permissions to all projects under TracEnvParentDir (E:/trac-projects) or do all permissions have to be set per project? Directly, well ... no. The idea that comes into my mind is as follows : - You should be using MS AD (isn't it ? ...) if so group the users (I am not very sure about how ... but anyway ... I think MS AD should provide a way -I insist I don't know it so ... research- some kind of user interface or alike ... ;) in as many groups as you need ... - Configure Trac so as to integrate user login with MS AD (nowadays I do it using Apache mod_ldap + mod_authz_ldap ... ;) - There is a plugin for Trac to use MSAD (i.e. LDAP ;) groups as if they were regular groups ... Install it ... - For better maintainance and low admin effort and synchronization ... share the plugins dir (... see option in trac.ini ;) so that information about groups be available at creation time ... - The only thing that's missing in all this reasoning is how to share group permissions (... I mean, the mapping from groups to Trac actions e.g. @admin - TRAC_ADMIN ;) ... but perhaps (... research ;) you could employ some kind of Authz permission system so that you can specify your policy and store such permissions in a file (... or anything you can share between projects ... ) ... and if the same file (or sequivalent ...) is specified as a config option, well, then you are actually sharing your permissions policy with (... in theory ...) low maintainance effort. Anyway ... these are only ideas ... you should research and be aware about the details ... and I could be wrong at some point ... these are nothing but suggestions ... I have never done something like this before ... but anyway ... Pls let us know about your research ... this is an interesting and useful use case ... ;) Not that I'm aware of Trac-Admin needs an environment passed to it, you could probably right a script that wraps your environments in a loop and iterate through them. Ummm ... maybe a lot of maintainance ... effort and perhaps errors ... IMO ... besides a lot of duplicated data (i.e. permissions ) ... :( But anyway ... its just a hint ... ;) -- Regards, Olemis. Blog ES: http://simelo-es.blogspot.com/ Blog EN: http://simelo-en.blogspot.com/ Featured article: --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Weekly notification
On Tue, Feb 3, 2009 at 4:32 PM, dreker davidre...@gmail.com wrote: Hi, I was wondering of there was an add-on or plugin where I could send a notification at the end of the week to all employees notifying them which tickets were not resolved. I saw your TracNotification page, but did not seem to resolve this question. Muchly appreciated. David Not that I know of, but this could be accomplished with a simple script. If you wanted to you could run it as a cron job to do it automatically at the end of the week. I have something similar going. --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Insert the ticket owner in the subject of notification
On Wed, Feb 4, 2009 at 10:28 AM, Mihamina Rakotomandimby (R12y) miham...@lab.vectoris.fr wrote: Flatfender wrote: I would like to add the ticket owner (at the time of notifying). What file should I hack in order to do so? Try adding $ticket.owner to the ticket_subject_template line in trac.ini I finally found: subject = self.ticket['owner']+' '+self.format_subj(summary) in trac/ticket/notification.py Then restart Apache The restart is mandatory... Or you could just use flatfender's suggestion and use the ticket_subject_template option. This is exactly what it's for. No code modifications necessary. --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Interception of notification workflow
On Wed, Feb 4, 2009 at 4:40 AM, Dave McCoy its...@gmail.com wrote: Hi, I would like to do some additional actions on top of email notification for every creation/update of the ticket? How can I intercept the workflow in this case? For example, I want to trigger a program (not necessary python code). Please guide me. TIA, Dave ITicketChangeListener: http://trac.edgewall.org/browser/trunk/trac/ticket/api.py#L112 --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Multiple projects and permissions
On Tue, Feb 3, 2009 at 5:58 PM, cambo_frog cambo_f...@yahoo.com wrote: Hi All, I am new to trac and svn, but have both setup and working OK with Apache. I have Apache setup on Windows XP to use multiple projects( trac environments) using the following in httpd.conf: snip I can add a permission for a single project, e.g. trac-admin E:/trac-projects/trac-test permission add admin TRAC_ADMIN I cannot add permissions to the trac projects parent directory (E:/ trac-projects). I guess that's because the parent directory doesn't contain a trac environment, but is there any way of adding permissions to all projects under TracEnvParentDir (E:/trac-projects) or do all permissions have to be set per project? Thanks in advance for your help. How about for /D %p in (e:\trac-projects\*) do @trac-admin %p permission add admin TRAC_ADMIN? --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Interception of notification workflow
Thanks Erik. Should I write my code directly inside this api.py? Dave On Feb 5, 7:27 am, Erik Bray hyugaricd...@gmail.com wrote: On Wed, Feb 4, 2009 at 4:40 AM, Dave McCoy its...@gmail.com wrote: Hi, I would like to do some additional actions on top of email notification for every creation/update of the ticket? How can I intercept the workflow in this case? For example, I want to trigger a program (not necessary python code). Please guide me. TIA, Dave ITicketChangeListener:http://trac.edgewall.org/browser/trunk/trac/ticket/api.py#L112 --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] What plugin(s) does Trac-Hacks use for blogging?
Anyone know what plugin(s) trac-hack.org uses for blogging? Unless I am blind (and I may very well be) the ieat one's own dog food/i section on the trac-hack.org front page does not denote how the blogging is achieved (within Trac). Cheers, Rob --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: What plugin(s) does Trac-Hacks use for blogging?
Hi. Anyone know what plugin(s) trac-hack.org uses for blogging? Yes, currently that is [1]. When we switch to Trac 0.11, however, that will change to [2]. Unless I am blind (and I may very well be) the ieat one's own dog food/i section on the trac-hack.org front page does not denote how the blogging is achieved (within Trac). True, that section needs to be updated. Some of the plugins mentioned there are no longer in use, but others have been added and are not mentioned. That will be fixed soon. Bye, Mike [1] http://trac-hacks.org/wiki/TracBlogPlugin [2] http://trac-hacks.org/wiki/FullBlogPlugin --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Adding attachments doesn't work
2.6 it is. I'll try downgrading to 2.5 later tonight and report back if it makes a difference. 2.6 support is already added to 0.11-stable, and should be released shortly (about mid-February) in 0.11.3. I've installed it from 0.11-stable and it worked! Now I have attachments! First I tried installing python 2.5 without deleting 2.6 (opensuse has tons of stuff dependent on it...) Spent few hours but couldn't make it all work. But thanks to you it all seems to work now. Thanks for your help! Victor --~--~-~--~~~---~--~~ 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 trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---