[rt-users] question about pointer to info for upgrade/conversion of RT

2009-05-21 Thread Tim Mitchell
Hi all I have my db converted from postgresql to mysql after a bit of trouble and inserted into a new 3.8 install, getting an error trying to change my "rt at a glance" preferences: Internal Error: Couldn't execute the query 'INSERT INTO Attributes (ContentType, Creator, ObjectId, LastUpdatedBy,

Re: [rt-users] Desperately need help identifying Email CC object

2009-05-21 Thread Ruslan Zakirov
There is no attachments on a ticket, but transactions that have attachments. http://wiki.bestpractical.com/view/AddAttachmentLinksToMail On Fri, May 22, 2009 at 12:23 AM, Ken Crocker wrote: > Ruslan, > >     I turned on the log for my test and when I sent an email to the Queue, > this was the res

Re: [rt-users] Desperately need help identifying Email CC object

2009-05-21 Thread Ken Crocker
Ruslan, I turned on the log for my test and when I sent an email to the Queue, this was the resulting message for my scrip: [Thu May 21 20:16:51 2009] [error]: Scrip 50645 Commit failed: RT::Ticket::Attachments Unimplemented in RT::Action::UserDefined. ((eval 461) line 6). I've not s

Re: [rt-users] Desperately need help identifying Email CC object

2009-05-21 Thread Ken Crocker
Ruslan, Thanks. I'm not sure where to put this in my code, but I'll pass it on to my perl guy and I'm sure we'll get this going. Thanks again. Kenn LBNL On 5/21/2009 12:49 PM, Ruslan Zakirov wrote: my @user_ids; my $users = $ticket->Cc->UserMembersObj; while ( my $user = $users->Next ) {

Re: [rt-users] Desperately need help identifying Email CC object

2009-05-21 Thread Ruslan Zakirov
my @user_ids; my $users = $ticket->Cc->UserMembersObj; while ( my $user = $users->Next ) { push @user_ids, $user->id; } On Thu, May 21, 2009 at 10:50 PM, Ken Crocker wrote: > List, > >    I've copied the code that RT uses to get the Email address of CC's > and add them as ticket watchers. When

Re: [rt-users] "No object mapping for field" when referencing the UserObject of a MembersObject...

2009-05-21 Thread Ruslan Zakirov
You need a user object loaded that represents actor - a user who changing things. GetCurrentUser function is for command line tools that can be executed by many users on your system, like bin/rt tool. If you don't need mulit-user script then you can use $RT::SystemUser. Each object you construct us

Re: [rt-users] Can Simple.html search Email OR Content (not AND) ?

2009-05-21 Thread Kenneth Marshall
On Thu, May 21, 2009 at 11:41:50AM -0700, allen+rtl...@crystalfontz.com wrote: > > This known issue that if email is not in the db then result would be > > empty even if condition is ORed with another, but believe me correct > > query will kick breath out of your DB server. > > > > Are you saying

Re: [rt-users] "No object mapping for field" when referencing the UserObject of a MembersObject...

2009-05-21 Thread Johnathan Bell
Thanks... But another snippet on that page is now giving me trouble... --code-- my $currentUser = GetCurrentUser(); $currentUser->Load("tester97"); my ($status, $msg) = $groupObj->AddMember($currentUser->id()); die $msg unless $status; exit(0); --/code-- That code dies stating "Permission Denied"

[rt-users] Desperately need help identifying Email CC object

2009-05-21 Thread Ken Crocker
List, I've copied the code that RT uses to get the Email address of CC's and add them as ticket watchers. When I HARD-CODE the Emaill address, it works fine. The ticket has several CC Watchers. However, I'm having trouble getting the actual CC Address ID's from the incoming Email. In my co

Re: [rt-users] Can Simple.html search Email OR Content (not AND) ?

2009-05-21 Thread allen+rtlist
> This known issue that if email is not in the db then result would be > empty even if condition is ORed with another, but believe me correct > query will kick breath out of your DB server. > Are you saying that this "known issue" is a bug or is it intentional? I know that with a ton of tickets,

Re: [rt-users] Can Simple.html search Email OR Content (not AND) ?

2009-05-21 Thread Jerrad Pierce
> Looking at the synopsis of that, "cannot be meaningfully combined with > other search terms" seems to mean that a person could not search for > "from:foo bar" and expect to find tickets that were from User "foo" > and/or had the word "bar" in them. Is that right? If so, I don't think > that is go

Re: [rt-users] Can Simple.html search Email OR Content (not AND) ?

2009-05-21 Thread allen+rtlist
>> I would like to make it so that the Simple Search (3.8.2) will always >> search Content, Requestor and Subject fields using LIKE comparisons so >> and "email:" (won't find partial email addresses) > Is email: some newfangled 3.8.2 thing? Oops. Mixed up one of my attempted mods with how the st

Re: [rt-users] Can Simple.html search Email OR Content (not AND) ?

2009-05-21 Thread Ruslan Zakirov
This known issue that if email is not in the db then result would be empty even if condition is ORed with another, but believe me correct query will kick breath out of your DB server. On Thu, May 21, 2009 at 9:27 PM, wrote: > Hi, > > I would like to make it so that the Simple Search (3.8.2) will

Re: [rt-users] "No object mapping for field" when referencing the UserObject of a MembersObject...

2009-05-21 Thread Ruslan Zakirov
There is example in: http://wiki.bestpractical.com/view/CodeSnippets On Thu, May 21, 2009 at 10:11 PM, Ruslan Zakirov wrote: > As group may have another group as meber as well as user, so records > in GroupMembers and CachedGroupMembers objects reference Principals. > > If you are looking for use

Re: [rt-users] "No object mapping for field" when referencing the UserObject of a MembersObject...

2009-05-21 Thread Ruslan Zakirov
As group may have another group as meber as well as user, so records in GroupMembers and CachedGroupMembers objects reference Principals. If you are looking for users only that are members of a group then it's easier to do the following: my $group = ... $group->Load... my $users = $group->UserMe

[rt-users] "No object mapping for field" when referencing the UserObject of a MembersObject...

2009-05-21 Thread Johnathan Bell
Please let me know if this is supposed to go to RT-Users or RT-Devel. I'm trying to write a utility to interface with Request Tracker, and part of what that utility has to do is get the members of some user created groups. Just sub in actual groups for what you want in there, CurrentUser works

Re: [rt-users] FW: Regular Authentication and ExternalAuth RT 3.8.1

2009-05-21 Thread Eric Chatham
On Thursday, May 21, 2009 10:39, Mike Peachey wrote, >> I'm still having a problem with this. Does anyone know how to get LDAP >working on RT 3.8.2? Thank you. > >Absolutely. > >You don't mention actually *installing* RT::Authen::ExternalAuth into >your RT install.. I did the CPAN install. Wo

[rt-users] Can Simple.html search Email OR Content (not AND) ?

2009-05-21 Thread allen+rtlist
Hi, I would like to make it so that the Simple Search (3.8.2) will always search Content, Requestor and Subject fields using LIKE comparisons so that users won't need to prepend "fulltext:" and "email:" (the latter won't find partial email addresses) on search terms. I have created a local overl

Re: [rt-users] FW: Regular Authentication and ExternalAuth RT 3.8.1

2009-05-21 Thread Mike Peachey
Thu 21 May 2009 15:18:29 GMT Eric Chatham wrote: > I'm still having a problem with this. Does anyone know how to get LDAP > working on RT 3.8.2? Thank you. Absolutely. > -Original Message- > From: Eric Chatham > Sent: Wednesday, May 20, 2009 14:55 > To: 'Eric Chatham'; RT-Users@lists.b

[rt-users] FW: Regular Authentication and ExternalAuth RT 3.8.1

2009-05-21 Thread Eric Chatham
I'm still having a problem with this. Does anyone know how to get LDAP working on RT 3.8.2? Thank you. -Original Message- From: Eric Chatham Sent: Wednesday, May 20, 2009 14:55 To: 'Eric Chatham'; RT-Users@lists.bestpractical.com Subject: RE: Regular Authentication and ExternalAuth RT 3

Re: [rt-users] Remove a user or merge two users?

2009-05-21 Thread Ruslan Zakirov
Can you find log of the installation? Especially that part where you run Makefile.PL. This extension has up to date installer to install into plugins directory, but in the error I see old style path. In you case I think adding "require RT::Extension::MergeUsers;" to the end of the site config will

Re: [rt-users] Ingest csv, xls or xml to create, modify or resolve tickets

2009-05-21 Thread Ruslan Zakirov
You can deliver using web request with credentials of an user. On Thu, May 21, 2009 at 2:48 PM, Simon Dray wrote: > Roy > > This looks like a possibility many thanks for the prompt response, do you > know if it is documented anywhere in full I guess probably in the Docs. Is it > possible to RT

Re: [rt-users] Ingest csv, xls or xml to create, modify or resolve tickets

2009-05-21 Thread Simon Dray
Roy This looks like a possibility many thanks for the prompt response, do you know if it is documented anywhere in full I guess probably in the Docs. Is it possible to RT command line to ingest the file as I want to automate the whole process i.e a file get delivered to my RT server and at a gi

Re: [rt-users] Ingest csv, xls or xml to create, modify or resolve tickets

2009-05-21 Thread Raed El-Hames
Simon; Do you mean something similar to : Tools->Offline ?? Roy Simon Dray wrote: > > Hi, > > > > Has anyone had to use csv,xml,plain or xls files and then ingest them > into RT to Create, Change or delete I ask the question because there > is no point in re-inventing the wheel if somet

[rt-users] Ingest csv, xls or xml to create, modify or resolve tickets

2009-05-21 Thread Simon Dray
Hi, Has anyone had to use csv,xml,plain or xls files and then ingest them into RT to Create, Change or delete I ask the question because there is no point in re-inventing the wheel if something has already been written that can be shared. Regards Simon _