You may need to surround your text file name with parenthesis: '...in (phoneupdate2.csv) do admod.exe...'
Also, open your text file in notepad or something similar and see if the fields are surrounded by quotes; if so, get rid of the quotes. From: David Lum [mailto:[email protected]] Sent: Friday, December 17, 2010 1:00 PM To: NT System Admin Issues Subject: RE: LDIFDE brain cramp Thanks1 1. I always dump to Notepad first - removes the funny stuff and once I get a command to work I save the notepad document for later use and reference. I then cut and paste from Notepad to the command line. 2. Yes I created a 2nd text file with just 2 accounts. In addition I am testing it on a cloned DC VM so I can not affect production. Command run: for /f "tokens=1,2,3 delims=;" %1 in phoneupdate2.csv do admod.exe -b "%1" "telephoneNumber::%2" "otherTelephone::%3" Result: "1 was unexpected at this time" Text file content was in the format you listed without my obfuscation ..semicolons delimiting each record From: Coleman, Hunter [mailto:[email protected]] Sent: Friday, December 17, 2010 11:21 AM To: NT System Admin Issues Subject: RE: LDIFDE brain cramp 2 other things: -You'll need to retype the command rather than copy/paste. Outlook tends to wreck the "-" character and convert it to an emdash, which hoses the command line. -test it on one or two accounts before doing it on all of them From: David Lum [mailto:[email protected]] Sent: Friday, December 17, 2010 12:11 PM To: NT System Admin Issues Subject: RE: LDIFDE brain cramp OH? I can change my formatting to match that format easy. Does the admod you posted command need any changes other than the correct filename to work as is? From: Coleman, Hunter [mailto:[email protected]] Sent: Friday, December 17, 2010 10:58 AM To: NT System Admin Issues Subject: RE: LDIFDE brain cramp If you have a text file that has your desired information in a format like cn=David Lum,ou=Users,dc=domain,dc=nwea,dc=pvt;503-548-5229;5229 then you can run something like for /f "tokens=1,2,3 delims=;" %1 in (yourFile.txt) do admod.exe -b "%1" "telephoneNumber::%2" "otherTelephone::%3" From: David Lum [mailto:[email protected]] Sent: Friday, December 17, 2010 11:39 AM To: NT System Admin Issues Subject: LDIFDE brain cramp So I need to change 295 phone numbers in AD, and I could have SWORE I've done similar without too much headache, but it looks like taking an LDIFDE export and making it a "modify" is far more involved than an add. Sample exported record: dn: CN=David Lum,OU=Users, DC=Domain,DC=nwea,DC=pvt changetype :add telephoneNumber: 4311 otherTelephone: 971-222-1025 I need it to change to: dn: CN=David Lum,OU=Users, DC=Domain,DC=nwea,DC=pvt changetype :modify replace: telephoneNumber telephoneNumber: 503-548-5229 - Replace: otherTelephone otherTelephone: 5229 I usually use Excel to handle repositioning/matching magic, but can't figure this one out and there has to be a better way. Anyone? David Lum // SYSTEMS ENGINEER NORTHWEST EVALUATION ASSOCIATION (Desk) 971.222.1025 // (Cell) 503.267.9764 ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
