Re: [rt-users] Look up User by Attribute in Scrip

2012-10-27 Thread Ram
 On 10/26/2012 04:52 PM, Ram wrote:
 Hey folks,
 I'm writing a scrip to help us manage our voicemails in RT. The
 voicemails arrive via email as attachments and the extension of the
 recipient is the only distinguishing characteristic in the email. How
 can I load an RT user in a script given only their work telephone?

 You want the LoadByCols method provided by DBIx::SearchBuilder::Record.

 my $user = RT::User-new( RT-SystemUser );
 $user-LoadByCols( WorkPhone = 1234 );

 if ($user-id) {
  # loaded!
 } else {
  # couldn't find that user...
 }

 Note that WorkPhone isn't forced to be unique, so you should make sure
 that you keep it unique if you're going to load by it.

Awesome, thanks!! Yep our phone extensions are unique so it'll be fine.
ram

We're hiring! http://bestpractical.com/jobs


Re: [rt-users] Look up User by Attribute in Scrip

2012-10-27 Thread k...@rice.edu
On Fri, Oct 26, 2012 at 04:52:37PM -0700, Ram wrote:
 Hey folks,
 I'm writing a scrip to help us manage our voicemails in RT. The
 voicemails arrive via email as attachments and the extension of the
 recipient is the only distinguishing characteristic in the email. How
 can I load an RT user in a script given only their work telephone?
 thanks!
 ram

Hi Ram,

You will need to lookup their phone number in a table that has their
user information. Here this is all available in our campus LDAP directory
so some simple Net::LDAP calls can be used for this. It could also pull
the information from an RT custom field for the user as well.

Cheers,
Ken

We're hiring! http://bestpractical.com/jobs