[Trac] Re: Trac Developer Contact Job
Just a note, people here are not necessarily associated with the Trac project. Trac developer doesn't mean someone that is actually a core author I assume. We take no responsibility, yada yada. --Noah On Jun 24, 2009, at 5:21 PM, Adam Thompson wrote: Hello, I'm a developer at Alelo (alelo.com). We're looking for an experienced Trac developer to do custom work for us. According to past posts here, this the best place to post this job. Should I also cross post to Trac Dev? Thank you, -Adam Thompson athomp...@alelo.com Trac-Database Contract Programmer Alelo is looking for a contract programmer to do custom Trac development, including significant database creation and integration work. The candidate must have demonstrable Trac knowledge as well as proven database experience. The position will contract for 15-20 hours a week for several weeks, with extension possible based upon the quality of work produced. The ideal candidate will be local to Los Angeles and able to travel to our offices for occasional meetings. Fully offsite candidates will be considered on a case-by-case basis. The candidate must have the right to work in the US. To apply, send a resume in PDF form to j...@alelo.com, with the subject line Trac Programmer. Alelo Inc. produces immersive simulations of real-life social communication based on interactive 3D video games involving spoken dialogs and cultural protocols with socially intelligent virtual humans. (Alelo means language in Hawaiian.) Our initial applications teach how to communicate in foreign languages and cultures, and are rapidly growing in several training, entertainment, advertising and healthcare markets. Please visit us at http://www.alelo.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] Trac: install locale german -- HOW?
Hi, I would be install the locale for german translation of trac front-end and wiki-sites but i didn´t found a how-to. I have tried following instructions but without success http:// trac.edgewall.org/wiki/TracL10N. can everybody help me? thanks, Ronny my system: windows server 2003 standard edition, SP2 apache 2.2.11 python 2.4.3 trac 0.11.3 babel 0.9.4 genshi 0.5.1 mod_python 3.3.1 --~--~-~--~~~---~--~~ 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: Finding broken wiki links
Exactly, this is where I got to with the code snippet I posted before. It's surely not hard to do this because Trac does it already, but doing it as a standalone app is another matter... On Jun 24, 6:50 am, Ted Gifford tedford...@gmail.com wrote: what about a SQL query directly on the database? What would be the problem? Might be a bit harder to parse the wiki markup. Ted --~--~-~--~~~---~--~~ 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 Wiki Assistance
On Wed, Jun 24, 2009 at 11:58:02AM -0400, Guilliams, Ken wrote: Group, how do I add new documents, charts etc to the wiki pages in Trac? I would like to add a process flow chart. Do I need a special plug in for that? For flow charts I would recommend the Graphviz plugin: http://trac-hacks.org/wiki/GraphvizPlugin (assuming that fits your use case) Jeff Also when reviewing a DR and moving it to another State, example from New to TI is there a way to have a user pull down with a list of names so you know who to send the investigation to? Thank you, Kenny G Confidentiality Note: The information contained in this message, and any attachments, may contain proprietary and/or privileged material. It is intended solely for the person or entity to which it is addressed. Any review, retransmission, dissemination, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. --~--~-~--~~~---~--~~ 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] 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
On Jun 24, 4:42 pm, yoheeb yoh...@gmail.com wrote: you can use a custom sql report, as mentioned above. but you don't need to install the datefield plugin. The datefield plugin is valuable. however, what you are trying to do has been done with sql and date functions: see this thread:http://groups.google.com/group/trac-users/browse_thread/thread/c3452e... It has a few different types of date based reports for you. closed the last month, closed THIS month..etc. I believe they are SQLlite examples, no guarantees on postgres or mysql. one of these is looking for tickets that transitioned to closed between 2 dates. The dates in this thread are hardcoded, but could be supplied as part of the url to the report to dynamic variables. in your case, you would only need half the equations the greater than date X part. Rather then between. you would send the date to the report by appending it to the report url like so: YourProjectPath/report/18?DATEONE=2009-03-24 or something, might have to escape for urls assuming you used DATEONE as your variable. then in place of the hardcoded date you just put DATEONE. The downside of this is if you click on the actual report link in view tickets it bonks, since you need to provide the dynamic variable. It's easy to provide the variable as part of a wiki link however. if you wanted to auto-fill in the date form a selection, you'd need a custom form, or template, or maybe something that uses the datepicker javascript plugin thingy with some custom page/template- fu somehow. I'm sure it's easy for people that understand css and templates etc. I just embed it as a link on a wiki page :D If you get the sql working for you please add it here with {{{ code }}} http://trac.edgewall.org/ticket/8354 Thanks, Lucas hope this helps. --~--~-~--~~~---~--~~ 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
If you get the sql working for you please add it here with {{{ code }}} http://trac.edgewall.org/ticket/8354 Thanks, Lucas not sure what you are asking here. First, a trac ticket to add more custom reports to the supplied sample reports probably will be closed as invalid. It's not the trac dev's responsibilty, the supplied sample reports are just that, samples. If you need custom reports, you need to create your own, or hire it out. I suspect you are using a ticket to collect a recipes list. In that case, the wiki is more appropriate, and someone actually started a Cookbook idea http://trac.edgewall.org/wiki/CookBook/About finally, the sql IN the thread I linked does work. There are actually 3 or 4 reports in the thread (closed in the last month, closed in current month..etc.) If you find any of them useful, go ahead and paste them into your ticket. be sure to reference the poster of those sql and/or the thread. --~--~-~--~~~---~--~~ 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] Code for custom query, ticket_change?
Hello, 1. CustomQuery is really nice interface of doing queries. If one wanted to take it out of trac and reuse it in let say turbogears2 application what code would need to be ported? ticket/query.py for sure. What else custom query UI interacts with and would need to be ported out? 2. The second portion of interesting code is the ticket_change? Where is the code that watches for changes and updates the ticket_change table? I assume it has to be called somewhere between submit and save, as well as there has to be a code to know what has changed? Which files should I be looking at when browsing the source code? http://trac.edgewall.org/browser/trunk/trac Any help would be appreciated. Thanks, Lucas -- 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: Trac Wiki Assistance
Guilliams, Ken wrote: Also when reviewing a DR and moving it to another State, example from New to TI is there a way to have a user pull down with a list of names so you know who to send the investigation to? Taking a stab that DR might stand for defect report (no idea for TI except a custom workflow status), if you're asking about a list to pick from to assign tickets, try looking at the restrict_owner setting on http://trac.edgewall.org/wiki/TracIni. Note that there are some seemingly odd requirements that users have logged in at least once. - 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: 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 -~--~~~~--~~--~--~---