[turba] Merging of turba_objects table(s)

[ANANT S ATHAVALE]

----- Message from mrubinsk at horde.org ---------
     Date: Thu, 23 Apr 2009 11:54:02 -0400
     From: Michael Rubinsky <mrubinsk at horde.org>
Reply-To: Michael Rubinsky <mrubinsk at horde.org>
  Subject: Re: [turba] Merging of turba_objects table(s)
       To: turba at lists.horde.org


> Quoting lst_hoe02 at kwsoft.de:
>
>> Zitat von ANANT S ATHAVALE <asa at isac.gov.in>:
>>
>>> Dear List,
>>>
>>>
>>> We currently have two servers running HORDE 3.1.5 and its    
>>> applications.  The users on these two systems are different.
>>>
>>> We are in the process of migration to latest version of HORDE.     
>>> During this migration, we want to merge users of both servers.     
>>> During this process, I am finding difficulty in merging    
>>> turba_object table of both.
>>>
>>> while inserting data from second server, I get following error.
>>>
>>> ERROR 1062 (23000) at line 30588: Duplicate entry    
>>> '12345678901234567890123450000899' for key 1
>>>
>>> That is 'object_id' is clashing.  I don't want users loose their    
>>> address book during the process of migration.  How can I achieve it?
>>
>> As far as i know the "object_id" only have to be unique so simply    
>> adding the hostname before migration might be a solution.
>
> This is only partially true.  The object_id is used elsewhere to
> identify the object. For example, in contact groups, the
> object_members field contains the object_ids of the contacts in the
> group (the longer story is that the value may be a key made up of the
> source name and the object id) but nevertheless, the object id cannot
> just be changed without checking for and changing it elsewhere. This
> is also complicated by the fact the sources other than sql based
> source may have added a contact from this table, and thus the
> object_id would need to be changed there as well.
>
>
> Thanks,
> mike

Dear Sir,

What is the best way to merge now?  We have decided to merge the users  
from both servers into a one.

Suppose, a user exports his Address book and imports it back on new  
server, will it get back with the same status?  In this process,  
anything is lost?
If nothing is lost and this duplication issue is solved, I would like  
somebody to share php code which can export address book for all users  
and import it on new server.  It would be a great help for me.

Regards,
ANANT.


>
> --
> The Horde Project (www.horde.org)
> mrubinsk at horde.org
>
> "Time just hates me. That's why it made me an adult." - Josh Joplin


----- End message from mrubinsk at horde.org -----



Regards,

Anant Athavale.