Mailing List Archive: Request Tracker: Devel

RT 3.8.1 and adding a new portlet to the database

Index | Next | Previous | View Threaded

tjrc at sanger

Nov 18, 2008, 2:02 AM

Post #1 of 3 (941 views)
Permalink

RT 3.8.1 and adding a new portlet to the database

Ages ago, I tried doing an RT 3.8.0 upgrade, and I worked out a way of
creating a new portlet for all my users' front pages which showed
tickets they'd submitted, and this involved me adding a bit of extra
data to the upgrade process. I even still have the content of that
upgrade file:

@Attributes = (
{ Name => 'Search - My Requested Tickets',
Description => '[_1] tickets I requested',
Content =>
{ Format => q{'<a href="__WebPath__/Ticket/Display.html?
id=__id__">__id__</a>/TITLE:#', '<a href="__WebPath__/Ticket/
Display.html?id=__id__">__Subject__</a>/TITLE:Subject', QueueName,
ExtendedStatus, OwnerName},
Query => " Requestor.id = '__CurrentUser__' AND ( Status =
'new' OR Status = 'open' OR Status = 'stalled')",
OrderBy => 'id',
Order => 'DESC'
},
},
);

1;

What I can't remember for the life of me is what the command line
invocation is to load that data file into the appropriate chunk of the
database. Can you help me out here?

Thanks,

Tim

--
The Wellcome Trust Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.
_______________________________________________
List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

elacour at easter-eggs

Nov 18, 2008, 3:16 AM

Post #2 of 3 (893 views)
Permalink

Re: RT 3.8.1 and adding a new portlet to the database [In reply to]

On Tue, Nov 18, 2008 at 10:02:39AM +0000, Tim Cutts wrote:
> Ages ago, I tried doing an RT 3.8.0 upgrade, and I worked out a way of
> creating a new portlet for all my users' front pages which showed
> tickets they'd submitted, and this involved me adding a bit of extra
> data to the upgrade process. I even still have the content of that
> upgrade file:
>
> @Attributes = (
> { Name => 'Search - My Requested Tickets',
> Description => '[_1] tickets I requested',
> Content =>
> { Format => q{'<a href="__WebPath__/Ticket/Display.html?
> id=__id__">__id__</a>/TITLE:#', '<a href="__WebPath__/Ticket/
> Display.html?id=__id__">__Subject__</a>/TITLE:Subject', QueueName,
> ExtendedStatus, OwnerName},
> Query => " Requestor.id = '__CurrentUser__' AND ( Status =
> 'new' OR Status = 'open' OR Status = 'stalled')",
> OrderBy => 'id',
> Order => 'DESC'
> },
> },
> );
>
> 1;
>
> What I can't remember for the life of me is what the command line
> invocation is to load that data file into the appropriate chunk of the
> database. Can you help me out here?
>

rt-setup-database --action insert --datafile your file

rt-setup-database --help for more infos ;)

_______________________________________________
List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

tjrc at sanger

Nov 18, 2008, 3:40 AM

Post #3 of 3 (882 views)
Permalink

Re: RT 3.8.1 and adding a new portlet to the database [In reply to]

On 18 Nov 2008, at 11:16 am, Emmanuel Lacour wrote:

> rt-setup-database --action insert --datafile your file

Thanks, yep, just discovered that for myself, with a little reading of
the source code. Thanks!

Tim

--
The Wellcome Trust Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.
_______________________________________________
List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads