New CustomFields

Hi all,

I am new to RT and hope this will end up being the solution I am looking for.

I have a couple questions about CustomFields. First, is there a limit to how many items you can have in a ‘select one’ field? I have alot of entries I need to put into this ‘select one’ CustomField, is there a way for me to manually create it? I tried looking for where my CustomFields might be stored, but I couldnt find them. I didnt see an option to import from a cvs or other type of file.

Any help is appreciated.

Thanks,

Dave Kettmann
NetLogic
636-561-0680

If you want you can do it through SQL directly (just be careful ;p)

The tables are CustomFields and CustomFieldValues.

Ramon Kagan
York University, Computing and Network Services
Information Security - Senior Information Security Analyst
(416)736-2100 #20263
rkagan@yorku.ca


I have not failed. I have just I don’t know the secret to success,
found 10,000 ways that don’t work. but the secret to failure is
trying to please everybody.
- Thomas Edison - Bill Cosby
----------------------------------- ------------------------------------On Fri, 4 Feb 2005, Dave Kettmann wrote:

Hi all,

I am new to RT and hope this will end up being the solution I am looking for.

I have a couple questions about CustomFields. First, is there a limit to how many items you can have in a ‘select one’ field? I have alot of entries I need to put into this ‘select one’ CustomField, is there a way for me to manually create it? I tried looking for where my CustomFields might be stored, but I couldnt find them. I didnt see an option to import from a cvs or other type of file.

Any help is appreciated.

Thanks,

Dave Kettmann
NetLogic
636-561-0680


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

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Ack! Do no such thing!

Here is a script that takes 2 arguments, the name of the
CF and the name of a file that has one CF value per line
to be added to the CF.

#!/usr/bin/perl

use strict;
use Carp;

use lib ("/opt/rt3/lib", “/opt/rt3/local/lib”);

use RT;
RT::LoadConfig;
RT::Init;

my $fields = RT::CustomFields->new($RT::SystemUser);
$fields->UnLimit;
$fields->Limit( FIELD => ‘Name’, VALUE => shift );
my $cf = $fields->First;
while (<>) {
chomp;
$cf->AddValue(Name => $) or warn "Couldn’t load value $";
}On Fri, Feb 04, 2005 at 03:03:15PM -0500, Ramon Kagan wrote:

If you want you can do it through SQL directly (just be careful ;p)

The tables are CustomFields and CustomFieldValues.

Ramon Kagan
York University, Computing and Network Services
Information Security - Senior Information Security Analyst
(416)736-2100 #20263
rkagan@yorku.ca


I have not failed. I have just I don’t know the secret to success,
found 10,000 ways that don’t work. but the secret to failure is
trying to please everybody.

  • Thomas Edison - Bill Cosby

On Fri, 4 Feb 2005, Dave Kettmann wrote:

Hi all,

I am new to RT and hope this will end up being the solution I am looking for.

I have a couple questions about CustomFields. First, is there a limit to how many items you can have in a ‘select one’ field? I have alot of entries I need to put into this ‘select one’ CustomField, is there a way for me to manually create it? I tried looking for where my CustomFields might be stored, but I couldnt find them. I didnt see an option to import from a cvs or other type of file.

Any help is appreciated.

Thanks,

Dave Kettmann
NetLogic
636-561-0680


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

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com


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

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com