Re: [rt-users] Import user rigths and tickets across systems
Hello Ruslan you said importing a ticket is harder but i can't imagine what i have to do where i have to start with... that i can import some tickets to the other machine maybe i guess it has something to do with the database but this just an assumption from myself best regards john s. -- View this message in context: http://old.nabble.com/Import-user-rigths-and-tickets-across-systems-tp31653363p31661705.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] Link to existing attachment
Hi, I want to try and prevent creating duplicate attachments in a workflow. Is it possible to link an existing attachment in the database to a different transaction from a new or other ticket without adding the same attachement again? For viewing it looks like a user requires showticket or showcomments permission for the ticket that has the attachment. My goal is having a Ticket that requires an action from a different team. A new (sub)ticket is created for that team. However the first ticket will hold a document that the second ticket should be able to read without having full access to the main ticket. Storing the attachment a second time would waiste diskspace. Not for a single attachment but for the workflow in the coming years. Any thoughts on how I can try to get this working without duplicating the attachment disk storage? A reference to the existing attachment in the new ticket could also work. Is this possible? Thanks! Kind regards, Ton Hoogstraten IS Analyst
[rt-users] Adding a predefined search field
There's a particular search we do constantly against our custom field PO Number. Since the custom field is only applied to certain queues, building the search is a two-step process of first adding the Queue is XYZ search term which then gives us visibility to add the PO Number search term. It's not uncommon to need to do 20 or 30 such searches in rapid succession. This gets tedious because you have to Edit Search, delete the old value, add the new value, and repeat 30 times. What I'd really like is a search field in the upper bar (separate from the existing one) which automatically does a search queue XYZ for tickets with PO Number value of whatever is input in the field search. That would avoid all of these tedious steps. What's the best way to go about adding such functionality to our RT 3.8 interface? -- Fran Fabrizio Director of Information Systems UAB College of Arts and Sciences http://www.uab.edu/cas/ HHB510E | 205.996.5698 | fabri...@uab.edumailto:fabri...@uab.edu
Re: [rt-users] Adding a predefined search field
On Fri, May 20, 2011 at 6:22 PM, Francis L Fabrizio fabri...@uab.edu wrote: There’s a particular search we do constantly against our custom field “PO Number”. Since the custom field is only applied to certain queues, building the search is a two-step process of first adding the “Queue is XYZ” search term which then gives us visibility to add the PO Number search term. It’s not uncommon to need to do 20 or 30 such searches in rapid succession. This gets tedious because you have to Edit Search, delete the old value, add the new value, and repeat 30 times. What I’d really like is a search field in the upper bar (separate from the existing one) which automatically does a “search queue XYZ for tickets with PO Number value of whatever is input in the field” search. That would avoid all of these tedious steps. What’s the best way to go about adding such functionality to our RT 3.8 interface? One way: http://requesttracker.wikia.com/wiki/SearchCustomField This solution shows how to enable the following syntax in the search input box: cf.xxx:value You just should adjust it a little and your users can type: po:123 and perform the search. -- Fran Fabrizio Director of Information Systems UAB College of Arts and Sciences http://www.uab.edu/cas/ HHB510E | 205.996.5698 | fabri...@uab.edu -- Best regards, Ruslan.
[rt-users] dashboard my reminders error after upgrade to RT 4
After upgrading to RT 4 from 3.8.10, I'm seeing several errors in the dashboard reminders section in the form Couldn't find Ticket for reminder N. Please contact administrator. Oddly enough, it displays on all users' dashboards. This seems to only affect two or three really old entries as we really don't use the reminder functionality. It's certainly possible that some data was corrupted by my mucking about in the database or by using RT-Shredder incorrectly before it was merged into the mainline, but I'm not sure where to start looking. Thanks, -Jon
[rt-users] RT4 - Article custom field with Rich Text
Hi, I am just starting to use RT4 and would like to know if anyone has gotten Rich Text to work as a custom field in the articles. Perhaps there is another way. Thanks in advance, Gilbert.
Re: [rt-users] Adding a predefined search field
I just installed RTx::Tags to get the enhanced simple search custom field functionality without having to patch code. Thanks for the suggestion! Works great except RTx::Tags seems to have broken my layout in the upper right of the page. See the attached image - the New Ticket queue dropdown got moved under the Search button for some reason. (This is RT 3.8.8 / Firefox 3.6.17 / 64-bit Win7.) -Original Message- From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Friday, May 20, 2011 9:47 AM To: Francis L Fabrizio Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Adding a predefined search field On Fri, May 20, 2011 at 6:22 PM, Francis L Fabrizio fabri...@uab.edu wrote: There’s a particular search we do constantly against our custom field “PO Number”. Since the custom field is only applied to certain queues, building the search is a two-step process of first adding the “Queue is XYZ” search term which then gives us visibility to add the PO Number search term. It’s not uncommon to need to do 20 or 30 such searches in rapid succession. This gets tedious because you have to Edit Search, delete the old value, add the new value, and repeat 30 times. What I’d really like is a search field in the upper bar (separate from the existing one) which automatically does a “search queue XYZ for tickets with PO Number value of whatever is input in the field” search. That would avoid all of these tedious steps. What’s the best way to go about adding such functionality to our RT 3.8 interface? One way: http://requesttracker.wikia.com/wiki/SearchCustomField This solution shows how to enable the following syntax in the search input box: cf.xxx:value You just should adjust it a little and your users can type: po:123 and perform the search. -- Fran Fabrizio Director of Information Systems UAB College of Arts and Sciences http://www.uab.edu/cas/ HHB510E | 205.996.5698 | fabri...@uab.edu -- Best regards, Ruslan. attachment: NewTicketDropdownBrokenLayout.png
Re: [rt-users] Adding a predefined search field
On Fri, May 20, 2011 at 12:36:41PM -0500, Francis L Fabrizio wrote: I just installed RTx::Tags to get the enhanced simple search custom field functionality without having to patch code. Thanks for the suggestion! Works great except RTx::Tags seems to have broken my layout in the upper right of the page. See the attached image - the New Ticket queue dropdown got moved under the Search button for some reason. (This is RT 3.8.8 / Firefox 3.6.17 / 64-bit Win7.) RTx-Tags is a 3rd party extension, so you may need to report the bug to the rt.cpan queue if the author doesn't reply on-list. https://rt.cpan.org/Public/Dist/Display.html?Queue=RTx-Tags -kevin -Original Message- From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Friday, May 20, 2011 9:47 AM To: Francis L Fabrizio Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Adding a predefined search field On Fri, May 20, 2011 at 6:22 PM, Francis L Fabrizio fabri...@uab.edu wrote: There’s a particular search we do constantly against our custom field “PO Number”. Since the custom field is only applied to certain queues, building the search is a two-step process of first adding the “Queue is XYZ” search term which then gives us visibility to add the PO Number search term. It’s not uncommon to need to do 20 or 30 such searches in rapid succession. This gets tedious because you have to Edit Search, delete the old value, add the new value, and repeat 30 times. What I’d really like is a search field in the upper bar (separate from the existing one) which automatically does a “search queue XYZ for tickets with PO Number value of whatever is input in the field” search. That would avoid all of these tedious steps. What’s the best way to go about adding such functionality to our RT 3.8 interface? One way: http://requesttracker.wikia.com/wiki/SearchCustomField This solution shows how to enable the following syntax in the search input box: cf.xxx:value You just should adjust it a little and your users can type: po:123 and perform the search. -- Fran Fabrizio Director of Information Systems UAB College of Arts and Sciences http://www.uab.edu/cas/ HHB510E | 205.996.5698 | fabri...@uab.edu -- Best regards, Ruslan. pgpiNtK7RyNFa.pgp Description: PGP signature
Re: [rt-users] Rt and field crews
Is there any way to do custom print.css based on the queue? I only need this one particular print form for one queue. On Tue, May 17, 2011 2:16 pm, Ruslan Zakirov wrote: Hello Yan, RT uses print.css - style sheet that only used for printing. You can change it adopt for your needs. Also, you can create a special print view as combination of customized Display.html and custom style sheet. On Tue, May 17, 2011 at 10:40 PM, Yan Seiner y...@seiner.com wrote: We're using RT to manage work crews. We have crews that go out and work on various projects. We have a crew that specifically deals with small projects; these are small one day or less jobs. Dispatch gets a work order, typically by phone. She takes down the information, location, etc. on a pre-printed form, does some basic research on ownership, access, etc, and then sends the same form out with the crew to fix the issue. I've created the dispatch part of the form in RT. The bottom half of the form is blanks that gets filled out in the field by the crew foreman. I need to get RT to print the form so dispatch can put them in the crew work order pile. I've looked around and RT doesn't really seem to have any simple way to print tickets in a specific format. Any guidance on this? -- My daughter is racing a triathlon to raise money for her swim club. Want to help? http://akari.seiner.com -- Best regards, Ruslan. !DSPAM:4dd2e76b277131901992046! -- My daughter is racing a triathlon to raise money for her swim club. Want to help? http://akari.seiner.com
[rt-users] RT 4.0.0, PostgresQL and Fulltext search
Hi,
I'm testing a new RT4 installation with Postgres to try FullText search. I got
RT up and running, ran the rt-setup-fulltext-index utility, updated my
RT_SiteConfig file but get errors when trying to run the indexer:
root@rt2:/opt/rt4# sbin/rt-setup-fulltext-index --dba postgres --dba-password
'removed'
Enter name of a DB table that will be used to store Pg tsvector. Attachments
table can be used.
[Attachments]:
Enter name of a column that will be used to store Pg tsvector
[ContentIndex]:
Configure your RT via site config:
Set( %FullTextSearch,
Enable = 1,
Indexed = 1,
Column = 'ContentIndex',
Table = 'Attachments',
);
Going to do the following change in the DB:
ALTER TABLE Attachments ADD COLUMN ContentIndex tsvectorYou have choice between
GiST or GIN index, the first is times slower to search, but it takes less place
and faster to update.
[GiST]:
Going to do the following change in the DB:
CREATE INDEX ContentIndex_idx ON Attachments USING gist(ContentIndex)
root@rt2:/opt/rt4#
root@rt2:/opt/rt4# sbin/rt-fulltext-indexer
[Fri May 20 19:40:14 2011] [warning]: Use of uninitialized value $table in
concatenation (.) or string at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder.pm line 1223.
(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder.pm:1223)
[Fri May 20 19:40:14 2011] [warning]: Use of uninitialized value
$args{TABLE2} in concatenation (.) or string at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 989.
(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:989)
[Fri May 20 19:40:14 2011] [warning]: DBD::Pg::st execute failed: ERROR:
relation _3 does not exist
LINE 1: ...) AND ( Transactions_1.ObjectId = main.id ) JOIN _3 ON ( _...
^ at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:509)
snip
Did I miss something? I read through the RT_Config file comments and the --help
flag for all related binaries.
Thanks,
Patrick
Re: [rt-users] RT 4.0.0, PostgresQL and Fulltext search
On Fri, 2011-05-20 at 19:42 +, Patrick Fish wrote: I'm testing a new RT4 installation with Postgres to try FullText search. We've fixed these bugs and improved the documentation immeasurably on 4.0-trunk in git, which will be shortly branched for 4.0.1 release engineering. If you wanted to test that, and let us know any troubles you run into, that'd be appreciated. - Alex
[rt-users] lots of apache errors in new rt 4.0 install
Hi, Total rt newbie here. installed rt 4.0 on CentOS Linux box, with Apache2 and fastcgi (mod_fcgid, actually). It's mostly working, but I'm seeing a lot of errors in the apache logs, and I don't like them. [Fri May 20 14:25:05 2011] [warn] (104)Connection reset by peer: mod_fcgid: read data from fastcgi server error. [Fri May 20 14:25:05 2011] [error] [client 67.84.105.167] Premature end of script headers: bpslogo.png, referer: http://dev-rt.avalontel.com/Ticket/Display.html?id=3results=ac40e8d551e1154c9342a8d71b365fda [Fri May 20 14:25:05 2011] [warn] (104)Connection reset by peer: mod_fcgid: read data from fastcgi server error. [Fri May 20 14:25:05 2011] [error] [client 67.84.105.167] Premature end of script headers: empty_star.gif, referer: http://dev-rt.avalontel.com/Ticket/Display.html?id=3results=ac40e8d551e1154c9342a8d71b365fda [Fri May 20 14:25:05 2011] [debug] arch/unix/fcgid_proc_unix.c(525): (111)Connection refused: mod_fcgid: can't connect unix domain socket: /var/run/mod_fcgid/3443.368 I've checked the permissions on the tree /opt/rt4 and it's read by world all the way down. I had to chmod -R apache the whole tree so that things would work at all, the default root:root permissions weren't doing it. I have no idea why apache is pi--ing and moaning about bpslogo.png and empty_star.gif (and later on rollup-arrow.gif); the files are there, readable, etc. Can anybody help? uname -a Linux dev1.avalontel.com 2.6.18-194.8.1.el5 #1 SMP Thu Jul 1 19:07:06 EDT 2010 i686 i686 i386 GNU/Linux httpd -v Server version: Apache/2.2.3 Server built: May 4 2011 06:51:15 perl -v This is perl, v5.8.8 built for i386-linux-thread-multi mod_fcgid.i386 2.2-11.el5 I'm sure I'm forgetting something else. Thanks, -- Bill Dudley ext: 2010 phone: 732 719 8047 cell: 310 707 8245 yahoo: w_f_dudley skype: william.f.dudley
Re: [rt-users] RT 4.0.0, PostgresQL and Fulltext search
Thanks Alex. I cloned 4.0-trunk and installed it over my 4.0.0 dev instance, giving me 4.0.0-421-g0d9f41e. I ran rt-fulltext-indexer with no errors and searched fulltext:Veryuniquestringnotinanysubject and got the ticket out of it. Looking forward to the 4.0.1 release. Patrick -Original Message- From: Alex Vandiver [mailto:ale...@bestpractical.com] Sent: Friday, May 20, 2011 1:03 PM To: Patrick Fish Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT 4.0.0, PostgresQL and Fulltext search On Fri, 2011-05-20 at 19:42 +, Patrick Fish wrote: I'm testing a new RT4 installation with Postgres to try FullText search. We've fixed these bugs and improved the documentation immeasurably on 4.0-trunk in git, which will be shortly branched for 4.0.1 release engineering. If you wanted to test that, and let us know any troubles you run into, that'd be appreciated. - Alex
[rt-users] Roles in history not being translated
I created a new .po file to change the role names displayed for the various roles used in RT. This works really well in most cases. For example, I changed AdminCC to Team Member, which better describes our role. I built the .po file and now I have most of the labels changed to what I want. Except for the history. In the history, RT uses the original lables: AdminCC, CC, Requestor instead of Team Member, Stakeholder, and Customer. While my knowledge of perl is miniscule, I did figure out that the problem is in one of the following areas: lib/RT/Record.pm:1717 lib/RT/Transaction_Overlay.pm:736 lib/RT/Transaction_Overlay.pm:779 as these are templates that RT then fills in with the role... Is there any way to correct this? -- My daughter is racing a triathlon to raise money for her swim club. Want to help? http://akari.seiner.com
[rt-users] Trouble with User Custom Field
I am on 4.0 and trying to create a custom field that is tied to User. I create it, give it global rights but when I go into a user screen I see Custom Fields button but no custom fields I created do not show up. This is a dev instance so I went into our PRD 3.87 system and had the same issue. I thought I tried this in 3.82 and it worked fine so I am not sure if we messed something up when we left 3.82 or if I am doing something wrong. Any words of wisdom welcomed Thanks Joe Joe Kirby , Assistant Vice President, Business Systems Division of Information Technology (DoIT) Support Response - http://www.umbc.edu/oit Administration 627 Office - 410-455-3020 Email - ki...@umbc.edu
Re: [rt-users] Rt and field crews
On 05/20/2011 03:25 PM, Yan Seiner wrote: Is there any way to do custom print.css based on the queue? I only need this one particular print form for one queue. Not out of the box. You'd need to use a callback or two to add a class or ID to ticket pages in the one queue. Then you can select elements to style using that class in print.css. Thomas
