Solved

Adding new contacts to a central list

Posted on 2007-11-17
6
578 Views
Last Modified: 2008-02-01
Greets, we are running SBS 2003 Exchange SP2.
I am seeking a nice solution to store thousands of company contacts. We have tried "Public Folder", but it is not always dependable. Is it wise to add 3,000 new contacts to the Global Address List? Is there any other way to do this. Contacts need to be cemtralized and viewable from Hand-held Pocket PC's as well as traveling laptops that are not always online. The administrative staff needs a place to add in contacts so that all users in the company have the same data and is easily accessable. Thanks for the help.
DR
0
Comment
Question by:tagltd
  • 3
  • 2
6 Comments
 
LVL 74

Assisted Solution

by:Jeffrey Kane - TechSoEasy
Jeffrey Kane - TechSoEasy earned 62 total points
ID: 20306887
No, it's absolutely not wise to add 3,000 new contacts to the Global Address List.  Managing that would be a nightmare, plus there are very few fields in the GAL so gathering useful business information about those contacts is impossible.

It sounds like you need a CRM system.  Depending on how may users you have, you could use Microsoft Business Contact Manager for Outlook.  

If you are using Outlook 2003, please see:
http://office.microsoft.com/en-us/outlook/HP102186801033.aspx?pid=CH012060611033

If you are using Outlook 2007, please see:
http://office.microsoft.com/en-us/contactmanager/FX101674171033.aspx

BCM is a FREE add-on to Office 2003/2007 Small Business or Professional Editions.

The database can be installed on your SBS for centralized access, and can be cached on any laptop for offline access as well.  (http://office.microsoft.com/en-us/outlook/HA100676851033.aspx?pid=CH101207721033)

Demos online:  http://blogs.msdn.com/bcm/archive/2007/04/23/bcm-demos-are-live-on-office-online.aspx

BCM works well with up to about 10 users.  When you have more users than that needing access, you might want to consider Microsoft Dynamics CRM:  http://www.microsoft.com/crm which is available in either a hosted (on-line) version or on-premise.  CRM is a lot more than a contact list though, so this may be much more than what you're looking for.

One other alternative is to use Windows SharePoint Services, since you have SBS, this is installed by default as your http://companyweb.  You could easily add a new "Contact List" which can be managed easily with Access.  A SharePoint Contact List can be linked to Outlook as an Address Book as well.  

Details about SharePoint as a contact list are here:  
http://office.microsoft.com/en-us/sharepointtechnology/HA011377891033.aspx

Hopefully that gives you enough of an overview of your options. Please let me know if you need further info.

Jeff
TechSoEasy
0
 

Author Comment

by:tagltd
ID: 20307011
Hi Jeff, Thanks for the extended explanation. Here are my thoughts:
1) GAL, understood. Would be a big mistake to use. I will take your advice.
2) We use Outlook 2003 on the systems that need the centralized contact list.(the link you gave me linked me to a lecture on IIS and FTP security and had nothing to do with Contact Manager)
3) BCM seems to be a possible solution. We probably need only 5-7 users max with this feature so it matches your "10 or less" configuration.
4) Share Point, we tried it and the use and management are frustrating and sometimes hard to operate for particular users. I will pass on this.

If you have any other possible solutions, then please feel free to suggest them. Many thanks!
DR
0
 
LVL 104

Accepted Solution

by:
Sembee earned 63 total points
ID: 20307731
What is wrong with public folders? I have that running on a number of sites and it works well. There are no capacity issues other than what the human mind can cope with.

The problem you have is the requirement to view those items offline and on handhelds. Many solutions will not allow that because of the nature of the information. Some applications will literally have the same database on the laptops, so will be using some kind of database (MSDE/SQL Express usually) and then attempt to sync back. Handhelds - no handheld is going to take 3000+ contacts. That is a lot of space required. That is why the GAL isn't stored on the handheld but is used on a live lookup.

You probably need to look at something web based that has handheld support so that it can be viewed live rather than an offline copy.

Simon.
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 20310567
Sorry about the link for Outlook 2003 BCM I've corrected it now, so the link goes to the right place.

"If you have any other possible solutions, then please feel free to suggest them"

If you have 5-7 users, then there aren't any other native solutions to look at.  There are third party ones, but I've not used any that I could recommend.  There are also on-line solutions but they may not be available in your part of the world and they wouldn't satisfy the offline laptop issue.

So, BCM is really what I'd recommend.  It does support PocketPC and SmartPhone integration as well.
http://www.microsoft.com/downloads/details.aspx?familyid=7bc78c14-7143-41d9-84a9-bd628db7b6a0&displaylang=en

And that's not true that a handheld can't hold 3000+ contacts.  I've got more than that on mine and the contact database is stored on a 2GB mini-SD card.  The contact database (which is handled by MSDE/SQL Express) only takes about 350MB on mine, and it can take less depending on how much data from each record you want to sync with the PPC.
::
Jeff
TechSoEasy
0
 
LVL 104

Expert Comment

by:Sembee
ID: 20319160
A handheld with a memory card will take all of those contacts, but that does expose your data quite badly. Remote wipe doesn't wipe a memory card, it can be easily removed and the data stolen. I was referring to the internal memory of the device - Blackberry devices didn't have memory card support until very recently.

Simon.
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 20319245
You can find problems with any solution... to me, those are all solvable and the benefit of having everything with me is invaluable.  Here are some tips:  http://www.microsoft.com/midsizebusiness/businessvalue/mobile-security.mspx

Jeff
TechSoEasy
0

Featured Post

Swamped with email signature updates?

Have you been given a load of changes to make to your users’ email signatures? Having to manually implement multiple signatures for every department? Let Exclaimer save you from being swamped with email signature updates!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now