WOW!!! Man, I am blown away! Awesome Script!
I never thought of using the Jet OLEDB in this way. I already tested the files you have in your example and they work great. Tomorrow I am going to take this puppy in the lab and take it for a spin on about 1000 users.
dilettante, I thank you so...
dilletante and PHV,
Thanks for your responses. dilletante, you are absolutely correct in your description, basically it has all the elements you mention and yes I am retaining the formatting of the site by using a ";" as the delimeter.
The original problem is that the .csv file has a...
JGillespie,
Thanks for the response. Yes I do have an On Error Resume Next right before this snip, I use some error handling stuff in the Do While Loop. I'm not sure I follow what you mean by setting the aLine = "". Do you mean to set the variables like aLine = nothing? I know it is...
I am reading the file in a line at a time, the code above is only for formatting the file for use. Here is the snippet that actually reads the file into the script for use.
Const ForReading = 1
Set objFSO = CreateObject("scripting.filesystemobject")
Set objTF =...
I really can't post the entire script as it is over 600 lines and it is run on a DOD network, too much infrastructure specific things in it. But here is the part of the script I use for formatting the .csv.
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set TF =...
JGillespie,
Yes I am reading in the csv file a line at a time then using the split function to create an array that the script can use. I don't have a problem with blank lines throughout the script. It is one blank line at the very end of the .csv file that I am trying to get rid of. For some...
Bastien,
Thanks for the tips on TRIM and LEN, but this is not exactly what I am after. I need to be able to remove blank lines at the end of the .csv file, I don't have an issue with spacing in the lines of the .csv file that contain texts. Looking for other suggestions.
Thanks,
Z
I am having an issue formatting a .csv file. I wrote a script to create User accounts, the input used for the script is a .csv file exported from Remedy, when the file is exported it is not in the proper format, so I have written the scripting neccesary to take care of that. I am able to...
Well, not sure really what you are trying to do here. What are you trying to accomplish by copying these files to this directory. Looks like you might be trying to set the default desktop environmet, if so there are better ways to accomplish this. If not explain further please.
Z
You are on the right track the local accounts may seem identical, but they are really not. Example: If you have an account on CompA, CompB and CompC called Admin and has the same password it would appear that they are identical. But actually the credential is thus:
CompA\Admin
CompB\Admin...
Sorry about that, the site went through a redesign a little while back. Here is the new link. Enjoy!
http://www.mcseworld.com/forums/showthread.php?p=23708#post23708
Z
Go into AD users and computers and search for the computer account of the machine you are trying to add. Once you find it delete it. Then let AD cook(replicate) for a bit. Then go back and try to re-join the domain. Not sure why it is giving you a user already exists error. Just an Idea.
Z
Edge07,
You can run executables in vbscript by setting a shell environment like so:
Set wshShell = Wscript.CreateObject("Wscript.Shell)
Then you can run the exe file like so.
wshShell.run ("cmd.exe /c \\server\trackit\audit32.exe),0,True
You can follow it easily, the 0 tells it...
Sure thing, post up your question in the vbscript forum and maybe even the batch file that you are currently using. Tell them you are a vbscript "noob" and you would like some help rewriting this batch in vbscript, also tell them why. There are some great script writers over there, and...
...as the obscure Microsoft tools, They are all very well documented and fairly intuitive to use, If you don't think so try doing the same thing in a *nix environment and you will quickly change your mind.
In short RTFM, and you can not go wrong. Otherwise have your backup tapes handy cause...
Well I have noticed that you have several threads going on the DNS stuff you are dealing with. I would recommend that you get a good reference book and start there. DNS is a simple priciple concept, but can become increasingly complex as the configurations will be different to each environment...
You might want to consider rewriting the Logon script in vbscript. It is more robust than batch, and you can easily do what you are wanting to do but instead of disabling the close button, you can make the command window invisible to the user so they never even see it. Just an Idea.
Z
No it is not possible to have failover for the FSMO roles. There are 5 roles, different DC can have one or more of the roles. But if a DC goes down that hosts a FSMO role, you have to manually seize and move the role to another DC.
HTH,
Z
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.