Re: [rt-users] Modifying some contents in History

2016-11-28 Thread Kriegers Horst
Hi Ken,
Thanks for your reply.
It's works like a charm :)

Regards,
Horst

> -Message d'origine-
> De : Kenneth Marshall [mailto:k...@rice.edu]
> Envoyé : lundi 28 novembre 2016 17:09
> À : Kriegers Horst 
> Cc : ML - rt-users 
> Objet : Re: [rt-users] Modifying some contents in History
>
> On Mon, Nov 28, 2016 at 03:43:01PM +, Kriegers Horst wrote:
> > Hi,
> >
> > Thanks for your reply.
> > I know this is the easiest way, but it is not acceptable in our case
> >
> > Regards,
> > Horst
>
> Hi Horst,
>
> When the shredder runs, it generates a SQL file to reconstitute the deleted 
> item
> when run. You could run shredder and then edit the SQL file to obfuscate the
> needed items. Then run the resulting file to re-add the now cleaned up item 
> back
> into the system.
>
> Regards,
> Ken


Note Importante: Le contenu de ce courriel est uniquement réservé à la personne 
ou l'organisme à qui il est destiné. Si vous n'êtes pas le destinataire prévu, 
veuillez nous en informer au plus vite et détruire le présent courriel. Dans ce 
cas, il ne vous est pas permis de copier ce courriel, de le distribuer ou de 
l'utiliser de quelque manière que ce soit.


Important Notice: The content of this e-mail is intended only and solely for 
the use of the named recipient or organization. If you are not the named 
recipient, please inform us immediately and delete the present e-mail. In this 
case, you are not allowed to copy, distribute or use this e-mail in any way.


-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017


Re: [rt-users] Owner not showing in search results?

2016-11-28 Thread Kenneth Marshall
On Mon, Nov 28, 2016 at 11:32:36AM -0500, Alex Hall wrote:
> Thanks, I didn't know that would happen. I did that to suppress the email 
> notification; we want users notified if their tickets change owners, but only 
> if that change is NOT from "nobody" to themselves.
> 
> I just updated the script to record the transaction. It worked, because I got 
> the email I wanted suppressed, and the owner still changed. Oddly, "nobody" 
> is still the owner when I search for my ticket, though. Should I flush a 
> cache or something? Mason cache wouldn't have anything to do with this, would 
> it?

Hi Alex,

Well, that is not what I would have expected to happen. I do not know enough
about the DB queries that are being run to generate the search results. 
Probably,
my next step would be to look at the actual query and see where the incorrect
results are being produced. I am not much help because we use PostgreSQL as
the DB and not MySQL. Sorry, I cannot be of more assistance.

Regards,
Ken
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017


Re: [rt-users] Owner not showing in search results?

2016-11-28 Thread Alex Hall
Thanks, I didn't know that would happen. I did that to suppress the email 
notification; we want users notified if their tickets change owners, but only 
if that change is NOT from "nobody" to themselves.

I just updated the script to record the transaction. It worked, because I got 
the email I wanted suppressed, and the owner still changed. Oddly, "nobody" is 
still the owner when I search for my ticket, though. Should I flush a cache or 
something? Mason cache wouldn't have anything to do with this, would it?
> On Nov 28, 2016, at 11:18, Kenneth Marshall  wrote:
> 
> Hi Alex,
> 
> You do not record your transaction in your scrip. That means that the
> system does not know that a change has been made and to invalidate the
> caches. You will either need to record it or live with the result.
> 
> Regards,
> Ken
> 
> On Mon, Nov 28, 2016 at 11:12:00AM -0500, Alex Hall wrote:
 my ($status, $msg) = $self->TicketObj->_Set(Field => 'Owner', Value =>
 $Actor, RecordTransaction => 0);
> 
> This should be 1, not 0 to record the transaction and that should flush
> the cached info.
> 

-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017


Re: [rt-users] Owner not showing in search results?

2016-11-28 Thread Kenneth Marshall
Hi Alex,

You do not record your transaction in your scrip. That means that the
system does not know that a change has been made and to invalidate the
caches. You will either need to record it or live with the result.

Regards,
Ken

On Mon, Nov 28, 2016 at 11:12:00AM -0500, Alex Hall wrote:
> >> my ($status, $msg) = $self->TicketObj->_Set(Field => 'Owner', Value =>
> >> $Actor, RecordTransaction => 0);

This should be 1, not 0 to record the transaction and that should flush
the cached info.

-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017


Re: [rt-users] Modifying some contents in History

2016-11-28 Thread Kenneth Marshall
On Mon, Nov 28, 2016 at 03:43:01PM +, Kriegers Horst wrote:
> Hi,
> 
> Thanks for your reply.
> I know this is the easiest way, but it is not acceptable in our case
> 
> Regards,
> Horst

Hi Horst,

When the shredder runs, it generates a SQL file to reconstitute the
deleted item when run. You could run shredder and then edit the SQL
file to obfuscate the needed items. Then run the resulting file to
re-add the now cleaned up item back into the system.

Regards,
Ken
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017


Re: [rt-users] Owner not showing in search results?

2016-11-28 Thread Alex Hall
I just wondered if anyone had any more thoughts on this problem. We just
set up email dashboards, and they're doing the same thing search results
do; owners are often set to 'nobody', but if you go into the ticket, the
real owner is shown. Since dashboards and searches use the same display, or
seem to, I'm not surprised. But seeing that reminded me that this is still
a problem we'd like to get fixed if possible. As I mentioned before, I've
made no changes to the search results pages, and the problem appears to be
when the owner is set via our script to auto-assign the requestor as the
owner. The owner is set correctly if you view the ticket, but not if that
ticket appears in a search results page. Thanks.

On Fri, Nov 18, 2016 at 9:18 AM, Alex Hall  wrote:

> We always leave it at the default. I did a search for "queue:technology",
> and here's the format it uses:
>
>'__id__
> /TITLE:#',
>'__
> Subject__/TITLE:Subject',
>Status,
>QueueName,
>Owner,
>Priority,
>'__NEWLINE__',
>'__NBSP__',
>'__Requestors__',
>'__CreatedRelative__',
>'__ToldRelative__',
>'__LastUpdatedRelative__',
>'__TimeLeft__'
>
> On Fri, Nov 18, 2016 at 9:03 AM, Sinapius, Vinzenz <
> vinzenz.sinap...@tracetronic.de> wrote:
>
>> Hi Alex,
>>
>>
>>
>> What is the Format-String of your search? (It’s under the advanced tab,
>> when you edit the search)
>>
>>
>>
>> The scrip looks fine.
>>
>>
>>
>> Cheers,
>>
>> Vinzenz
>>
>> Vinzenz Sinapius
>> Information Technology | Informationstechnik
>>
>> *trace**tronic* GmbH
>> Stuttgarter Str. 3
>> 01189 DRESDEN
>> GERMANY
>>
>> Phone: +49 351 205768-167
>> Fax: +49 351 205768-999
>> E-mail: vinzenz.sinap...@tracetronic.de
>>
>> Head Office | Hauptsitz: Stuttgarter Str. 3, 01189 DRESDEN, GERMANY
>> Managing Directors | Geschäftsführer: Dr.-Ing. Rocco Deutschmann,
>> Dr.-Ing. Peter Strähle
>> Registration Court | Registergericht: Amtsgericht Dresden, HRB 23 086
>>
>>
>>
>> *Von:* rt-users [mailto:rt-users-boun...@lists.bestpractical.com] *Im
>> Auftrag von *Alex Hall
>> *Gesendet:* Freitag, 18. November 2016 14:29
>> *An:* rt-users 
>> *Betreff:* [rt-users] Owner not showing in search results?
>>
>>
>>
>> Hi all,
>>
>> We have an odd problem. I've put a script in place that sets the
>> requestor of a ticket to be its owner, and that works perfectly when
>> viewing a ticket--the owner is shown as the requestor. The problem is that
>> search results show most tickets as being owned by nobody, but if you click
>> a ticket, you see the owner has actually been set as expected. It's just
>> search results that don't want to show the owner.
>>
>> I found this script on the Wiki, and don't know enough about RT's
>> internals to say if it does everything it should. Does anyone see any
>> possible problems with it that would cause the issue with search results?
>>
>>
>> # get actor ID
>> my $Actor = $self->TransactionObj->Creator;
>> #if actor is RT_SystemUser then get out of here
>> return 1 if $Actor == $RT::SystemUser->id;
>> #prevents a ticket being assigned to an unprivileged user, comment out if
>> you want this
>> return 1 unless $self->TransactionObj->CreatorObj->Privileged;
>> #get out unless ticket owner is nobody
>> return 1 unless $self->TicketObj->Owner == $RT::Nobody->id;
>> #try to change owner
>> $RT::Logger->info("Auto assign ticket #". $self->TicketObj->id ." to user
>> #". $Actor );
>> my ($status, $msg) = $self->TicketObj->_Set(Field => 'Owner', Value =>
>> $Actor, RecordTransaction => 0);
>> unless( $status ) {
>> $RT::Logger->error( "Impossible to assign the ticket to $Actor: $msg"
>> );
>> return undef;
>> }
>>
>> return 1;
>>
>>
>> --
>>
>> Alex Hall
>>
>> Automatic Distributors, IT department
>>
>> ah...@autodist.com
>>
>> -
>> RT 4.4 and RTIR training sessions, and a new workshop day!
>> https://bestpractical.com/training
>> * Los Angeles - January 9-11 2017
>>
>
>
>
> --
> Alex Hall
> Automatic Distributors, IT department
> ah...@autodist.com
>



-- 
Alex Hall
Automatic Distributors, IT department
ah...@autodist.com
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017

Re: [rt-users] Modifying some contents in History

2016-11-28 Thread Kriegers Horst
Hi,

Thanks for your reply.
I know this is the easiest way, but it is not acceptable in our case

Regards,
Horst


> -Message d'origine-
> De : Kenneth Marshall [mailto:k...@rice.edu]
> Envoyé : lundi 28 novembre 2016 16:33
> À : Kriegers Horst 
> Cc : ML - rt-users 
> Objet : Re: [rt-users] Modifying some contents in History
>
> Hi,
>
> It is easier to just use the Shredder to delete the transaction from the 
> system.
>
> Regards,
> Ken
>
> On Mon, Nov 28, 2016 at 02:32:17PM +, Kriegers Horst wrote:
> > Hello,
> >
> > We have users they have mentioned confidential information in RT.
> > Now I need just to anonymize these information in the Ticket History.
> >
> > I’ve identified the transaction Id and now I how can I decode et
> > re-encode the Content value located in the Attributes table
> >
> > Example :
> >
> > ConfidentialData  --> xx
> >
> >
> >
> >
> > Our config :
> >
> > -  RT 4.2.12
> >
> > -  MySQL
> >
> >
> >
> > Thanks in advance for your help.
> > Horst
> >
> >
> > 
> > Note Importante: Le contenu de ce courriel est uniquement réservé à la 
> > personne
> ou l'organisme à qui il est destiné. Si vous n'êtes pas le destinataire 
> prévu, veuillez
> nous en informer au plus vite et détruire le présent courriel. Dans ce cas, 
> il ne vous
> est pas permis de copier ce courriel, de le distribuer ou de l'utiliser de 
> quelque
> manière que ce soit.
> >
> > 
> > Important Notice: The content of this e-mail is intended only and solely 
> > for the
> use of the named recipient or organization. If you are not the named 
> recipient,
> please inform us immediately and delete the present e-mail. In this case, you 
> are
> not allowed to copy, distribute or use this e-mail in any way.
> >
> > 
>
> > -
> > RT 4.4 and RTIR training sessions, and a new workshop day!
> > https://bestpractical.com/training
> > * Los Angeles - January 9-11 2017



Note Importante: Le contenu de ce courriel est uniquement réservé à la personne 
ou l'organisme à qui il est destiné. Si vous n'êtes pas le destinataire prévu, 
veuillez nous en informer au plus vite et détruire le présent courriel. Dans ce 
cas, il ne vous est pas permis de copier ce courriel, de le distribuer ou de 
l'utiliser de quelque manière que ce soit.


Important Notice: The content of this e-mail is intended only and solely for 
the use of the named recipient or organization. If you are not the named 
recipient, please inform us immediately and delete the present e-mail. In this 
case, you are not allowed to copy, distribute or use this e-mail in any way.


-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017

[rt-users] Disable RSS

2016-11-28 Thread Tobias W .
Hello,

Is there a way to disable RSS ?

On the RT_SiteConfig ?

Thank you,
Tobi


-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017

Re: [rt-users] Modifying some contents in History

2016-11-28 Thread Kenneth Marshall
Hi,

It is easier to just use the Shredder to delete the transaction
from the system.

Regards,
Ken

On Mon, Nov 28, 2016 at 02:32:17PM +, Kriegers Horst wrote:
> Hello,
> 
> We have users they have mentioned confidential information in RT.
> Now I need just to anonymize these information in the Ticket History.
> 
> I’ve identified the transaction Id and now I how can I decode et re-encode 
> the Content value located in the Attributes table
> 
> Example :
> 
> ConfidentialData  --> xx
> 
> 
> 
> 
> Our config :
> 
> -  RT 4.2.12
> 
> -  MySQL
> 
> 
> 
> Thanks in advance for your help.
> Horst
> 
> 
> 
> Note Importante: Le contenu de ce courriel est uniquement réservé à la 
> personne ou l'organisme à qui il est destiné. Si vous n'êtes pas le 
> destinataire prévu, veuillez nous en informer au plus vite et détruire le 
> présent courriel. Dans ce cas, il ne vous est pas permis de copier ce 
> courriel, de le distribuer ou de l'utiliser de quelque manière que ce soit.
> 
> 
> Important Notice: The content of this e-mail is intended only and solely for 
> the use of the named recipient or organization. If you are not the named 
> recipient, please inform us immediately and delete the present e-mail. In 
> this case, you are not allowed to copy, distribute or use this e-mail in any 
> way.
> 
> 

> -
> RT 4.4 and RTIR training sessions, and a new workshop day! 
> https://bestpractical.com/training
> * Los Angeles - January 9-11 2017

-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017

Re: [rt-users] Emailing dashboards?

2016-11-28 Thread Barton Chittenden
Alex,

Navigate to Home > All dashboards, and go to the dashboard you want to
receive emails about.

In the upper right hand corner, you'll see the following menus:

Basics, Content, Subscription, Show.

Click 'Subscription', and you'll be prompted for frequency, time, rowsn and
recipients.

The one caveat here is that it's possible to add a subscription to a person
or group that they can't un-subscribe from, so be courteous about that.

--Barton





On Wed, Nov 23, 2016 at 4:56 PM, Alex Hall  wrote:

> Hi all,
> I know RT can automatically email dashboards to specific users. I've just
> not sure how to set this up. I found one list of dashboards where a
> "subscription" column was present in the table, but it only listed a
> single, global dashboard and not those for a given user. I've been through
> users and settings, but didn't find it. This must be obvious, but where
> would I tell users to go to set up subscriptions to their custom
> dashboards? I just want certain users to get emails once a day with the
> content of a specific saved search. Thanks!
>
> --
> Alex Hall
> Automatic Distributors, IT department
> ah...@autodist.com
>
> -
> RT 4.4 and RTIR training sessions, and a new workshop day!
> https://bestpractical.com/training
> * Los Angeles - January 9-11 2017
>
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017

[rt-users] Modifying some contents in History

2016-11-28 Thread Kriegers Horst
Hello,

We have users they have mentioned confidential information in RT.
Now I need just to anonymize these information in the Ticket History.

I’ve identified the transaction Id and now I how can I decode et re-encode the 
Content value located in the Attributes table

Example :

ConfidentialData  --> xx




Our config :

-  RT 4.2.12

-  MySQL



Thanks in advance for your help.
Horst



Note Importante: Le contenu de ce courriel est uniquement réservé à la personne 
ou l'organisme à qui il est destiné. Si vous n'êtes pas le destinataire prévu, 
veuillez nous en informer au plus vite et détruire le présent courriel. Dans ce 
cas, il ne vous est pas permis de copier ce courriel, de le distribuer ou de 
l'utiliser de quelque manière que ce soit.


Important Notice: The content of this e-mail is intended only and solely for 
the use of the named recipient or organization. If you are not the named 
recipient, please inform us immediately and delete the present e-mail. In this 
case, you are not allowed to copy, distribute or use this e-mail in any way.


-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017