[rt-users] RT API

[George Beitis]

Hey everyone, looking for a PERL API to query the RT db, specificly to
search for a user see if he is there and if not add him.

Can anyone give me some recommendations and possibly an example?  is
RT::Client::REST::User what i should be looking at? using search does not
seem to work

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

[rt-users] Displaying a "note" (ie. instructions or details) somewhere on a ticket screen

[DSS\MAS]

Hi,

 

I am looking for a way to display a "note" (ie. some instructions, description 
or details for the users) somewhere on the self-service ticket screen. This 
text would be different for each queue. Any ideas/suggestions on how to 
implement this?

 

Thank you!

 

 

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Database size management

[Kenneth Marshall]

Calvin,

We keep everything. Even at 25MB/week, that is only 1.3GB/year
which means a standard 146GB drive will last a bit over a century.
That is a bit tongue-in-cheek, but really this data volume is
easily managed by small laptops and PDAs. You can use the shredder
function to delete tickets after a certain period to free up space.
We have zeroed out some large attachments that people attached to
a ticket (100+MB) otherwise we just let it be. Bringing them back
online is not particularly easy since the entire app was built with
historical accuracy and permanence in mind.

Cheers,
Ken

On Mon, Jan 19, 2009 at 05:44:34PM +, Calvin Chiang wrote:
> Hi All,
> 
> I've got a RT 3.6 install. Approx 20 users, and a database size of about 
> 500MB.
> It looks like i'm adding 25MB of data per week.. so it's growing quite a 
> bit faster than i'd like.
> 
> Any recommendations for data that i should look at stripping out of the 
> database? or do people archive their databases? if you do is it pretty 
> easy to bring them back online again if need be?
> 
> Cheers,
> 
> -- 
> Calvin Chiang
> Network Admin
> Utilyx
> 1st Floor, 55 North Wharf Road
> Paddington
> London, W2 1LA
> Tel: 020 7087 8673
> www.utilyx.com
> 
> 
> __
> "Utilyx" is the trading name of "Utilyx Limited" and "Utilyx Risk Management 
> Limited" (URML). URML is authorised and regulated by the Financial Services 
> Authority (FSA). This message contains information that may be privileged or 
> confidential and is the property of Utilyx. It is intended only for the 
> person to whom it is addressed. No confidentiality or privilege is waived or 
> lost by any mistransmission. Any views or opinions expressed in this message 
> are solely those of the author and do not necessarily represent those of 
> Utilyx. Unless otherwise stated, any pricing information given in this 
> message is indicative only and does not constitute an offer to deal at any 
> price quoted. If you are not the intended recipient, you are not authorized 
> to read, print, retain, copy, disseminate, distribute or use this message or 
> any part thereof. If you receive this message in error, please notify the 
> sender immediately and delete all copies of this message.
> __
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
> __
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sa...@bestpractical.com
> 
> 
> 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: sa...@bestpractical.com


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

Re: [rt-users] Anyone updated for 3.8.2 - http://wiki.bestpractical.com/view/PasswordReminder

[Gavin Henry]

I meant the link in the subject ;-)

On 17/01/2009, kem cho  wrote:
> I experimented upgrading from 3.8.1, it went without a hitch. Just followed
> README file.
> I was working on Fedora 9, PERL 5.10, mysql 5.0
>
> Good luck.
>
> --- On Sat, 1/17/09, Gavin Henry  wrote:
>
> From: Gavin Henry 
> Subject: [rt-users] Anyone updated for 3.8.2 -
> http://wiki.bestpractical.com/view/PasswordReminder
> To: rt-users@lists.bestpractical.com
> Date: Saturday, January 17, 2009, 3:25 PM
>
> Just wondering how easy?
>
> Thanks.
>
> --
> http://www.suretecsystems.com/services/openldap/
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sa...@bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>
>
>

-- 
Sent from my mobile device

http://www.suretecsystems.com/services/openldap/
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

[rt-users] CPU is going wild

[Marcus Pauli]

Hello *,

after managing to authenticate against LDAP, I faced another issue:
After logging in, the CPU gets extremely occupied. As the System is a
Dual Intel(R) Pentium(R) 4 CPU 2.80GHz I don't think, that this
behaviour is normal. :-)

BTW: The problem occurs with both mod_perl and fastcgi.

Apache is 2.0.58-r2, mod_perl is 2.0.3-r2, perl is 5.8.8, linux is
2.6.17-gentoo

Here's what RT's log is telling me (I can't find anything suspicious)

---8<---
Jan 19 17:53:02 ganymed RT: Working around bug in RT and reloading
RT::User
(/var/www/myhost/rt-3.8.2/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth:12)
Jan 19 17:53:02 ganymed
Log::Dispatch::__ANON__('Log::Dispatch=HASH(0xfc8ab88)', 'Working around
bug in RT and reloading RT::User') called at
/var/www/myhost/rt-3.8.2/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth
line 12
Jan 19 17:53:02 ganymed
RT::Interface::Web::Request::callback('RT::Interface::Web::Request=HASH(0xfeb72f4)',
'CallbackName', 'Auth') called at /var/www/myhost/htdocs/autohandler
line 256
Jan 19 17:53:02 ganymed
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0xfeb72f4)')
called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
Jan 19 17:53:02 ganymed
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0xfeb72f4)')
called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 826
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x912a20c)',
'Apache2::RequestRec=SCALAR(0xe580080)') called at
/var/www/myhost/rt-3.8.2/bin/webmux.pl line 149 eval {...} at
/var/www/myhost/rt-3.8.2/bin/webmux.pl line 149
RT::Mason::handler('Apache2::RequestRec=SCALAR(0xe580080)') called at -e
line 0 eval {...} at -e line 0
--->8---

---8<---
package RT;
use RT::Config;

Set($rtname , "myhost");
Set($EmailSubjectTagRegex, qr/\Q$rtname\E/i );
Set($Organization , "myhost");
Set($MinimumPasswordLength , "0");
Set($Timezone , 'Europe/Berlin');

Set($DatabaseType , 'mysql');
Set($DatabaseHost   , '');
Set($DatabaseRTHost , '');
Set($DatabasePort , '');
Set($DatabaseUser , 'tasks');
Set($DatabasePassword , 'myhost');
Set($DatabaseName , 'tasks');
Set($UseSQLForACLChecks, '1');

Set($RTAddressRegexp , '^...@lessrain.net$');

Set($CanonicalizeOnCreate, 0);

Set($MailCommand , 'smtp');

Set($SMTPServer, 'mail.lessrain.net');
Set($SMTPDebug, 1);

Set( @Plugins, qw(RT::Authen::ExternalAuth) );

# The order in which the services defined in ExternalSettings
# should be used to authenticate users. User is authenticated
# if successfully confirmed by any service - no more services
# are checked.
Set($ExternalAuthPriority,  [ 'less rain ldap' ]);

# The order in which the services defined in ExternalSettings
# should be used to get information about users. This includes
# RealName, Tel numbers etc, but also whether or not the user
# should be considered disabled.
# Once user info is found, no more services are checked.
Set($ExternalInfoPriority,  [ 'less rain ldap' ]);

# If this is set to true, then the relevant packages will
# be loaded to use SSL/TLS connections. At the moment,
# this just means "use Net::SSLeay;"
Set($ExternalServiceUsesSSLorTLS,0);

# If this is set to 1, then users should be autocreated by RT
# as internal users if they fail to authenticate from an
# external service.
Set($AutoCreateNonExternalUsers,   0 );
###Set($AutoCreate, {Privileged => 1});
# These are the full settings for each external service as a HashOfHashes
# Note that you may have as many external services as you wish. They will
# be checked in the order specified in the Priority directives above.
# e.g.
#   Set(ExternalAuthPriority,['less rain
ldap','My_MySQL','My_Oracle','SecondaryLDAP','Other-DB']);
#


Set($ExternalSettings, 
{  
'less rain ldap'   =>  {   ## GENERIC SECTION
   # The type of service (db/ldap/cookie)
  'type'  =>  'ldap',
  # Should the service be used for authentication?
  'auth'  =>  1,
  # Should the service be used for information?
  'info'  =>  1,
  # The server hosting the service
  'server'=>  'localhost',
  ## SERVICE-SPECIFIC SECTION
  # If you can bind to your LDAP server anonymously you should
  # remove the user and pass config lines, otherwise specify them here:
  #
  # The username RT should use to connect to the LDAP server
  'user'  =>  'username',
  # The password RT should use to connect to the LDAP server
  'pass'=>  'password',
  #
  # The LDAP search base
  'base'  =>  'ou=People,...',
  #
  # ALL FILTERS MUST BE VALID LDAP FILTERS ENCASED IN PARENTHESES!
  # YOU **MUST** SPECIFY A filter AND A d_filter!!
  #
  # The filter to use to match RT-Users
  'filter'=> 

[rt-users] Database size management

[Calvin Chiang]

Hi All,

I've got a RT 3.6 install. Approx 20 users, and a database size of about 
500MB.
It looks like i'm adding 25MB of data per week.. so it's growing quite a 
bit faster than i'd like.

Any recommendations for data that i should look at stripping out of the 
database? or do people archive their databases? if you do is it pretty 
easy to bring them back online again if need be?

Cheers,

-- 
Calvin Chiang
Network Admin
Utilyx
1st Floor, 55 North Wharf Road
Paddington
London, W2 1LA
Tel: 020 7087 8673
www.utilyx.com


__
"Utilyx" is the trading name of "Utilyx Limited" and "Utilyx Risk Management 
Limited" (URML). URML is authorised and regulated by the Financial Services 
Authority (FSA). This message contains information that may be privileged or 
confidential and is the property of Utilyx. It is intended only for the person 
to whom it is addressed. No confidentiality or privilege is waived or lost by 
any mistransmission. Any views or opinions expressed in this message are solely 
those of the author and do not necessarily represent those of Utilyx. Unless 
otherwise stated, any pricing information given in this message is indicative 
only and does not constitute an offer to deal at any price quoted. If you are 
not the intended recipient, you are not authorized to read, print, retain, 
copy, disseminate, distribute or use this message or any part thereof. If you 
receive this message in error, please notify the sender immediately and delete 
all copies of this message.
__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

[rt-users] Another question about importing RT2 to RT3

[Joseph Spenner]

I've been having pretty good success with my import, but am curious about the 
'incremental' update.  In the README, it states:

===
rt-2.0-to-dumpfile NEWDIRNAME since 2003-01-01 

 (replace that date with the date before the initial export)

Then execute:

dumpfile-to-rt-3.0 NEWDIRNAME
===

What if there is overlap?  Is it best to go with a little overlap, to make sure 
you don't miss anything?  (ie: if the original dump wasn't done on exactly 
00:00:00 of a particular day, there would either be overlap or a gap, wouldn't 
there?)




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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

[rt-users] query builder page display problems: firefox 3.0.5

[jmoseley]

I have tried other versions of Firefox, and IE 7 seems to work fine, but
when the query builder page is viewed from Firefox 3.0.5, the Saved
searches box overlaps the Current search: box.  If I minimize the Saved
searches box, then I can see the Current search box:.  Minor annoyance I
thought I would pass along.


James Moseley


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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

[rt-users] RT not sending email

[Andreas Heinlein]

Hello,

I need your help debugging RTs mail system.

I have had RT send emails successfully when replying to or creating new
tickets. As such, the mail system is working. I have fiddled with the
global scrips to invoke some more mails, i.e. on owner change. But now
somehow, RT does not send any mail at all.

I am not sure if this has to do with the scrips at all. In any case,
when you reply to a ticket, no recipients are shown at the bottom (Below
"...mail will be sent to the following users..."), and no mail is sent
on reply. Dito when entering someone as Cc: or AdminCc: for a ticket,
both for the whole ticket and one-time when replying. In all cases, RT
claims "Outgoing message recorded" after saving changes, but the ticket
display does not show any outgoing mail (I have the "ShowOutgoingMail"
right).

>From the mail server logs I can see that no attempt to send mail is
done. From syslog, I see "RT::User::CanonicalizeEmailAddress called with
"" from RT::Ticket". I checked the user account settings, and alle users
have valid working mail addresses associated with them.

I am using RT 3.6 on debian etch with the packages from the etch
repository. I do not want to upgrade to 3.8 at the moment.

Thank you,
Andreas
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Programatically creating tickets with specific idnumbers

[Matthew Seaman]

Steffen Tronstad wrote:

You can just alter the table to start auto_increment from a higher number...
So that RT starts from 18001->

Very easy to do with phpMyAdmin



Yeah -- I'll need to do something like that after I've got all the legacy 
stuff imported.  We'll probably start using RT live with ticket 2 or 
so, just so it's obvious what came from where.


Cheers,

Matthew

--
Dr Matthew SeamanThe Bunker, Ash Radar Station
PGP: 0x60AE908C on servers   Marshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK



signature.asc
Description: OpenPGP digital signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Happy new year....and a really stupid question i think

[Ham MI-ID, Torsten Brumm]

Hi Joop,

thanks for your answer. Just cross checked: 

RT::rtname  rt3dev-messenger.int.kn 

And the same result: Couldn't resolve 'at://rt3dev-messenger.int.kn/asset/1' 
into a URI.

Something went wrong in my head :-(

Torsten 


Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), 
Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, 
Christian Marnetté (Stellv.),  Mark Reinhardt (Stellv.), Jens Wollesen, Rainer 
Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 
812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: 
Contern/Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne


-Ursprüngliche Nachricht-
Von: Joop [mailto:joopvandew...@mococo.nl] 
Gesendet: Montag, 19. Januar 2009 13:49
An: Ham MI-ID, Torsten Brumm
Cc: RT Users
Betreff: Re: [rt-users] Happy new yearand a really stupid question i think

Ham MI-ID, Torsten Brumm wrote:
> Dear RT Users,
> this is my first day at work this year and it looks like my brain is still on 
> holiday. I'm trying to link from a ticket to an RTFM Article manually and the 
> same need i have against an asset, but i can't remember the correct syntaxt 
> anymore...!
>
> I tried this from a ticket to a asset: RefersTo: 
> at://rt3dev-messenger.int.kn/asset/1 it end up with: Couldn't resolve 
> 'at://rt3dev-messenger.int.kn/asset/1' into a URI.
Should work, that is, if your $rtname is rt3dev-messenger.int.kn. To me it 
looks like you used your servers DNS name instead of $rtname.
(example for my system: dns=rt3test.mococo.nl $rtname=mococo.nl -->
at://mococo.nl/asset/1)

Greetings,

Joop


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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Happy new year....and a really stupid question i think

[Joop]

Ham MI-ID, Torsten Brumm wrote:
> Dear RT Users,
> this is my first day at work this year and it looks like my brain is still on 
> holiday. I'm trying to link from a ticket to an RTFM Article manually and the 
> same need i have against an asset, but i can't remember the correct syntaxt 
> anymore...!
>
> I tried this from a ticket to a asset: RefersTo: 
> at://rt3dev-messenger.int.kn/asset/1 it end up with: Couldn't resolve 
> 'at://rt3dev-messenger.int.kn/asset/1' into a URI.
Should work, that is, if your $rtname is rt3dev-messenger.int.kn. To me 
it looks like you used your servers DNS name instead of $rtname.
(example for my system: dns=rt3test.mococo.nl $rtname=mococo.nl --> 
at://mococo.nl/asset/1)

Greetings,

Joop

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Programatically creating tickets with specific id numbers

[Matthew Seaman]

Dominic Hargreaves wrote:

On Mon, Jan 19, 2009 at 10:22:16AM +, Matthew Seaman wrote:




If anyone can point me towards examples on the Net of code for doing this
sort of migration I'd be grateful.



You might find that there is inspiration to be drawn from
dumpfile-to-rt-3.0, part of RT::Extension::RT2toRT3 available on CPAN.


Excellent.  That's exactly what I need.

Thank you very much

Matthew

--
Dr Matthew SeamanThe Bunker, Ash Radar Station
PGP: 0x60AE908C on servers   Marshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK



signature.asc
Description: OpenPGP digital signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

[rt-users] Happy new year....and a really stupid question i think

[Ham MI-ID, Torsten Brumm]

Dear RT Users,
this is my first day at work this year and it looks like my brain is still on 
holiday. I'm trying to link from a ticket to an RTFM Article manually and the 
same need i have against an asset, but i can't remember the correct syntaxt 
anymore...!

I tried this from a ticket to a asset: RefersTo: 
at://rt3dev-messenger.int.kn/asset/1 it end up with: Couldn't resolve 
'at://rt3dev-messenger.int.kn/asset/1' into a URI.

Sorry to be annoying, but i'm really lost in space at the moment.

Thanks for your Help.

Torsten

Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), 
Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, 
Christian Marnetté (Stellv.),  Mark Reinhardt (Stellv.), Jens Wollesen, Rainer 
Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 
812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: 
Contern/Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne



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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Day of the week

[Tomáš Sára]

Thank you everybody for your help. This:

  my $dayOfWeek = POSIX::strftime ("%A", localtime );
  $RT::Logger->debug("Day of Week is : $dayOfWeek ");

works fine. I had a stupid error there,
Tom.

Micah Gersten napsal(a):
> This might be what you're looking for:
> http://search.cpan.org/~stbey/Date-Calc-5.4/Calc.pod
>
> Thank you,
> Micah Gersten
> onShore Networks
> Internal Developer
> http://www.onshore.com
>
>
>
> Tomáš Sára wrote:
>   
>> Hello everybody,
>>
>> is there a possibility to find out the day of the week out of the date? 
>> I sopose there should be a perl function for this. Am I right? I 
>> searched mailing lists but I didn't find any information there.
>>
>> Thanks in advance for any help,
>> Tom.
>>   
>> 
>
>   

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

[rt-users] Sorting in Dashboard searches

[Marco Dieckhoff]

Hi!

I have some searches put in a dashboard for quick access.
If I click on the dashboard link, I can't click on the table headers for
sorting.

That only works on direct search results, so I have to click edit and
show results to get a table where I can click on the headers for sorting.

Is there any way to either enable sorting on dashboard link outputs, or
put the search "show result" link into the dashboard instead of the
dashboard search link?

Thank you for any advice,
Marco

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

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Programatically creating tickets with specific idnumbers

[Steffen Tronstad]

You can just alter the table to start auto_increment from a higher number...
So that RT starts from 18001->

Very easy to do with phpMyAdmin


Med vennlig hilsen / with kind regards 
Steffen Tronstad 
BroadPark Games drift/design 
NextGenTel AS, part of TeliaSonera Group 
Tlf: +47 466 988 46
Mail: s...@nextgentel.com  
 please don't print this e-mail unless you really need to. 


-Opprinnelig melding-
Fra: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] På vegne av Dominic Hargreaves
Sendt: 19. januar 2009 11:53
Til: rt-users@lists.bestpractical.com
Emne: Re: [rt-users] Programatically creating tickets with specific idnumbers

On Mon, Jan 19, 2009 at 10:22:16AM +, Matthew Seaman wrote:
> We're in the process of migrating to RT from an ancient ticketing system.
> I'd like to load our existing database of around 18,000 tickets into RT -- 
> which seems eminently do-able using a bit of perl scripting.  Except for 
> one thing: is it possible to set ticket ID numbers programatically?  As 
> far as I can tell the ticket id is derived from an autoincrement value in 
> one of the DB tables and there's no api for choosing a specific value. 
> Which makes it rather hard to preserve the existing ticket ID numbers.
> 
> If anyone can point me towards examples on the Net of code for doing this
> sort of migration I'd be grateful.

You might find that there is inspiration to be drawn from
dumpfile-to-rt-3.0, part of RT::Extension::RT2toRT3 available on CPAN.

-- 
Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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: sa...@bestpractical.com


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

Re: [rt-users] Programatically creating tickets with specific id numbers

[Dominic Hargreaves]

On Mon, Jan 19, 2009 at 10:22:16AM +, Matthew Seaman wrote:
> We're in the process of migrating to RT from an ancient ticketing system.
> I'd like to load our existing database of around 18,000 tickets into RT -- 
> which seems eminently do-able using a bit of perl scripting.  Except for 
> one thing: is it possible to set ticket ID numbers programatically?  As 
> far as I can tell the ticket id is derived from an autoincrement value in 
> one of the DB tables and there's no api for choosing a specific value. 
> Which makes it rather hard to preserve the existing ticket ID numbers.
> 
> If anyone can point me towards examples on the Net of code for doing this
> sort of migration I'd be grateful.

You might find that there is inspiration to be drawn from
dumpfile-to-rt-3.0, part of RT::Extension::RT2toRT3 available on CPAN.

-- 
Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

[rt-users] Programatically creating tickets with specific id numbers

[Matthew Seaman]

Dear all,

We're in the process of migrating to RT from an ancient ticketing system.
I'd like to load our existing database of around 18,000 tickets into RT -- 
which seems eminently do-able using a bit of perl scripting.  Except for 
one thing: is it possible to set ticket ID numbers programatically?  As 
far as I can tell the ticket id is derived from an autoincrement value in 
one of the DB tables and there's no api for choosing a specific value. 
Which makes it rather hard to preserve the existing ticket ID numbers.


If anyone can point me towards examples on the Net of code for doing this
sort of migration I'd be grateful.

Cheers,

Matthew


--
Dr Matthew SeamanThe Bunker, Ash Radar Station
PGP: 0x60AE908C on servers   Marshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK



signature.asc
Description: OpenPGP digital signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Day of the week

[Micah Gersten]

This might be what you're looking for:
http://search.cpan.org/~stbey/Date-Calc-5.4/Calc.pod

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



Tomáš Sára wrote:
> Hello everybody,
>
> is there a possibility to find out the day of the week out of the date? 
> I sopose there should be a perl function for this. Am I right? I 
> searched mailing lists but I didn't find any information there.
>
> Thanks in advance for any help,
> Tom.
>   
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Day of the week

[Matthew Seaman]

Tomáš Sára wrote:
This shows no errors but instead of writing the day of the week into log 
file it writes "0". I'm not sure what "localtime" is. Is it the variable 
containing the local time? Something like:

  my $localtime = my $now = RT::Date->new($RT::SystemUser);
  $now->SetToNow;
Or should I write there just "localhost"? None of this seem to work.


localtime() is a standard perl function that returns the time according to
the local timezone broken down into an array of fields: sec, min, hour,
day etc.  See: 'perldoc -f localtime' for the full story.  There's also
gmtime() which produces the UTC time in the same format.

Either of those two functions takes an optional argument which is a
timestamp expressed as 'seconds since the epoch' a.k.a. unix time --
without an argument they default to the current time.

If you just want to get a timestamp on your log records, then there's
potentially a much simpler method you could use.  Instead of logging
to a file, just use the Unix syslog instead: that will automatically
tag each line with a timestamp.  Something like:

Set($LogToSyslog, 'debug');

(although this seems to be the default already).

Cheers,

Matthew

--
Dr Matthew SeamanThe Bunker, Ash Radar Station
PGP: 0x60AE908C on servers   Marshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK



signature.asc
Description: OpenPGP digital signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


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

Re: [rt-users] Day of the week

[Tomáš Sára]

This shows no errors but instead of writing the day of the week into log 
file it writes "0". I'm not sure what "localtime" is. Is it the variable 
containing the local time? Something like:
  my $localtime = my $now = RT::Date->new($RT::SystemUser);
  $now->SetToNow;
Or should I write there just "localhost"? None of this seem to work.

Do you have any ideas what to do?
Thank a lot,
Tom.

Marouane Himdi napsal(a):
> Sorry
> my $dayOfWeek = POSIX::strftime ("%A", localtime );
> $RT::Logger->debug("Day of Week is : $dayOfWeek ");
>
> Works for me
>
>
> Dr Marouane HIMDI
>
>
> - Mail Original -
> De: "Tomáš Sára" 
> À: rt-users@lists.bestpractical.com
> Envoyé: Vendredi 16 Janvier 2009 14h23:05 GMT +01:00 Amsterdam / Berlin / 
> Berne / Rome / Stockholm / Vienne
> Objet: Re: [rt-users] Day of the week
>
> Unfortunatelly even this does not work. I got this error "Scrip 83 
> Commit failed: syntax error at (eval 2172) line 26, near "strftime "%A"" 
> (/opt/rt3/bin/../lib/RT/Action/UserDefined.pm:80).
>
> Any suggestions.
>
> Thanks, Tom.
>
> Marouane Himdi napsal(a):
>   
>> i think this should work
>>
>> my $dayOfWeek = strftime "%A", localtime;
>>
>>
>>
>> Dr Marouane HIMDI
>>
>>
>> - Mail Original -
>> De: "Tomáš Sára" 
>> À: "Matthew Seaman" 
>> Cc: rt-users@lists.bestpractical.com
>> Envoyé: Vendredi 16 Janvier 2009 11h56:30 GMT +01:00 Amsterdam / 
>> Berlin / Berne / Rome / Stockholm / Vienne
>> Objet: Re: [rt-users] Day of the week
>>
>> Thanks for your answer. What you wrote works fine in shell. I need to 
>> do this in scrip. Is there any possibility?
>>
>> Thanks a lot for any comments,
>> Tom.
>>
>> Matthew Seaman napsal(a):
>> 
>>> Tomáš Sára wrote:
>>>   
 Hello everybody,

 is there a possibility to find out the day of the week out of the 
 date? I sopose there should be a perl function for this. Am I right? 
 I searched mailing lists but I didn't find any information there.

 Thanks in advance for any help,
 
>>> % perl -MPOSIX -le 'print strftime "%A", localtime;'
>>> Friday
>>>
>>> Cheers,
>>>
>>> Matthew
>>>
>>>   
>> ___
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sa...@bestpractical.com
>>
>>
>> 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: sa...@bestpractical.com
>
>
> 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: sa...@bestpractical.com


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

Re: [rt-users] Preselect value

[Tomáš Sára]

Kenn, thanks for your reply.
If you can send some example I would be greatful. Is there any 
possibility to set that value before pressing create button? It would be 
nice if the creator of the ticket is able to see the preselected values 
right after the form with the new ticket is displayed. Is there any 
chance to do that? If not I sill use the action "onCreate".

Thank you for reply,
Tom.

Kenneth Crocker napsal(a):
> Tomas,
>
>
> When did you want this to happen? At create time? Just write a 
> scrip with the condition to when you want it to happen (may have to 
> make this user-defined) and then write an action to set the value of 
> the CF. IF this is the case and you have trouble with the scrip, I 
> have many examples I can send you. If I'm wrong, then ignore my 
> suggestion. :-)
>
>
> Kenn
> LBNL
>
> On 1/16/2009 5:26 AM, Tomáš Sára wrote:
>> Hello,
>> When I was configuring RT system (version 3.8.2) I wanted to 
>> preselect value in Custom Field (type - select one value). Is there a 
>> possibility to do so? I searched mailing lists for answer to this 
>> question but I was not successful in finding the answer.
>>
>> Tahnks in advance for your help,
>> Tom.
>>
>> ___
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sa...@bestpractical.com
>>
>>
>> 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: sa...@bestpractical.com


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