Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SBS 2003, Import Contacts into CompanyWeb/Contact list

Posted on 2006-07-06
2
Medium Priority
?
956 Views
Last Modified: 2008-01-09
I am trying to import contacts into the "Contact list" within the "CompanyWeb" on a SBS.

I first tried importing the contacts from an Excel spreadsheet into a user's Outlook Contacts.  However, the Contact List import feature does not identify this users contacts to import.  Second, I created a web administrator/power user and imported the Excel contacts into that Outlook Contacts.  When I go to the CompanyWeb, Import Contacts - it allows me to do a drop down to all contacts, but none of the contacts are shown.

Simply, How do I import contacts into a CompanyWeb contact list?  It CAN'T be this difficult.
0
Comment
Question by:redvipergts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 2000 total points
ID: 17062849
Since the Contacs is a "List" you can convert the Excel document into a list and then just attach it as a data source in SharePoint.

To make this easier, create a new Data Sheet View for your Contacts List (they offer this view in other areas by default, I don't know why the Company Contacts list didn't get one).  

To do this, Go to the Contact List in Companyweb, Click Modify Settings and Columns, at the very bottom is "Create new View".  Select Datasheet view, and then give it a name, check ALL field names, and click OK.

Then go back to the list and click on your new VIEW.  Then click on Task Pane > Query List with Excel.  You can have it create a new workbook and then copy and past your current Excel sheet into this new one.  Changes will automaticly be updated in SharePoint.

Jeff
TechSoEasy

0
 
LVL 1

Author Comment

by:redvipergts
ID: 17094029
That works.  Thanks Tech.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

The SBS 2011 release date (RTM) is supposed to be around Christmas, 2011.  This article is a compilation of my notes -- things I have learned first hand.  The items are in a rather random order, but I think this list covers most of what is new and d…
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

730 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