[rt-users] Extensiones for reports

Hi, I have searching new plugins for RT to build new reports. do you know where I can obtain them? thanks a lot, ALBERTO VILLANUEVA VAL Consultor Altran Technologies ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34

[rt-users] Modidy Requestor

-- return 1; *** I don't understand "custom condition", and in the "preparation code" I don't know if I have to use all lines... :( :( :( Thanks a lot! -- ALBERTO VILLANUEVA VAL Consultor

[rt-users] Modifying source code

hi, how do I know where source code in PHP (of RT) is? I need to modify it for shwoing new controls in the web page. thanks a lot! ALBERTO VILLANUEVA VAL Consultor Altran Technologies ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022

[rt-users] Status not saved

Hi, I have modified the perl code for customizing RT to my client. But I have a big problem :( :( ->the "status" field not maintain the value. do you know why?? :( :( regards, ALBERTO VILLANUEVA VAL Consultor Altran Technologies Parq

Re: [rt-users] Add a custom status

Hi, I'm doing the same, and I have tried two possibilities but anything has run. When I finish, I'll tell us the solution that I have installed in the production server. Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueE

[rt-users] Add custom fields

Hello, I'm trying to add a custom field in the file "Quick Create", but the CF is a combobox which was created in the user interface. Do you know how I could do it?? Thanks a lot! ALBERTO VILLANUEVA VAL Consultor _

Re: [rt-users] Add custom fields

nts/EditCustomField, CustomField => $CF, NamePrefix => "Object-RT::Transaction--CustomField-" &><% $CF->FriendlyType %> % } % } Thanks! ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Ed

[rt-users] Trying to set an attachment via command line interface

Dear All, I am trying to set an attachment (plain text) from a ticket. I am using the rt command line interface. Thanks for any hint. God bless ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C

Re: [rt-users] RT380: Adding custom Status

This will help you :-) http://wiki.bestpractical.com/view/CustomStatuses Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24

Re: [rt-users] RT380: Adding custom Status

I would try to write the same in the "RT_Config.pm" file, and you should remove these lines of the "RT_SiteConfig.pm" file. And. restart apache Good luck!! Regards, ALBERTO VILLANUEVA VAL Consultor Altran P

Re: [rt-users] RT380: Adding custom Status

I am according of Drew. I have forgotten to say it. Sorry :( Furthermore, Drew's advice appears in the wiki many times. Once I had to do it in the RT_Config.pm file because the server was changed completely :( :( Regards, ALBERTO VILLANUEVA VAL Cons

Re: [rt-users] change Queue order !!!

Order?? You refers to priority?? Or, text in combo?? Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24 57 <h

Re: [rt-users] colorize status

¿Have you tried to colorize using HTML code? :S :S Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24 57 www.altran.es

Re: [rt-users] colorize status

The code was HTML embebed :( :( :(. Get up early is bad :P When I look that code, I will try to suggest something ;) Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel

[rt-users] Remove a ticket

Hi all, I would to remove all tickets, but I don't remove the whole database. Does someone know which the best manner to do that? I have a solution, but I don't know if it's the best: mysql -p use delete * from Transactions; delete * from Tickets; Reg

Re: [rt-users] Remove a ticket

Hi, When I execute the sentence (rt-shredder --force -plugin 'Tickets=status,new'), I get the next error: [warning]: RT::CachedGroupMember-12--- bla,bla,bla I'sorry by the "warning". Any idea?? Thanks a lot! Regards, ALBERTO

Re: [rt-users] Remove a ticket

ON Transactions(ReferenceType, OldReference); CREATE INDEX SHREDDER_TXN2 ON Transactions(ReferenceType, NewReference); CREATE INDEX SHREDDER_TXN3 ON Transactions(Type, OldValue); CREATE INDEX SHREDDER_TXN4 ON Transactions(Type, NewValue); Saludos, ALBERTO VILLANUEVA VAL Consultor

[rt-users] a question about rigths

Hi all!! I have a question: "OwnTicket" right involves "StealTicket"?? Thanks! Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : +

[rt-users] Deleted status

Hi, Does anyone know if a ticket has 'deleted' status it will be deleted permanently? Thanks! Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel

Re: [rt-users] Deleted status

Thanks!! I thought that :) Now, if I want to delete several tickets by id, could it be done on shredder? I doesn't accept queries :( Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1.

Re: [rt-users] Deleted status

I have a possible solution: - Select tickets - Change to "deleted" status - Remove to "shredder" Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : +

Re: [rt-users] a question about rigths

Hi! Thanks by the answer ;) But... I have granted the "take" permission to my users..., and they can steal tickets!! :( :( Any idea? Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo

[rt-users] 500 - Internal error

ction server that it worked fine until 18.30 :-( :-( Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24 57 <http://www.a

Re: [rt-users] 500 - Internal error

23160 090219 20:19:46 [Note] /usr/sbin/mysqld-max: ready for connections. Version: '5.0.51a-Max' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM Thanks! Regards, ALBERTO VILLANUEVA VAL Consultor Altran Parque

Re: [rt-users] a question about rigths

Good morning ;) Yes, I have checked all permissions, and nobody has that. Anyway, I will check them again. Thanks! ;) Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel

[rt-users] Restore root password

oot') called at /usr/lib/perl5/site_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1207 DBIx::SearchBuilder::Record::_LoadFromSQL('RT::User=HASH(0x393a730)', 'SELECT * FROM Users WHERE Name = ?', 'root') called at /usr/lib/perl5/site_perl/5.10.0/DBIx

[rt-users] Users

mmand line)?? thanks! Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24 57 <http://www.altran.es&g

Re: [rt-users] Users

The users table is related to Principals :-) The second question is not necessary because I have had via SQL. Thanks a lot! Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo

Re: [rt-users] a question about rigths

I haven't a solution yet because I'rm restoring a database, but the extension has been installed in my testing environment, and I consider that it's very useful. Thanks a lot! Regards, ALBERTO VILLANUEVA VAL Consultor Altran Parque

Re: [rt-users] 382 Shredder deleting tickets and attachments?

Hi Paul, This link could help you to understand how a ticket must be deleted: http://wiki.bestpractical.com/view/DatabaseAdmin Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022

[rt-users] RT problem or internet conn??

"0,3" :-) My connection to RT goes in the Client's network :S I don't know why RT goes some days slowly :-( :-( Any suggestions?? Any idea?? Regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial La

[rt-users] CSS in source code

" ** I have a table, that it has several rows XD *** I'm using the next: ** Result: the row hasn't got the blue border :-( :-( Any idea? Any file that I have to search in? Best regards, ALBERTO VILLANUEVA VAL Consultor ___

Re: [rt-users] CSS in source code

I have found this link [1] on RT Wiki. Should I do it this way?? [1]: <http://wiki.bestpractical.com/view/CustomizingWithCallbacks> http://wiki.bestpractical.com/view/CustomizingWithCallbacks Regards, ALBERTO VILLANUEVA VAL Con

[rt-users] Masson --> Permission denied

Good morning! On Tuesday our RT server was down. The error is (because I haven't got any correct solution) the next: mkdir /opt/rt3/var/mason_data/obj/2362954981: Permission denied at /usr/lib/perl5/vendor_perl/5.10.0/HTML/Mason/Compiler/ToObject.pm line 107 My mason directory is that, and the g

Re: [rt-users] Masson --> Permission denied

I resolved before Terence answers :), but I'm speaking to my Cliente. They are happy :) My solution was next: Give write permission to ownership group. Best regards, Alberto Terence Monteiro escribió: > Hi, > > On Wed, Mar 25, 2009 at 09:34:04AM +0100, Alberto Villanueva

[rt-users] Question about RT installation

Hi all! I have a stupid question, and I think the answer is simple, but Internet doesn't run well :-( :-( The question is: Is tomcat used by RT? I think it's no, but I have the doubt :-( :-( Thanks a lot! Best regards, ALBERTO VILLANUEVA VAL

Re: [rt-users] Output encoding, Web vs CLI

I did with putty changing the translation to utf8. Best regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24 57 www.altran.es

[rt-users] Mason permissions

ng that. Thanks a lot! Best regards, ALBERTO VILLANUEVA VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24 57 &

[rt-users] Combined charts

Hi all, Do you know if the chart (of Reports) could show several columns of data? PS. I send you an image (with Paint xD) I want to do. Best regards, ALBERTO VILLANUEVA DEL VAL Consultor Altran ParqueEmpresarial Las Mercedes

Re: [rt-users] Combined charts

Thanks jul!! It does something I need, but not all because I have to do graphs with owners ;) I think I'm going to write my own reports :S :S Best regards, ALBERTO VILLANUEVA DEL VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio

Re: [rt-users] Combined charts

Thanks Jesse, but it isn't I want to :( :( Best regards, ALBERTO VILLANUEVA DEL VAL Consultor Altran ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel : + 34 91 744 46 00 Fax: + 34 91 415 24 57 www.altran.es -Me

[rt-users] Replace an attachment

Hi all, In a queue, I'm using for inserting documents (attachments). I'd like to replace a attachment in a RT queue, and I don't want to see all versions. Do you know how I could do this? Is there an extension to do it? Thanks a lot! Best regards, ALBERTO VIL

Re: [rt-users] Urgently need the E-R diagramfor RT schema for 3.8

Hi Uday, The schema for RT 3.4: http://bestpractical.com/rt/3.4-schema.png This tells you how you can generate the schema for your version: http://wiki.bestpractical.com/view/DBSchema Best regards, ALBERTO VILLANUEVA DEL VAL Consultor Altran

[rt-users] Query Customfiels in MySQL

ncipalType from Principals group by PrincipalType) is "Group" or "User". Any idea? Thanks a lot!! Best regards, ALBERTO VILLANUEVA DEL VAL Consultor Altran Technologies ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Mad

[rt-users] RT db schema

Hi, Does someone know the "RECORDS" table?? If I write "show tables" in MySQL, this table doesn't exist. Any idea?? Best regards, ALBERTO VILLANUEVA DEL VAL Consultor Altran Technologies ParqueEmpresarial Las Mercedes,

Re: [rt-users] RT db schema

Then, how do I link Tickets to CustomFields?? :-( :-( Thanks a lot! Best regards, ALBERTO VILLANUEVA DEL VAL Consultor Altran Technologies ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 28022 Madrid Tel: + 34 91 744 46 00 - Ext: 2205 Fax

Re: [rt-users] RT db schema

7;t know if it's easier than. I need to do several queries in MySQL because the different reports tools for RT don't run all queries my Client wants to. So if I get all queries, I'll speak to my boss for developing a perl script to do them :-) > > Regards; > Roy Best regards,

[rt-users] Query about Tickets table

COUNT(id) as 'TOTAL' FROM Tickets WHERE Status = 'resolved'; The result in RT is: 28.536 The result in MySQL is: 28.659 Any idea? Thanks a lot!! Best regards, ALBERTO VILLANUEVA DEL VAL Consultor Altran Technologies ParqueEmpre

[rt-users] Tickets with Owner= (no value)

ssign tickets that they haven't Owner or it's Nobody") Could I tell me how I assign the new owner? Best regards, ALBERTO VILLANUEVA DEL VAL Consultant Altran Technologies ParqueEmpresarial Las Mercedes, Edificio 1 Campezo Street, 1- 28022

Re: [rt-users] HOWTO: add entries to Status field

Hi Michael, You must do this: http://wiki.bestpractical.com/view/ActiveStatus Or also you can do that: http://wiki.bestpractical.com/view/InactiveStatus Best regards, ALBERTO VILLANUEVA DEL VAL Consultant Altran Technologies ParqueEmpresarial

Re: [rt-users] Finding tickets that have never been worked on

Is valid for you the next query? Status != 'resolved' AND Started = 'null' Best regards, Alberto Villanueva Industria __ C/Campezo, 1, Edificio 1, Planta 4 28022 Madrid, Spain Tel : + 34 91 550 41 00 Fax: + 34 91 415 61 53 www.a

Re: [rt-users] Searching for CustomFields

Only I have found that is possible when you use a queue that has the custom fields of that queue. The steps are: 1.- Show results 2.- Edit search --> I can search by custom fields of that queue. Surely I'm doing a huge error :( :( Regards, -- Alberto Villanueva I

[rt-users] Select deleted tickets

Hi all, I'm trying to select the deleted tickets on MySQL, and I don't see nothing :( :( In MySQL, where is the requestor in the tables? Thanks a lot!! -- Alberto Villanueva Industria __ C/Campezo, 1, Edificio 1, Planta 1 (temporalmente) 28

[rt-users] Export "deployment" data

ea? Thanks a lot!! Att, -- Alberto Villanueva Departamento de Industria __ C/Campezo, 1, Edificio 1, Planta 4 28022 Madrid, Spain Tel : + 34 91 550 41 00 Fax: + 34 91 415 61 53 www.altran.es Antes de imprimir este mensaje, asegúrate de que es necesario. P

[rt-users] Perl script against RT database

word); if (!$db) print "Connection unsuccessful. Please check your login credentials. ".$DBI::errstr; # Execute a Query $query = $db->prepare("SELECT EffectiveId FROM Tickets"); $query->execute; # How many rows in result? $numrows = $query->rows; # Clea

Re: [rt-users] Perl script against RT database

> The error is: syntax error at ./query.pl line 13, near ") I have found the solution. the parenthesis were dissapeared :( :( :( Sorry. -- Alberto Villanueva Departamento de Industria __ C/Campezo, 1, Edificio 1, Planta 4 28022 Madrid, Spain Tel :

[rt-users] Download a source code of RT

Good morning, I would like to download a file of the RT source code. The filename is "combobox.js", and the version is "3.8.1". Does a ftp exist where I can download the file? Thanks a lot! Best regards, -- Alberto Villanueva Depar

Re: [rt-users] how to delete tickets in RT

these tickets. also after deletion of > tickets ticket counter no should be reset. > > also kindly help me to change the ticket status menu items like if i want to > rename ticket status "open" to some thing else, where should i apply this > change and how. > &g

[rt-users] Understanding schema of RT

;Any RT::Record" has MANY id in "Principals" table. - Therefore, ONE Creator of "Transactions" has MANY id in "Principals" table. Before I show several queries I have test, I would like to know if my explanation is correct. Thanks a lot! Best regards, --

[rt-users] Query about "Principals" table

s" table used to? I don't understand that table. Any explanation? Thanks a lot! Best regards, -- Alberto Villanueva Industria __ ALTRAN C/Campezo, 1, Edificio 1, Planta 4 28022 Madrid, Spain Tel : + 34 91 550 41 00 Fax: + 34 91 415 61 53 www.altran.es Ant

Re: [rt-users] Query about "Principals" table

't id of user A + 1. Ok. Thanks!! Best regards, -- Alberto Villanueva Industria __ ALTRAN C/Campezo, 1, Edificio 1, Planta 4 28022 Madrid, Spain Tel : + 34 91 550 41 00 Fax: + 34 91 415 61 53 www.altran.es Antes de imprimir este mensaje, asegúrate

Re: [rt-users] Slow Ticket History 3.8.8

gt;> Justin Hayes >>> OpenBet Support Manager >>> justin.ha...@openbet.com <mailto:justin.ha...@openbet.com> >>> >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>> Buy a copy at http://rtbook.best

Re: [rt-users] How to convert ObjectCustomFieldValue content from free form to date

rators_functions.htm - http://psoug.org/reference/convert_func.html - http://psoug.org/reference/date_func.html#dftr An example could be useful: select to_date(' Thanks. Best regards, -- Alberto Villanueva Industria __ ALTRAN C/Campezo, 1, Edificio

Re: [rt-users] RT::Client::REST

would one do it? You could do using MySQL queries. [1]: http://wiki.bestpractical.com/view/REST Best regards, -- Alberto Villanueva Industria __ ALTRAN C/Campezo, 1, Edificio 1, Planta 4 28022 Madrid, Spain Tel : + 34 91 550 41 00 Fax: + 34 91 415 61 53

[rt-users] Remove an attachment

[1]: http://github.com/bestpractical/rt-extension-utils -- Alberto Villanueva Industria __ ALTRAN C/Campezo, 1, Edificio 1, Planta 4 28022 Madrid, Spain Tel : + 34 91 550 41 00 Fax: + 34 91 415 61 53 www.altran.es Antes de imprimir este mensaje, asegúrate

Re: [rt-users] Sending emails issue

Poland -- Alberto Villanueva Industria __ C/Campezo, 1, Edificio 1 28022 Madrid, Spain Tel : + 34 91 550 41 00 Fax: + 34 91 415 61 53 www.altran.es www.altran360.es Antes de imprimir este mensaje, asegúrate de que es necesario. Proteger el medio ambiente está

[rt-users] View as HTML

t =~ s/<(([^ >]|\n)*)>//g; # strip HTML tags from text/html" Do you know how I could resolve this? [1]: http://requesttracker.wikia.com/wiki/AddTicketHistoryToMail Best regards, -- Alberto Villanueva Industria __ C/Campezo, 1, Edificio 1 2802

[rt-users] Help to configure incoming e-mails

he mail configuration or on the connection between the machines. But I don't :-( Could you help me? Thank you very much!! Best regards, -- Alberto VILLANUEVA DEL VAL Consultor Altran España, Industria ___ ALTRAN: talento generando innovación Par