[Trac] Re: Fields customization and progrmatically assign to
On Aug 20, 1:41 pm, Andres Chaves anchav...@gmail.com wrote: Hi, I have been using trac since 2 years and right now I have this two requirements over the system: 1. Based on the ticket type chosen show/hide or add some fields 2. Based on the ticket type and component and current tickets of the engineers calculate the assign to field For item 1, I'd suggest looking at the TracTicketChainedFieldsPlugin (1). There are other plug-ins that might accomplish this as well. You might look at the TicketSubmitPolicyPlugin (2). Could you clarify what you want for item 2? - Ryan (1) http://trac-hacks.org/wiki/TracTicketChainedFieldsPlugin (2) http://trac-hacks.org/wiki/TicketSubmitPolicyPlugin --~--~-~--~~~---~--~~ 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] Installation Question
I am new to track and need to know if there are issues installing on a Windows 2003 Server that is running SQL2005 (MSDE), Quickbook, and ACT? Thank you in advance for the response. --~--~-~--~~~---~--~~ 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 - User Access restriction
Hi, We have added few components to the components list(ticket), We have few external clients,we want them (users) to create/modify/view tickets. In this scenario we want access restriction for the clients based on the components. Please give me an immense solution for this. Thanks, Ramesh V --~--~-~--~~~---~--~~ 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 - User Access restriction
Please give me an immense solution for this. Please: do not cross-post to several mailing lists at once. Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Bulk edit / sql update queries
Hey Don, You won't be able to execute SQL UPDATEs from the web interface. If you want to execute that SQL you'll need to use an external database client. Alternatively you could try installing http://trac-hacks.org/wiki/BatchModifyPlugin -- it might also do what you need (but without any SQL). egj On Thu, Aug 20, 2009 at 4:34 PM, Dondon...@verizon.net wrote: Sorry if this is a newbie question, didn't see it in the help faq. I'm trying to do a bulk update like update ticket set owner='joe' where owner='shmoe'; But I'm not sure where to run that from. When I try to enter it in a custom query, I'm getting an error because it is trying to get a count from the query results, as in: select count(*) from (update ticket set owner=...) thanks, - Don --~--~-~--~~~---~--~~ 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: Firefox Plugin for Trac
Just a thought, but why not have a second copy of firefox open, rather than tabbed-browsing, and minimizes as needed for screenies. There is also a handy plugin on the Hacks site to attach an image as part of the initial ticket creation. Although an app that has a hot-key mapped, takes a screen shot, prompts for summary and descritpion, connects to trac via xmlrpc, creates a ticket, and adds the attachment...and makes coffee would be cool. that last part would be an optional enhancment of course :D I just need the coffee part, really no need for screenshots for our particular work, since there is no screen --~--~-~--~~~---~--~~ 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 - User Access restriction
On Aug 21, 8:59 am, ramesh. saadhvi ramesh.saad...@gmail.com wrote: Hi, We have added few components to the components list(ticket), We have few external clients,we want them (users) to create/modify/view tickets. In this scenario we want access restriction for the clients based on the components. Please give me an immense solution for this. Thanks, Ramesh V I would immensely instruct them on what these restrictions are, and require them to stick to the rules. sillyness aside you could look at the TracTicketChainedFieldsPlugin however you won't be able to use the default component field, but rather would need to use a --~--~-~--~~~---~--~~ 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: Errno 31 Too many links in xmlrpclib while uploading tickets
On Thu, Aug 20, 2009 at 6:28 PM, Lukasz Szybalskiszybal...@gmail.com wrote: On Thu, Aug 20, 2009 at 5:13 PM, Lukasz Szybalskiszybal...@gmail.com wrote: Hello, I am uploading tickets to trac. 500 a day. After almost a month+ I've received this error. Traceback (most recent call last): File xxx.py, line 115, in module filename=server.ticket.putAttachment(number,file_name,file_name,xmlrpclib.Binary(open(os.path.join(folder_name,file_name)).read())) File /usr/lib/python2.5/xmlrpclib.py, line 1147, in __call__ return self.__send(self.__name, args) File /usr/lib/python2.5/xmlrpclib.py, line 1437, in __request verbose=self.__verbose File /usr/lib/python2.5/xmlrpclib.py, line 1201, in request return self._parse_response(h.getfile(), sock) File /usr/lib/python2.5/xmlrpclib.py, line 1340, in _parse_response return u.close() File /usr/lib/python2.5/xmlrpclib.py, line 787, in close raise Fault(**self._stack[0]) xmlrpclib.Fault: Fault 2: '[Errno 31] Too many links: '/home/trac/trac/attachments/ticket/32433'' while executing 'ticket.putAttachment()' Is there a way to close the xmlrpclib.ServerProxy. I think that is what caused this error. Every time I upload a file I create a service that connects to trac. I do that because the filename of the file I want to upload comes on stdin. I found this: http://www.wlug.org.nz/EMLINK Too Many Links There are too many hard links to a file or directory on a filesystem. The exact number allowed is file-system dependent. Eg /usr/src/linux-2.4.19/include/linux/sysv_fs.h contains enum { XENIX_LINK_MAX = 126, /* ?? / SYSV_LINK_MAX = 126, / 127? 251? / V7_LINK_MAX = 126, / ?? */ COH_LINK_MAX = 1, }; while /usr/src/linux-2.4.19/include/linux/ext3_fs.h has 1. define EXT3_LINK_MAX 32000 and /usr/src/linux-2.4.19/include/linux/reiserfs_fs.h has 1. define REISERFS_LINK_MAX (MAX_US_INT - 1000) (for maximum unsigned integer on the system). This could be caused by a directory having too many subdirectories (each subdirectory has .. as a hardlink to it's parent directory which causes that directory's hardlink count to be increased by one. So yes, this does mean that you are limited to 32000 subdirectories in one directory in ext3, even if you have hashdirs enabled.) As a consequence of this you can stat(2) a directory and add one (for ..) and you will know how many directories are in the current directory. (or subtract one (for .) to find out how many subdirectories there are). Some file systems (such as FAT) don't have hardlinks so the hardlink count can't overflow, and you can't rely on the hardlink count of a directory to be representive of how many subdirectories it has. What a confusing world we live in. I did reach the 32000 tickets. I have exactly: 31999 folder for ticket# on my ext3. ls -l |wc -l 31999 How do I increase that number on ext3? Thanks, Lucas Well, when lots of SVN users started hitting limits like that for revisions, they just added a second directory level to handle the situation. I don't think many Trac instances have, to this point, been used in a such a way that they've hit this limit. --~--~-~--~~~---~--~~ 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 grouped by Custom Fields
Hey Jon, You're talking about (SQL) reports, not custom queries, right? (In custom queries your available custom fields should show up in the Group by dropdown.) Try something like this in your report's query: {{{ SELECT id AS ticket, summary, owner, version AS Reported in, c.value AS __group__ FROM ticket t LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = 'confirmation') ORDER BY c.value, version, component, id }}} Replace 'confirmation' in `c.name='confirmation'` with the internal name (not label) of your custom field. Make sure that `c.value` is listed first in ORDER BY -- otherwise your results will not be grouped together correctly. Hope this helps, egj On Thu, Aug 20, 2009 at 1:29 PM, Jon Russelljruss...@indexuniverse.com wrote: Hi, I've created a custom field but cannot work out how to group my report by that custom field. I've created a field titled 'Developer' - this details the main developer for any ticket and is useful to keep a track of the work that my team does (I cannot use the Default Owner field as this regularly changes between the developer, testing and the business). If anyone knows how to group a set of results in a report by a custom field, I would be eternally grateful. Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Bulk edit / sql update queries
On Aug 21, 2:27 pm, Ethan Jucovy ethan.juc...@gmail.com wrote: Hey Don, You won't be able to execute SQL UPDATEs from the web interface. If you want to execute that SQL you'll need to use an external database client. Alternatively you could try installinghttp://trac-hacks.org/wiki/BatchModifyPlugin-- it might also do what you need (but without any SQL). egj On Thu, Aug 20, 2009 at 4:34 PM, Dondon...@verizon.net wrote: Sorry if this is a newbie question, didn't see it in the help faq. I'm trying to do a bulk update like update ticket set owner='joe' where owner='shmoe'; But I'm not sure where to run that from. When I try to enter it in a custom query, I'm getting an error because it is trying to get a count from the query results, as in: select count(*) from (update ticket set owner=...) thanks, - Don I typically use batchmodifyplugin for these types of things, however there are quite a few sqllite convience tools, like Line 709, not sure I like a SQL Lite Browser that make this easy. sqllite also has a command-line option, if I remember correctly , and you could write a python script that connects to the db and exectues the query as well. Just some thoughts. --~--~-~--~~~---~--~~ 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: Firefox Plugin for Trac
a save screen shot utility sounds useful, but if you use the gui to save what the gui looks like you aren't saving exactly what you want to save, all the time. So a keyboard approach to snapshotting simply can't be avoided. That said, a way to paste an image from the clipboard directly into the ticket instead of creating and using an image file would be handy too and is one of the components of what you're asking for. I think there are rich text entry widgets that can do that already, or at least they hide a lot of the details. The paucity of the discussion at http://stackoverflow.com/questions/420701/copy-pasting-image-into-javascript-rich-text-editor seems to indicate that paste-to-rich-text-widget is something of an open problem. Maybe a plugin could do it, possibly combined with server support. --~--~-~--~~~---~--~~ 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: Errno 31 Too many links in xmlrpclib while uploading tickets
Lukasz Szybalski wrote: How do I increase that number on ext3? I'm not sure you can. But I remember reading about a sharding scheme for attachments that would solve the issue. Here's the ticket: http://trac.edgewall.org/ticket/7397 There's a patch attached, but it didn't get a review yet. -- Remy signature.asc Description: OpenPGP digital signature
[Trac] Re: Errno 31 Too many links in xmlrpclib while uploading tickets
On Aug 21, 2009, at 6:32 PM, Erik Bray wrote: On Thu, Aug 20, 2009 at 6:28 PM, Lukasz Szybalskiszybal...@gmail.com wrote: On Thu, Aug 20, 2009 at 5:13 PM, Lukasz Szybalskiszybal...@gmail.com wrote Traceback (most recent call last): File xxx.py, line 115, in module filename = server .ticket .putAttachment (number ,file_name ,file_name ,xmlrpclib.Binary(open(os.path.join(folder_name,file_name)).read())) File /usr/lib/python2.5/xmlrpclib.py, line 1147, in __call__ return self.__send(self.__name, args) File /usr/lib/python2.5/xmlrpclib.py, line 1437, in __request verbose=self.__verbose File /usr/lib/python2.5/xmlrpclib.py, line 1201, in request return self._parse_response(h.getfile(), sock) File /usr/lib/python2.5/xmlrpclib.py, line 1340, in _parse_response return u.close() File /usr/lib/python2.5/xmlrpclib.py, line 787, in close raise Fault(**self._stack[0]) xmlrpclib.Fault: Fault 2: '[Errno 31] Too many links: '/home/trac/trac/attachments/ticket/32433'' while executing 'ticket.putAttachment()' Is there a way to close the xmlrpclib.ServerProxy. I think that is what caused this error. Every time I upload a file I create a service that connects to trac. I do that because the filename of the file I want to upload comes on stdin. I did reach the 32000 tickets. I have exactly: 31999 folder for ticket# on my ext3. ls -l |wc -l 31999 How do I increase that number on ext3? Thanks, Lucas Well, when lots of SVN users started hitting limits like that for revisions, they just added a second directory level to handle the situation. I don't think many Trac instances have, to this point, been used in a such a way that they've hit this limit. Implementing this two level architecture seems reasonably easy to do so it is either that or you move to another filesystem, which is simpler if you don't want to extend trac. Theres a lot of fs that don't have this problem besides Reiserfs: ext4 with an extension has no limits (64k otherwise) http://en.wikipedia.org/wiki/Ext4#Break_32.2C000_subdirectory_limit jfs and xfs probably don't have this problem either http://en.wikipedia.org/wiki/XFS http://en.wikipedia.org/wiki/JFS_file_system -- Leonardo Santagada santagada at gmail.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Ticket - User Access restriction
ramesh. saadhvi wrote: Hi, We have added few components to the components list(ticket), We have few external clients,we want them (users) to create/modify/view tickets. In this scenario we want access restriction for the clients based on the components. Please give me an immense solution for this. Thanks, Ramesh V You might look at http://trac-hacks.org/wiki/PrivateTicketsPlugin. It may not do quite what you want but perhaps you could modify it to suit your needs. - jevans --~--~-~--~~~---~--~~ 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: Firefox Plugin for Trac
David Nicol wrote: That said, a way to paste an image from the clipboard directly into the ticket instead of creating and using an image file would be handy too and is one of the components of what you're asking for. That would be so awesome. - jevans --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---