[turba] Address book import question

Aria Bamdad aria at bsc.gwu.edu
Thu Jul 30 20:01:53 UTC 2009


Hi,

I export data from a database, a list of company employees and other
information into a CSV file and then import into a public shared read only
address book that is available to all IMP users.  I import the CSV into
Turba using the Import/Export web interface and select 'Replace exiting
address book with the imported one' so that employees who have left are
automatically removed.

This works fine as long as you just reference the address book from IMP
accounts.  However, the bad side effect of doing a delete before the import
is that if any IMP user were to create a personal 'Contact List' or
distribution list and then include any member from the 'public' shared
address book, then the next time the public address book is purged and new
records are imported into it, all the Contact Lists that used entries from
the public address book will lose those individuals who were from the public
list.  

I understand the technical reasons why this is happening.  Now for the
questions:

1-Does anyone have a script that can import and replace existing records AND
remove any records that do not exist in the source CSV file from the Turba
database?

2-Would it make more sense for the Turba import interface to allow you to do
an intelligent import where the above problem can be avoided?  Replace
records that match based on a specific field and delete all others that had
no match from the database.  This could be another option in addition to the
one that deletes all records first.

Thanks 





More information about the turba mailing list