Link to home
Start Free TrialLog in
Avatar of EVeuger
EVeugerFlag for Netherlands

asked on

Adding computer objects using CSVDE

I would like to use CSVDE to import a large amount of computer objects on a Windows 2003 server.
I can only find example files for user objects.

Can someone write me an example for the following case:
Computer object name: NL1NB001
OU structure:Netherlands>Zeist>notebooks
Domain:sous.edit.com

I know the syntaxis for the tool itself, just not for the input file.

Thanks!
Avatar of Farhan Kazi
Farhan Kazi
Flag of Australia image

Copy following lines into file (like comps.csv)

DN,objectClass
"CN=NL1NB001,OU=Netherlands,OU=Zeist,OU=notebooks,DC=sous,DC=edit,DC=com",computer

And Import it like:

CSVDE -i -f  Comps.csv

Hope this helps!
Farhan
Avatar of EVeuger

ASKER

I tried the following on the DC: (please note that this was a test on a different domain and OU)

Content file  (new.csv):
DN,objectClass
"CN=NL1NB002,OU=test,DC=mathys,DC=local",computer

Command line: csvde -i -f c:\new.csv

Result:

C:\Documents and Settings\Administrator>csvde -i -f c:\new.csv
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "c:\new.csv"
Loading entries.
Add error on line 2: Constraint Violation
The server side error is "A required attribute is missing."
0 entries modified successfully.
An error has occurred in the program

C:\Documents and Settings\Administrator>

Any idea which attribute is missing?
>> Connecting to "(null)"
You are probably trying CSVDE from an XP machine??  Try adding -s <servername> swtich.

csvde -s DomainControlerNameHere -i -f c:\new.csv

Or there may be misnamed container (does mathys.local exist?)
Avatar of EVeuger

ASKER

I was running it on the DC using TS. I added the server switch to make sure and I get the same error.
The only change is that it now connects to the server in stead of "(null)"
Mathys.local is our domain, so that should be OK.

Any more ideas?
ASKER CERTIFIED SOLUTION
Avatar of Farhan Kazi
Farhan Kazi
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of EVeuger

ASKER

OK, that worked!

Points for you!

thanks!
Thats great, Thanks for the points.