LDIFDE - Change Data Import Back to Domain

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

I want to add a digit to user's phone numbers for particular OUs. The
users phone numbers are all different however the digit being added
will be the same for all users in the particular OU.

I have sucessfully exported user accounts for a specific ou but am not
sure how to import the change back in. Should I use the CSVDE utility?

Any suggestions?
 
JB said:
I want to add a digit to user's phone numbers for particular OUs. The
users phone numbers are all different however the digit being added
will be the same for all users in the particular OU.

I have sucessfully exported user accounts for a specific ou but am not
sure how to import the change back in. Should I use the CSVDE utility?

Any suggestions?
Click to expand...

IF You exported this data using ldifde You can also import it using ldifde
 
Yes correct however in order to import this file back in to the same AD
environment I have to hack the file up which would be quite time
consuming. For instance here is what my exported file looks like, minus
several hundred users.

DN,cn
"CN=Account 1,OU=NewBrunswick,DC=Any,DC=com",Account 1
"CN=Account 2,OU=NewBrunswick,DC=Any,DC=com",Account 2
"CN=CN=Account 3,OU=NewBrunswick,DC=Any,DC=com",Account 3
"CN=Account 4,OU=NewBrunswick,DC=Any,DC=com",Account 4

Now in order to make the change to the telephone I would have to do the
following:

dn: CN=Account 1,OU=NewBrunswick,DC=Any,DC=com
changetype: modify
replace: telephonenumber
telephonenumber: 732-249-7600
-

dn: CN=Account 2,OU=NewBrunswick,DC=Any,DC=com
changetype: modify
replace: telephonenumber
telephonenumber: 732-249-7600
-

dn: CN=Account 3,OU=NewBrunswick,DC=Any,DC=com
changetype: modify
replace: telephonenumber
telephonenumber: 732-249-7600
-

dn: CN=Account 4,OU=NewBrunswick,DC=Any,DC=com
changetype: modify
replace: telephonenumber
telephonenumber: 732-249-7600
-

The idea is that I would like to be able to do this with a little less
effort.
 
Tried that as well. I have to make the change to the users one at a
time using this tool, at least I believe so, I posted a question to the
message board concerning this. It is definately more efficient then AD
User and Computers. But still not terribly efficient.
 
JB said:
Tried that as well. I have to make the change to the users one at a
time using this tool, at least I believe so, I posted a question to the
message board concerning this. It is definately more efficient then AD
User and Computers. But still not terribly efficient.
Click to expand...
Use ADSI script
 
Do not have a clue on how to use it any help would be much appreciated.
I will research this myself how to do it but I do not have any
experience with it.
 
JB said:
Do not have a clue on how to use it any help would be much appreciated.
I will research this myself how to do it but I do not have any
experience with it.
Click to expand...
for single user:
<code>
Set objUser = GetObject("LDAP://" & userDN )

objUser.Put "homePhone", objUser.Get("homePhone") & "7555"
objUSer.SetInfo
</code>

where userDN is distinguished name of user ex:
CN=Jan,OU=Test,DC=example,DC=COM


For all users in specified OU:
<code>
Set objOU = GetObject("LDAP://" & objOUPath)
objOU.Filter = Array("user")
For each objUser in objOU
objUser.Put "homePhone", objUser.Get("homePhone") & "7555"
objUSer.SetInfo
Next
</code>

where objOUPAth is OU=Test,DC=example,DC=Com

Of course this is simplest possible code
 
You have been very helpful thank you is there anyway I can push my luck
and ask for further assistance.I have modified the code that you have
given me as follows:

<code>
Set objUser = GetObject("LDAP://" & CN=John
Doe,CN=Users,DC=Domain,DC=com )

objUser.Put "telephonenumber", objUser.Get("telephonenumber") & "7555"
objUSer.SetInfo
</code>

Saved the notepad file with vbs extension and then when I run it I get
the following error.

Windows Script Host
Line: 1
Char: 1
Error: Expected Statement
Code: 800A0400
Source: Microsoft VBScript Compilation Error
 
Been Playing and changed the script as follows:

Set objUser = GetObject("LDAP://" & "CN=John
Doe,CN=Users,DC=Domain,DC=com")
objUser.Put "TelephoneNumber", objUser.Get("TelephoneNumber") & "7555"
objUSer.SetInfo

Now I receive the following error:
Windows Script Host
Line: 2
Char: 1
Error: The directory property cannot be found in the cache
Code: 8000500D
Source: Active Directory
 
After looking at your script I have come to the conclusion that it may
be easier to just use a script like this to specify the entire number
instead of having it edit the existing number. It is a four digit
number and would still be much quicker if I could use something like
this as opposed to the other methods I have been toying with.

Can you help me with modifying this script to accomplish this?
 
You may have moved on to bigger and better things. FYI for anyone that
may come accross the same. Here is the code to make the necessary
changes on a per user basis, I would now like to feed this a csv file
with multiple users and phone numbers:

Const ADS_PROPERTY_UPDATE = 2

'Need to duplicate all of the following for multiple accounts.

Set objUser = GetObject _
("LDAP://CN=USERNAME,OU=ORGANIZATIONALUNIT,DC=DOMAINNAME,DC=COM")

objUser.Put "telephoneNumber", "EXT"

objUser.SetInfo
 
JB said:
You may have moved on to bigger and better things. FYI for anyone that
Click to expand...

Not, not moved - just long day at work :)
may come accross the same. Here is the code to make the necessary
changes on a per user basis, I would now like to feed this a csv file
with multiple users and phone numbers:

Const ADS_PROPERTY_UPDATE = 2

'Need to duplicate all of the following for multiple accounts.

Set objUser = GetObject _
("LDAP://CN=USERNAME,OU=ORGANIZATIONALUNIT,DC=DOMAINNAME,DC=COM")

objUser.Put "telephoneNumber", "EXT"

objUser.SetInfo
Click to expand...

Yes, this is completly good code. Few words of explanation for Your
previous posts:

<quote>
Error: The directory property cannot be found in the cache
</quote>
This message indicates that You were trying to read property that was
not initialized or the name was misspelled - If user has no value in
this property when You invoke Get method this error can occur.

first two errors are just syntax error

I'm glad thath You sucseeded on Your own - it always good to learn
something new, huh?
 
Back
Top