Solved

SBS 2003, Import Contacts into CompanyWeb/Contact list

Posted on 2006-07-06
2
944 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
2 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This guide is intended for migrating Windows 2003 Standard with Exchange 2003 to Windows Small Business Server 2008. You will need the following: Exchange Best Practice Analyzer: http://www.microsoft.com/downloads/details.aspx?FamilyID=DBAB201F-…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

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