Guillaume Barreau | 1 Aug 02:19 2005
Picon

search returns everything

Hi Folks,

The search function appears to return all the entries in my database
no matter which field I search and what I put in the search box.
Any idea? 

I have an ldap back end and I am using version 2.0.2.

Guillaume
--

-- 
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

Kevin Konowalec | 2 Aug 19:54 2005
Picon

Turba fields

I've been trying to figure out how to do a mass (50,000+ users)  
import of addressbooks from our existing system over to turba.   
Supposedly there are mysql scripts out there that will do this but I  
can't seem to find any of them.  So I started looking into how to do  
it myself but I found that there are 2 fields, object_id and  
object_uid, that are generated by the server somehow and I'm not sure  
what to do about them.  Do I ignore them and just load up the table  
with entries or do I somehow have to generate them?

If anyone has the mysql scripts that could be used for this task, or  
has any insight into how to mass import to mysql from csv files  
please let me know.

Thanks.
--

-- 
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

Kevin Druff | 2 Aug 20:01 2005

Re: Turba fields

http://dev.mysql.com/doc/mysql/en/load-data.html

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 Konowalec
Sent: Tuesday, August 02, 2005 1:55 PM
To: turba <at> lists.horde.org
Subject: [turba] Turba fields

I've been trying to figure out how to do a mass (50,000+ users)  
import of addressbooks from our existing system over to turba.   
Supposedly there are mysql scripts out there that will do this but I  
can't seem to find any of them.  So I started looking into how to do  
it myself but I found that there are 2 fields, object_id and  
object_uid, that are generated by the server somehow and I'm not sure  
what to do about them.  Do I ignore them and just load up the table  
with entries or do I somehow have to generate them?

If anyone has the mysql scripts that could be used for this task, or  
has any insight into how to mass import to mysql from csv files  
please let me know.

Thanks.
--

-- 
(Continue reading)

Kevin Konowalec | 2 Aug 22:11 2005
Picon

Re: Turba fields

Awesome!  That should work nicely!

Now all I need to know is what to do with the object_id and  
object_uid fields and we'll be in business.....

Thanks Kevin!

On Aug 2, 2005, at 12:01 PM, Kevin Druff wrote:

> http://dev.mysql.com/doc/mysql/en/load-data.html
>
> 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 Konowalec
> Sent: Tuesday, August 02, 2005 1:55 PM
> To: turba <at> lists.horde.org
> Subject: [turba] Turba fields
>
> I've been trying to figure out how to do a mass (50,000+ users)
> import of addressbooks from our existing system over to turba.
> Supposedly there are mysql scripts out there that will do this but I
> can't seem to find any of them.  So I started looking into how to do
(Continue reading)

Scott Greenberg | 3 Aug 05:12 2005

Re: Turba fields

Both object_id and object_uid are created when adding a new turba object
(contact).  The initialization varers based on the turba driver.  Below I have
listed info for the sql driver.  If you are using another option refer to
./turba/lib/Driver/*.php > function _makeKey, id is the same in all cases.

<?php
if (!isset($GLOBALS['conf']['server']['name'])) {
    $GLOBALS['conf']['server']['name'] = $_SERVER['SERVER_NAME'];
}

$user = 'user';

$contacts = array(
    array('Test1', 'test1 <at> none.net'),
    array('Test2', 'test2 <at> none.net'),
    array('Test3', 'test3 <at> none.net')
    );

foreach ($contacts as $contact) {

    $id = md5(uniqid(mt_rand(), true));

    $uid = date('YmdHis') . '.' . substr(base_convert(microtime(), 10, 
36), -16)
. $GLOBALS['conf']['server']['name'];

    $sql = "INSERT INTO `turba_objects` (`object_id` , `owner_id` ,
`object_type` , `object_uid` , `object_members` , `object_name` ,
`object_alias` , `object_email`) VALUES ('$id', '$user', 'Object', '$uid',
NULL, '$contact[0]', '', '$contact[1]');";
(Continue reading)

Scott Greenberg | 4 Aug 03:40 2005

Re: Turba fields

As far as I can tell the uid is used only for logging and api. In the 
case where
you may manual add contacts to database while bypassing Horde, no logging is
preformed. This is a non-issue. For daily use of the address book it could be
anything you want, even null.  Please note in my last msg, I left out  <at>  in the
uid field.  The correct creation of uid using sql driver is listed bellow:

$uid = date('YmdHis') . '.' . substr(base_convert(microtime(), 10, 36), -16) .
' <at> ' . $GLOBALS['conf']['server']['name'];

Kevin, in your case I would do the following, working on MySQL server machine:
-Create a php script
-Read contacts from a file or database
-Appends each contact with a user, id, & uid, where uid uses main server name
(again, note this is only for logging purposes and will not effect the use of
address book)
-Create insert statement for each contact
-Execute inserts using php or MySQL console app

--

-- 
Scott Greenberg
me <at> gogogadgetscott.info
GoGoGadgetScott.info

Quoting Kevin Konowalec <kevin.konowalec <at> ualberta.ca>:

> Hi Scott,
>
> Thanks for the code!  So I have 50,000 addressbooks... I can 
> concatenate them all into a single file with the form "userid, name, 
(Continue reading)

Kevin Druff | 4 Aug 03:50 2005

Re: Turba fields

Well, that only works if he is comfortable with PHP... I think LOAD DATA
INFILE will work much easier. With a 50,000 record list, you can simply open
it up in Excel and create new columns for uid and the other fields. You
could even create fake data for those columns using RAND function in
Excel...

KD

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 Scott Greenberg
Sent: Wednesday, August 03, 2005 9:41 PM
To: turba <at> lists.horde.org
Subject: Re: [turba] Turba fields

As far as I can tell the uid is used only for logging and api. In the 
case where
you may manual add contacts to database while bypassing Horde, no logging is
preformed. This is a non-issue. For daily use of the address book it could
be
anything you want, even null.  Please note in my last msg, I left out  <at>  in
the
uid field.  The correct creation of uid using sql driver is listed bellow:

(Continue reading)

Jan Schneider | 4 Aug 23:13 2005

Turba H3 (2.0.3) (final)

The Horde Team is pleased to announce the final release of the Turba Contact
Manager version H3 (2.0.3).

Turba is the Horde contact management application. It is a production level
address book, and makes heavy use of the Horde framework to provide
integration with IMP and other Horde applications.

Major changes compared to the Turba version H3 (2.0.3-RC1) are:
    * Fixed "Add" button not being displayed with only one source.
    * Added Turkish translation.
    * Updated French, German, and Slovak translations.

Major changes compared to the Turba version H3 (2.0.2) are:
    * Added a generic SQL upgrade script.
    * Added example how to add a category field.
    * Don't show "Add" and "Browse" icons if not applicable.
    * Support birthdays in vCard imports and exports.
    * Use bind variables in SQL driver.
    * Several IMSP improvements.

The full list of changes (from version H3 (2.0.2)) can be viewed here:

http://cvs.horde.org/diff.php/turba/docs/CHANGES?r1=1.181.2.17&r2=1.181.2.43&ty=h

The Turba H3 (2.0.3) distribution is available from the following locations:

    ftp://ftp.horde.org/pub/turba/turba-h3-2.0.3.tar.gz
    http://ftp.horde.org/pub/turba/turba-h3-2.0.3.tar.gz

Patches against version H3 (2.0.2) are available at:
(Continue reading)

John H. Bennett III | 5 Aug 19:27 2005

Re: [announce] Turba H3 (2.0.3) (final)

>Major changes compared to the Turba version H3 (2.0.2) are:
>    * Added example how to add a category field.

Can you tell me where I can find this?  I looked within Turba and in the
docs and couldn't find this info.  Quite possibly I just overlooked it.

Thanks,

John

--

-- 
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

Kevin M. Myer | 5 Aug 19:43 2005

Re: [announce] Turba H3 (2.0.3) (final)

Quoting "John H. Bennett III" <bennettj <at> thebennetthome.com>:

>> Major changes compared to the Turba version H3 (2.0.2) are:
>>    * Added example how to add a category field.
>
> Can you tell me where I can find this?  I looked within Turba and in the
> docs and couldn't find this info.  Quite possibly I just overlooked it.
>

The example is in turba/config/attributes.php.dist.

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


Gmane