A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

need to export firmwide contacts to access or any db



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 4th 07, 08:29 PM posted to microsoft.public.outlook.contacts
[email protected]
external usenet poster
 
Posts: 3
Default need to export firmwide contacts to access or any db

I am looking for a way to export **all** of the firm's user's contacts
to an access database and also have some sort of synchronization where
the Database gets updated with changes in the user's contacts for our
marketing dept ... I have seen many products that do this for an
individual mailbox but not for collecting firmwide contacts. I would
appreciate any help in terms of product or code

Thanks!

Ads
  #2  
Old January 5th 07, 08:01 AM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default need to export firmwide contacts to access or any db

The first thing you may want to do is clarify/define what you mean by
"**all**" the firm's contacts". Multiple Exch folders? GAL? etc

Depending on your definition - our ContactGenie Exporter product (Premium
edition) may do what you're looking for -
http://www.contactgenie.com/cgxfeatures.htm

Karl
__________________________________________________ ___________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com


wrote in message
ps.com...
I am looking for a way to export **all** of the firm's user's contacts
to an access database and also have some sort of synchronization where
the Database gets updated with changes in the user's contacts for our
marketing dept ... I have seen many products that do this for an
individual mailbox but not for collecting firmwide contacts. I would
appreciate any help in terms of product or code

Thanks!



  #3  
Old January 8th 07, 04:17 PM posted to microsoft.public.outlook.contacts
[email protected]
external usenet poster
 
Posts: 3
Default need to export firmwide contacts to access or any db

I would like to export every individual user's contacts and merge them
into a database so we have a complete list of contacts from all of our
firm members. I would also like to synchronize with the database to
keep the db list up to date

Karl Timmermans wrote:
The first thing you may want to do is clarify/define what you mean by
"**all**" the firm's contacts". Multiple Exch folders? GAL? etc

Depending on your definition - our ContactGenie Exporter product (Premium
edition) may do what you're looking for -
http://www.contactgenie.com/cgxfeatures.htm

Karl
__________________________________________________ ___________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com


wrote in message
ps.com...
I am looking for a way to export **all** of the firm's user's contacts
to an access database and also have some sort of synchronization where
the Database gets updated with changes in the user's contacts for our
marketing dept ... I have seen many products that do this for an
individual mailbox but not for collecting firmwide contacts. I would
appreciate any help in terms of product or code

Thanks!


  #4  
Old January 8th 07, 06:18 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default need to export firmwide contacts to access or any db


Unfortunately you still haven't identified where the individual user
contact's reside - "local PST file" or in a personal Exch folder
(assume you're not using a global contacts folder at this point).
Makes a big difference in how things get implemented.

There are various potential 3rd party solutions to this as well
which you can find and may want to look at on
http://www.slipstick.com.

From our experience, the term "sync" can identify a great many
issues within an organization when there are no firm rules in
place for such things as duplicates, master data ownership and
the like. As for CG, we only have one-way products that will
update either contact folders (on import) or databases (on
export) but currently haven't released a "two way multi-contact
folder" sync product as of yet. "Syncing" between any two single
data sources is a lot easier then when dealing with an equation
that includes a one-to-many scenario (such as mutiple contact
folders where there are no firm rules for "uniqueness" or "ultimate"
data ownership). Have seen very few solutions that actually work
long term beyond the most simplistic of environments.

Generally, a true an full "sync" needs to address things like:
#1 - Can each contact be absolutely uniquely identified by some
data field(s) to avoid duplicates?
#2 - When duplicates are found - how will these be handled at the
contact folder level and DB level?
#3 - If a contact is deleted from the master database - does it in
turn get deleted from the contact folders?
#4 - Which data source has priority? If a change is made to a
contact in a folder but deleted from the DB the same day -
does it get re-added?
#5 - When does a contact get deleted from the DB? When the
first person deletes it from their folder or when no one
references the contact or by the DB Admin?
#5 - What's the priority of changes? Those made to the DB or
"last in"?
....................list of questions can goe on and on but all depends
on actual requirements/objective and importance of info.


Karl

--
__________________________________________________ ___________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



wrote in message
oups.com...
I would like to export every individual user's contacts and merge them
into a database so we have a complete list of contacts from all of our
firm members. I would also like to synchronize with the database to
keep the db list up to date

Karl Timmermans wrote:
The first thing you may want to do is clarify/define what you mean by
"**all**" the firm's contacts". Multiple Exch folders? GAL? etc

Depending on your definition - our ContactGenie Exporter product (Premium
edition) may do what you're looking for -
http://www.contactgenie.com/cgxfeatures.htm

Karl
__________________________________________________ ___________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com


wrote in message
ps.com...
I am looking for a way to export **all** of the firm's user's contacts
to an access database and also have some sort of synchronization where
the Database gets updated with changes in the user's contacts for our
marketing dept ... I have seen many products that do this for an
individual mailbox but not for collecting firmwide contacts. I would
appreciate any help in terms of product or code

Thanks!




  #5  
Old January 8th 07, 07:18 PM posted to microsoft.public.outlook.contacts
[email protected]
external usenet poster
 
Posts: 3
Default need to export firmwide contacts to access or any db

we would like to export each user's contacts from our exchange server
and we are not using a global contacts folder. the requirements are
pretty simple. a mere export to a fresh database daily would suffice. 2
way sync is not necessary... and can't the owner attribute of the
contact be enough in case of duplicates?

Karl Timmermans wrote:
Unfortunately you still haven't identified where the individual user
contact's reside - "local PST file" or in a personal Exch folder
(assume you're not using a global contacts folder at this point).
Makes a big difference in how things get implemented.

There are various potential 3rd party solutions to this as well
which you can find and may want to look at on
http://www.slipstick.com.

From our experience, the term "sync" can identify a great many
issues within an organization when there are no firm rules in
place for such things as duplicates, master data ownership and
the like. As for CG, we only have one-way products that will
update either contact folders (on import) or databases (on
export) but currently haven't released a "two way multi-contact
folder" sync product as of yet. "Syncing" between any two single
data sources is a lot easier then when dealing with an equation
that includes a one-to-many scenario (such as mutiple contact
folders where there are no firm rules for "uniqueness" or "ultimate"
data ownership). Have seen very few solutions that actually work
long term beyond the most simplistic of environments.

Generally, a true an full "sync" needs to address things like:
#1 - Can each contact be absolutely uniquely identified by some
data field(s) to avoid duplicates?
#2 - When duplicates are found - how will these be handled at the
contact folder level and DB level?
#3 - If a contact is deleted from the master database - does it in
turn get deleted from the contact folders?
#4 - Which data source has priority? If a change is made to a
contact in a folder but deleted from the DB the same day -
does it get re-added?
#5 - When does a contact get deleted from the DB? When the
first person deletes it from their folder or when no one
references the contact or by the DB Admin?
#5 - What's the priority of changes? Those made to the DB or
"last in"?
...................list of questions can goe on and on but all depends
on actual requirements/objective and importance of info.


Karl

--
__________________________________________________ ___________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



wrote in message
oups.com...
I would like to export every individual user's contacts and merge them
into a database so we have a complete list of contacts from all of our
firm members. I would also like to synchronize with the database to
keep the db list up to date

Karl Timmermans wrote:
The first thing you may want to do is clarify/define what you mean by
"**all**" the firm's contacts". Multiple Exch folders? GAL? etc

Depending on your definition - our ContactGenie Exporter product (Premium
edition) may do what you're looking for -
http://www.contactgenie.com/cgxfeatures.htm

Karl
__________________________________________________ ___________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com


wrote in message
ps.com...
I am looking for a way to export **all** of the firm's user's contacts
to an access database and also have some sort of synchronization where
the Database gets updated with changes in the user's contacts for our
marketing dept ... I have seen many products that do this for an
individual mailbox but not for collecting firmwide contacts. I would
appreciate any help in terms of product or code

Thanks!



  #6  
Old January 8th 07, 09:08 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default need to export firmwide contacts to access or any db

Your requirements are then simple enough and easily do-able -
just need to be able to export the custom fields. Either of our
Exporter versions (Adv or Premium) could do exactly what you
need http://www.contactgenie.com/cgxfeatures.htm
You may also find other alternatives on http://www.slipstick.com

Karl

__________________________________________________ ___________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



wrote in message
ups.com...
we would like to export each user's contacts from our exchange server
and we are not using a global contacts folder. the requirements are
pretty simple. a mere export to a fresh database daily would suffice. 2
way sync is not necessary... and can't the owner attribute of the
contact be enough in case of duplicates?

Karl Timmermans wrote:
Unfortunately you still haven't identified where the individual user
contact's reside - "local PST file" or in a personal Exch folder
(assume you're not using a global contacts folder at this point).
Makes a big difference in how things get implemented.

There are various potential 3rd party solutions to this as well
which you can find and may want to look at on
http://www.slipstick.com.

From our experience, the term "sync" can identify a great many
issues within an organization when there are no firm rules in
place for such things as duplicates, master data ownership and
the like. As for CG, we only have one-way products that will
update either contact folders (on import) or databases (on
export) but currently haven't released a "two way multi-contact
folder" sync product as of yet. "Syncing" between any two single
data sources is a lot easier then when dealing with an equation
that includes a one-to-many scenario (such as mutiple contact
folders where there are no firm rules for "uniqueness" or "ultimate"
data ownership). Have seen very few solutions that actually work
long term beyond the most simplistic of environments.

Generally, a true an full "sync" needs to address things like:
#1 - Can each contact be absolutely uniquely identified by some
data field(s) to avoid duplicates?
#2 - When duplicates are found - how will these be handled at the
contact folder level and DB level?
#3 - If a contact is deleted from the master database - does it in
turn get deleted from the contact folders?
#4 - Which data source has priority? If a change is made to a
contact in a folder but deleted from the DB the same day -
does it get re-added?
#5 - When does a contact get deleted from the DB? When the
first person deletes it from their folder or when no one
references the contact or by the DB Admin?
#5 - What's the priority of changes? Those made to the DB or
"last in"?
...................list of questions can goe on and on but all depends
on actual requirements/objective and importance of info.


Karl

--
__________________________________________________ ___________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



wrote in message
oups.com...
I would like to export every individual user's contacts and merge them
into a database so we have a complete list of contacts from all of our
firm members. I would also like to synchronize with the database to
keep the db list up to date

Karl Timmermans wrote:
The first thing you may want to do is clarify/define what you mean by
"**all**" the firm's contacts". Multiple Exch folders? GAL? etc

Depending on your definition - our ContactGenie Exporter product
(Premium
edition) may do what you're looking for -
http://www.contactgenie.com/cgxfeatures.htm

Karl
__________________________________________________ ___________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com


wrote in message
ps.com...
I am looking for a way to export **all** of the firm's user's
contacts
to an access database and also have some sort of synchronization
where
the Database gets updated with changes in the user's contacts for
our
marketing dept ... I have seen many products that do this for an
individual mailbox but not for collecting firmwide contacts. I would
appreciate any help in terms of product or code

Thanks!





 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Text Only Export into Access LI_SpeedyG Outlook and VBA 1 December 15th 06 05:12 PM
Outlook Web Access - Export Contacts?! RMarko Outlook - Using Contacts 4 December 6th 06 02:05 PM
Tasks--Export to MS Access craigs Outlook and VBA 2 August 15th 06 02:49 PM
How do I export contacts to Hotmail without the export software? Nessquirk Outlook - Using Contacts 1 June 13th 06 10:09 PM
Automating folder export from Outlook to Access [email protected] Outlook and VBA 1 March 6th 06 06:15 PM


All times are GMT +1. The time now is 11:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.