Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / September 2004

Tip: Looking for answers? Try searching our database.

Allow merge of CSV files When Importing.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tylast - 19 Sep 2004 20:35 GMT
The only option available is to not create duplicate.  Well, how about merge
data upon importing?  Outlook should recognize that the Contact name is the
same & ask which data for each field to use.  How about an auto setting that
picks the most recently modified version of the contact?
Karl Timmermans - 20 Sep 2004 03:01 GMT
If you are looking for "update" capabilities when importing, our DataPorter
series product may be of some interest to you (see link in sig line below -
a more advanced update/append function will be available in the upcoming 2.1
series of the product).

However, a few reasons why you're suggestion(s) won't work are as follows:

#1 - " How about an auto setting that picks the most recently modified
version of the contact?

The modified date/time stamp applies to the contact record as a whole and
not to a specific field. However, even if it did, you wouldn't generally
have an applicable field in a CSV file to compare anything to but getting
back to point on the initial reason, you may be importing 10 fields (for
sake of argument) and your contact record may be been changed for something
totally unrelated. In other words, while your contact record may have a
"LastModifiedTime" stamp greater then a corresponding field contained in
your CSV file - doesn't mean that the input data isn't the most current for
for the fields in the dataset.

#2 - "Outlook should recognize that the Contact name is the same & ask which
data for each field to use."

- The assumption in this case is that the criteria that constitutes a dupe
is based on contact name which is not a good field to use exclusive of
anything else (at a "bare" minimum, you'd need something like email address
and even then - this doesn't deal with duplicate contacts that potentially
may exist within a folder)
- If you import thousands of records as many of our customers do on a
regular on-going basis - having Outlook ask for "each" match just wouldn't
be practical.

Once you go outside of "the absolute simplistic" import scenarios there are
a LOT of things that you need to handle - for instance:
    - if you're updating, does an "empty" field mean that there is "no
data" and the original data should be retained OR
      does it mean that the data in the contact record should be cleared
    - what constitutes a field that has "No data" versus one that should be
set to blank (or zero) etc?
       i.e. is a field that has one only one space character (or
alternatively padded with all spaces)  the same as one that is
            "empty"? Are either of these equivalent to a field containing a
NULL value?
    (answer to the above is that there is no "single" answer since everyone
has their own set of definitions and rules
      based on the data that they have to work with and different programs
can generate the same data in different
      ways).

Karl

Signature

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

> The only option available is to not create duplicate.  Well, how about merge
> data upon importing?  Outlook should recognize that the Contact name is the
> same & ask which data for each field to use.  How about an auto setting that
> picks the most recently modified version of the contact?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.