Re: [rt-users] Can't load UntouchedInHours module

2013-08-30 Thread Dominic Hargreaves
On Thu, Aug 29, 2013 at 05:39:33PM +, Elliott, Kevin C (DOR) wrote:

 root@DorJnuASD-RT:~/Bin# ls -la /usr/share/request-tracker4/lib/RT/Condition/
 total 60
 drwxr-xr-x  2 root root 4096 Aug 29 09:24 .
 drwxr-xr-x 17 root root 4096 Jun 11 11:27 ..
 -rw-r--r--  1 root root 2247 May 22 09:49 AnyTransaction.pm
 -rw-r--r--  1 root root 2742 May 22 09:49 BeforeDue.pm
 -rw-r--r--  1 root root 2677 May 22 09:49 CloseTicket.pm
 -rw-r--r--  1 root root 2475 May 22 09:49 Overdue.pm
 -rw-r--r--  1 root root 2351 May 22 09:49 OwnerChange.pm
 -rw-r--r--  1 root root 2356 May 22 09:49 PriorityChange.pm
 -rw-r--r--  1 root root 2325 May 22 09:49 PriorityExceeds.pm
 -rw-r--r--  1 root root 2306 May 22 09:49 QueueChange.pm
 lrwxrwxrwx  1 root root9 Aug 29 08:37 RCS - /root/RCS
 -rw-r--r--  1 root root 2829 May 22 09:49 ReopenTicket.pm
 -rw-r--r--  1 root root 4593 May 22 09:49 StatusChange.pm
 -rw-r--r--  1 root root  800 Aug 29 09:23 UntouchedInHours.pm
 -rw-r--r--  1 root root 2458 May 22 09:49 UserDefined.pm

Hi,

Probably not related to your problem, but I really recommend not
putting locally installed files in /usr/share as that space is
reserved for the package manager (dpkg) and you could end up with
overwritten files there (plus it's difficult to see what came from
where).

/usr/local/share/request-tracker4/lib exists for this purpose so you
could move that file into
/usr/local/share/request-tracker4/lib/RT/Condition/

Cheers,
Dominic.

-- 
Dominic Hargreaves, Systems Development and Support Section
IT Services, University of Oxford, 13 Banbury Road, Oxford, OX2 6NN


signature.asc
Description: Digital signature


Re: [rt-users] Show History on Update Page

2013-08-30 Thread Ruslan Zakirov
Hi,

Google for clear mason cache request tracker.


On Fri, Aug 30, 2013 at 7:15 AM, Jason Ledford jledf...@biltmore.comwrote:

 I will be honest I am struggling a little bit with this.  I have tried a
 couple different approaches and can't get this to work.  First I just made
 a local copy of history.html and named it MyPage.html and it worked.  I
 then tried to add those elements into a local Update.html page and can't
 get it to show anything additional.  Just for testing I added a simple test
 div just to try and display something extra on the Update page and can't
 get that to work.  I have restarted the server and the mason/obj/folder is
 empty.  What am I doing wrong?  I have read through ticket/display.thml and
 history.html over and over and I feel like I am just overlooking something.
  Perl is new to me and help is most appreciated.  Thanks.
 
 From: ruslan.zaki...@gmail.com [ruslan.zaki...@gmail.com] On Behalf Of
 Ruslan Zakirov [r...@bestpractical.com]
 Sent: Thursday, August 29, 2013 10:48 AM
 To: Jason Ledford
 Cc: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Show History on Update Page

 Hi,

 Grep Ticket/Display.html for History and more importantly take a look at
 Ticket/Hisotry.html file. Work from these examples to embed history in
 Update.html.


 On Thu, Aug 29, 2013 at 5:45 PM, Jason Ledford jledf...@biltmore.com
 mailto:jledf...@biltmore.com wrote:
 I am wanting to customize the update page (reply or resolve) so that the
 History section also shows on the page.  We want to see the ticket history
 to know what we are replying or commenting to.  Can someone assist in
 getting that info on the page?  I have already placed the Update.html in my
 local folder but perl is not my strongsuit.  Taking that a step further, is
 it possible to have the first comment in the reply?  Would that be a
 template change?  Help is appreciated.  Thanks.






 --
 Best regards, Ruslan.




-- 
Best regards, Ruslan.


Re: [rt-users] make fixdeps error

2013-08-30 Thread Ruslan Zakirov
On Thu, Aug 29, 2013 at 6:50 PM, Dewhirst, Rob robdewhi...@gmail.comwrote:

 There's a LOT of output from this script -- how much do you need to make
 it useful?


Something useful. You trimmed a little bit earlier.



 On Thu, Aug 29, 2013 at 9:46 AM, Ruslan Zakirov r...@bestpractical.comwrote:

 You've cut to much of the output. I see that script tries and fails to
 restart itself to get fresh environment. You can run it again yourself, but
 as I said it's not enough of the output to see what's wrong with Plack.


 On Thu, Aug 29, 2013 at 6:16 PM, Dewhirst, Rob robdewhi...@gmail.comwrote:

 I am starting a new install on RHEL6 and getting this error after
 running make fixdeps.


 I've already installed all dependencies via CPAN as best I can tell.  I
 looked at the line generating the error in the script and can't easily tell
 what it's doing.

 Test Summary Report
 ---
 t/01plack-test.t (Wstat: 512 Tests: 0 Failed: 0)
   Non-zero exit status: 2
   Parse errors: No plan found in TAP output
 t/02graceful.t   (Wstat: 512 Tests: 0 Failed: 0)
   Non-zero exit status: 2
   Parse errors: No plan found in TAP output
 t/03post.t   (Wstat: 512 Tests: 0 Failed: 0)
   Non-zero exit status: 2
   Parse errors: No plan found in TAP output
 t/04-bumpy-life.t(Wstat: 512 Tests: 0 Failed: 0)
   Non-zero exit status: 2
   Parse errors: No plan found in TAP output
 t/05server-header.t  (Wstat: 512 Tests: 0 Failed: 0)
   Non-zero exit status: 2
   Parse errors: No plan found in TAP output
 t/06harakiri.t   (Wstat: 512 Tests: 0 Failed: 0)
   Non-zero exit status: 2
   Parse errors: No plan found in TAP output
 t/07remote_port.t(Wstat: 512 Tests: 0 Failed: 0)
   Non-zero exit status: 2
   Parse errors: No plan found in TAP output
 t/08chunked_req.t(Wstat: 512 Tests: 0 Failed: 0)
   Non-zero exit status: 2
   Parse errors: No plan found in TAP output
 t/09chunked_zero_length.t (Wstat: 512 Tests: 0 Failed: 0)
   Non-zero exit status: 2
   Parse errors: No plan found in TAP output
 Files=10, Tests=1,  0 wallclock secs ( 0.02 usr  0.03 sys +  0.44 cusr
  0.08 csys =  0.57 CPU)
 Result: FAIL
 Failed 9/10 test programs. 0/1 subtests failed.
 make[1]: *** [test_dynamic] Error 2
 make[1]: Leaving directory `/root/.cpan/build/Starlet-0.20-Cis82r'
   KAZUHO/Starlet-0.20.tar.gz
   /usr/bin/make test -- NOT OK
 //hint// to see the cpan-testers results for installing this module, try:
   reports KAZUHO/Starlet-0.20.tar.gz
 Warning (usually harmless): 'YAML' not installed, will not store
 persistent state
 Running make install
   make test had returned bad status, won't install without force
 SMTP dependencies:
 Net::SMTP ...found
 USERLOGO dependencies:
 Convert::Color ...found
 Can't exec ./sbin/rt-test-dependencies: No such file or directory at
 ./sbin/rt-test-dependencies line 419.





 --
 Best regards, Ruslan.





-- 
Best regards, Ruslan.


Re: [rt-users] rt-validator does not delete osbolete ObjectCustomFieldValue records

2013-08-30 Thread Ruslan Zakirov
Hi,

Do you care enough to send patch or git pull request? If not then file a
feature request on http://issues.bestpractical.com .


On Thu, Aug 29, 2013 at 5:18 PM, David Moreau Simard dmsim...@iweb.comwrote:

 Hi,

 We're trying to do a large cleanup of our database. There are a lot of
 obsolete ObjectCustomFieldValue records that are related to deleted tickets.
 I would expect rt-validator to both delete related Transactions AND The
 ObjectCustomFieldValue records themselves.

 This is not happening, although it does detect issues - for example:
 ===
 Record #33716942 in ObjectCustomFieldValues references a nonexistent
 record in Tickets
 ObjectId = '6417200' = id
 ===
 Record #1 in ObjectCustomFieldValues references a nonexistent record in
 Transactions
 ObjectId = '8651463' = id
 ===

 After spending a lot on time on this, I came to realize that the sub in
 rt-validator for custom fields integrity does not use delete_record at all.

 Example that uses delete_record:
 ===
 push @CHECKS, 'Tickets - Role Groups' = sub {
 # XXX: we check only that there is at least one group for a queue
 # from queue to group
 check_integrity(
 'Tickets', 'id' = 'Groups', 'Instance',
 join_condition   = 't.Domain = ?',
 bind_values = [ 'RT::Ticket-Role' ],
 );
 # from group to ticket
 check_integrity(
 'Groups', 'Instance' = 'Tickets', 'id',
 condition   = 's.Domain = ?',
 bind_values = [ 'RT::Ticket-Role' ],
 action = sub {
 my $id = shift;
 return unless prompt(
 'Delete', Found a role group of a nonexistent ticket.
 );

 delete_record( 'Groups', $id );
 },
 );
 };
 ===

 Now, custom field checks are done this way, without delete_record:
 ===
 push @CHECKS, 'CustomFields and friends' = sub {
 #XXX: ObjectCustomFields needs more love
 check_integrity(
 'CustomFieldValues', 'CustomField' = 'CustomFields', 'id',
 );
 check_integrity(
 'ObjectCustomFieldValues', 'CustomField' = 'CustomFields', 'id',
 );
 foreach my $model ( @models ) {
 check_integrity(
 'ObjectCustomFieldValues', 'ObjectId' = m2t($model), 'id',
 condition   = 's.ObjectType = ?',
 bind_values = [ RT::$model ],
 );
 }
 };
 ===

 I'm not entirely safe with putting a delete_record somewhere in there.

 Can someone chime in about what would be my best course of action ?

 Thanks,

 David Moreau Simard




-- 
Best regards, Ruslan.


Re: [rt-users] Show History on Update Page

2013-08-30 Thread Jason Ledford
I thought I was clearing the cache, apparently I wasn’t.  Cleared the cache and 
restarted and I have history on my update page.  Thanks for your help.

From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of 
Ruslan Zakirov
Sent: Friday, August 30, 2013 8:23 AM
To: Jason Ledford
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Show History on Update Page

Hi,

Google for clear mason cache request tracker.

On Fri, Aug 30, 2013 at 7:15 AM, Jason Ledford 
jledf...@biltmore.commailto:jledf...@biltmore.com wrote:
I will be honest I am struggling a little bit with this.  I have tried a couple 
different approaches and can't get this to work.  First I just made a local 
copy of history.html and named it MyPage.html and it worked.  I then tried to 
add those elements into a local Update.html page and can't get it to show 
anything additional.  Just for testing I added a simple test div just to try 
and display something extra on the Update page and can't get that to work.  I 
have restarted the server and the mason/obj/folder is empty.  What am I doing 
wrong?  I have read through ticket/display.thml and history.html over and over 
and I feel like I am just overlooking something.  Perl is new to me and help is 
most appreciated.  Thanks.

From: ruslan.zaki...@gmail.commailto:ruslan.zaki...@gmail.com 
[ruslan.zaki...@gmail.commailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan 
Zakirov [r...@bestpractical.commailto:r...@bestpractical.com]
Sent: Thursday, August 29, 2013 10:48 AM
To: Jason Ledford
Cc: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Show History on Update Page

Hi,

Grep Ticket/Display.html for History and more importantly take a look at 
Ticket/Hisotry.html file. Work from these examples to embed history in 
Update.html.

On Thu, Aug 29, 2013 at 5:45 PM, Jason Ledford 
jledf...@biltmore.commailto:jledf...@biltmore.commailto:jledf...@biltmore.commailto:jledf...@biltmore.com
 wrote:
I am wanting to customize the update page (reply or resolve) so that the 
History section also shows on the page.  We want to see the ticket history to 
know what we are replying or commenting to.  Can someone assist in getting that 
info on the page?  I have already placed the Update.html in my local folder but 
perl is not my strongsuit.  Taking that a step further, is it possible to have 
the first comment in the reply?  Would that be a template change?  Help is 
appreciated.  Thanks.





--
Best regards, Ruslan.



--
Best regards, Ruslan.


Re: [rt-users] Global RT at a Glance not taking effect

2013-08-30 Thread Kevin Falcone
On Thu, Aug 29, 2013 at 09:47:56PM +0100, Guy Baxter wrote:
On 29 August 2013 21:37, Kevin Falcone [1]falc...@bestpractical.com 
 wrote:
 
  On Thu, Aug 29, 2013 at 05:34:14PM +0100, Guy Baxter wrote:
   Hi all,
   I've got an issue with RT at a glance global configuration not 
 working. I want only
   Dashboards to be visible on the homepage after a user logs in.
   I've set the following in tools  configuration  Global  RT at a 
 Glance
   RT at a glance body: Dasboards
   RT at a glance: Summary: blank
   When logging in as root this applies fine.
   When logging in as any other users ( we use RT External Auth) it does 
 not apply.
 
  Do these users have their own homepage settings from previous
  use/customization? You will need to reset that, or just clear their
  homepage preferences in the Attributes table in the database.
 
No, they've never been able to set them no permissions to set 
 preferences was the error they
got. How would I go about clearing the homepage preferences anyway?

As the relevant user - Settings - RT at a Glance, although if they
don't have ModifySelf they may not be able to get there and you may
need to go look in the Attributes table for rows with a name of
Pref-HomepageSettings and then use /opt/rt4/sbin/rt-attributes-viewer
with the id of the row to see what user has an override.

-kevin


pgpx4WwJIsajL.pgp
Description: PGP signature


[rt-users] Searching in RT

2013-08-30 Thread Bryon Baker
I have ran into an issue when search for tickets.

I am searching for a number in the subject line when I am doing this RT assumes 
that I am search for a ticket number.  Is there something I can do to change 
this behavior?

I am using version 4.13

Thanks
Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726  *  262-783-6261 ext. 2296
bba...@copesan.commailto:cstep...@copesan.com
www.copesan.comhttp://www.copesan.com/
Servicing North America with Local Care



Re: [rt-users] Can't load UntouchedInHours module

2013-08-30 Thread Elliott, Kevin C (DOR)
That was indeed the issue. Thanks.

 -Original Message-
 From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
 boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
 Sent: Thursday, August 29, 2013 12:35 PM
 To: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Can't load UntouchedInHours module
 
 On Thu, Aug 29, 2013 at 05:39:33PM +, Elliott, Kevin C (DOR) wrote:
 
  [Thu Aug 29 17:32:17 2013] [critical]: Failed to load module
  RT::Condition::UntouchedInHours. () at /usr/bin/rt-crontool line 307.
  (/usr/share/request-tracker4/lib/RT.pm:351)
  Failed to load module RT::Condition::UntouchedInHours. () at /usr/bin/rt-
 crontool line 307.
 
  root@DorJnuASD-RT:~/Bin# cat /usr/share/request-
 tracker4/lib/RT/Condition/UntouchedInHours.pm
 
  package RT::Condition::UntouchedInHours; require
  RT::Condition::Generic;
 
   use RT::Date;
 
 
   @ISA = qw(RT::Condition::Generic);
 
 At the very least, this line is wrong:
 http://bestpractical.com/docs/rt/latest/UPGRADING-4.0.html#Removals-
 and-updates
 
 You want to inherit from RT::Condition.
 
 -kevin
 
   use strict;
   use vars qw/@ISA/;
 
   sub IsApplicable {
   my $self = shift;
 
   if ((time()-$self-TicketObj-LastUpdatedObj-Unix)/3600 =
 $self-Argument) {
  return 1;
   }
   else {
  return 0;
  }
 
   }
 
   # The following could be omitted. They're there to allow overrides
  from Vendor and Local  # but as this isn't a core module, they're just
  there for completeness :)  eval require
  RT::Condition::UntouchedInHours_Vendor;
   die $@ if ($@  $@ !~ qr{^Can't locate
  RT/Condition/UntouchedInHours_Vendor.pm});
   eval require RT::Condition::UntouchedInHours_Local;
   die $@ if ($@  $@ !~ qr{^Can't locate
  RT/Condition/UntouchedInHours_Local.pm});
 
   1;


Re: [rt-users] Can't load UntouchedInHours module

2013-08-30 Thread Elliott, Kevin C (DOR)
Good call. I've moved it over to /usr/local/share/request-tracker.

 -Original Message-
 From: Dominic Hargreaves [mailto:dominic.hargrea...@it.ox.ac.uk]
 Sent: Friday, August 30, 2013 1:17 AM
 To: Elliott, Kevin C (DOR)
 Cc: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Can't load UntouchedInHours module
 
 On Thu, Aug 29, 2013 at 05:39:33PM +, Elliott, Kevin C (DOR) wrote:
 
  root@DorJnuASD-RT:~/Bin# ls -la
  /usr/share/request-tracker4/lib/RT/Condition/
  total 60
  drwxr-xr-x  2 root root 4096 Aug 29 09:24 .
  drwxr-xr-x 17 root root 4096 Jun 11 11:27 ..
  -rw-r--r--  1 root root 2247 May 22 09:49 AnyTransaction.pm
  -rw-r--r--  1 root root 2742 May 22 09:49 BeforeDue.pm
  -rw-r--r--  1 root root 2677 May 22 09:49 CloseTicket.pm
  -rw-r--r--  1 root root 2475 May 22 09:49 Overdue.pm
  -rw-r--r--  1 root root 2351 May 22 09:49 OwnerChange.pm
  -rw-r--r--  1 root root 2356 May 22 09:49 PriorityChange.pm
  -rw-r--r--  1 root root 2325 May 22 09:49 PriorityExceeds.pm
  -rw-r--r--  1 root root 2306 May 22 09:49 QueueChange.pm
  lrwxrwxrwx  1 root root9 Aug 29 08:37 RCS - /root/RCS
  -rw-r--r--  1 root root 2829 May 22 09:49 ReopenTicket.pm
  -rw-r--r--  1 root root 4593 May 22 09:49 StatusChange.pm
  -rw-r--r--  1 root root  800 Aug 29 09:23 UntouchedInHours.pm
  -rw-r--r--  1 root root 2458 May 22 09:49 UserDefined.pm
 
 Hi,
 
 Probably not related to your problem, but I really recommend not putting
 locally installed files in /usr/share as that space is reserved for the 
 package
 manager (dpkg) and you could end up with overwritten files there (plus it's
 difficult to see what came from where).
 
 /usr/local/share/request-tracker4/lib exists for this purpose so you could
 move that file into /usr/local/share/request-tracker4/lib/RT/Condition/
 
 Cheers,
 Dominic.
 
 --
 Dominic Hargreaves, Systems Development and Support Section IT Services,
 University of Oxford, 13 Banbury Road, Oxford, OX2 6NN


Re: [rt-users] Searching in RT

2013-08-30 Thread Jim Berry
Try putting the number in quotes.Also, Just hit enter in the Search... 
box to see the instructions for the simple search.

Jim

From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Bryon Baker
Sent: Friday, August 30, 2013 2:20 PM
To: RT Users (rt-users@lists.bestpractical.com)
Subject: [rt-users] Searching in RT

I have ran into an issue when search for tickets.

I am searching for a number in the subject line when I am doing this RT assumes 
that I am search for a ticket number.  Is there something I can do to change 
this behavior?

I am using version 4.13

Thanks
Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726  *  262-783-6261 ext. 2296
bba...@copesan.commailto:cstep...@copesan.com
www.copesan.comhttp://www.copesan.com/
Servicing North America with Local Care



Re: [rt-users] Searching in RT

2013-08-30 Thread Bryon Baker
Great thanks that works great.

Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726  *  262-783-6261 ext. 2296
bba...@copesan.commailto:cstep...@copesan.com
www.copesan.comhttp://www.copesan.com/
Servicing North America with Local Care

From: Jim Berry [mailto:jim.h.be...@frb.gov]
Sent: Friday, August 30, 2013 1:58 PM
To: Bryon Baker; RT Users (rt-users@lists.bestpractical.com)
Subject: RE: Searching in RT

Try putting the number in quotes.Also, Just hit enter in the Search... 
box to see the instructions for the simple search.

Jim

From: 
rt-users-boun...@lists.bestpractical.commailto:rt-users-boun...@lists.bestpractical.com
 [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Bryon Baker
Sent: Friday, August 30, 2013 2:20 PM
To: RT Users 
(rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com)
Subject: [rt-users] Searching in RT

I have ran into an issue when search for tickets.

I am searching for a number in the subject line when I am doing this RT assumes 
that I am search for a ticket number.  Is there something I can do to change 
this behavior?

I am using version 4.13

Thanks
Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726  *  262-783-6261 ext. 2296
bba...@copesan.commailto:cstep...@copesan.com
www.copesan.comhttp://www.copesan.com/
Servicing North America with Local Care



Re: [rt-users] Searching in RT

2013-08-30 Thread k...@rice.edu
On Fri, Aug 30, 2013 at 06:20:27PM +, Bryon Baker wrote:
 I have ran into an issue when search for tickets.
 
 I am searching for a number in the subject line when I am doing this RT 
 assumes that I am search for a ticket number.  Is there something I can do to 
 change this behavior?
 
 I am using version 4.13
 

Hi Bryon,

I am using 3.8.13+secpatches and in it if I lead or follow the number with
a SPACE it searches in the subject. I do not know if that will work on 4.x.

Regards,
Ken


Re: [rt-users] Re-send a previously attached attachment?

2013-08-30 Thread akos . torok
Hi Boli,

We (Bekeny) did something related:
http://requesttracker.8502.n7.nabble.com/attachment-improvements-td45499.html

Regards,

Ákos


On Tue, Aug 13, 2013 at 10:35 PM, Boli b...@itss.co.tz wrote:

 Hi All,

 Apologies if I have missed something obvious.

 How can I re-send an attachment that has previously been attached to a
 ticket without downloading it and re-attaching it.

 For example, if a new requestor or CC is added to a ticket, and I want
 to get them up to date quickly by referring to previously
 discussed/attached information.

 Comments/Suggestions welcomed

 Regards,

 Boli
 --
 Network Engineer




Re: [rt-users] Most efficient way to update custom fields without creating too many transactions

2013-08-30 Thread Kevin Falcone
On Fri, Aug 30, 2013 at 02:09:16PM -0700, Landon Stewart wrote:
On 29 August 2013 13:31, Kevin Falcone [1]falc...@bestpractical.com 
 wrote:
 
  Because Custom Fields can hold a LONGBLOB worth of data.
  Go save a large text CF and look in the database.
  Saving them as 1000 individual values makes 1000 records in the
  database, saving them as 1 large record makes 1 record. These are
  treated differently on update and display.
 
  If you follow the advice of the wiki article that was linked to and
  reach around the API, you'll hurt yourself.
 
  Not recording transactions is orthogonal to the size of the data which
  can be recorded.
 
I'm sorry - I'm pretty sure I'm reading you correctly but I'm unable to 
 add multiple values to
a Custom Field without creating multiple ObjectCustomFieldValue records. 
 Maybe it's not

If you have a multiple value custom field, then each value will be an
OCFV.

As I wrote above Go save a large *text* CF and look in the database
(added emphasis on text).

It's unclear to me how you think we could store a Custom Field with a
thousand distinct values as anything other than distinct records in
the database?

Think particularly about searching in the context of my question.

RecordTransactions = 0 does what it sounds like, it stops you from
getting 1000 transactions about the updates.

-kevin


pgprQ9NUn9h3G.pgp
Description: PGP signature


Re: [rt-users] Most efficient way to update custom fields without creating too many transactions

2013-08-30 Thread Landon Stewart
On 29 August 2013 13:31, Kevin Falcone falc...@bestpractical.com wrote:

 Because Custom Fields can hold a LONGBLOB worth of data.
  Go save a large text CF and look in the database.
 Saving them as 1000 individual values makes 1000 records in the
 database, saving them as 1 large record makes 1 record.  These are
 treated differently on update and display.

 If you follow the advice of the wiki article that was linked to and
 reach around the API, you'll hurt yourself.

 Not recording transactions is orthogonal to the size of the data which
 can be recorded.


I'm sorry - I'm pretty sure I'm reading you correctly but I'm unable to add
multiple values to a Custom Field without creating multiple
ObjectCustomFieldValue records.  Maybe it's not possible to do so.

The %Updates hash is a hash of arrays like this (this is one key, I don't
know why Dumper prints it as two VARs):
$VAR11 = 'Customer';
$VAR12 = [
   '1xxx59',
   '1xxx22',
   '1xxx56',
   '1xxx5',
   '6xxx5',
   '1xxx93',
   '6xxx1',
   '4xxx1',
   '2xxx1',
   '3xxx8',
   '6xxx7',
   '1xxx08',
   '1xxx36'
 ];

Here's what I've tried and seen:
foreach my $ufn (keys %Updates) {
$ticket-AddCustomFieldValue( Field = $ufn, Value = join(\n,
@{$Updates{$ufn}}), RecordTransaction = 0 );
}
-- What this does is adds one ObjectCustomFieldValue record with \n between
some stuff.  These are displayed in RT as values with spaces between them.

foreach my $ufn (keys %Updates) {
$ticket-AddCustomFieldValue( Field = $ufn, Value = join(',',
@{$Updates{$ufn}}), RecordTransaction = 0 );
}
-- I didn't think this would really work but I thought I'd try it anyway.
 Same thing but comma delimited.  They are displayed in RT as values with
commas between them.

So in other words I'm starting to think I've been after something that
can't be done.  RecordTransaction = 0 stops the Transactions table from
getting a ton of records added to it (one for each OCFV record added) but I
cannot avoid tons of OCFV records being added.

-- 
Landon Stewart :: lstew...@iweb.com
Lead Specialist, Abuse and Security Management
Spécialiste principal, gestion des abus et sécurité
http://iweb.com :: +1 (888) 909-4932


Re: [rt-users] Most efficient way to update custom fields without creating too many transactions

2013-08-30 Thread Landon Stewart
On 30 August 2013 14:29, Kevin Falcone falc...@bestpractical.com wrote:

 If you have a multiple value custom field, then each value will be an
 OCFV.

As I wrote above Go save a large *text* CF and look in the database
 (added emphasis on text).

 It's unclear to me how you think we could store a Custom Field with a
 thousand distinct values as anything other than distinct records in
 the database?


I thought it was possible simply because I was asked by someone who has
experience with RT to find out how to do it.

Anyway - thanks for confirming that it's not possible at least.

-- 
Landon Stewart :: lstew...@iweb.com
Lead Specialist, Abuse and Security Management
Spécialiste principal, gestion des abus et sécurité
http://iweb.com :: +1 (888) 909-4932