[Trac] creating a TRAC ticket via direct POST
I'd like to be able to use the TRAC posting functionality via php, in order to create a ticket from a php script and also benefit from the TRAC internals. So I assume that sending a correctly formatted POST request to the http: server might be what I want, but I'm not sure..authentication is an issue of course and the __FORM_TOKEN may be as well. Is it possible to do what I want this way, or is there an easier way? Thanks Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@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.
RE: [Trac] Re: creating a TRAC ticket via direct POST
Is there an example of how to construct the XML request for the ticket.create function? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of osimons Sent: Monday, June 14, 2010 1:42 PM To: Trac Users Subject: [Trac] Re: creating a TRAC ticket via direct POST On Jun 14, 8:22 pm, Dan Winslow dwins...@aiminstitute.org wrote: I'd like to be able to use the TRAC posting functionality via php, in order to create a ticket from a php script and also benefit from the TRAC internals. So I assume that sending a correctly formatted POST request to the http: server might be what I want, but I'm not sure..authentication is an issue of course and the __FORM_TOKEN may be as well. Is it possible to do what I want this way, or is there an easier way? http://trac-hacks.org/wiki/XmlRpcPlugin :::simon https://www.coderesort.com http://www.ohloh.net/accounts/osimons -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@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. -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@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] Getting userid in Wiki
How can I get the current userid in a wiki page? Is there a macro or built in function that does this? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@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.
RE: [Trac] Re: Inserting HTML from arbitrary URL into a wiki page
Yes, I enabled render_unsafe_html. We don't have an external TRAC, so I'm less concerned about attacks than I probably should be. I am using php ( CodeIgniter ) to render chunks of page contents without the page headers, and it seems to work well. For instance, emitting a table by itself works well without page header etc. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Hal Sent: Thursday, June 10, 2010 9:58 AM To: Trac Users Subject: [Trac] Re: Inserting HTML from arbitrary URL into a wiki page On Jun 9, 11:35 am, Noah Kantrowitz n...@coderanger.net wrote: The Include macro does this, with the appropriate flags set. Disclaimer: May cause security holes and CSRF/XSS attacks. --Noah Dan, FWIW, depending on your need, you may need to modify the include macro. I fought with it a bit this last weekend. There is no way to say get me the content (body) of the HTML page at , so you only get to render the entire page, including head / section. Since html / is not considered safe by Genshi, the net effect is nothing is rendered. (It might be if you enable render_unsafe_html, but I that is not something I've explored) There are a number of patches posted to address the issue, if your needs aren't met out-of-the-box. --Hal -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@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. -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@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] Inserting HTML from arbitrary URL into a wiki page
Is there a way to include the html output from an arbitrary external URL into a wiki page? Like Image(), but handling HTML. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@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] Report special columns
Where can I find documentation about what the 'magic column names' are for TRAC? I don't mean the main Wiki page for TracReports, as that just mentions them and does not define them. It does talk about special formatting for a few of them, but doesn't seem to mention all of them. For instance, 'report' seems to be one but as far as I can tell it's not documented anywhere. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@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.
RE: [Trac] embedding a report call in a report
No answers? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Tuesday, June 01, 2010 3:38 PM To: trac-users@googlegroups.com Subject: [Trac] embedding a report call in a report Is it possible to embed a call to another report in a report column? Similar to the way that TRAC handles the id #. I tried emitting a HTML link as the content of the field but it just printed out as text. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@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. -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@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.
RE: [Trac] Access the SQLite database outside Trac
I just use the sqlite3 command line interface to do small work, and for larger things I use the PHP PDO package to access the db. Sqlite has programming interfaces for a number of common languages. It's true that intensive work will intermittently lock the db for others, as sqlite3 uses file locking to ensure integrity, but it's very easy to write your code so that the lock is only for a short time. The usual way of dealing with a db lock is to merely retry the operation. You do not have to leave the db to unlock it, just have the select or update or whatever transaction you are in end. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Scott Mead Sent: Sunday, January 10, 2010 10:16 AM To: trac-users@googlegroups.com Subject: Re: [Trac] Access the SQLite database outside Trac On Sun, Jan 10, 2010 at 2:59 PM, pederalm peder@eis.semcon.com wrote: I'm used to MySQL. With MySQL (like many db engines) you can access the db outside the server where the db engine is installed using a db client and a SQL command. I want to access the SQLite db in that way, but I don't know if it works. Does it? Or is there any other way to access the db? Or do I have to change the Trac db engine to MySQL? You can do that, BUT if you are doing writes to the database, nobody else can read from it at the same time. So your trac and reporting program will 'bump' into each other. If you have the ability to switch to mysql or postgresql and you think it's worth the effort, I'd personally say go for it. It will make things much easier if you're going to be doing a lot of data-intensive work. --Scott -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@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] $USER in query
Hi Folks. Using TRAC 0.11, I am trying to run the following query : SELECT id AS ticket, summary, priority, severity, status, type as __group__, owner, date(time,unixepoch) as 'Created', date(changetime,unixepoch) as 'Modified', reporter, (case when c.value is NULL then '' else c.value end) as 'estimate', (case when c3.value is NULL then '' else c3.value end) as 'actual', (case when c1.value is NULL then '' when c1.value = 'click to set date' then '' else c1.value end) as 'date desired', (case when c2.value is NULL then '' when c2.value = 'click to set date' then '' else c2.value end) as 'date due' FROM ticket t LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = 'estimate_hours') LEFT OUTER JOIN ticket_custom c1 ON (t.id = c1.ticket AND c1.name = 'date_desired') LEFT OUTER JOIN ticket_custom c2 ON (t.id = c2.ticket AND c2.name = 'date_due') LEFT OUTER JOIN ticket_custom c3 ON (t.id = c3.ticket AND c3.name = 'actual_hours') WHERE owner = '$USER' and c2.value is not NULL and c2.value != 'click to set date' and strftime(%s,substr(c2.value,7,4) || - || substr(c2.value,1,2) || - || substr(c2.value,4,2)) strftime('%s','now') and t.status != 'closed' and t.status != 'completed' and type not in ( 'Collaboration Ticket', 'Information Request' ) ORDER BY lower(type),t.changetime desc When doing so, I get : Report execution failed: not enough arguments for format string I can use '$USER' successfully in simpler queries ( select * from tickets where owner='$USER' ), but not in more complex ones. Any suggestions? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: $USER in query
Well, I ran into another ticket that said that the % in the strftime call needed to be 'escaped' with another %. Seems to have fixed it...needless to say pretty opaque and strange error. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Thursday, August 27, 2009 7:47 AM To: trac-users@googlegroups.com Subject: [Trac] $USER in query Hi Folks. Using TRAC 0.11, I am trying to run the following query : SELECT id AS ticket, summary, priority, severity, status, type as __group__, owner, date(time,unixepoch) as 'Created', date(changetime,unixepoch) as 'Modified', reporter, (case when c.value is NULL then '' else c.value end) as 'estimate', (case when c3.value is NULL then '' else c3.value end) as 'actual', (case when c1.value is NULL then '' when c1.value = 'click to set date' then '' else c1.value end) as 'date desired', (case when c2.value is NULL then '' when c2.value = 'click to set date' then '' else c2.value end) as 'date due' FROM ticket t LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = 'estimate_hours') LEFT OUTER JOIN ticket_custom c1 ON (t.id = c1.ticket AND c1.name = 'date_desired') LEFT OUTER JOIN ticket_custom c2 ON (t.id = c2.ticket AND c2.name = 'date_due') LEFT OUTER JOIN ticket_custom c3 ON (t.id = c3.ticket AND c3.name = 'actual_hours') WHERE owner = '$USER' and c2.value is not NULL and c2.value != 'click to set date' and strftime(%s,substr(c2.value,7,4) || - || substr(c2.value,1,2) || - || substr(c2.value,4,2)) strftime('%s','now') and t.status != 'closed' and t.status != 'completed' and type not in ( 'Collaboration Ticket', 'Information Request' ) ORDER BY lower(type),t.changetime desc When doing so, I get : Report execution failed: not enough arguments for format string I can use '$USER' successfully in simpler queries ( select * from tickets where owner='$USER' ), but not in more complex ones. Any suggestions? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: [agilo] trac-admin deploy doesn't work
Delete '/tmp/deploy1/htdocs/agilo'? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Christian Unger Sent: Thursday, July 16, 2009 10:31 AM To: Trac Users Subject: [Trac] [agilo] trac-admin deploy doesn't work in an attempt to make my slw trac faster, I tried to gather the static resources with the trac-admin deploy command - to no avail. it errors out with the following traceback: agilo.utils.web_ui.CoreTemplateProvider /Library/Python/2.5/site-packages/agilo-0.8.0_RC1_r1707_20090712-py2.5.e gg/agilo/htdocs agilo.ticket.web_ui.AgiloTicketModule /Library/Python/2.5/site-packages/agilo-0.8.0_RC1_r1707_20090712-py2.5.e gg/agilo/ticket/htdocs Traceback (most recent call last): File /usr/local/bin/trac-admin, line 8, in module load_entry_point('Trac==0.11.4', 'console_scripts', 'trac-admin')() File /Library/Python/2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/admin/cons ole.py, line 1317, in run return admin.onecmd(command) File /Library/Python/2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/admin/cons ole.py, line 133, in onecmd rv = cmd.Cmd.onecmd(self, line) or 0 File /System/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/ cmd.py, line 219, in onecmd return func(arg) File /Library/Python/2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/admin/cons ole.py, line 1245, in do_deploy copytree(source, dest) File /Library/Python/2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/admin/cons ole.py, line 97, in copytree copytree_rec(str_path(src), str_path(dst)) File /Library/Python/2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/admin/cons ole.py, line 67, in copytree_rec os.mkdir(dst) OSError: [Errno 17] File exists: '/tmp/deploy1/htdocs/agilo' any ideas anyone? __ cu christian unger --~--~-~--~~~---~--~~ 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: New ticket field should be 'Set Owner', not 'Assign to'
You can rename fields using one of the plugins...blackmagic I think. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of RJOllos Sent: Wednesday, July 15, 2009 3:07 PM To: Trac Users Subject: [Trac] Re: New ticket field should be 'Set Owner', not 'Assign to' It looks like I can rename the 'Assign to' field by changing line 1093 (Trac 0.11.4) in /trac/ticket/web_ui.py [1]. 1092: if not ticket.exists: 1093:field['label'] = 'Assign to' 1094:if 'TICKET_MODIFY' in req.perm(ticket.resource): Is this the 'proper' way to modify the field, or is there a better way? Looking at the BlackMagicTicketTweaksPlugin [2] hints at a better way, but it seems like it should be unnecessary to install a plug-in for such a simple change. The downside I see is the need to preserve this change through Trac upgrades. [1] http://trac.edgewall.org/browser/tags/trac-0.11.4/trac/ticket/web_ui.py [2] http://trac-hacks.org/wiki/BlackMagicTicketTweaksPlugin - Ryan On Jul 13, 1:19 pm, RJOllos ry...@physiosonics.com wrote: Hello, I was very confused that my tickets where not changing to the Status: assigned when I set the 'Assign to' field during ticket creation. I went off searching and found a nice explanation [1]. I thought I would pose the following question for comment before I went off and created a ticket: When a user is selected from the 'Assign to' field during ticket creation, the Owner of the ticket is changed, however the Status is not changed. Therefore, shouldn't this field be named 'Set Owner' or 'Owner:'? It is only setting the owner; it is not assigning the ticket. Renaming this field might reduce some of the confusion that I and others have experienced. Is there a way I could rename the field for my trac instance? [1]http://groups.google.com/group/trac-users/browse_thread/thread/fe7770... - Ryan --~--~-~--~~~---~--~~ 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: Test Ticket Generation
You could just do a bunch of SQL inserts into the ticket table. The only other table I know of to worry about is the ticket_custom table, which holds ticket custom field values, but if you are just testing you may not care about custom fields. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Steve Sent: Wednesday, July 08, 2009 6:01 AM To: Trac Users Subject: [Trac] Test Ticket Generation Hi, I have set up a trial TRAC server and would like to play around with some of the available plugins. Before I do this, however, I need to populate my project's database with suitable test tickets that I can use for queries and reports. Are there any tools available to automatically generate test data for such a scenario as doing it by hand looks like it will be too time consuming? Kind regards, Steve --~--~-~--~~~---~--~~ 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: Trac web login does not allow different users from the same computer
You have to clear cookies. From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Paul Malmsten Sent: Thursday, July 02, 2009 3:56 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Trac web login does not allow different users from the same computer Hi there, How are you authenticating your users? I imagine you're using basic authentication? If that's the case, then try closing and re-opening your browser before trying to log in as a different user. That usually clears the current session. Unfortunately, I'm not aware of any way to directly 'log out' of a basic authentication session; it's a very limited system. Good luck, ~Paul Malmsten On Thu, Jul 2, 2009 at 1:40 PM, Anu Ramachandra a...@molecularimprints.com wrote: Hello, I have set up trac 0.10.5 with subversion. For web access (I have set it up as a virtual host on our server), the login works as follows - I login as user A Logout Next time I click login, it automatically logs me in as A ie no password. It does not allow me to log in as user B We need to be able to login as different users when we open bugs in trac from our tools. What is the setup for that? Thanks! Anu --~--~-~--~~~---~--~~ 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: Query options of a custom field
Right, they are in the trac.ini file. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of yoheeb Sent: Wednesday, July 01, 2009 2:13 PM To: Trac Users Subject: [Trac] Re: Query options of a custom field On Jul 1, 1:21 pm, RJOllos ry...@physiosonics.com wrote: It sounds to me like the values for custom fields of a ticket are stored in the ticket_custom table, but not the available options for a custom field. Where are the possible values for the custom field stored? On Jun 30, 5:00 am, Dan Winslow dwins...@aiminstitute.org wrote: The custom values are stored in the ticket_custom table. The columns are ticket, name, and value. Ticket holds the ticket id, name holds the field name, and value holds the field value. It's quite a cumbersome way to do things but it works. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of RJOllos Sent: Monday, June 29, 2009 7:51 PM To: Trac Users Subject: [Trac] Query options of a custom field Hi, I would like to list the options of a custom field in a wiki page. Using the WikiTable macro [1] I've been able to do this for fields of a ticket that have their own table or exist in a table of the database, such as component and resolution. SELECT name, description FROM component ORDER BY name SELECT name FROM enum WHERE type = 'resolution' However, I don't understand from looking at the database schema [2] if/ where the options of a custom field or stored, though I think that I understand that the actual value of a custom field is stored in the database rather than a key. [1]http://trac-hacks.org/wiki/WikiTableMacro [2]http://trac.edgewall.org/wiki/TracDev/DatabaseSchema Thanks! the possible options of custom fields (I am assuming a select type here) are stored in the .ini file. my guess is the only off the shelf option you'll find, and I have never used this, so I can't verify is the http://trac-hacks.org/wiki/IniGetMacro in theory, something like this [[IniGet(CustomFieldA.options)]] probably in a table or something: ||'''Custom Field Name'''||'''Possible Values'''|| ||CustomFieldA|| [[IniGet(CustomFieldA.options)]] || ||CustomFieldX|| [[IniGet(CustomFieldX.options)]] || I also expect it will be ugly with a response like 100|200|300|400| 500 so you might want to augment this macro to split on the | and format the result string. Again, assuming it works. --~--~-~--~~~---~--~~ 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: Show all states the ticket has gone through
One of the nice ( but not easy ) things about SQLITE is that you can always write your own user function ( in C or C++ ) to make custom SQL-callable functions. You do not have to recompile or modify SQLITE itself but you do have to write your own function in a dynamically loaded library. In MySQL I think they have stored procedure support now, and so you could write a SQL procedure that would accomplish your concatenation. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of RJOllos Sent: Thursday, June 25, 2009 8:28 PM To: Trac Users Subject: [Trac] Re: Show all states the ticket has gone through I remember that comment as well. I want to say that the comment was that the group_concat method needs to be replaced by some other method that is supported by sqlite, however the only thread I could find was this user with a similar problem, http://groups.google.com/group/trac-users/browse_thread/thread/882029b8268f59be/d73c2b5699491fa8?lnk=gstq=group_concat#d73c2b5699491fa8 On Jun 24, 3:13 pm, yoheeb yoh...@gmail.com wrote: On Jun 24, 5:11 pm, yoheeb yoh...@gmail.com wrote: On Jun 23, 1:58 am, Sneha sneha.shet...@gmail.com wrote: Hi All, I want to create a report to display all states a ticket has gone through. Ex: Ticket 1 | new - assigned - closed - reopened - assigned I tried using following query to generate the result: select ticket,group_concat(newvalue) from ticket_change where field='status' It is working fine if directly executed on db, but when I added this in Trac reports, its showing no such function: group_concat error. Is there any other way to get the all states of a ticket? Thanks in advance. -Sneha hmm, I would think you could do this with a custom sql report, on the ticket_change table. newvalue where ticket=N and field=status that's not the actual sql, but those are the tables and field names. where N is the ticket # you are inquiring about. now, you'd need some kind of concatenation or something if you wanted something like a list like. since I am an sql nit-wit...I have no idea how you would get something like: ticket|states 2 assigned,closed 3 assigned,accepted,new,closed . wow, looking at it, I somehow missed your comment about already trying that...sorry, must have more coffee. There was a comment in this group about theconcatmethod recently, might be worth a search. --~--~-~--~~~---~--~~ 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: re-ordering reports and queries
The reports are already listed in their own table. If we could embed a sql statement somewhere to generate the displayed list of reports, then we could have control over how it looks. Actually, you probably can already do this by providing your own renderer for this admin panel, but I would have to go digging to find it. I'm no TRAC expert. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of kurgbe Sent: Friday, June 26, 2009 3:30 AM To: Trac Users Subject: [Trac] Re: re-ordering reports and queries I have the same problem: I want to put some logical order in my long list of reports. It would be nice if the reports had a property Display Order that could be changed in the edit screen of a report. Meanwhile, I will investigate the database schema to see how to change the order by editing the tables. On Jun 2, 1:31 pm, Christian Unger christian.un...@mac.com wrote: so we have added and deleted reports over time. and I want to put them in a certain order. every report obviosuly got it's own report ID now some queries show this id under e.g. report=7 if I change this to a different number I get presented withan error like so: Error: When specified, the report number should be 29. even when earlier slots like 9,10,11 and so on are free trac tries to append the new report at the end of the report list rather than inserting it in the free slot which I specified in the query. What gives? __ cu christian unger --~--~-~--~~~---~--~~ 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: reports available
One thing that comes to mind immediately is that you could add some indexes. Not sure what the default indexing is like on mysql but if it's like it is on SQLITE it could use some tweaking. The time killer in this query is probably all the full table scans of the ticket_change table. I would think a join might help out speed-wise, as it could throw out all the rows that don't match the ticket. Or even just a single ( select * from ticket_change tc where t.id=tc.id ) subselect and pull the columns from there instead of re-scanning the whole table for each separate column you want to build. Just some suggestions, I'm not a SQL expert. I know you asked for the actual SQL statement, but I don't have your data and I don't run on mysql. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Lukasz Szybalski Sent: Thursday, June 25, 2009 12:06 PM To: trac-users@googlegroups.com Subject: [Trac] reports available Hello, http://trac.edgewall.org/ticket/8354 I've opened a ticket to add more management reports to trac. We have a high value of tasks that is being tracked so reports listed in above ticket are crucial. Here is one I need help optimizing(500 tickets a day, 4000 in 8 days since we started) My Recently closed tickets. Is there a way to optimized it better in mysql? Can somebody run this in mysql query browser and see if you can modify it to run faster? I'm looking for actual final sql statement for mysql. Thanks, Lucas select id, summary, component, milestone, owner , (select tc.author from ticket_change tc where t.id = tc.ticket and field = 'status' and newvalue = 'closed' order by tc.time DESC limit 1) as ModifiedBy, (TIME(FROM_UNIXTIME((select MAX(tc.time) from ticket_change tc where t.id = tc.ticket and field = 'status' and newvalue = 'closed' as closetime, (DATE(FROM_UNIXTIME((select MAX(tc.time) from ticket_change tc where t.id = tc.ticket and field = 'status' and newvalue = 'closed' as closedate from ticket t where t.status = 'closed' and (select tc.author from ticket_change tc where t.id = tc.ticket and field = 'status' and newvalue = 'closed' order by tc.time DESC limit 1) = '$USER' and (select MAX(tc.time) from ticket_change tc where t.id = tc.ticket and field = 'status' and newvalue = 'closed') UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY) order by closedate DESC,closetime DESC -- Using rsync. How to setup rsyncd. http://lucasmanual.com/mywiki/rsync DataHub - create a package that gets, parses, loads, visualizes data http://lucasmanual.com/mywiki/DataHub --~--~-~--~~~---~--~~ 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: Show Closed Tickets from a certain date
Use the View Tickets menu. You will see a 'create report' option. If you want to edit an existing report, select it for viewing. If you have admin rights you will see a 'edit report' button. Both create and edit options give you an edit box you can type in. The SQL itself is stored in the 'report' database table. You can use the date-time functions in SQL to limit the selection date based on the database columns 'time' and/or 'changetime'. From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Alejandro Mussi Sent: Wednesday, June 24, 2009 3:21 AM To: trac-users@googlegroups.com Subject: [Trac] Re: Show Closed Tickets from a certain date Thanks Vela, i have installed the plug-in, but it seems it only add a due date when creating a new ticket (which it is good), but what i really need is to change some reports in order to get a list of closed tickets from a specific date. Where is hosted the reports files which their sql??, i would like to add some reports but i do not where to put the sql query. Thanks On Mon, Jun 22, 2009 at 7:07 AM, velappan velappan velapp...@gmail.com wrote: Hi Alex, This thing you can attain by using this plugin http://trac-hacks.org/wiki/DateFieldPlugin. With basic options in trac you can see the reports based on the date. Regards Vela.Velappan On Jun 19, 11:30 pm, Alex M alemu...@gmail.com wrote: Hi all, I would like to see closed tickets from a specific date. How can I add this report to the existing ones? Thanks -- - Alejandro Mussi Campos Cervera --~--~-~--~~~---~--~~ 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: change user email notification
I believe inserts into the session and session_attribute table will do the trick. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Alex Sent: Tuesday, June 23, 2009 1:08 PM To: Trac Users Subject: [Trac] change user email notification Hi ! How can I edit user email with trac-admin utility or manually in sqlite database without edit preferences-email address? --~--~-~--~~~---~--~~ 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: accessing ticket fields
Thanks, that works. Say, is there anything resembling internal system documentation for TRAC? -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Erik Bray Sent: Thursday, June 18, 2009 6:02 PM To: trac-users@googlegroups.com Subject: [Trac] Re: accessing ticket fields On Thu, Jun 18, 2009 at 11:01 AM, Dan Winslowdwins...@aiminstitute.org wrote: In plugin code, I am trying to access the value of the 'owner' field. Can anyone guide me on how to do this? My latest attempt is from trac.ticket.model import Ticket ... try: tkt = Ticket(self.env, res.id) except TracError: return None # Ticket doesn't exist disabled = True which almost worksexcept at runtime it says that 'NameError: global name 'res' is not defined'. The 'res' is not currently passed into the method I am in ( def filter_stream(self, req, method, filename, stream, data): ). If there's a better way, in code, to obtain the value of the current ticket 'owner', please let me know. Ah...after a close look, this provides just enough context (more than your previous post) to divine what you're trying to do. Assuming that you're filtering on the ticket page (filename=='ticket.html') you want data['ticket']. --~--~-~--~~~---~--~~ 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: Concatenate multiple row data into single row
Right, this would need an aggregate function of some kind, probably flavor dependent, or possibly a stored procedure using procedural SQL. Sqlite has one, I forget the name currently...and also with sqlite you can always write your own in C if you so desire :) -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Chris Peterson Sent: Thursday, June 18, 2009 6:06 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Concatenate multiple row data into single row Actually a join would not help here, from what I have looked at, you would need to use a stored procedure to create this type of result, or use some oracle-only function to do that =) Chris On 6/18/09 6:45 PM, Erik Bray hyugaricd...@gmail.com wrote: On Thu, Jun 18, 2009 at 2:06 AM, rishikeshrishimishra1...@gmail.com wrote: I have a sub-query which selects some rows from a table. I want to concatenate these rows in a single row. Example: Column1 Row1 Row2 Row3 Row4 I want this result as: Column1 Row1Row2Row3Row4 Looking for a solution with Single query Well, your example is too abstract to provide an actual query, but you would have to use JOINs to do this. --~--~-~--~~~---~--~~ 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] Accessing permissions
In plugin code, I am trying to access the permissions associated with the current user (req.authname). I am trying to check whether or not the person viewing the current page (the ticket page) has a specific permission. Can anyone guide me on how to do this? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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] Limiting fields to owner only
I have seen several people, including myself, asking if it were possible to limit the ticket properties fields to owner or admin only. Here's how I did it, using the blackmagictweaks plugin. In the source file blackmagic.py ( lines I added are marked as #NEW: def filter_stream(self, req, method, filename, stream, data): if filename == ticket.html: tkt=data['ticket'] #NEW owner=tkt['owner'] #NEW status=tkt['status'] #NEW user=req.authname #NEW self.env.log.info(user %s owner %s status %s % (user,owner,status)) #NEW enchants = self.config.get('blackmagic', 'tweaks', '') for field in (x.strip() for x in enchants.split(',')): disabled = False hidden = False perm = self.config.get('blackmagic', '%s.permission' % field, '').upper() if perm and perm not in req.perm: denial = self.config.get('blackmagic', '%s.ondenial' % field, None) if denial: if denial == disable: disabled = True elif denial == hide: hidden = True else: disabled = True else: disabled = True if owner != user and not 'TRAC_ADMIN' in req.perm: #NEW disabled=True #NEW This is a very simplistic method, but effective. It will cause any field listed in the tweaks config line to be disabled except when being viewed by the owner or by the admin. It is very easy to set up conditional based on status, like so : statuslist = self.config.get('blackmagic', '%s.owner_only' % field, '') self.env.log.info( checking %s.owner_only for status %s % (field,status)) for statusfield in (sf.strip() for sf in statuslist.split(',')): self.env.log.info(statusfield %s % (statusfield)) if status == statusfield: self.env.log.info(found matching status %s % (statusfield)) if owner != user and not 'TRAC_ADMIN' in req.perm: self.env.log.info( disabling field %s % (field)) disabled=True which would read a line like this in the [blackmagic] section: estimate_hours.owner_only = accepted, assigned, Assigned_Costing, closed, completed, inforequested, Needs Costing, Needs Review, new, onhold, reviewed, started, tested and disable the field based on the workflow status. Other combinations are possible as well, but I decided to go the simple route for now. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: [task] Locking Ticket # while working on it?
... that should be enough. Should be enough for whom? Depending on people to behave correctly when using information systems often causes problems. I don't know of any simple database-based way given the architecture...db level locking is problematic in a web environment, and SQLITE anyways uses file-level update locking. My approach is to block anyone who is not the owner (or TRAC_ADMIN) from doing most operations on a ticket. You can use the VirtualTicketsPermissions plugin to restrict your choice of workflow operations to owner only. That does not block folks from changing ticket properties, however, and so I looking at some other plugins for that. I am hoping that blackmagictweaks can do that, although I know I will have to modify it as it does not pay attention to owner and current user relationship. The concept of permissions, workflow, and command dependence on Owner == Current User is a basic ticket system concept and is missing from TRAC core, as far as I can tell. I'm hoping it gets included in the next versions. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Tomek Grzechowski [k3o] Sent: Wednesday, June 17, 2009 4:34 PM To: trac-users@googlegroups.com Subject: [Trac] Re: [task] Locking Ticket # while working on it? yeah, a person can accept a ticket and the ticket will have its status changed to assigned. another person should not work on a ticket that has status eq assigned. that should be enough. 2009/6/17 Lukasz Szybalski szybal...@gmail.com: Hello, We have setup our trac to monitor our high volume of tasks(500 a day). We've put in out task in milestone categories. Now we have 2 or 3 people that are working on particular milestone and tasks in it. While one opened the ticket, and is working on it (average 3 minutes) another person pulls the same report and starts working on the same ticket. Is there a solutions that would lock the ticket or notify another user that somebody is working on this ticket(preferred)? Thanks, Lucas -- Tomek Grzechowski - mini...@k3o; developer/programmer; http://k3o.eu miniman@gmail.com; +48 662 279 869 (cell) skype: miniman.k3o --~--~-~--~~~---~--~~ 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] accessing ticket fields
In plugin code, I am trying to access the value of the 'owner' field. Can anyone guide me on how to do this? My latest attempt is from trac.ticket.model import Ticket ... try: tkt = Ticket(self.env, res.id) except TracError: return None # Ticket doesn't exist disabled = True which almost worksexcept at runtime it says that 'NameError: global name 'res' is not defined'. The 'res' is not currently passed into the method I am in ( def filter_stream(self, req, method, filename, stream, data): ). If there's a better way, in code, to obtain the value of the current ticket 'owner', please let me know. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: Does Trac really work on Windows
Except for the one from Yoheeb... yes, it does. You have already decided in your mind, that since it's not on Linux, it must be crap. You also decided to substituted a bunch of non- supported components, that probably should work, and decided since it doesn't, it's crap. in other words, you did this: So, I put this brand new Ford engine in my old Chevy, and would you believe, the parts didn't just FIT out of the box, and it had this requirement for some-sort of on-board computer my old Chevy didn't have. boy, Ford makes crappy engines. Cuz, I'm a great mechanic, and if I can't make it work with the stuff I have in my garage, it just isn't worth nuttin. Kind of uncalled for, imho. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Chris Mulligan Sent: Thursday, June 18, 2009 9:51 AM To: trac-users@googlegroups.com Subject: [Trac] Re: Does Trac really work on Windows You asked for support with a non-supported configuration. I'm the last person to defend most mailing lists, but I think you actually got a lot of useful advice and people acted in a reasonable manner given your initial tone and knowing disregard of what is expected to work. On Thu, Jun 18, 2009 at 8:46 AM, Nelson, Cynthia L.cynthia.nel...@thermofisher.com wrote: I mean both. Our company was wanting us to use the VisualSVN server and and VisualSVN Client and Tortoise for the folks using Microsoft. I was able to get VisualSVN, Visual SVN client and Tortoise working rather quickly. The problem occurred when I tried to interface with Trac. I got a persistent error that svn module could not be found. I did not make this choice. The company I work for asked me to to it this way and try to get it to work. I got a lot of rude and flaming hate mail from this group. Basically accusing me of being an idiot for wanting to use VisualSVN. It was not my choice. I would have used a Linux platform if left up to me. My boss has now told me to use Linux for now on the server side for now. Cindy -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Wednesday, June 17, 2009 6:15 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Does Trac really work on Windows When you say visualsvn do you mean the server or the client? --Noah -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of cindy Sent: Wednesday, June 17, 2009 7:10 AM To: Trac Users Subject: [Trac] Re: Does Trac really work on Windows Thanks for sharing your configuration. I am in a rather difficult situation. I have been asked to use a configuration which I do not believe will work. VisualSVN, the latest release of python and Trac and a Postgres database. I am going to try your configuration and see what happens. The only problem is I have to use an XP machine instead of a server. Thanks. Cindy On Jun 16, 10:34 pm, David Headley raider...@gmail.com wrote: I just got Trac running on Windows and it works great. Here is my setup: Trac 0.11.4 SVN 1.5.6 (r36142) Python 2.5.4 Apache 2.2.11 Windows Small Business Server 2008 I use the mod_wsgi module, and used the instructions here:http://trac.edgewall.org/wiki/TracModWSGI #1: It definitely works on Windows. #2: Trac log is in your Trac environment directory under the log folder. But trac.ini in the conf folder needs to be set to FILE: [logging] log_file = trac.log log_level = DEBUG log_type = file Info on logging is here:http://trac.edgewall.org/wiki/TracIni#logging-section On Tue, Jun 16, 2009 at 6:22 PM, Noah Kantrowitz n...@coderanger.netwrote: Strike that: http://subversion.tigris.org/servlets/ProjectDocumentList?folderID=81. .. ndFolder=8100folderID=91http://subversion.tigris.org/servlets/Projec t DocumentList?folderID=81...has some built for 2.6. Newer version of SVN too. --Noah -Original Message- From: trac-users@googlegroups.com [mailto:trac- us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Tuesday, June 16, 2009 4:17 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Does Trac really work on Windows PySVN is not the same thing as the SVN SWIG bindings. You find the correct bindings at http://subversion.tigris.org/servlets/ProjectDocumentList?folderID=91 but I don't see any built for Python 2.6. You can either try to build them yourself, or switch to 2.5. --Noah -Original Message- From: trac-users@googlegroups.com [mailto:trac- us...@googlegroups.com] On Behalf Of cindy Sent: Tuesday, June 16, 2009 10:56 AM To: Trac Users Subject: [Trac] Does Trac really work on Windows OK so I am trying to install svn and trac on the same windows machine per my boss's wishes.
[Trac] Re: Does Trac really work on Windows
True enough...lets call it 'unfriendly mail' :) -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Jennifer A. Drummond Sent: Thursday, June 18, 2009 10:23 AM To: trac-users@googlegroups.com Subject: [Trac] Re: Does Trac really work on Windows But also not exactly hate mail. On Thu, Jun 18, 2009 at 10:05:40AM -0500, Dan Winslow wrote: Except for the one from Yoheeb... yes, it does. You have already decided in your mind, that since it's not on Linux, it must be crap. You also decided to substituted a bunch of non- supported components, that probably should work, and decided since it doesn't, it's crap. in other words, you did this: So, I put this brand new Ford engine in my old Chevy, and would you believe, the parts didn't just FIT out of the box, and it had this requirement for some-sort of on-board computer my old Chevy didn't have. boy, Ford makes crappy engines. Cuz, I'm a great mechanic, and if I can't make it work with the stuff I have in my garage, it just isn't worth nuttin. Kind of uncalled for, imho. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Chris Mulligan Sent: Thursday, June 18, 2009 9:51 AM To: trac-users@googlegroups.com Subject: [Trac] Re: Does Trac really work on Windows You asked for support with a non-supported configuration. I'm the last person to defend most mailing lists, but I think you actually got a lot of useful advice and people acted in a reasonable manner given your initial tone and knowing disregard of what is expected to work. On Thu, Jun 18, 2009 at 8:46 AM, Nelson, Cynthia L.cynthia.nel...@thermofisher.com wrote: I mean both. Our company was wanting us to use the VisualSVN server and and VisualSVN Client and Tortoise for the folks using Microsoft. I was able to get VisualSVN, Visual SVN client and Tortoise working rather quickly. The problem occurred when I tried to interface with Trac. I got a persistent error that svn module could not be found. I did not make this choice. The company I work for asked me to to it this way and try to get it to work. I got a lot of rude and flaming hate mail from this group. Basically accusing me of being an idiot for wanting to use VisualSVN. It was not my choice. I would have used a Linux platform if left up to me. My boss has now told me to use Linux for now on the server side for now. Cindy -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Wednesday, June 17, 2009 6:15 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Does Trac really work on Windows When you say visualsvn do you mean the server or the client? --Noah -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of cindy Sent: Wednesday, June 17, 2009 7:10 AM To: Trac Users Subject: [Trac] Re: Does Trac really work on Windows Thanks for sharing your configuration. I am in a rather difficult situation. I have been asked to use a configuration which I do not believe will work. VisualSVN, the latest release of python and Trac and a Postgres database. I am going to try your configuration and see what happens. ?The only problem is I have to use an XP machine instead of a server. Thanks. Cindy On Jun 16, 10:34 pm, David Headley raider...@gmail.com wrote: I just got Trac running on Windows and it works great. ?Here is my setup: ?Trac 0.11.4 ?SVN 1.5.6 (r36142) ?Python 2.5.4 ?Apache 2.2.11 ?Windows Small Business Server 2008 I use the mod_wsgi module, and used the instructions here:http://trac.edgewall.org/wiki/TracModWSGI #1: It definitely works on Windows. #2: Trac log is in your Trac environment directory under the log folder. But trac.ini in the conf folder needs to be set to FILE: [logging] log_file = trac.log log_level = DEBUG log_type = file Info on logging is here:http://trac.edgewall.org/wiki/TracIni#logging-section On Tue, Jun 16, 2009 at 6:22 PM, Noah Kantrowitz n...@coderanger.netwrote: Strike that: http://subversion.tigris.org/servlets/ProjectDocumentList?folderID=81.. .. ndFolder=8100folderID=91http://subversion.tigris.org/servlets/Projec t DocumentList?folderID=81...has some built for 2.6. Newer version of SVN too. --Noah -Original Message- From: trac-users@googlegroups.com [mailto:trac- us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Tuesday, June 16, 2009 4:17 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Does Trac really work on Windows PySVN is not the same thing as the SVN SWIG bindings. You find the correct bindings at http://subversion.tigris.org/servlets/ProjectDocumentList
[Trac] Bad report
I have a report that was saved with an error in the sql such that running the report produces a python error. Since selecting the report causes an unavoidable run ( and subsequent error ), I am unable to get to the 'edit report' button. Is there a way I can delete or edit that report without it trying to be run first? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: Bad report
Hmm, I'm on 0.11. Doesn't seem to be fixed. I'll check ticket thanks. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Jennifer A. Drummond Sent: Thursday, June 18, 2009 11:10 AM To: trac-users@googlegroups.com Subject: [Trac] Re: Bad report On Thu, Jun 18, 2009 at 10:58:40AM -0500, Dan Winslow wrote: I have a report that was saved with an error in the sql such that running the report produces a python error. Since selecting the report causes an unavoidable run ( and subsequent error ), I am unable to get to the 'edit report' button. Is there a way I can delete or edit that report without it trying to be run first? Yes, this one's a major bummer. Are you still on 0.10.4? The ticket on t.e.o. says this is actually fixed in 0.11; but there are also some good workarounds mentioned. http://trac.edgewall.org/ticket/7354 =-=- Jenn Drummond // j...@rice.edu Project Developer, Connexions Project (cnx.org) Rice University --~--~-~--~~~---~--~~ 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] Bounces?
I'm getting... Your message did not reach some or all of the intended recipients. Subject: [Trac] Re: Bad report Sent: 6/18/2009 11:22 AM The following recipient(s) could not be reached: McClean, Paul (GE Infra, Energy) on 6/18/2009 11:25 AM The message could not be delivered because the recipient's mailbox is full. BUDMLVEM08.e2k.ad.ge.com #5.2.2 Is this a list feature? Can we turn off bouncebacks? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: accessing ticket fields
I don't know...would it? I'll try it. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Chris Heller Sent: Thursday, June 18, 2009 3:02 PM To: trac-users@googlegroups.com Subject: [Trac] Re: accessing ticket fields Wouldn't that be 'req' that you want? On Thu, Jun 18, 2009 at 8:01 AM, Dan Winslowdwins...@aiminstitute.org wrote: In plugin code, I am trying to access the value of the 'owner' field. Can anyone guide me on how to do this? My latest attempt is from trac.ticket.model import Ticket ... try: tkt = Ticket(self.env, res.id) except TracError: return None # Ticket doesn't exist disabled = True which almost worksexcept at runtime it says that 'NameError: global name 'res' is not defined'. The 'res' is not currently passed into the method I am in ( def filter_stream(self, req, method, filename, stream, data): ). If there's a better way, in code, to obtain the value of the current ticket 'owner', please let me know. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: access to the ticket array
... Ok, I am trying to access the ticket[] elements. How might I do that? From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Tuesday, June 16, 2009 4:04 PM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array Please ask questions about what you actually trying to _do_, not specific implementation details. --Noah From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Tuesday, June 16, 2009 1:52 PM To: trac-users@googlegroups.com Subject: [Trac] access to the ticket array I am in some plugin source, and I would like to access the ticket[] array. It's not available in the class I am in : class TicketTweaks(Component): implements(ITemplateStreamFilter, ITemplateProvider, IPermissionRequestor) I am guessing because it does not do some of this ( from another plugin ) from trac.core import * from trac.ticket import ITicketManipulator from trac.ticket import TicketSystem class RequiredFieldValidator(Component): Basic ticket validator for required fields implements(ITicketManipulator) I guess this because the ticket[] array *is* visible in the second plugin. Can I just add the import for trac.ticket.TicketSystem? Or must I also implement the ITicketManipulator interface? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: Printing out request
Sounds good...not quite sure what you mean by and then include param debug=true in URL (disregarding the URL you 'r accessing ;) though. If I disregard the URL I'm accessing then where do I put the debug=true? Also, I did install the plugin and I get this : Oops... Trac detected an internal error: IndexError: list index out of range Python Traceback {{{ Traceback (most recent call last): File /usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/main.py, line 435, in _dispatch_request dispatcher.dispatch(req) File /usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/main.py, line 227, in dispatch data, content_type) File /usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/chrome.py, line 742, in render_template stream.render(method, doctype=doctype, out=buffer) File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/core.py, line 179, in render File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/output.py, line 61, in encode File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/output.py, line 311, in __call__ File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/output.py, line 753, in __call__ File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/output.py, line 592, in __call__ File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/output.py, line 698, in __call__ File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/output.py, line 532, in __call__ File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/core.py, line 283, in _ensure File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/core.py, line 283, in _ensure File /usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/chrome.py, line 807, in _strip_accesskeys for kind, data, pos in stream: File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/core.py, line 283, in _ensure File /usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/chrome.py, line 796, in _generate for kind, data, pos in stream: File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/core.py, line 283, in _ensure File /usr/lib/python2.4/site-packages/Genshi-0.5.1-py2.4-linux-i686.egg/genshi/core.py, line 283, in _ensure File build/bdist.linux-i686/egg/tracdeveloper/log.py, line 64, in fn IndexError: list index out of range }}} a new ticket at the Trac project site, where you can describe the problem and explain how to reproduce it. TracDeveloper plugin and then include param debug=true in URL (disregarding the URL you 'r accessing ;) and you'll get back lots of debug info instead of page contents . You'll see req structure inside rendering context and many other useful things too ;) That plugin's great ! -- Regards, Olemis. Blog ES: http://simelo-es.blogspot.com/ Blog EN: http://simelo-en.blogspot.com/ Featured article: Lo que es tuyo, mío y de todos ... La polémica de los datos - http://feedproxy.google.com/~r/simelo-es/~3/uewBy5tX6wg/lo-que-es-tuyo-mio-y-de-todos-la.html --~--~-~--~~~---~--~~ 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: access to the ticket array
I suspect that the ticket{} elements are present in the req, too, but as I can't see the structure of req I don't know. From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Wednesday, June 17, 2009 7:31 AM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array ... Ok, I am trying to access the ticket[] elements. How might I do that? From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Tuesday, June 16, 2009 4:04 PM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array Please ask questions about what you actually trying to _do_, not specific implementation details. --Noah From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Tuesday, June 16, 2009 1:52 PM To: trac-users@googlegroups.com Subject: [Trac] access to the ticket array I am in some plugin source, and I would like to access the ticket[] array. It's not available in the class I am in : class TicketTweaks(Component): implements(ITemplateStreamFilter, ITemplateProvider, IPermissionRequestor) I am guessing because it does not do some of this ( from another plugin ) from trac.core import * from trac.ticket import ITicketManipulator from trac.ticket import TicketSystem class RequiredFieldValidator(Component): Basic ticket validator for required fields implements(ITicketManipulator) I guess this because the ticket[] array *is* visible in the second plugin. Can I just add the import for trac.ticket.TicketSystem? Or must I also implement the ITicketManipulator interface? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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] action.permissions
If I list more than one permission on a workflow spec, such as Someoperation.permissions = TICKET_VIEW,TICKET_IS_OWNER Does that mean they are *both* required, or just that any one of them is? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: access to the ticket array
Noah, I'm sorry but I don't understand what you are getting at in this case. You ask me what I am trying to do, and I say 'I am trying to get access to the elements of the ticket'. You say 'Yes, but what are you trying to do?' This confuses me. So, I don't know what to say. I suppose I could tell you exactly what ticket field I happen to interested in, and why, but my question is really just generally how to access any fields of the ticket. If you don't know, or if my question doesn't make sense, then just say so. For instance, you could say 'well, there's no such thing as a 'ticket' per se, so if you tell me what field you want I can tell you where it is in the ever-mysterious req structure', or something along those lines, rather than ' .. what are you trying to _do_'. Anyways, I can't really help asking about implementation details because, in fact, implementation details are exactly what I want. I want to get a hold of the values of the ticket, and for that I need implementation details. Like this, for instance : try: tkt = Ticket(self.env, res.id) except TracError: return None # Ticket doesn't exist Ah! There's a ticket constructor in the trac.ticket.model stuff. Wonderful. I even asked about that import in my first post. Which (I think) is exactly what I need, and I found it after having spent about 5 hours today, which I couldn't afford, roaming around inside the implementation details of several plugins. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Wednesday, June 17, 2009 11:47 AM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array You are still asking about implementation details. What are you trying to _do_. --Noah On Jun 17, 2009, at 8:14 AM, Dan Winslow wrote: I suspect that the ticket{} elements are present in the req, too, but as I can't see the structure of req I don't know. From: trac-users@googlegroups.com [mailto:trac- us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Wednesday, June 17, 2009 7:31 AM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array ... Ok, I am trying to access the ticket[] elements. How might I do that? From: trac-users@googlegroups.com [mailto:trac- us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Tuesday, June 16, 2009 4:04 PM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array Please ask questions about what you actually trying to _do_, not specific implementation details. --Noah From: trac-users@googlegroups.com [mailto:trac- us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Tuesday, June 16, 2009 1:52 PM To: trac-users@googlegroups.com Subject: [Trac] access to the ticket array I am in some plugin source, and I would like to access the ticket[] array. It's not available in the class I am in : class TicketTweaks(Component): implements(ITemplateStreamFilter, ITemplateProvider, IPermissionRequestor) I am guessing because it does not do some of this ( from another plugin ) from trac.core import * from trac.ticket import ITicketManipulator from trac.ticket import TicketSystem class RequiredFieldValidator(Component): Basic ticket validator for required fields implements(ITicketManipulator) I guess this because the ticket[] array *is* visible in the second plugin. Can I just add the import for trac.ticket.TicketSystem? Or must I also implement the ITicketManipulator interface? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: access to the ticket array
Yes, I can see that, now you mention it. I had assumed this was a developer/coder list...when actually it's named 'trac-users'. Is there a more targeted list for developers? -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Wednesday, June 17, 2009 12:57 PM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array You asked specifically about how to access some ticket array (still not sure what you meant by that) and about the fields on a req. If you had asked How do I access the fields of a ticket from code? someone would have been able to give you an answer almost instantly. The difference is subtle, but important. --Noah -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Wednesday, June 17, 2009 10:27 AM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array Noah, I'm sorry but I don't understand what you are getting at in this case. You ask me what I am trying to do, and I say 'I am trying to get access to the elements of the ticket'. You say 'Yes, but what are you trying to do?' This confuses me. So, I don't know what to say. I suppose I could tell you exactly what ticket field I happen to interested in, and why, but my question is really just generally how to access any fields of the ticket. If you don't know, or if my question doesn't make sense, then just say so. For instance, you could say 'well, there's no such thing as a 'ticket' per se, so if you tell me what field you want I can tell you where it is in the ever-mysterious req structure', or something along those lines, rather than ' .. what are you trying to _do_'. Anyways, I can't really help asking about implementation details because, in fact, implementation details are exactly what I want. I want to get a hold of the values of the ticket, and for that I need implementation details. Like this, for instance : try: tkt = Ticket(self.env, res.id) except TracError: return None # Ticket doesn't exist Ah! There's a ticket constructor in the trac.ticket.model stuff. Wonderful. I even asked about that import in my first post. Which (I think) is exactly what I need, and I found it after having spent about 5 hours today, which I couldn't afford, roaming around inside the implementation details of several plugins. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Wednesday, June 17, 2009 11:47 AM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array You are still asking about implementation details. What are you trying to _do_. --Noah On Jun 17, 2009, at 8:14 AM, Dan Winslow wrote: I suspect that the ticket{} elements are present in the req, too, but as I can't see the structure of req I don't know. From: trac-users@googlegroups.com [mailto:trac- us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Wednesday, June 17, 2009 7:31 AM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array ... Ok, I am trying to access the ticket[] elements. How might I do that? From: trac-users@googlegroups.com [mailto:trac- us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Tuesday, June 16, 2009 4:04 PM To: trac-users@googlegroups.com Subject: [Trac] Re: access to the ticket array Please ask questions about what you actually trying to _do_, not specific implementation details. --Noah From: trac-users@googlegroups.com [mailto:trac- us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Tuesday, June 16, 2009 1:52 PM To: trac-users@googlegroups.com Subject: [Trac] access to the ticket array I am in some plugin source, and I would like to access the ticket[] array. It's not available in the class I am in : class TicketTweaks(Component): implements(ITemplateStreamFilter, ITemplateProvider, IPermissionRequestor) I am guessing because it does not do some of this ( from another plugin ) from trac.core import * from trac.ticket import ITicketManipulator from trac.ticket import TicketSystem class RequiredFieldValidator(Component): Basic ticket validator for required fields implements(ITicketManipulator) I guess this because the ticket[] array *is* visible in the second plugin. Can I just add the import for trac.ticket.TicketSystem? Or must I also implement the ITicketManipulator interface? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ You received this message because you
[Trac] Re: Controlling access to parts of a wiki and tickets
VirtualTickets allows you to restrict workflow actions based on whether the current user is the owner or reporter or on the CC list. It works well and is something badly needed...however, so far as I can tell it does not restrict form field visibility or enabled-ness. I am still looking for a way to mark fields visible or non-updateable based on whether the viewer is the owner/reporter. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of RJOllos Sent: Wednesday, June 17, 2009 2:12 PM To: Trac Users Subject: [Trac] Re: Controlling access to parts of a wiki and tickets I had also wanted to implement restricted access to the wiki pages, and the fine people at the hosting company I use (wush.net) pointed me here: http://trac.edgewall.org/wiki/TracFineGrainedPermissions, and to this plug-in: http://trac.edgewall.org/browser/branches/0.11-stable/sample-plugins/permissions/authz_policy.py On Jun 17, 1:23 am, David Brown da...@westcontrol.com wrote: Chris Heller wrote: There are two plugins on trac-hacks that will help you. The private wiki plugin and the private tickets plugin. Many thanks - these look like the plugins I'm looking for. I'm not sure how I missed them while looking through the lists of plugins (perhaps because there are so many!). The PrivateWiki plugin needs a patch to restrict anonymous access, as described in one of the bug tickets for the plugin. The patch is working fine, but I thought I'd mention it here in case anyone else is reading this. With the patch in place, this is working nicely. I see there is also a VirtualTicketPermissions plugin, which seems to do almost the same thing as PrivateTickets. Have you any ideas about the differences? mvh., David On Tue, Jun 16, 2009 at 7:51 AM, David Brownda...@westcontrol.com wrote: Is it possible to limit access to different parts of a wiki to different users (or groups of users)? What about tickets - can they be limited to different users? Ideally, I'd like general users to be able to create tickets and then view the ticket and its history, and also add comments to the ticket. But the general users could only view tickets that they create themselves - others would be invisible to them. Is something like that possible, or should I just re-think my requirements (such as perhaps setting up two separate trac environments)? mvh., David --~--~-~--~~~---~--~~ 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: Mandatory fields
' % field_name) # for field_name in required_fields # if self._is_empty(ticket[field_name])] return errors def _get_state(self, req, ticket): Get the state this ticket is going to be in. if 'action' not in req.args: return 'new' action = req.args['action'] action_changes = {} for controller in self._get_action_controllers(req, ticket, action): action_changes.update(controller.get_ticket_changes(req, ticket, action)) return 'status' in action_changes and action_changes['status'] or ticket['status'] def _get_action_controllers(self, req, ticket, action): for controller in TicketSystem(self.env).action_controllers: actions = [action for weight, action in controller.get_ticket_actions(req, ticket)] if action in actions: yield controller -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of yoheeb Sent: Tuesday, June 16, 2009 1:01 PM To: Trac Users Subject: [Trac] Re: Mandatory fields On Jun 10, 3:33 pm, Dan Winslow dwins...@aiminstitute.org wrote: You can use a couple different plugins. I wound up using TicketValidator plugin...although I had to modify it to do more than just check if the field was blank or not. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of John Andrunas Sent: Wednesday, June 10, 2009 3:22 PM To: trac-users@googlegroups.com Subject: [Trac] Mandatory fields Is there any way to make mandatory fields in trac? I don't seen any way but it seems like the kind of thing that would be in there. -- John Any chance you could post these modifications to the hack as an attachment or something similiar? --~--~-~--~~~---~--~~ 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] current user
Is the current user name available anywhere within the request structures or environment? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: Printing out request
I think I might need a clue to where in the source I can find the..class I suppose. Whatever it is in python. Or is it a map or dict type array? From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Tuesday, June 16, 2009 3:35 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Printing out request There are a lot. Might help to ask about what you are looking for. --Noah From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Tuesday, June 16, 2009 1:28 PM To: trac-users@googlegroups.com Subject: [Trac] Printing out request How can I print out all of the fields in the req structure? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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] Email locations
When people put their emails in via the preferences, where are these stored? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: Email locations
Thanks. And that is persistent? I.e., once they've done that it persists? Or does it disappear with the cookie? -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Greg Troxel Sent: Wednesday, June 10, 2009 8:51 AM To: trac-users@googlegroups.com Subject: [Trac] Re: Email locations When people put their emails in via the preferences, where are these stored? In the database: #!/bin/sh psql trac-foo -c select * from session_attribute where name='email' psql trac-foo -c select * from session_attribute where name='name' --~--~-~--~~~---~--~~ 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: Mandatory fields
You can use a couple different plugins. I wound up using TicketValidator plugin...although I had to modify it to do more than just check if the field was blank or not. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of John Andrunas Sent: Wednesday, June 10, 2009 3:22 PM To: trac-users@googlegroups.com Subject: [Trac] Mandatory fields Is there any way to make mandatory fields in trac? I don't seen any way but it seems like the kind of thing that would be in there. -- John --~--~-~--~~~---~--~~ 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: New custom fields and old tickets
You have to write SQL to update manually. The ticket_custom table ( I think that's what it's called ) has a ticket id, the name of the field, and the value of the field. You have to write insert statements, such as : insert into ticket_custom (ticket,name,value) values (x,y,z) where x is the ticket id, y is the name of the custom field, and z is the value of the field you want. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of zineb Sent: Tuesday, June 09, 2009 8:44 AM To: trac-users@googlegroups.com Subject: [Trac] Re: New custom fields and old tickets Hello, I know that it's a very old topic but i am currently having the same promblem and don't know how to update the tickets Please some help Zineb d...@vid seaward-2 wrote: On Nov 14, 2:47 pm, Erik Andersson kir...@gmail.com wrote: Hi It's not set for old tickets, but you can set it. Thanks Erik. I have updated http://trac.edgewall.org/wiki/TracTicketsCustomFields to reflect this. d...@vid -- View this message in context: http://www.nabble.com/New-custom-fields-and-old-tickets-tp13745894p23943 138.html Sent from the Trac Users mailing list archive at Nabble.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] TICKET_EDIT_CC
The TICKET_EDIT_CC and TICKET_EDIT_DESCRIPTION permission do not seem to work. Nothing shows up unless you also have TICKET_MODIFY, which renders everything editable, which I don't want. My goal is to allow the users to edit the desc and CC fields only ( after initial creation ). Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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] Python question
Can someone explain this construct to me? errors = [(field_name, '%s is required' % field_name) for field_name in required_fields if self._is_empty(ticket[field_name])] What does 'errors' contain? I can see that it's a list of some sort...but the parenthetical grouping in the first line looks like it is some kind of initializer for field_name...so what does it return? The contents of field_name? and how does the for loop work...what's the difference between the if returning false or true? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: Python question
Thanks, very much, I was having trouble finding it in Python docs. I didn't know what to call it! -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Emmanuel Blot Sent: Monday, June 08, 2009 12:04 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Python question Can someone explain this construct to me? You'd want to look for list comprehension documentation in Python The code snipped can be rewritten as: errors = [] for field_name in required_fields: if self._is_empty(ticket[field_name]): errors.append((field_name, '%s is required' % field_name)) errors = [(field_name, '%s is required' % field_name) for field_name in required_fields if self._is_empty(ticket[field_name])] --~--~-~--~~~---~--~~ 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: Python question
Although...this errors=[] errors.append(name,message) gives TypeError: append() takes exactly one argument (2 given -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Emmanuel Blot Sent: Monday, June 08, 2009 12:04 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Python question Can someone explain this construct to me? You'd want to look for list comprehension documentation in Python The code snipped can be rewritten as: errors = [] for field_name in required_fields: if self._is_empty(ticket[field_name]): errors.append((field_name, '%s is required' % field_name)) errors = [(field_name, '%s is required' % field_name) for field_name in required_fields if self._is_empty(ticket[field_name])] --~--~-~--~~~---~--~~ 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: Python question
Never mind, looks like I needed an internal paren, I guess to produce a 'tuple' errors=[] errors.append((name,message)) -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Monday, June 08, 2009 12:10 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Python question Although...this errors=[] errors.append(name,message) gives TypeError: append() takes exactly one argument (2 given -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Emmanuel Blot Sent: Monday, June 08, 2009 12:04 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Python question Can someone explain this construct to me? You'd want to look for list comprehension documentation in Python The code snipped can be rewritten as: errors = [] for field_name in required_fields: if self._is_empty(ticket[field_name]): errors.append((field_name, '%s is required' % field_name)) errors = [(field_name, '%s is required' % field_name) for field_name in required_fields if self._is_empty(ticket[field_name])] --~--~-~--~~~---~--~~ 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 fields
Are custom field values present in the the ticket[] list? If not is there a custom_ticket[]? Else where can I get the value of a custom field at ticket validation time. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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] Ticket print?
I did this and my trac process went crazy, endlessly dumping lines to log. for t in ticket: self.env.log.info(t) Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: Ticket print?
Well...I thought it might print out the contents of Ticket. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Olemis Lang Sent: Monday, June 08, 2009 1:36 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Ticket print? On Mon, Jun 8, 2009 at 1:31 PM, Dan Winslowdwins...@aiminstitute.org wrote: I did this and my trac process went crazy, endlessly dumping lines to log. for t in ticket: self.env.log.info(t) Wow ! What d'u wnat to do ? -- Regards, Olemis. Blog ES: http://simelo-es.blogspot.com/ Blog EN: http://simelo-en.blogspot.com/ Featured article: ¡ Bienvenido OpenSolaris 2009.06 ! - http://feedproxy.google.com/~r/simelo-es/~3/UY8IF3M3Alw/bienvenido-opensolaris-200906.html --~--~-~--~~~---~--~~ 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] CalendarpopupPlugin
Anyone have any idea how CalendarPopupPlugin is supposed to work? How do you get date popup fields configured? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: CalendarpopupPlugin
Never mind, figured it out. From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Monday, June 08, 2009 2:46 PM To: trac-users@googlegroups.com Subject: [Trac] CalendarpopupPlugin Anyone have any idea how CalendarPopupPlugin is supposed to work? How do you get date popup fields configured? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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 fields
Answer : Yes, they are in the ticket[] list. I was having trouble with something uppercasing the first character of the field name, causing the lookup to fail. From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Monday, June 08, 2009 1:22 PM To: trac-users@googlegroups.com Subject: [Trac] custom fields Are custom field values present in the the ticket[] list? If not is there a custom_ticket[]? Else where can I get the value of a custom field at ticket validation time. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: Ticket print?
It was in a validate_ticket callback in the ticketvalidator plugin. def validate_ticket(self, req, ticket): Make sure required fields for the next state have been the ticket will be in have been entered. state = self._get_state(req, ticket) for t in ticket: self.env.log.info(t) From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Monday, June 08, 2009 2:47 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Ticket print? You would have to be far more specific. Where is this? --Noah From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Monday, June 08, 2009 11:32 AM To: trac-users@googlegroups.com Subject: [Trac] Ticket print? I did this and my trac process went crazy, endlessly dumping lines to log. for t in ticket: self.env.log.info(t) Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: Ticket print?
Apparantly it means LOTS of iteration... If I had to guess I'd say that it wound up trying to iterate over the entire index range of the item...say from 0 to maxint or something like that. From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Monday, June 08, 2009 3:01 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Ticket print? ticket should be a ticket object, not sure that even supports iteration or what it would mean to do so. --Noah From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Monday, June 08, 2009 12:51 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Ticket print? It was in a validate_ticket callback in the ticketvalidator plugin. def validate_ticket(self, req, ticket): Make sure required fields for the next state have been the ticket will be in have been entered. state = self._get_state(req, ticket) for t in ticket: self.env.log.info(t) From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Noah Kantrowitz Sent: Monday, June 08, 2009 2:47 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Ticket print? You would have to be far more specific. Where is this? --Noah From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Dan Winslow Sent: Monday, June 08, 2009 11:32 AM To: trac-users@googlegroups.com Subject: [Trac] Ticket print? I did this and my trac process went crazy, endlessly dumping lines to log. for t in ticket: self.env.log.info(t) Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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] Hiding fields
Is it possible to hide fields based on the current state? Ie., to have a field not show up on the create form but be displayed in later states? Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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] error validating fields
I am attempting to modify some plugin code, despite my lack of python knowledge. I wanted to add type checking to the validator plugin, and so I added the modified the function. With a trac.ini entry of [fieldscheck] int_fields=Hours and running this code : def validate_ticket(self, req, ticket): Make sure required fields for the next state have been the ticket will be in have been entered. state = self._get_state(req, ticket) editcheck_fields = self.config.getlist('fieldscheck','int_fields') errors = [(field_name, '%s must be an integer' % field_name) for field_name in editcheck_fields if self._is_not_integer(ticket[field_name])] required_fields = self.config.getlist('ticketvalidator', state + '.required') errors = errors + [(field_name, '%s is required' % field_name) for field_name in required_fields if self._is_empty(ticket[field_name])] return errors I get : TypeError: cannot concatenate 'str' and 'list' objects On the line : if self._is_not_integer(ticket[field_name])] I get the feeling this is just a python problem of mine and not something intrinsic to TRAC, but I thought I'd ask you guys anyways. Thanks in advance. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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: Trac Recipies
So do I. Track hacks is a OK place to get plugins from, but not information on how to do things. In general there is a crippling lack of information all across the web about TRAC. I have spent two weeks trying to understand various aspects of TRAC, and I am just now starting to get a vague idea. I am not a python programmer, nor do I have any wish to become one. All of the documentation I can find about a specific subject is usually only a few terse sentences, maybe a *very* short example, and then they all trail off with ' .. and of course, you can always write a plugin to do anything more.'. I don't want to write plug-ins. I don't want to have to read through bunch of alien-looking code to try and figure out what it means. I'm not faulting the developers in particular, they've done a fine job and it's a huge amount of work to maintain decent docs. I was so frustrated that I tried to get management to let me write my own system, but they declined. I think a collection point for trac recipies would be a greta idea. From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Ariel Balter Sent: Wednesday, June 03, 2009 12:59 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Trac Recipies I disagree. Noah Kantrowitz wrote: Trac-hacks is that site. --Noah -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of abalter Sent: Wednesday, June 03, 2009 10:52 AM To: Trac Users Subject: [Trac] Trac Recipies I would like to help put together a site of recipes for using Trac. There is a ton of great information in this email list and forums and out there on the web. I think it would be great to take a sort of best of of the actual solutions and organize them into a set of recipes such as You want to do XXX...Do this:. Not surprisingly, I thing the best way to build this recipe book is with a Trac site. The first thing I would need would be a place to host it. Perhaps the folks that run Trac-hacks would be willing to give me some space. Or, perhaps edgewall.com. I'm open to suggestions. I'd love to hear feedback on this idea. Thanks, Ariel -- /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\ Ariel I Balter, Ph.D. Postdoc Biological Monitoring/Modeling Fundamental and Computational Sciences Directorate Pacific Northwest National Laboratory Mail: PO Box 999, MS P7-58,Richland, WA 99352 Shipping: 790 6th Street, MS P7-58, Richland, WA 99354 Tel: 509-376-7605 Cell: 509-713-0087 ariel.bal...@pnl.gov www.arielbalter.com www.pnl.gov --~--~-~--~~~---~--~~ 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: Trac Recipies
One thing I especially had trouble with was understanding what the workflow specification in the trac.ini was. I kept thinking that the values in there referred to some kind of internal call or constructs, when in reality they really are just abstract names that can be made up at will. (I did finally notice two lines in the wiki page about workflow that said as much ). In general, if I had been aware of the way that the Python config reader works, I probably would have come to that conclusion much sooner. Being totally ignorant of python, I had no idea what to expect and everything looked like code to me at that point. So, some topic suggestions would be : 1. Detailed explanantions about workflow and how to set it up to meet various 'best-of' practices. Now that I have some idea of what I am doing I am setting one up for us to use, and I'd be happy to post an annotated copy of it somewhere. Here's some things I'd still like to know about (thread hijack warning): 1. How to validate fields pre-commit and block the commit with a fail warning. I know about the ticketvalidator plugin but so far it doesn't seem to work, and even if it did it doesn't seem to be able to validate field content, just whether or not it has something in it. What we need is either way more field types or a validation callout of some sort that we can hook to. A SQL query tag comes to mind. 2. How to restrict fields from display/and or edit based on some condition. This might be able to be done via a user-specifiable SQL query tag on the field returning true or false. The query gets run, if its true the field gets displayed, if its false it doesn't. Or something like that. 3. How to modify workflow to select different states depending on condition. Again, if I could specify a query that returned the status I wanted, instead of having to specify it by name in the workflow, things would be a lot more flexible. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Lance Hendrix Sent: Wednesday, June 03, 2009 1:28 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Trac Recipies In line with your note, perhaps you could suggest a few items (or a few topics) that you especially feel would be important/critical/useful to develop (what were you unable to find documentation about). IMHO one of the biggest issues facing the adoption of OSS is the lack of documentation and as a result one of my major objectives to support the OSS effort is to attempt to provide or at least assist with the development of (I am capable of at generating content quickly, I'll let someone else be the judge of it's usefulness) documentation; however, in order to be most useful, I think the effort should be driven by the community (as to what to develop). In short, while you could develop the documentation yourself (as has been suggested), there is also the option of assisting or collaborating with someone (me?) to help improve the documentation. Anyone else with any documentation requests would also be welcome. (I know, be careful what you wish for...) Lance Dan Winslow wrote: So do I. Track hacks is a OK place to get plugins from, but not information on how to do things. In general there is a crippling lack of information all across the web about TRAC. I have spent two weeks trying to understand various aspects of TRAC, and I am just now starting to get a vague idea. I am not a python programmer, nor do I have any wish to become one. All of the documentation I can find about a specific subject is usually only a few terse sentences, maybe a **very** short example, and then they all trail off with ' .. and of course, you can always write a plugin to do anything more.'. I don't want to write plug-ins. I don't want to have to read through bunch of alien-looking code to try and figure out what it means. I'm not faulting the developers in particular, they've done a fine job and it's a huge amount of work to maintain decent docs. I was so frustrated that I tried to get management to let me write my own system, but they declined. I think a collection point for trac recipies would be a greta idea. *From:* trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] *On Behalf Of *Ariel Balter *Sent:* Wednesday, June 03, 2009 12:59 PM *To:* trac-users@googlegroups.com *Subject:* [Trac] Re: Trac Recipies I disagree. Noah Kantrowitz wrote: Trac-hacks is that site. --Noah -Original Message- From: trac-users@googlegroups.com mailto:trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of abalter Sent: Wednesday, June 03, 2009 10:52 AM To: Trac Users Subject: [Trac] Trac Recipies I would like to help put together a site of recipes for using Trac. There is a ton of great information in this email list and forums and out
[Trac] Re: Trac Recipies
Lance, that seems like a good place to start, but I am not familiar with the trac wiki situation...are you suggesting we enter tickets, or are we supposed to edit the wiki page directly? If we are supposed to enter tickets, I am not sure exactly how that would equate to actual documentation. Or are you suggesting that we use the tickets to specify what we'd like to see? And then we write documentation somewhere? Or somebody does? The whole thing seems to remain slightly opaque to me..its probably due to my own ignorance of course, but there you have it. -Original Message- From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Remy Blank Sent: Wednesday, June 03, 2009 2:30 PM To: trac-users@googlegroups.com Subject: [Trac] Re: Trac Recipies Lance Hendrix wrote: In line with your note, perhaps you could suggest a few items (or a few topics) that you especially feel would be important/critical/useful to develop (what were you unable to find documentation about). I have started a page to collect documentation topics: http://trac.edgewall.org/wiki/SeaChange/DocumentationRequests one of my major objectives to support the OSS effort is to attempt to provide or at least assist with the development of (I am capable of at generating content quickly, I'll let someone else be the judge of it's usefulness) documentation; We seem to have at least two people who are willing to spend some time writing documentation for Trac. So here's your chance: add relevant topics to the page above, vote for the topics you would find most useful, and maybe, just maybe, this could be the starting point of a vastly improved Trac documentation! -- 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] Trac field workflow validation
I want to be able to control validation of fields on certain actions. For instance, I want to block changing the status to Closed if a certain field has not been filled out. So, two questions : 1. Is this possible within the current Trac 0.11, and if so, how. 2. Can it be done with custom fields? 3. Has anyone considered a general purpose mechanism to apply constraints to workflow, in the following manner : a. Add the ability to specify a SQL query to an action, such that when the action is fired, the query is run. b. If the query returns a single column of boolean false, the action is blocked with a validation error. If it returns anything else, it proceeds. This would allow a very easy way to specify a workflow section setting that could be customized for any condition. Example : resolve = in_QA - closed resolve.operations = set_resolution resolve.permissions = TICKET_MODIFY resolve.validate = select 1=0 from tickets where somefield 0; Obviously thats not a real example but you get the idea. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---