Re: Exchange 5.5 to SBS2003 migration question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bill Peng [MSFT] (v-bpeng_at_online.microsoft.com)
Date: 01/07/05


Date: Fri, 07 Jan 2005 03:00:43 GMT

Hi Joe,

Yes, I tested it on my SBS 2003 test machine and it works fine.

To narrow down the root cause of this issue, please do the following tests:

1. Create a file named C:\test.csv
2. Use NotePad to open this file.
3. Please copy and past the following content into the NotePad.

DN,objectClass,cn
"CN=testcommonname,CN=Users,DC=DOMAIN,DC=LOCAL",contact,testcommonname

[Note 1:] Please make sure that you've used the quotation marks to included
the DN.
[Note 2:] Please change the DC=DOMAIN,DC=LOCAL to your domain's DN.
[Note 3:] Please refer to KB 327620 I mentioned in the previous reply. To
import a contact, there should be at least DN, objectClass and CN entries.
[Note 4:] If you're using Microsoft Excel to modify the .csv file, please
click "Yes" when Excel prompts "test.csv may contain features that are not
compatible with CSV (Comma delimited). Do you want to keep the workbook in
this format?)".

4. Save the file.
5. Click Start and click Run.
6. Type cmd and click OK.
7. In the CMD prompt, please key in the following command and press Enter.

Csvde -i -f c:\test.csv

8. Make sure that the command succeeded.
9. Click Start and click Run.
10. Type dsa.msc and click OK.
11. Under "Users" container, please check whether the testcommonname
contact has been created.

If the above steps succeeded, the Csvde command works fine and the problem
should be your .csv file. If you would, please double-check it against KB
281563.

XGEN: Exchange Server 5.5 to Exchange 2000 Attribute Mappings for the
Migration Wizard
http://support.microsoft.com/default.aspx?scid=KB;EN-US;281563

If the problem persists, please post the content of your .csv file to the
newsgroup with the error message when you run the csvde command; then, I
will analyze them.

Have a nice day!

Bill Peng
MCSE 2000, MCDBA
Microsoft Online Partner 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: Joe <joe@jretrading.com>
>Newsgroups: microsoft.public.windows.server.sbs
>Subject: Re: Exchange 5.5 to SBS2003 migration question
>Date: Thu, 6 Jan 2005 21:30:13 +0000
>Organization: JRE Trading Ltd
>Lines: 34
>Message-ID: <iykLYnHl3a3BFwAc@jretrading.com>
>References: <96553526-96F2-468F-91DC-9010C360E5B3@microsoft.com>
> <tpabSn78EHA.1392@cpmsftngxa10.phx.gbl>
>NNTP-Posting-Host: jretradingltd.demon.co.uk
>Mime-Version: 1.0
>Content-Type: text/plain;charset=us-ascii;format=flowed
>X-Trace: news.demon.co.uk 1105047230 11895 80.177.211.93 (6 Jan 2005
21:33:50 GMT)
>X-Complaints-To: abuse@demon.net
>NNTP-Posting-Date: Thu, 6 Jan 2005 21:33:50 +0000 (UTC)
>User-Agent: Turnpike/6.02-S (<E0utCD8Xw3IXQW5z677XXvu+AT>)
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.zanker.org!feeder.enertel.nl!nntpfeed-01.ops
asmr-01.energis-idc.net!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.
com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.u
k!blueyonder!peer-uk.news.demon.net!kibo.news.demon.net!news.demon.co.uk!dem
on!jretrading.com!joe
>Xref: cpmsftngxa10.phx.gbl microsoft.public.windows.server.sbs:134971
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>In message <tpabSn78EHA.1392@cpmsftngxa10.phx.gbl>, "Bill Peng [MSFT]"
><v-bpeng@online.microsoft.com> writes
>>Hi Bobby,
>>
>>When you migrating SBS 5.5 to SBS 2003, Exchange does not provide a
>>build-in feature to migrate custom recipients and DLs; however, we can
>>export the directory from Exchange 5.5 server as a .CSV file and then use
>>Csvde tool to import it to Exchange 2003 active directory after
>>modification.
>>
>[Snip details]
>>
>>Open a command prompt and enter: csvde -i -f filename. For more
information
>>about how to use Csvde to import contacts and user objects into Active
>>Directory, please refer to the following article.
>>
>Could I ask if you've actually done this successfully?
>
>A few months ago, I spent five or six hours trying to manipulate the
>ES5.5 data into a form that either csvde or its LDIF cousin would import
>to AD. I manually created some AD contacts and exported them to examine.
>They looked pretty standard LDAP, but I wasn't able to re-import these,
>either.
>
>I couldn't get past the AD error message saying that multiple components
>were not permitted in DNs, no matter what quotation or separation I
>tried. DNs are by definition composite, of course.
>
>I posted a question here but apparently nobody had actually done this.
>Everyone advised using public folders for contacts, but I wanted them in
>AD. There were only about 80 contacts, and after a while I lost interest
>and typed them in by hand.
>--
>Joe
>



Relevant Pages

  • Re: Using CSVDE to reset invidually set mailbox storage limits
    ... I am trying to reset all user accounts with ... I took an AD export (with CSVDE), ... resulting CSV file in Excel by changing all the mDBUseDefaults FALSE ...
    (microsoft.public.windows.server.active_directory)
  • Re: How to create list of user accounts at once?
    ... > The easiest way to use CSVDE is to export a test user object with example ... Use CSVDE to import it. ... >>> list in Microsoft Excel (also CSV file). ...
    (microsoft.public.windows.server.active_directory)
  • Re: Export mailadresses in Exchange 2003
    ... CSVDE would result in a csv file that is easier to read in Excel. ... objects that will have SMTP addresses). ...
    (microsoft.public.exchange.admin)
  • Re: Enumeration of AD
    ... You can use the CSVDE command line tool to extract a subset of the LDAP ... Here is an example VBScript program that documents all user Distinguished ... Microsoft MVP Scripting and ADSI ...
    (microsoft.public.windows.server.active_directory)
  • Re: Using CSVDE to reset indivually set mailbox storage limits
    ... Can't use csvde to modify, ... Now I have tried to do this using CSVDE. ... then modified the resulting CSV file in Excel by changing all the ... Should LDIFDE be used instead?? ...
    (microsoft.public.exchange.admin)