Re: Renaming a resource?

On Tue, 2009-08-18 at 12:58 -0400, Jeff wrote:
> I see that I can edit a resource, but it doesn't appear that I can
> edit the name of the resource, only other details such as Email, Email
> Subject, etc.
> (I'm looking at the Edit Appointment Resources in the Administration)
> Is it possible?

It is 'possible' but not I think through the WebUI.  A problem is that
resources are identified BY NAME in appointments, so if you rename you
potentially loose the reference [it has always been that way, not sure
why, it sucks].

It is pretty trivial to change in the database:

SELECT COUNT(*) FROM date_x WHERE resource_names LIKE '%Big Classroom%';

UPDATE appointment_resource
SET name = 'GRD Classroom' 
WHERE name = 'Big Classroom';

UPDATE date_x
SET resource_names = REPLACE(resource_names, 'Big Classroom', 'GRD
Classroom'), object_version = (object_version + 1);

SELECT COUNT(*) FROM date_x WHERE resource_names LIKE '%GRD Classroom%'

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users