Is your server running slowly? Check with SolarWinds ipMonitor.
Get your free evaluation copy of ipMonitor
here
IPAM will assist
you in managing IP addresses.
To let you into a secret, this utilities is fun to use, even if you
don't have a pressing need to calculate your IP address space.
Get a free evaluation copy of
Orion IPAM
Introduction to Troubleshooting CSVDE Techniques
The art of troubleshooting is to narrow down the search. With CSVDE, there are three avenues to investigate, so the sooner you can rule out two and concentrate on the remaining avenue the better.
- Active Directory - Example: does the username already exist.
- Excel Spreadsheet - Example: is there a blank column.
- CSVDE - The command syntax itself. Example: an extra comma, or space, perhaps a missing bracket.
Troubleshooting CSVDE ProblemsMy best advice is - keep it simple. Get a basic CSVDE example working. Build on success. If all else fails try an Export, if that won't work nothing
will. If that did work, then examine the CSV file, compare the first row of the export with the first row of the import.
Remember that you cannot use CSVDE to set user's passwords, for passwords you need VBScript. Moreover the default domain Group
Policy may be blocking the import unless especially if you set the UserAccountControl = 512. Other Active Directory problems revolve around spelling mistakes in the name of the domain. Indeed, in some cases
the domain name is not what people thought it was. Launch ADSI Edit to check the spelling of the LDAP properties. OUs have there share of problems. Does the OU in your spreadsheet actually
exist? Remember that the USERS is a container is not an OU, so it would be CN=USERS. Nested OUs give problems, so start by just using a top level OU. The problem is that the lowest level OU is
the first OU in the script. (Lowest is Leftmost).
Guy Recommends: SolarWinds LANSurveyor
LANSurveyor will produce a neat diagram of your network topology. But that's
just the start;
LANSurveyor can
create an inventory of the hardware and software
of your machines and network devices. Other neat features include dynamic
update for when you add new devices to your network. I also love the ability to export
the diagrams
to Microsoft Visio.
Finally, Guy bets that if you take a free trial of LANSurveyor then you will
find a device on your network that you had forgotten about, or someone else
installed without you realizing!
Download a Free Trial of LANSurveyor
If you are exporting, make sure that a spreadsheet of the same name is not already
open. There must be no blank columns. Naturally, you can have blank values for non-essential attributes such as displayName. The DN gives most problems, double check the commas, and speech
marks. One of my nastiest problems was two single quotes pretending to be one double quote. Another problem was a client thinking dc= meant domain controller. Wrong, dc= mains domain
context. If you keep on getting the CSVDE help screen, then there is a problem with your switch, for example there is no -e for export.
In order to export, all you need is CSVDE -f filename.csv. The hardest problem that I had was with an unwanted ° that appeared when I tested my examples by copying and pasting
from the html page into the CMD prompt. The extra ° only appeared when I copied the text into Word for Windows. For example, CSVDE -i °-f Newport.csv. Sometimes closing the CMD prompt window, then re-opening magically
clears the problem. When you start a second CMD prompt, CSVDE suddenly works, whereas previously it failed. I only solved my latest mystery error by logging off and logging on again.
I say again if CSVDE fails or encounters an error it seems to freeze when you subsequently issue a perfectly valid command.
If you get a clear error message then
refer to this page. For example, if the error message begins: "Add error on line 2:" see more here.
- Ignoring errors with - k (Only works for import)
- Logging errors with -J and -v
- In Active Directory Users and Computers, right click and Refresh (F5 does not always work)
- Re-reading the error message - every word, very s l o w l y
- Opening and closing the CMD Prompt
- Logoff and logon again
- Importing to a different top level OU
- Typing the CSVDE command by hand (Instead of copying and pasting)
- An Export - who knows what you will find if you examine the first two rows
- Go away for 10 minutes, take a walk, make a drink, have a bath (All my best ideas occur in the bath)
Narrow down the problem. Is it a typo? Check Active Directory. Could it be a problem with the
spreadsheet, do you have a good CSVDE error message?
See Also
|
Save
hours of frustration and buy Guy's eBook. The extra features include:
detailed instructions on how to import and export user accounts, ten new pages
of worked CSVDE examples.