Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!emory!hubcap!dragon
From: dragon@hubcap.clemson.edu (Michael E. Quattlebaum)
Newsgroups: comp.sys.mac.apps
Subject: 4D Importing and Exporting Data (Merging databases)
Keywords: merge, import, export
Message-ID: <11775@hubcap.clemson.edu>
Date: 21 Nov 90 16:17:31 GMT
Organization: Clemson University, Clemson, SC
Lines: 17

I am helping with the development of a database for many users around
the country.  As you might imagine, we have several test sites where
we have people evaluating the database.  Now that most of the bugs are
out we are ready to ship the final version.  Along with this version 
has to go some data from the national clearinghouse to be merged with
their existing data.  No problem.  I can set up a procedure that exports
data and imports it so that they can do this easily.  The problem comes
with indexed fields.  Some of the data they have is likely to have the
same values for indexed fields (and thus 4D will not write that record).
I was wondering if anyone has any creative solutions to this problem.
Please respond via e-mail and I will summarize responses to the net.

Thanks in advance.

Michael Quattlebaum
Internet: dragon@hubcap.clemson.edu
AppleLink: ST0673