headers
Kevin Druff | 1 Jul 2005 22:47

Attributes & Drop-Down Menu

Good Afternoon -

I am attempting to do a bit of customization on Turba. I want my end users
to be able to select a particular locality from a list of choices. When
fully complete, the list will be quite large, however, I cannot get even one
or two options to appear. I would like to store in my SQL tables the number
that precedes the Locality name. Each locality has a unique numerical
identifier in another table that we will use in more sophisticated queries.
The following is the entry in config/attributes.php:

$attributes['county'] = array(

    'label' => _("County"),

    'type' => 'enum',

    'enum' => array('0' => _("Accomack"),

                    '1' => _("Albemarle"),

                    '2' => _("Alleghany"))

);

And the following is my entry in sources.php (using the MySQL backend, the
column name is county and it is a varchar field):

'county' => 'county'

Can anyone perhaps give me pointers? Is what I want possible?
(Continue reading)

Permalink | Reply | 1 comment |
headers
Kevin Myer | 1 Jul 2005 22:57

Location addition to SQL schema?

Would there be support for adding a location field to the existing SQL schema? 
The rationale would be that many people in an organization are often tied to a
location (such as a building, or a place on a campus).  This location may not
have anything to do with the postal address or may only be remotely related.

Kevin

-- 
Kevin M. Myer
Senior Systems Administrator
Lancaster-Lebanon Intermediate Unit 13  http://www.iu13.org

--

-- 
Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: turba-unsubscribe <at> lists.horde.org
Permalink | Reply | 2 comments |
headers
Kevin Druff | 1 Jul 2005 23:03

Re: Location addition to SQL schema?

This is similar to what I'm trying to do. I just made a post on it to the
list. I have added the column to the SQL table, and am trying to create a
drop-down menu with the location...

Cheers,

Kevin Druff
MySQL Database Administrator
Tim Kaine for Governor
www.kaine2005.org 
(804) 673-2100x2258

-----Original Message-----
From: turba-bounces <at> lists.horde.org [mailto:turba-bounces <at> lists.horde.org]
On Behalf Of Kevin Myer
Sent: Friday, July 01, 2005 4:58 PM
To: turba <at> lists.horde.org
Subject: [turba] Location addition to SQL schema?

Would there be support for adding a location field to the existing SQL
schema? 
The rationale would be that many people in an organization are often tied to
a
location (such as a building, or a place on a campus).  This location may
not
have anything to do with the postal address or may only be remotely related.

Kevin

--

--
(Continue reading)

Permalink | Reply | 0 comments |
headers
Jan Schneider | 3 Jul 2005 12:48
Favicon
Gravatar

Re: Location addition to SQL schema?

Zitat von Kevin Myer <kevin_myer <at> iu13.org>:

> Would there be support for adding a location field to the existing 
> SQL schema?
> The rationale would be that many people in an organization are often 
> tied to a
> location (such as a building, or a place on a campus).  This location may not
> have anything to do with the postal address or may only be remotely related.

I'm very reluctant to adding more entries to the default scheme, unless 
we need them somewhere else in Horde (like the public key fields), or 
we want to match some external, kind of standard, scheme.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/

--

-- 
Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: turba-unsubscribe <at> lists.horde.org
Permalink | Reply | 0 comments |
headers
Jan Schneider | 3 Jul 2005 12:49
Favicon
Gravatar

Re: Attributes & Drop-Down Menu

Zitat von Kevin Druff <kevin <at> druffs.com>:

> I am attempting to do a bit of customization on Turba. I want my end users
> to be able to select a particular locality from a list of choices. When
> fully complete, the list will be quite large, however, I cannot get even one
> or two options to appear. I would like to store in my SQL tables the number
> that precedes the Locality name. Each locality has a unique numerical
> identifier in another table that we will use in more sophisticated queries.
> The following is the entry in config/attributes.php:
>
>
>
> $attributes['county'] = array(
>
>    'label' => _("County"),
>
>    'type' => 'enum',
>
>    'enum' => array('0' => _("Accomack"),
>
>                    '1' => _("Albemarle"),
>
>                    '2' => _("Alleghany"))
>
> );

Try

'params' => array(array(0 => 'Accomack', ...))
(Continue reading)

Permalink | Reply | 0 comments |
headers
Kevin Myer | 8 Jul 2005 02:41

Creating shared SQL addressbooks for users/groups

We make available to users a personal addressbook (localsql - My Addressbook)
and about two dozen directory server (LDAP) based addressbooks.  localsql is
read/write and the others are read-only.  There are some users that need to
share an additional address book between them and have read-write access to it.
 I thought that what I would do was copy the localsql config, change the name
of it, set public -> true, set some Horde permissions for the users for that
addressbook, and things would work.  I found that instead, all of the objects
in turba_objects show up in that address book, even though I'm not the owner of
them.

So I'm thinking that a better solution is to create a new table for each
additional shared address book I need.  That has the potential to get unwieldy,
if many people want small group, shared, read/write address books like this. 
Is there a better way?

Kevin

-- 
Kevin M. Myer
Senior Systems Administrator
Lancaster-Lebanon Intermediate Unit 13  http://www.iu13.org

--

-- 
Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: turba-unsubscribe <at> lists.horde.org
Permalink | Reply | 2 comments |
headers
Chuck Hagenbuch | 8 Jul 2005 04:15
Favicon
Gravatar

Re: Creating shared SQL addressbooks for users/groups

Quoting Kevin Myer <kevin_myer <at> iu13.org>:

> So I'm thinking that a better solution is to create a new table for each
> additional shared address book I need. That has the potential to get 
> unwieldy,
> if many people want small group, shared, read/write address books like this.
> Is there a better way?

Yes. A Share implementation for Turba.

-chuck

-- 
"But she goes not abroad in search of monsters to destroy." - John 
Quincy Adams
--

-- 
Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: turba-unsubscribe <at> lists.horde.org
Permalink | Reply | 1 comment |
headers
Kevin Myer | 8 Jul 2005 05:10

Re: Creating shared SQL addressbooks for users/groups

Quoting Chuck Hagenbuch <chuck <at> horde.org>:

> Quoting Kevin Myer <kevin_myer <at> iu13.org>:
>
>> So I'm thinking that a better solution is to create a new table for each
>> additional shared address book I need. That has the potential to get
>> unwieldy,
>> if many people want small group, shared, read/write address books like this.
>> Is there a better way?
>
> Yes. A Share implementation for Turba.
>
> -chuck

I meant one that I could use with the existing Turba code :)  I'll add 
it to my
list..

Kevin

-- 
Kevin M. Myer
Senior Systems Administrator
Lancaster-Lebanon Intermediate Unit 13  http://www.iu13.org

--

-- 
Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: turba-unsubscribe <at> lists.horde.org
(Continue reading)

Permalink | Reply | 0 comments |
headers
Michael Rubinsky | 8 Jul 2005 21:39
Gravatar

Re: Creating shared SQL addressbooks for users/groups


  Probably not what your looking for Kevin, but the IMSP driver for
turba now supports ACLs...and would make sharing addressbooks between
users pretty easy.  Of couse, you would need to be running an IMSP
server...
-- 
Thanks,
Mike

Quoting turba-request <at> lists.horde.org:
> Message: 3
> Date: Thu,  7 Jul 2005 23:10:45 -0400
> From: Kevin Myer <kevin_myer <at> iu13.org>
> Subject: Re: [turba] Creating shared SQL addressbooks for
users/groups
> To: turba <at> lists.horde.org
> Message-ID: <20050707231045.srqyetf2j05ws84o <at> webapps.iu13.org>
> Content-Type: text/plain;        charset=ISO-8859-1;       
format="flowed"
>
> Quoting Chuck Hagenbuch <chuck <at> horde.org>:
>
>> Quoting Kevin Myer <kevin_myer <at> iu13.org>:
>>
>>> So I'm thinking that a better solution is to create a new table
for each
>>> additional shared address book I need. That has the potential to
get
>>> unwieldy,
>>> if many people want small group, shared, read/write address books
(Continue reading)

Permalink | Reply | 1 comment |
headers
Kevin Myer | 8 Jul 2005 21:54

Re: Creating shared SQL addressbooks for users/groups

Quoting Michael Rubinsky <mike <at> theupstairsroom.com>:

>  Probably not what your looking for Kevin, but the IMSP driver for
> turba now supports ACLs...and would make sharing addressbooks between
> users pretty easy.  Of couse, you would need to be running an IMSP
> server...

I've been toying with that idea too and had messed around with IMSP in 
the past.
The problem was we host multiple domains and I hadn't found an easy way to run
multiple instances of IMSP.  Heck, might as well make it as complicated 
and use
as many different sources as possible :D  Since you've written the IMSP code,
what do you recommend for a server?

Kevin

-- 
Kevin M. Myer
Senior Systems Administrator
Lancaster-Lebanon Intermediate Unit 13  http://www.iu13.org

--

-- 
Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: turba-unsubscribe <at> lists.horde.org
Permalink | Reply | 0 comments |

Gmane