Re: Global Address List

Hello TR,

Thank you for posting in the SBS newsgroup.

According to your description, I understand that you would like to export
all clients' contacts lists from Outlook and import the all contact files
into the Global Address List on the SBS 2003 Server. If I have
misunderstood your concern, please don't hesitate to let me know.

Based on my research and testing, there is a complex workaround for your
reference:

To export client's contacts lists from Outlook

1. Open the Outlook, point to File -> Import and Export

2. On the dialog box, select Export to a file, then click Next

3. Select Comma Separated Values (.csv) (Windows) option, then click Next

4. Select the appropriate Contact node, then click Next

5. Select the appropriate destination to save.

Use Csvde To Import all contact files into the Global Address List

1. You must manually edit the all contact files (.csv) with the proper
attributes.

2. Use csvde.exe to importcreate the user accounts. To do so, use the
following command: "Csvde -i -f import.csv"

For more information, please refer the following KB article:

327620 HOW TO: Use Csvde to Import Contacts and User Objects into Active
Directory
http://support.microsoft.com/?id=327620

The following sample CSV file adds a contact for John Doe to the Sales
Organizational Unit (OU) in the MYDOMAIN.local domain. This file also
creates the necessary Exchange SMTP addresses so that Outlook clients can
select this contact from the Exchange 2000 Global Address List.

1. Copy and paste the following text into a plain text editor (such as
Notepad), and then save the file with a .csv file extension:

DN,instanceType,distinguishedName,objectCategory,objectClass,name,cn,
displayName,mail,givenName,legacyExchangeDN,middleName,proxyAddresses,
showInAddressBook,sn,textEncodedORAddress,internetEncoding,mailNickname,
mAPIRecipient,targetAddress
"CN=John Doe,OU=Sales,DC=MYDOMAIN,DC=local",4,"CN=John Doe,
OU=Sales,DC=MYDOMAIN,DC=local","CN=Person,CN=Schema,CN=Configuration,
DC=MYDOMAIN,DC=local",contact,John Doe,John Doe,John Doe,
John@xxxxxxx,John,/o=MYDOMAIN/ou=first administrative
group/cn=Recipients/cn=
John Doe,,SMTP:John@xxxxxxx;X400:c=us\
;a= \;p=MYDOMAIN\;o=Exchange\;s=Doe\;g=John\;,"CN=Default Global Address
List,CN=All Global Address Lists,CN=Address Lists Container,CN=MYDOMAIN,
CN=Microsoft
Exchange,CN=Services,CN=Configuration,DC=MYDOMAIN,DC=local;CN=All
Contacts,CN=All Address Lists,CN=Address Lists Container,CN=MYDOMAIN,
CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=MYDOMAIN,DC=local",
Doe,c=us\;a=\;
p=MYDOMAIN\;o=Exchange\;s=Doe\;g=John\;,1310720,JohnDoe,FALSE,
SMTP:John@xxxxxxx


2. Use a spread*** program (such as Excel) to open this .csv file and
view the header and value information.

NOTE: The preceding sample text is intended to be saved as a .csv file as
an example only. Additional information in this article should be used to
modify your own files for importation into the Active Directory.

When you modify your own files, remember that the file headers that are
included in the preceding example must be present in order for the contact
to import into the Active Directory and be mail-enabled. Some data fields
must stay the same for any import, but some data fields must be changed to
import individual contacts.

Data for the following headers must be modified to fit the individual
importation:

- DN - This data field contains the object's distinguished name so that it
can be located in the Active Directory. In the following example John Doe
is the contact that will be added to the Sales OU in MYDOMAIN.local:
"CN=John Doe,OU=Sales,DC=MYDOMAIN,DC=local"

- distinguishedName - Contains the same information as DN.
- objectCategory - Defines the Active Directory Schema category. In the
following example, the category is Person for MYDOMAIN.local:
CN=Person,CN=Schema,CN=Configuration,DC=MYDOMAIN,DC=local

- name - Contact name.
- cn - Same as name.
- displayName - Usually the same as name.
- mail - SMTP e-mail address.
- givenName - Contact's first name.
- legacyExchangeDN - Legacy distinguished name for backward compatibility.
In the following example, John Doe is a recipient in the first
administrative group of MYDOMAIN:
/o=MYDOMAIN/ou=first administrative group/cn=Recipients/cn=John Doe

- middleName - Contact's middle name, or initial.
- proxyAddresses - SMTP Address and X400 designation.
- showInAddressBook - Displays the contact in the Global Address List.
- sn - Surname, or last name of the contact.
- textEncodedORAddress - Mail attribute.
- mailNickname - E-mail alias.
- targetAddress - SMTP e-mail address.

Data for the following headers stays the same for any import:

- instanceType - Exchange instance attribute.
- objectClass - Contact.
- internetEncoding - Internet encoding type.
- mAPIRecipient - FALSE indicates that the contact is not a domain user.

NOTE: Use Microsoft Excel Help for information about such functions as
"concatenate" that can simplify the process of building a .csv file.

Alternatively, you can create a Contacts Public Folder to archive your aim.

For more information, look into the following article:

258775 XADM: How to Create and Manage a Contacts Public Folder
http://support.microsoft.com/?id=258775

327620 HOW TO: Use Csvde to Import Contacts and User Objects into Active
Directory
http://support.microsoft.com/?id=327620

Otherwise, I suggest you also post in the Exchange Server newsgroup. The
reason why I recommend this is that you will get the most qualified pool of
respondents, and the Exchange Server newsgroup more focus in the Exchange
Server issue or solution. Thank you for your understanding.

For your convenience, I have listed the Internet Explorer newsgroup below:
Microsoft.public.exchange.admin

I hope this helps. If you have any questions or concerns, please do not
hesitate to let me know. I am always happy to be of further assistance.

Best regards,

Nathan Liu (MSFT)
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
>From: "Merv Porter [SBS-MVP]" <mwport@xxxxxxxxxxxxxxxxxxx>
>References: <#eXNl9iaFHA.612@xxxxxxxxxxxxxxxxxxxx>
>Subject: Re: Global Address List
>Date: Sun, 5 Jun 2005 20:57:47 -0500
>Lines: 20
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Response
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <ub09ksjaFHA.1384@xxxxxxxxxxxxxxxxxxxx>
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: pool-71-97-129-90.aubnin.dsl-w.verizon.net 71.97.129.90
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:124646
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>Not into the Global Address List but you could create a public folder,
copy
>the contacts to that folder, then set the permissions you need on it.
>
>--
>Merv Porter [SBS MVP]
>===================================
>"TR" <tsomething@somewhere> wrote in message
>news:%23eXNl9iaFHA.612@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi all,
>>
>> Is there a way to take a client's disconnected Contacts lists from
Outlook
>> on various computers he has now and import them all into the Global
>> Address List on his new SBS2003 so that all these contacts will become
>> available to all his employees on the new system?
>>
>> Thanks
>> TR
>>
>
>
>

.

Loading