[cvs] [Wiki] changed: TurbaImportAddressBook
Chuck Hagenbuch
chuck at horde.org
Thu Feb 22 18:41:31 PST 2007
chuck Thu, 22 Feb 2007 18:41:31 -0800
Modified page: http://wiki.horde.org/TurbaImportAddressBook
New Revision: 1.1
Change log: add some info on turba special fields
@@ -1,5 +1,33 @@
+[[toc]]
+
+ Importing data into Turba's address book
+
+++ Special Fields
+
+Different versions of Turba have some of the following fields that are at least somewhat specific to Turba. The name of the Turba attribute is given first, and the standard SQL field name for that attribute in Turba's default schema is given in parentheses.
+
++++ __key (object_id)
+
+This is a backend-specific ID for the entry. It can have any value that is unique to this source (for a database backend, object_id + owner_id must be unique on a per-table basis). When importing data from external sources this value can be automatically generated to any value as long as this uniqueness criteria is met.
+
++++ __uid (object_uid)
+
+This value is a globally-unique id for the entry. It is used when synchronizing with PDAs and other addressbooks, or for maintaining relationships with external vCard data. If the data being imported has a UID it should be preserved; otherwise it can be generated. Using Turba's generateUID() method is the best way, but anything that approximates a unique id @ your server should work.
+
++++ __owner (owner_id)
+
+The Horde username of the object's owner (or alternately a share name).
+
++++ __type (object_type)
+
+Either 'Object' or 'Group'
+
++++ __members (object_members)
+
+A serialized PHP array of members of a Group.
+
+++ Migrating from IMP 2
This is a small !MySQL script to import address book data from IMP 2 into Turba 2's default SQL address book. You can tweak the code to import data from any other external database tables. Please adapt it to your needs before running it.
<code type="sql">
More information about the cvs
mailing list