Re: Importing schema properties

It depends...

If the users already exist in the directory you cannot use csvde to update them. In that case a custom script will need to be written that loops through the CSV file and updates the appropriate attributes.

Also, importing Schema properties/changes is something different than what is described here. OP will confuse folks by saying schema unless they are actually modifying the schema of a domain. It will effectively limit how many people look at the post as well as schema questions scare a lot of people.

joe

--
Joe Richards Microsoft MVP Windows Server Directory Services
Author of O'Reilly Active Directory Third Edition
www.joeware.net


---O'Reilly Active Directory Third Edition now available---

http://www.joeware.net/win/ad3e.htm



Vincent Xu [MSFT] wrote:
Hi,

Since you already have a CSV file, you can use a tool called CSVDE to import it. Please refer to following article:

327620 How to use Csvde to import contacts and user objects into Active Directory
http://support.microsoft.com/default.aspx?scid=kb;EN-US;327620

Hope it helps.

Best regards,

Vincent Xu
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 this issue. ======================================================
This posting is provided "AS IS" with no warranties,and confers no rights. ======================================================



--------------------
From: "jim" <jim@xxxxxxxxxx>
Subject: Importing schema properties
Date: Wed, 26 Apr 2006 13:28:10 -0400
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
Message-ID: <OTpKLbVaGHA.4248@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.win2000.active_directory
NNTP-Posting-Host: pat.axcelis.com 12.146.8.100
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.win2000.active_directory:113342
X-Tomcat-NG: microsoft.public.win2000.active_directory

We're in Win2k3 native mode at the top domain/forest functional levels.

What's the best way to import schema information that we have stored in a CSV file? In other words, a CSV file that contains user names (for
existing
users) and different information specific to their country's and regions. We'd like to import the information in the CSV so that it populates each user object with the additional info in the appropriate fields.

Any thoughts?




.

Relevant Pages

  • Re: Validate a CSV file
    ... a SP into a clone of the target table (just schema). ... >validate against our database.I was thinking about loading that CSV file ... >into a Typed-Dataset which has our database schema in it and then try to ... > of those refferecing tables into my dataset as well? ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Validating a (wrong) message just succeeds
    ... bad csv file that reproducess the problem so that I can look into this. ... I'm running into validation problems with Biztalk 2004. ... not more than the one in the schema of course. ... the 9th field of the first record is simple ...
    (microsoft.public.biztalk.general)
  • Re: What is the logic of storing XML in a Database?
    ... proprietary schema format for flatfiles and sell a proprietary tool ... for validating a CSV file that conforms to the flat file. ... I thought XML was supposed to be used for transport? ...
    (comp.databases.theory)
  • Re: Strange schema behaviour
    ... I have a schema that defines some tables. ... Table1 say, has columns A, B, C, D and E ... which is a property of the Columns property of the Table they are in a ... I don't recall ever seeing this happen with a CSV file. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Exchange 5.5 to SBS2003 migration question
    ... I tested it on my SBS 2003 test machine and it works fine. ... If you're using Microsoft Excel to modify the .csv file, ... the Csvde command works fine and the problem ...
    (microsoft.public.windows.server.sbs)
Loading