EVeuger
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>Zeis t>notebook s
Domain:sous.edit.com
I know the syntaxis for the tool itself, just not for the input file.
Thanks!
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>Zeis
Domain:sous.edit.com
I know the syntaxis for the tool itself, just not for the input file.
Thanks!
For more import /export techniques using CSVDE have a look at following:
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Export.htm
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Bulk.htm
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_import.htm
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Export.htm
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Bulk.htm
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_import.htm
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=ma thys,DC=lo cal",compu ter
Command line: csvde -i -f c:\new.csv
Result:
C:\Documents and Settings\Administrator>csv de -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?
Content file (new.csv):
DN,objectClass
"CN=NL1NB002,OU=test,DC=ma
Command line: csvde -i -f c:\new.csv
Result:
C:\Documents and Settings\Administrator>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?)
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?)
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK, that worked!
Points for you!
thanks!
Points for you!
thanks!
Thats great, Thanks for the points.
DN,objectClass
"CN=NL1NB001,OU=Netherland
And Import it like:
CSVDE -i -f Comps.csv
Hope this helps!
Farhan