![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |