[rt-users] Heads-up: request-tracker3.8 in Ubuntu 12.04 LTS
Hi all, Owing to a series of oversights, request-tracker3.8 escaped with the new Ubuntu LTS release. However, I recommend that it not be used for new installations; request-tracker4, also available, is likely to be better supported during the lifetime of that LTS release. Please see https://bugs.launchpad.net/bugs/990516 for more information. Cheers, Dominic. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford signature.asc Description: Digital signature
[rt-users] Menu Actions, and most comman used actions
Hi, I see if you open one ticket, that the most used actions are under Actions Menu. But, Have direct access for less (for me) used actions. Like Jumbo, Reminders, etc... Could i have direct access (without click on Actions menu), to my usefull Actions?? Like, Reply, Resolve, Take . Regards. -- Un saludo. Juanjo Corral
Re: [rt-users] Menu Actions, and most comman used actions
On Fri, May 4, 2012 at 12:30 PM, Juanjo juanji...@gmail.com wrote: Hi, I see if you open one ticket, that the most used actions are under Actions Menu. But, Have direct access for less (for me) used actions. Like Jumbo, Reminders, etc... Could i have direct access (without click on Actions menu), to my usefull Actions?? Like, Reply, Resolve, Take . With callbacks and a few lines of code you can manipulate menu as you want. Regards. -- Un saludo. Juanjo Corral -- Best regards, Ruslan.
[rt-users] ExtractCustomFieldValues, insert fixed value when match
Hello I need to set a custom field (for example CF1) with fixed value (for example Domain1) if incoming mail from address is *@domain1.com I didn't found anything such case. How to do this? Best regards -- Stefan
Re: [rt-users] ExtractCustomFieldValues, insert fixed value when match
Hi Stefan,
We do something similar. I am sure there may be a better way to do
this but I am new to RT (and perl).
I needed to add a column to to the CustomFieldValues table called email
Here it is:
Condition: On Create
Action: User defined
Stage: TransactionCreate
Custom action preparation code:
return 1;
my $requester_email = ($self-TicketObj-RequestorAddresses)[0];
$requester_email =~ /(^.+)@([^\.].*\.[a-z]{2,}$)/;
my $email = $2;
my $cf = RT::CustomField-new($RT::SystemUser);
$cf-LoadByName(Name = 'Customer');
use Mysql;
my $host = localhost;
my $database = rt3;
my $tablename = CustomFieldValues;
my $user = user;
my $pw = password;
my $connect = Mysql-connect($host, $database, $user, $pw);
$connect-selectdb($database);
my $myquery = SELECT Name FROM $tablename WHERE email='$email';
my $execute = $connect-query($myquery);
my @results = $execute-fetchrow();
my $result = $results[0];
$self-TicketObj-AddCustomFieldValue(Field = $cf, Value = $result);
return 1;
Hopefully this is what you were looking for.
Josh
On Fri, May 4, 2012 at 5:51 AM, Stefan Stefanov ststefa...@gmail.com wrote:
Hello
I need to set a custom field (for example CF1) with fixed value (for
example Domain1) if incoming mail from address is *@domain1.com
I didn't found anything such case.
How to do this?
Best regards
--
Stefan
Re: [rt-users] ExtractCustomFieldValues, insert fixed value when match
On Fri, May 4, 2012 at 6:11 AM, Joshua Laroff jlar...@gmail.com wrote: my $cf = RT::CustomField-new($RT::SystemUser); $cf-LoadByName(Name = 'Customer'); ... $self-TicketObj-AddCustomFieldValue(Field = $cf, Value = $result); return 1; Actually, I think you can just pass the field name into AddCustomFieldValue and cut out looking up the name yourself. At least that's what I've been doing and it appears to work. -- http://www.linkedin.com/in/paultomblin http://careers.stackoverflow.com/ptomblin
Re: [rt-users] ExtractCustomFieldValues, insert fixed value when match
Thanks for ideas, but I'm using extension ExtractCustomFieldValues just as it's described here: http://wiki-archive.bestpractical.com/view/ExtractCustomFieldValues -- Stefan Stefanov
Re: [rt-users] ExtractCustomFieldValues, insert fixed value when match
Hi, ECFV extension allows you to put code that changes value after match to any value you like, but it's not really job for this extension. It's better to use custom scrip for such thing. On Fri, May 4, 2012 at 1:51 PM, Stefan Stefanov ststefa...@gmail.com wrote: Hello I need to set a custom field (for example CF1) with fixed value (for example Domain1) if incoming mail from address is *@domain1.com I didn't found anything such case. How to do this? Best regards -- Stefan -- Best regards, Ruslan.
Re: [rt-users] ExtractCustomFieldValues, insert fixed value when match
In this case I have to write code which do almost the same work as ECFV is doing (extract from incoming mail field From:). I already use ECFV extension for filling other custom fields and I think most efficient will be if I can use it for this field also. Can someone post an example of such code in ECVF extension? On Fri, May 4, 2012 at 3:53 PM, Ruslan Zakirov r...@bestpractical.com wrote: Hi, ECFV extension allows you to put code that changes value after match to any value you like, but it's not really job for this extension. It's better to use custom scrip for such thing. On Fri, May 4, 2012 at 1:51 PM, Stefan Stefanov ststefa...@gmail.com wrote: Hello I need to set a custom field (for example CF1) with fixed value (for example Domain1) if incoming mail from address is *@domain1.com I didn't found anything such case. How to do this? Best regards -- Stefan -- Best regards, Ruslan. -- Stefan Stefanov
Re: [rt-users] RT3 - login history recorded?
At the httpd or OS level there is some information that could help you... although I don't know if it's the information you are looking for but check out your httpd log file and your access/error/message log files at the OS level Mike. On Thu, May 3, 2012 at 1:37 PM, Ruslan Zakirov r...@bestpractical.comwrote: On Thu, May 3, 2012 at 2:50 AM, Joseph Spenner joseph85...@yahoo.com wrote: I'm using RT 3.8.8 and am curious whether RT records login history of users logging into the web interface. ? No, RT doesn't track such thing and I don't recall extensions that do this. You can use Creator and Created columns in Transactions table to figure out last activity on tickets or other objects. Thanks! If life gives you lemons, keep them-- because hey.. free lemons. -- Best regards, Ruslan. -- Mike Johnson Datatel Programmer/Analyst Northern Ontario School of Medicine 955 Oliver Road Thunder Bay, ON P7B 5E1 Phone: (807) 766-7331 Email: mike.john...@nosm.ca
Re: [rt-users] Corrupt attachments
The .docx/.xml thing is related to apache's MIME-Type settings. You essentially have to add all the microsoft 2007/10 extensions. It's something to do with .docx files being zipped xml files or something like that... I don't recall the details, but Google will help you. Mike. On Wed, May 2, 2012 at 5:26 PM, Jennings, Barbara bjje...@sandia.govwrote: Folks – we are running 4.0.1 RT and 5.8.8 red hat perl. Larger attachments are getting corrupted when they are sent out. And from time to time we get .docx files that are label as .xml and come through burst into sub dirs. Has anyone else come across this problem? Thanks Barbara Jennings Sandia National Laboratories - Albuquerque Organization 6924 - Policy and Decision Analytics (505)845-8554 bjje...@sandia.gov -- Mike Johnson Datatel Programmer/Analyst Northern Ontario School of Medicine 955 Oliver Road Thunder Bay, ON P7B 5E1 Phone: (807) 766-7331 Email: mike.john...@nosm.ca
Re: [rt-users] RT3 - login history recorded?
On 2 May 2012, at 18:50, Joseph Spenner wrote: I'm using RT 3.8.8 and am curious whether RT records login history of users logging into the web interface. Not in its default config, but it can if you want it to and do external auth. If you use the RT::Authen::ExternalAuth extension and have debug-level logging, the log will include lines describing every step of every login.
[rt-users] Changing a user's options?
Hullo :) Running RT4.0.5, curious if there's a way for a SuperUser to change another user's options? Specifically, we have a few queues, and some users use X queue, and others use Y queue. I'd like to go in and set their default queue to the right one for each user. Is there a way to do that? Thanks in advance! Best, --Glenn
Re: [rt-users] mysql to oracle migration
On 05/04/2012 08:14 AM, Pedro Albuquerque wrote: Hi Scott, I successfully migrated from MySQL to Oracle thanks to your script! I don't know who wrote the script originally , but big thanks to them. I just had to make some minor changes but that was it. Regarding the sequences, I had to create a PL/SQL procedure to update the sequences.currval to have the max id for each table. Yes, forgot to mention that one. Many thanks for your help :) You're welcome, glad it went smooth. Best advice is not to use the migration tool in SQLDeveloper, we burnt a lot of time trying to get that to work. We should add the sequence update to the code and post it to the wiki. Cheers, Pedro. On 03/05/2012 15:04, Pedro Albuquerque wrote: Hi Scott, Many thanks for the script and explanation. I will take a look at this and will get back to you. Cheers, Pedro. On 02/05/2012 23:16, Scott wrote: We did this awhile ago, so my memory may be a little fuzzy. First off forget the SQLDeveloper migration, it mostly works but you have to work around some issues. Our biggest issue was that mysql defaults to utf8 and our Oracle DB's are not utf8, so some of the stored documents (mostly word) have don't totally display right. I thinks its just the apostrophes, quotes, ...etc. Another issue is that RT doesn't like to use blobs in PostgreSQL Oracle, so they base64 encode binary objects and store them in clobs. Like I said earlier I just modified the PostgreSQL migration script. I've attached the script, you probably don't need the NLS_LANG env setting or you may not want my NLS_DATE_FORMAT setting. I really didn't change much. I did add a new table list, just commented out the old one. So after all our messing around with the SQLDeveloper migration tool, we had success by using the Oracle table create sql that comes with the RT dist and running the attached script. As I said I may be forgetting a step, but give it a whirl. If you have questions, I will do my best to answer. Scott On 05/02/2012 10:15 AM, Pedro Albuquerque wrote: Many thanks Scott. Looking forward to hearing from you. Cheers, Pedro. On 02/05/2012 16:14, Scott wrote: I have done it, let me gather what we did and I will it to you. I think I used the postgresql script and just modified it. Sorry I'm swamped right now, but I will get back to you later today. n 05/02/2012 08:59 AM, pedroalb wrote: Hi, I took a look at the PostgreSQL scripts but they fail, for instance, when migrating the attachments. Encoding is base64 in Oracle and other errors occur. I am wondering why RT mentions it is possible to migrate using Oracle SQL developer if it does not work? Does anybody successfully migrated RT from MySQL to Oracle? Cheers, Pedro. Pedro Albuquerque-3 wrote: Thanks for the info. I will take a look at these scripts and try to use them in Oracle. I'll get back to you with updates. Cheers, Pedro. Pedro Albuquerque-3 wrote: Hi, I am trying to migrate mysql to oracle to have full text search. I updated successfully a RT 3.6.10 to RT 4.0.5 using mysql. However, when I migrate data and objects to oracle using sql developer, there is some issues in the attachments encoding, for instance. Does anyone has migrated from mysql to oracle? Cheers, Pedro.
