[cvs] [Wiki] changed: AddressBook

[Wiki Guest]

guest [170.148.92.21]  Thu, 04 Aug 2005 10:50:02 -0700

Modified page: http://wiki.horde.org/AddressBook
New Revision:  1.1
Change log:  new HOWTO

@@ -1 +1,61 @@
+	HOWTO Create a Separate AddressBook for Use By hermes/Timesheets
+(or how to stop all my friends from being listed when creating a timesheet entry)
+
+
+Some insight on where hermes (Time Tracking) gets it data for use within the pulldowns menu (as well as invoices, etc)
+
+hermes requires a good working install of turba (AddressBooks).
+This is because hermes needs an addressbook for the clients names, 
+Go to Office -> Time Tracking -> Enter Time -> Client to see what I
+am talking about. If you saw everyone in your addressbook as an option, then you
+probably have your default turba addressbook selected (in turba), annoying
+eh? My addressbooks contain several hundred entries, causing that  pulldown
+to look horrible. 
+
+Solution?  Create a separate addressbook for use by hermes.
+
+Step 1.
+
+Let's create a new table that is exactly the same as the default addressbook
+but with a different name. For the purposes of this document, I will use the
+name hordeclientdb for the new database table. (This is assuming you are
+using a sql backend).
+
+1a.  Create a new table.  
+
+Go to turba/scripts/sql and copy the file that you used to create your turba original
+turba table.  So, assuming that you are using mysql, cp turba_objects.mysql.sql
+to say something like turba_clients.mysql.sql.  Edit the new file, turba_clients.mysql.sql
+and change all entries that have turba_objects and change them with the new name,
+turba_clients. You should encounter three instances of turba_objects, one for the
+CREATE TABLE, another for a CREATE INDEX, and the last for a GRANT commands.
+
+Save your file and create the table.  I.e., in MySql do "mysql -p <  turba_clients.mysql.sql
+Assuming you've had no errors, continue to step 1b.
+
+1b.  Edit  turba/ config/ sources.php and add entries identical to the original table,
+leaving the original intact.  Change the lines for the new entry to look like the below example.
+
+
+$cfgSources['hordeclientdb'] = array(
+	'title' => _("My Addressbook"),
+	'type' => 'sql', 
+    'params' => array_merge($conf['sql'], array('table' => 'turba_clients')),
+
+(Look over the rest of the entries for the new table, ensuring that it is readable, etc.)
+
+Step 2.
+
+Now tell hermes which addressbook to use.  Using an Administrator enabled login, go to:
+
+Administration -> Setup -> Address Book (turba) -> name of client address book
+
+In the field above, enter the name of the database you wish to use, we used hordeclientdb. 
+
+Populate the new table with just the names and addresses for your
+clients, within turba as you would any addressbook entry.
+
+Permission your users to see/use this new database.
+
+Result? you should now have a nicely trimmed selection list.