[rt-users] Accessing Hashes from modules

2008-03-12 Thread Munoz, Alvaro
Hi All,

I've defined a hash in AT_SiteConfig.pm:
my %Links = (
Soporta= 'SeSoportaEn',
Ejecuta= 'SeEjecutaEn',
RefersTo= 'ReferredToBy',
);

And then I'm trying to access it from Asset_overlay.pm with the following line:
my %Links = %RTx::AssetTracker::Links;

But I got an empty hash. However if I access the very same config hash from 
Display.html I get it. Do you know whats wrong? Any hint?

Thanks,

Alvaro Muñoz Sánchez
P Antes de imprimir piensa en el medio ambiente

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Removing assets with Shredder

2008-03-05 Thread Munoz, Alvaro
Hi,

Is it possible to remove assets from AssetTracker with RT-Shredder?

Thanks!

Alvaro
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] COndition on customfield change

2008-02-08 Thread Munoz, Alvaro
Hi there,

Is there any way to match a customfiled value change from one specific value to 
another?

Transactions of type CustomField leave NewValue and OldValue to NULL so I 
just can know that the field has changed but not the old and new values.
In the ticket history you can see both values, can i use those values from a 
scrip condition?

Thanks in advance!

Alvaro

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] COndition on customfield change

2008-02-08 Thread Munoz, Alvaro

Hi Benjamin,

I looked at the wiki and the list before posting, but the problem is that 
newValue and oldValue attributes are not set inthe transaction


Alvaro Muñoz Sánchez
Technical Consultant
Hewlett Packard Consulting  Integration
Phone: 628 13 01 36
E-Mail: [EMAIL PROTECTED]
P Antes de imprimir piensa en el medio ambiente

-Original Message-
From: Benjamin Weser [mailto:[EMAIL PROTECTED]
Sent: viernes, 08 de febrero de 2008 14:53
To: Munoz, Alvaro
Cc: RT Users
Subject: Re: [rt-users] COndition on customfield change

Alvara,

have a look at http://wiki.bestpractical.com/view/Contributions, there are 
several examples how to read and manipulate the values of CFs via scrips.
First you have to look if the transaction was caused by a CF, something like 
this:

unless (
 ( $self-TransactionObj-Type eq CustomField
 $self-TransactionObj-Field == 6 )  ||  $self-TransactionObj-Type eq 
Create
 ) {
   return 0;
}

Hint: The 6 equals the id of the CF.

Then you can test for OldValue and NewValue. Have a look at the examples 
mentioned above.

Best,
Ben


Munoz, Alvaro schrieb:
 Hi there,

 Is there any way to match a customfiled value change from one specific
 value to another?

 Transactions of type CustomField leave NewValue and OldValue to NULL
 so I just can know that the field has changed but not the old and new
 values.
 In the ticket history you can see both values, can i use those values
 from a scrip condition?

 Thanks in advance!

 Alvaro

 --
 --

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com Commercial support:
 [EMAIL PROTECTED]


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Error adding watcher to queue, bug?

2008-01-30 Thread Munoz, Alvaro

Hi there,

Im getting an odd error while trying to add a watcher to a queue. When adding a 
new AdminCc to a queue I get a Group not found error that comes from:

/rt3/lib/RT/Queue_Overlay.pm {AddWatcher subfunction}
$group-LoadQueueRoleGroup(Type = $args{'Type'}, Queue = $self-Id);
unless ($group-id) {
return(0,$self-loc(Group not found));

The odd point is that I get this error just for one queue and it works for the 
rest of queues.
For the queue that does not work, Type = AdminCc and Queue = 16
For a queue that work, Type = AdminCc and Queue = 11

Both Queues are similar and have the same permissions (By the way, Im adding 
the watcher as root):
mysql select * from Queues where Id = 16;
++-+-+---++-+---+--+-+-+---+-+--+
| id | Name| Description | CorrespondAddress | CommentAddress | 
InitialPriority | FinalPriority | DefaultDueIn | Creator | Created 
| LastUpdatedBy | LastUpdated | Disabled |
++-+-+---++-+---+--+-+-+---+-+--+
| 16 | ADE_Requests | |   ||
  50 | 0 |0 |   1 | 2007-08-22 13:03:00 |   
  1 | 2007-08-22 13:03:00 |0 |
++-+-+---++-+---+--+-+-+---+-+--+
1 row in set (0,00 sec)

mysql select * from Queues where Id = 11;
++-+-+---++-+---+--+-+-+---+-+--+
| id | Name| Description | CorrespondAddress | CommentAddress | 
InitialPriority | FinalPriority | DefaultDueIn | Creator | Created 
| LastUpdatedBy | LastUpdated | Disabled |
++-+-+---++-+---+--+-+-+---+-+--+
| 11 | INT_Requests | |   ||
  50 | 0 |0 |   1 | 2007-07-06 11:03:47 |   
  1 | 2007-07-06 11:03:47 |0 |
++-+-+---++-+---+--+-+-+---+-+--+
1 row in set (0,00 sec)



Getting to the syslog I found the following error:

Jan 30 12:33:24 evia RT: Use of uninitialized value in join or string at 
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 1015. 
(/usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm:1015)
Jan 30 12:33:24 evia RT: DBD::mysql::st execute failed: You have an error in 
your SQL syntax; check the manual that corresponds to your MySQL server version 
for the right syntax to use near ')' at line 1 at 
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505. 
(/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
Jan 30 12:33:25 evia RT: RT::Handle=HASH(0x949510c) couldn't execute the query
'SELECT count(main.id) FROM GroupMembers main  WHERE (main.GroupId = ) ' at 
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518 
^IDBIx::SearchBuilder::Handle::SimpleQuery() called at 
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 294 
^IDBIx::SearchBuilder::_DoCount() called at 
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 1379 
^IDBIx::SearchBuilder::Count() called at 
/usr/local/rtir/rt3/share/html/Admin/Elements/EditQueueWatchers line 46 
^IHTML::Mason::Commands::__ANON__() called at 
/usr/share/perl5/HTML/Mason/Component.pm line 135 
^IHTML::Mason::Component::run() called at 
/usr/share/perl5/HTML/Mason/Request.pm line 1256 ^Ieval {...} called at 
/usr/share/perl5/HTML/Mason/Request.pm line 1246 ^IHTML::Mason::Request::comp() 
called at /usr/local/rtir/rt3/share/html/Admin/Queues/People.html line 71 
^IHTML::Mason::Commands::__ANON__() called at 
/usr/share/perl5/HTML/Mason/Component.pm line 135 ^IHTML::Mason:

Thanks in advance,
Regards,

Alvaro Muñoz Sánchez
mailto:[EMAIL PROTECTED]
P Antes de imprimir piensa en el medio ambiente

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Quey to match cf not filled

2007-12-18 Thread Munoz, Alvaro
Hi,
 
Im trying to match all the tickets with a customfield not filled up. Im
using this query but its not working. any hints?
 
( Status = 'open' AND Queue = 'Incidents' AND 'CF.{Report}' != '' )
 
Thanks in advance,
Regards
Alvaro
 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

RE: [rt-users] CommandByMail links

2007-09-17 Thread Munoz, Alvaro
I think you can define MemberOf relationship.

Regards 


Alvaro Muñoz Sánchez
Technical Consultant
Hewlett Packard Consulting  Integration
Phone: 628 13 01 36
E-Mail: [EMAIL PROTECTED]
P Antes de imprimir piensa en el medio ambiente

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Snyder
Sent: lunes, 17 de septiembre de 2007 20:47
To: RT Users
Subject: [rt-users] CommandByMail links

Looking at the perldoc, Parent or Child don't seem to be link options.  Is 
there fix for this or are they just not listed in the documentation?

Mathew
--
Keep up with me and what I'm up to: http://theillien.blogspot.com 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support: [EMAIL 
PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Commandbymail troubles

2007-09-03 Thread Munoz, Alvaro
 
Hi,

I cant get the custom part of commandbymail to work

I try to update or create a ticket and change a CF called GAPPInform by 
sending the command:

CustomField.{GAPPInform}: Whatever

But even I get no error message, I dont get the CF updated.

Any errors on the systax?


Thanks


Alvaro Muñoz Sánchez
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com