Re: Global Address List
- From: "TR" <tsomething@somewhere>
- Date: Mon, 6 Jun 2005 22:06:15 -0400
thanks
I will give it a shot and let you know what happens.
TR
"Nathan Liu [MSFT]" <v-natliu@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:VxV59epaFHA.3336@xxxxxxxxxxxxxxxxxxxxxxxx
> 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
>>>
>>
>>
>>
>
.
- Follow-Ups:
- Re: Global Address List
- From: Nathan Liu [MSFT]
- Re: Global Address List
- References:
- Global Address List
- From: TR
- Re: Global Address List
- From: Merv Porter [SBS-MVP]
- Re: Global Address List
- From: Nathan Liu [MSFT]
- Global Address List
- Prev by Date: Re: Outlook web access sub-folder maximum?
- Next by Date: Re: Exchange 2003 SP2
- Previous by thread: Re: Global Address List
- Next by thread: Re: Global Address List
- Index(es):