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
--
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
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
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
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
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
_
nts/EditCustomField, CustomField => $CF, NamePrefix =>
"Object-RT::Transaction--CustomField-" &><% $CF->FriendlyType
%>
% }
% }
Thanks!
ALBERTO VILLANUEVA VAL
Consultor
Altran
ParqueEmpresarial Las Mercedes, Ed
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
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
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
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
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
¿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
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
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
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
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
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 : +
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
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.
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 : +
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
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
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
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
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
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
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
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
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
"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
"
** 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
___
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
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
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
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
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
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
&
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
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
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
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
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
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
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,
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
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,
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
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
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
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
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
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
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
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
> 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 :
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
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
;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,
--
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
'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
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
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
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
[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
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á
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
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
68 matches
Mail list logo