Explore topic-wise InterviewSolutions in .

Hi
I have written a batch file that downloads a file from a website and I have added a line that will write text to a log file if there is an error ie no network or website unavailable but the Internet Explorer windows remains open after the batch file ends
Can someone tell me how I can have the Internet Exporer window to close if there is no network connection or the website is unavailabe.

Thanks
GingerAre you going to let us see the batch file, or not?
Quote from: Salmon Trout on September 04, 2010, 10:36:35 AM

Are you going to let us see the batch file, or not?

Corruption once again.

Anyway, Ginger, you could try something in the likes of
Code: [Select]IF pingDoesntSucceed
DO exit iexplorer
(I don't know, I'm just giving some tips here).

I think, rather than ponder how to close the right instance of Internet Explorer, I would rather avoid opening it at all, and use something like wget or curl, or a vbscript to find out if the network connection, website and desired file are all available, if so to get the file, if not to take appropriate action.

Code: [Select]F:\>ping www.slkqjdfmlkjsdf.com
Ping request could not find host www.slkqjdfmlkjsdf.com. Please check the name a
nd try again.

since invalid hosts still seem to resolve, but that might just be my DNS

advancedsearch.virginmedia.com

I'm pretty sure it is.

I am using the MOVE command, but running in to a problem.  If I put the command in to a Command WINDOW it works fine, but from a batch file I get errors.  Why?  I am running on a Windows 7(64 bit).

move /Y C:\#CAMS\Download\DST_exe\*.* C:\%Backup\DST\

If I use this at a DOS prompt it works great. 
If I use it in a batch file I get the messages "Cannot move multiple files to a single file"

Both folders do exist, and there are multiple files in them.

Maybe there is a better way.  What I am doing is moving file I download then extract files from (exe files and zip files)  to a different directory.  For example, all DST Files are an EXE file that is then ran and put in a 'DST_Work' folder for the DATABASE to PROCESS.  I clear the 'Work" folder, but I want to archive the files in the "DST_exe" folder.  I have 5 vendors like this.  Some are exe, some are zip, and another uses a different format.

Any advice is appreciated.

MichaelThere's a number of syntax problems with your line of code.

% needs to be escaped as %%. Better yet, you shouldn't use this character in folder or file names...

You should also surround your paths with QUOTATION marks, so the command doesn't screw up when it encounters a space.

move /Y "C:\#CAMS\Download\DST_exe\*.*" "C:\%%Backup\DST\"

If Backup is supposed to be an expanded variable, it's because you forgot the second %.

move /Y "C:\#CAMS\Download\DST_exe\*.*" "C:\%Backup%\DST\"

You see, % is USED in expanding DOS variables.

I'm writing a script which I want to support reading unicode paths from a text file. I want all the unicode to be reproduced the same as pasting the characters into DOS where it appears as a square-like character. (DOS has no problem dealing with unicode characters, they just can't be displayed and this is fine.)

Type will not reproduce unicode from a text file properly, regardless of the file's encoding and the current code page. For cannot process type's junky unicode output which makes it impossible to stick in a variable. For has no problem with pasted unicode as aforementioned...

So far:
I open cmd.exe /u so I can redirect a unicode path to a text file. This encodes it as UTF-16LE. Let's say I have the path containing the Japanese hiragana "ki". The path and UTF-16LE-encoded text file look like this:
"C:\Folder き"

Basically, I need a utility that works like type to read the text file and reproduce this string properly, as-is. I was told gawk might be able to do it, but I don't have a clue where to start with gawk.

Can anyone who knows vbscript accomplish this in vbscript? If it can't output the text properly to command prompt, if it can at least send the lines properly as arguments to an executable, that would be okay. I found this (second half, Unicode to ASCII) but don't know how much it could help. I've spent hours on this scouring the web and I've found next to nothing. Help please! Thanks!I am not sure I understand what you are trying to say in your description, but I do understand the question in the subject so THATS what I am going to answer.

I think in order to turn a ASCII text file into a unicode text file, you simply need to rewrite the file with every 2nd byte a null character. I might be wrong. If I am not, this could probably be accomplished in almost any programming language that supports file IO. In VB you could allocate two byte arrays. One of which twice the size of the other. The file could then be read into the first array and then copied to every other byte in the second array. Then every 2nd byte in the 2nd array could be set to 0. Finally, the second array could be written back to the file or to a new file if necessary.

If it is confirmed that my reasoning is correct, then I would write the code for you. I am just not sure that this is the correct way to convert.Thanks for responding. As you thought, you're not on the right track. Btw, Japanese characters overwrite that 00 padding, as part of unicode.

I have a text file encoded as UTF-16LE containing the following:
"C:\Folder き"

I want to type this file in a batch script to the same effect as typing set MYVAR="C:\Folder き" manually in command prompt, where the き character would appear as a square (which means the character is there, it just can't be displayed). But as I described, the type command only works properly with ANSI text files, and type-ing the text file within a for loop to set the output to a variable does not work - for fails. For works fine when entering the text manually as I described though. It leads me to believe it's how type outputs the characters based on the current code page, which is apparently not the same.

Again, I believe I just need a vbscript or something that can output the text file properly - in the same character coding context as doing it manually.

Edit: I should probably show what I'm describing after all, lol.

for /f "delims=" %%x in ('type unicode_path.txt') do set myvar=%%x

Does not do anything, because type is outputting sloppy ANSI/code-page interpreted unicode and for doesn't like it.

I think it would be a command prompt REVOLUTION of sorts if you could code a vbscript which works! This is a big issue! lol

I'm likely to reproduce my big script in PowerShell once it's done (I'll still complete it, unicode or not), but I'd like to exhaust any options first.Is this sufficient? It just reads a text file into the command prompt. There is a way to make it take the file name as an argument, but I can't remember that part right now. You probably could have done that yourself, but i figured I would respond anyway. I might be able to come up with something better later if needed. I am using a MAC now.

Code: [Select]Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("c:\blablabla.txt", 1)
Do Until objFile.AtEndOfStream
Wscript.Echo objFile.ReadLine
Loop
objFile.Close

EDIT: Be aware that you have to run this using cscript not wscript or it will just pop up a messagebox.I don't know vbscript at all actually, it's one of those things I can read but can't write.

I only need to process one file, so it doesn't need to accept a file name for an argument, but it does need to work with relative paths so hopefully that's not a problem.

I tested it and it's reading the text file similar to type, bad encoding. The only difference being that I can manipulate the output in for, so that's a good sign that it could just require some encoding work next.

There might be some vbscript clues in the link in my original post:

http://www.xtremedotnettalk.com/showpost.php?p=457931&postcount=7

Here is what they all output. UNI is the unicode file I'm working with. UTF is the unicode file converted to UTF-8. I also changed code pages from the default to UTF-8 just to see:



One more thing, if type utf.txt under the UTF-8 code page would work with for, that would almost solve the problem, except that I'd need a utility to convert the UTF-16LE file to UTF-8, and changing to code page 65001 makes batch scripts exit...  

I think I did it. I decided to program it in c because I thought this may be a useful tool for other people to use and it seems more official to make an exe tool. I know you said you didn't need it to take arguments, but I added one anyway just encase someone else needs it.

I've attached the exe and code below.

[recovering disk space - old attachment deleted by admin]I just realized that what I posted might not work. Do you just want all the unicode characters removed from the string or do you want to replace them with a space or a box or what?

I will reply with new code when you confirm this. I have already put way too much time into this thread so bear with me until I can figure this out.If you  can use Python,
Code: [Select]import codecs
import sys
inputfile=sys.argv[1]
f = codecs.open( inputfile, "r", "utf-16" )
for line in f:
   print line

output
Code: [Select]C:\test>more i.am.utf16.file.txt
here i am , utf-16 encoded file

C:\test>file i.am.utf16.file.txt
i.am.utf16.file.txt; Little-endian UTF-16 Unicode text, with no line terminators

C:\test>od -c i.am.utf16.file.txt
0000000       ■   h  \0   e  \0   r  \0   e  \0      \0   i  \0      \0
0000020   a  \0   m  \0      \0   ,  \0      \0   u  \0   t  \0   f  \0
0000040   -  \0   1  \0   6  \0      \0   e  \0   N  \0   c  \0   o  \0
0000060   d  \0   e  \0   d  \0      \0   f  \0   i  \0   l  \0   e  \0
0000100  \n  \0
0000102


C:\test>python test.py i.am.utf16.file.txt
here i am , utf-16 encoded file


its so much easier Quote from: Linux711 on September 08, 2010, 03:31:39 PM

I just realized that what I posted might not work. Do you just want all the unicode characters removed from the string or do you want to replace them with a space or a box or what?

I will reply with new code when you confirm this. I have already put way too much time into this thread so bear with me until I can figure this out.

What am I doing wrong?

ghostdog74, I installed Python 3.1.2 and saved your script as read.py.

My UTF-16LE file uni.txt contains:
"C:\Folder き"

Both files are inside the current directory.

This is my MS-DOS command prompt:



What am I doing wrong?

Assume I have one EXCEL file locates at H:\My Documents\Docs\X.xls. I start it by command "CALL H:\My Documents\Docs\X.xls". After X.xls is started, the command line can not accept NEW input until the X.xls file closed. Is there any SOLUTION to get back to command line and make the new input workable and meanwhile no need to close X.xls? Thanks!H:\My Documents\Docs\X.xls just thatDont USE call, use start
Thanks you two friends!! Both of your solutions work well!!

So to make this as simple as possible...

Our department is running WINXP X86, SP3. The PROBLEM I am having pertains to Outlook 2007. When opening attachments, Outlook 07 dumps the attachment into a temp folder. The location can be found in the registry key. When this folder reaches maximum CAPACITY, Outlook will no longer allow attachments to be opened. Ultimately, my question is can a batch file be created to erase files from a folder that has a randomly assigned name? Or, instead, can a batch file be created to change the registry key VALUE, so the OLK cache folder can be assigned a specific name? Then, I believe I could create a batch file to be used universally on all of our desktops that WOULD empty the temp folder. Any feedback would be appreciated. Quote

So to make this as simple as possible...

hi all - I need a batch file to search in a directory. If all the files have the current date stamp then execute command1 if files are not current then execute command2.
thank you.This can be done via Perl or a number of other languages which have abilities to compare STRINGS, but I cant see doing this in raw batch. Quote from: DaveLembke on September 21, 2010, 10:10:00 PM

This can be done via Perl or a number of other languages which have abilities to compare strings, but I cant see doing this in raw batch.

I need a batch file to search in a directory. If all the files have the current date stamp then execute command1 if files are not current then execute command2.
thank you.

these files will always have the same date. I guess we can look in one particular file to check for the date.
thanks

your script works good but it is missing the logic I need.

the YES condition works great but the NO logic only works for files that are older than 1 day. If the latest files are from yesterday it will still run the YES logic.

Hi,

I'm having troubles renaming folders

a colleague has a large amount of folders that contain # and she wants to replace these characters to _

123#12#12raw --> 123_12_12raw

What I have done today as a QUICK fix was list all the folders in a txt
dir /b *#* > print.txt

then I opened this txt in excel and generated LINES for each folder and pasted these in a *.bat

move 123#12#12raw 123_12_12raw
move 123#12#13raw 123_12_13raw
.....

This worked perfectly but it is not very user friendly

Is there a way to use the move command with wildcards?

I tried
move *#*#* *_*_*
but this (probably obvious) doesn't work.

If I try to find the files like that it does work
dir /b *#*#*

I spent the last 2 hours googeling but didn't find a decent solution yet

I also tried to do something with
for %1 in (*#*) do move %1 xxxxxx
but I can't figure out how to alter the variable so that # gets replaced with _ in %1

Anyone with suggestions?

Thanks,

JupkeGot an answer onan other (car)forum 

Wanted to share it here as well

Code: [Select]C:\Users\Roel\test>FOR /F "tokens=1,2,3 delims=#" %A IN ('dir /b *#*') DO move %
A#%B#%C %A_%B_%C

C:\Users\Roel\test>move 2123#12#14 2123_12_14
Er zijn         1 map(pen) verplaatst.

C:\Users\Roel\test>move 22123#12#13 22123_12_13
Er zijn         1 map(pen) verplaatst.

C:\Users\Roel\test>what's all that weird euro language stuff?
Quote from: Salmon Trout on September 15, 2010, 01:03:22 PM

what's all that weird euro language stuff?

Indeed, this also works, but the effect is in this case exactly the sale with move as rename here?

I'm not sure in win7 but I thought rename didn't work for folder in XP?

I'm trying to figure out how to use DOS CODING to open up Internet Explorer and make it go to a specific site. I know to make it go to IE, I NEED something lie:

echo off
START xxx/xxx/xxx/xxx/IE.exe

But how do I get it to go to a specific website?if you want to use DOS to start IE and then go to specific website and then do nothing else, you might as WELL go to your "Start" button and launch it. Its faster that way. BUT if you want to go to the  website  and download stuff and maybe you want to schedule it, then use vbscript for native or use a tool such as wget/curl to do it.The web page is entered an an argument for IEXPLORE.EXE.  Use the following link to Google as an example:
Code: [SELECT](path to ie directory)\IEXPLORE.EXE http://www.google.com
Interesting, would you be able to link in multiple sites? Like using && and just link in more?

Hi Guys,

I have a bunch of 'm4a' files that i need to RENAME, literally thousands, they're voice memos from my iPhone.

I have them stored on my hard disk in the directory 'C:\Memos'.

I have an xml file which contains the name of the file and the tag that the file should be called

The xml file contains all the file names, and all the tags that the files should be named.

I've included a sample of the xml file below to give a better idea of how it's structured.

 
 
-
-
  20090816 104438.m4a
  Autosleep
  20090816 124708.m4a
  Head pillow
 
 

So the file '20090816 104438.m4a' needs to be renamed 'Autosleep.m4a', the file '20090816 124708.m4a' needs to be renamed 'Head pillow.m4a' , etc.

Is there a way of doing this automatically with python or vbscript perhaps?

Any help or advice would be much appreciated as I am new to this and have been doing the renaming manually so far, but i've thousands of files to get through.

Thanks again,

JP
I'm sure you'll get a Python solution but I went with VBScript because it comes installed with Windows and there is no download required for those that won't or can't download third party products.

Code: [Select]Dim arrKey()
Dim arrString()

Set xmlDoc = CreateObject("Microsoft.XMLDOM")
Set fso = CreateObject("Scripting.FileSystemObject")

xmlDoc.async = False
xmlDoc.load("c:\temp\ch.xml")    'change path\filename as required

Set KeyList = xmlDoc.documentElement.selectNodes("dict/key")
i = -1
For Each key in KeyList
  i = i + 1
  ReDim Preserve arrKey(i)
  arrKey(i) = key.text
Next

Set StringList = xmlDoc.documentElement.selectNodes("dict/string")
i = -1
For Each str in StringList
  i = i + 1
  ReDim Preserve arrString(i)
  arrString(i) = str.text
Next

For i = 0 To UBound(arrKey)
Set f = fso.GetFile(arrKey(i))
newName = arrString(i)
f.Name = newName & "." & fso.GetExtensionName(arrKey(i))
Next

There is probably a simpler way to do this with the XMLDOM object, but I chose to go with brute force. Save the snippet with a vbs extension and run from the command line as cscript scriptname.vbs Be sure to change the path\file name as required.

Good luck.  Here's a Python solution. Note you should really use an XML parser like lxml, but since your sample XML is simple enough.....
Code: [Select]import os
import sys
inputfile=sys.argv[1]
keys=[]
strings=[]
for line in open(inputfile):
    s=line.rstrip()
    if "<key&GT;" in s:
        keys.append(s[s.index(">")+1:].replace("</key>",""))
    if "<string>" in s:
        strings.append(s[s.index(">")+1:].replace("</string>",""))
for k,v in zip(keys,strings):
    try:
        print "Renaming %s to %s"%(k, v)
        os.rename(k,v)
    except OSError,e:
        print e
    else:
        print "Renamed %s to %s." %(k,v)


on command line
Code: [Select]c:\test> python myscript.py myxml.xml
Thanks a million for your help.

Having a slight problem here

The vb script is called 'memos.vbs', the xml file is 'C:\memo\l.xml'

When i run the script from command prompt using 'cscript memos.vbs' i get the error:

C:\memo.vbs(27,2) Microsoft VBScript runtime error: File not found'

Any advice on RESOLVING the above would be much appreciated! Thanks again for your help.

My script is:

Dim arrKey()
Dim arrString()

Set xmlDoc = CreateObject("Microsoft.XMLDOM")
Set fso = CreateObject("Scripting.FileSystemObject")

xmlDoc.async = False
xmlDoc.load("C:\memo\l.xml")    'change path\filename as required

Set KeyList = xmlDoc.documentElement.selectNodes("dict/key")
i = -1
For Each key in KeyList
  i = i + 1
  ReDim Preserve arrKey(i)
  arrKey(i) = key.text
Next

Set StringList = xmlDoc.documentElement.selectNodes("dict/string")
i = -1
For Each str in StringList
  i = i + 1
  ReDim Preserve arrString(i)
  arrString(i) = str.text
Next

For i = 0 To UBound(arrKey)
   Set f = fso.GetFile(arrKey(i))
   newName = arrString(i)
   f.Name = newName & "." & fso.GetExtensionName(arrKey(i))
Next Thanks ghostdog!

The python scrit doesn't give the files the 'm4a' extension, but does change all the file names to the correct tag.

Is there a way to change the extension of multiple files, or perhaps include it in the python script?

Thanks again,

Jp Quote from: jpm999 on September 11, 2010, 07:43:03 PM

Thanks ghostdog!

The python scrit doesn't give the files the 'm4a' extension, but does change all the file names to the correct tag.

Is there a way to change the extension of multiple files, or perhaps include it in the python script?

Thanks again,

Jp

Hi Friends,

not sure if there are some shortcut keys for COPY and paste content in command line?

normally, I must use right click->mark->select TARGET text->enter to copy target text and right-click->paste.

it is boring to do so even it is frequent, so could you please do me a favor on this?

THANKS!If you enable the Quick EDIT Mode, and Insert Mode properties in the command WINDOW, then you can select the text with the left mouse button, click the right button to copy, and again to paste.

Hi,

This is my first post. I'm here for asking a question about a doubt I can't solve. I've already read most of on line help available, but I cannot do my batch work correctly.

This batch should look for every *inside.jpg files under my Music folder and if the file "Front Cover Inside.jpg" doesn't exist it should rename *inside.jpg file to "Front Cover Inside.jpg".
But if "Front Cover Inside.jpg" exist and there's some *inside file, it should log "Similar file to '*inside.jpg' already exists"

My batch:
Code: [Select]for /R %%x in (*inside.jpg) do if not exist "Front Cover Inside.jpg" (
ren "%%x" "Front Cover Inside.jpg"
echo "%%x" renamed to "Front Cover Inside.jpg" >> Log.txt
) ELSE (
echo Similar file to "%%x" already exists >> Log.txt
)

PS: Log.txt file already exists. I'm working on a Windows XP Professional SP3 machine.I just ran your script twice, and the first time, it renamed "0D0A inside.jpg" to "Front Cover Inside.jpg", and added this line to log.txt

"S:\Test\Batch\After 03-07-2010\for-if\0D0A inside.jpg" renamed to "Front Cover Inside.jpg" 

The second time it did nothing and wrote this line

Similar file to "S:\Test\Batch\After 03-07-2010\for-if\Front Cover Inside.jpg" already exists

Isn't this what you want?

Quote from: Salmon Trout on September 08, 2010, 02:13:06 PM

I just ran your script twice, and the first time, it renamed "0D0A inside.jpg" to "Front Cover Inside.jpg", and added this line to log.txt

"S:\Test\Batch\After 03-07-2010\for-if\0D0A inside.jpg" renamed to "Front Cover Inside.jpg" 

The second time it did nothing and wrote this line

Similar file to "S:\Test\Batch\After 03-07-2010\for-if\Front Cover Inside.jpg" already exists

Isn't this what you want?

echo off
for /R %%x in (*-inside.jpg) do if not exist "Front Cover Inside.jpg" (
ren "%%x" "Front Cover Inside.jpg"
if errorlevel 1 (
echo Similar file to "%%x" already exists >> Log.txt
goto end
)
echo "%%x" renamed to "Front Cover Inside.jpg" >> Log.txt
)

:end

Finally I think I've solved my problem. My final batch looks like this:

The trick is using errorlevel. When trying to rename the file, if there's already a file with the same name, MS-DOS will return a error message. I've just use this to sove my problem.
I've tried different scenarios and it worked the way I want it. So, I'm proud of myself, considering how newbie I'm in MS-DOS command line...

This is going to start driving me completely insane.

Hello .. guys..

As i cannot find any batchfile wich can do my job,and
since i got a unsorted folder with more then 20000 files to be sorted, i am TIRED of doing it manualy
can or is it possible to batch this.
can some one tell me if this is possible in a msdos batch file ..
folders has more then one files but particular file extensions makes my decision where to put the folder.
this is the situation in unsorted
 
\---root
    +---sorted
    |   +---te1
    |   +---te2
    |   \---te3
    \---unsorted
        +---folder1
        |       pre.te3
        |       
        +---folder2
        |       pre.te1
        |       
        \---FOLDER3
                pre.te2

this is what i want to end up sorted all files in the corrsponding folders.

|   
\---root
    +---sorted
    |   +---te1
    |   |   \---folder2
    |   |           pre.te1
    |   |           
    |   +---te2
    |   |   \---folder3
    |   |           pre.te2
    |   |           
    |   \---te3
    |       \---folder1
    |               pre.te3
    |               
    \---unsorted


In short i wanne sort files  but keep the folder names in the new sorted map structure.

i have tried to use different aproaches like dir *.te1 /D/B/S > te1.log
and use this log file to sort, but got stuck on how to use this log in a "for" environement

help is appreciateddo you actually just need to view the output (at your screen) as sorted, or do you actually want to move the files from "unsorted" folder into the the "sorted" folder, then display them ? define your problem clearlymoving the folders as shown above.
or copy  and use the unsorted as backup.

i do not need to view the output
as i said in my first post just moving/copying into the sorted folder

The folder structure shown above is only to clearify my problem. Since words are sometimes not enough and misunderstood.

Quote from: mazhive on September 06, 2010, 12:27:02 PM

can some one tell me if this is possible in a msdos batch file ..

it seems that it moves only the file not the folder

so i get root\sorted\te1\xxxxxx.te1
not  root\sorted\te1\folder 3\xxxxx.te1

do i have to change more than only the sorted path and unsorted path.

thanx.. alot for this piece of code... i use cygwin to do some linux like stuf and it has python installed on default.

thanx i didn't know,... i am not that familiar with python scripting.

but now i got this,...

print "Moving " r , " to ", os.path.join(dirsortedpath,ext)
                   ^
SyntaxError: Invalid syntax

i greatly appreciate your help and patience.
 

thanx ,... hmm i feel like stupid right now ,....
now it doesn't move anything.
and no error...

I can't change drive by using D:

I tried using the CD command and specifying the full location but that doesn't work either.

Someone help a newbie out?
Are you positive that you have a drive D? Can you access it via WINDOWS explorer?Yes. It certainly is there. I'm using a windows 7 starter edition because I'm in a foreign country running a netbook, is that helpfull?What if you create a shortcut to cmd.exe and under the "Start in" field or something SIMILAR, type D:\. Now when you run that shortcut, does it work?If that doesn't work you could try command.com instead of cmd.exeThat "Start in" option worked. Now when I start up cmd I'm in the D partition... and I cannot change to my C drive. It keeps saying my syntax is not in order but all I type in is C: or I tried C:\ or CD C:\somefolder and hit returnthe way to change DRIVES is to type the letter, upper case or lower case, followed by a colon. A full colon like this :

Code: [Select]c:\>D:

D:\>
Quote

It keeps saying my syntax is not in order

Hi,

   I'm trying to create a command script(.cmd file) with if statements.I don't think the if statements work here.Because even though the first if condition fails,the CONTROL always goes to LAST STEP.

Also can you please explain how to do if<> and <>

Thanks and appreciate your help on this.

Here is the code:

ECHO ON

SET JOBNAME=TEST

for /F  %%G in ('sqlcmd -E -S TAMANS-SQ12DCL\SQL1A -d SalesInterface -h-1 -W -Q "set nocount on;SELECT count(*) FROM table_test"') do (echo %BATCH_QUERY%:%%G)


if %ERRORLEVEL% equ 0 if %BATCH_QUERY% gtr 0 (GOTO LASTSTEP)
if %ERRORLEVEL% NEQ 0 (GOTO ERROR1)

:LASTSTEP
echo **********************************************
echo * COMPLETION OK                        *
echo **********************************************
:NORMAL
ECHO SUCESSFUL Completion of ICV001.
SET ControlM=0
GOTO END


:ERROR1
echo **********************************************
echo * %JOBNAME% NOT OK                       *
echo **********************************************
echo %JOBNAME% Abended
REM THERE WAS AN ERROR!
SET CONTROLM=1
goto END


:END
ECHO %JOBNAME% done.

  Where does the variable %BATCH_QUERY% get a value?
from %%G after the query executes.

for /F  %%G in ('sqlcmd -E -S TAMANS-SQ12DCL\SQL1A -d SalesInterface -h-1 -W -Q "set nocount on;SELECT count(*) FROM table_test"') do (echo %BATCH_QUERY%:%%G)
Quote

from %%G after the query executes.

So,should it be like this......

set set BATCH_QUERY=0

set BATCH_QUERY=for /F  %%G in ('sqlcmd -E -S test-SQ17CL\SQL1A -d SalesInterface -h-1 -W -Q "set nocount on;SELECT count(*) FROM table_test"') do echo %%G

I'm trying to make a batch file that will answer prompted questions automatically for a program.  I need to click "next" 4 times and click "enter".  Quote from: DaveIsRacerX on September 17, 2010, 07:42:21 PM

I'm trying to make a batch file that will answer prompted questions automatically for a program.  I need to click "next" 4 times and click "enter". 

I'm trying to make a batch file that will answer prompted questions automatically for a program.  I need to click "next" 4 times and click "enter". 

Win XP Home.  Batch script.

Newbie.

Does the If command COMPARE the ASCII decimal value when comparing strings?  If so why does the following return True when the ASCII values would show that the return should be False?

Thanks

Code: [SELECT]echo off
cls

if "2" gtr ";" echo 2 is greater than ;
The cmd.exe IF TEST does not do a plain ASCII comparison. Numerals come before letters; letters are normalized to lower case. For example 4 has a lower character value than 6, so 49 is LESS than 6.1 when compared as strings; ',' is less than ';', etc. ACCORDING to the byte value of the characters.

I have created several BATCH programs and saved them in a directory, updated my search PATH to include directory, and whenever i am in a different directory, the batch files do not WORK, why?1. What do you mean they "don't work"? Do you mean you cannot start them by typing the batch name, or that you can start them but they don't work in the WAY that you want them to?
2. What is this "search path"?
3. How did you "update" it?
If your talking about updating the PATH variable to include the directory with your batch files and after doing so, not being able to access the batch files, then. . .

You need to RESTART the comp.

Hi all,

I'm cracking my head with a small and simple thing, that unfortunately seems out of reach for my head...
I need to transfer files from a ftp server to my computer in a automatic way. The problem is that the FOLDER in the ftp, were these files are, acts as a backup as well, having files with 3 weeks OLD. Is there a way of SORTING the files by date, and just download these ones instead of everything?

Thanks in advance

Regardsthe windows ftp client that came with INSTALLATION is primitive. Instead, use a programming language, eg Python (or any others) that provides you FTP libraries for file transfer. eg in Python
Code: [Select]import ftplib
server="localhost"
user="anonymous"
password="[email protected]"
filelist=[]
DEF download(ftp, filename):
    ftp.retrbinary("RETR " + filename, open(filename,"wb").write)
try:
   ftp = ftplib.FTP()
   ftp.debug(3)
   ftp.connect(server,21)
   ftp.login(user,password)
except Exception,e:
    print e
else:
    ftp.cwd("directory to change if any")
    ftp.retrlines('LIST',filelist.append)
    for latest in filelist:
        if latest.startswith("-") and "latest file pattern if any" in latest:
            print latest
            download(ftp,latest)
    ftp.quit()
sys.exit()

this assumes that your old files are named in a distinct format, such as file.bak or something, and your latest file is not in that format.

usage:
Code: [Select]C:\test> python myscript.py

Hello,

I need help.  When I start computer and it starts it setup it stops and has 2 LOST ALLOCATION UNITS FOUND 1 CHANINS.
CONVERT LOST CHANINS TO FILES Y-N, so here is where I should be ABLE to type and I can't. It will not let me do anything, so I restart computer and hit the key to go to the amibios simple setup utility(ver 1.19), but can't find anywhere in setup to RUN the -CHKDSK- for fix my PROBLEM.  I have read in many places on the web that this will fix computer, but can't get to a C: or a CHKDSK file.   
Any ideas would be amazing!  Thanks you Quote

so here is where I should be able to type and I can't. It will not let me do anything, so I restart computer

I have a batch file "Test.bat":
Code: [Select]echo on
msg * This is a test.
del Test.bat
pause

Well this script looks fine but if i change the file name "Test.bat" to "Testing.bat" (Not the name in script).
The script seems not to work. The error is:
Del Test.bat
Could Not Find C:\Test.bat

I need a script that can detect its own file name.
Could anyone help me find a way out of this problem?As long has you have not used the SHIFT command, then
%~f0
refers to the fully qualified name of the batch file
Thats a zero at the end btwI am sure a script can detect itself,
and can even copy itself,
but I would expect the O.S. to CONSIDER the file in use if it tried to move or delete itself.

Alan
It is certainly possible for a batch file to delete or rename itself, but there will be an error message when cmd.exe comes back from carrying out the del or ren command to find the script gone or renamed.

consider...

Code: [Select]C:\>echo del %~f0>test.bat

C:\>test.bat

C:\>del test.bat
The batch file cannot be found.
and...

Code: [Select]C:\>echo ren %~f0 test1.bat>test.bat

C:\>test.bat

C:\>ren test.bat test1.bat
The batch file cannot be found.



Quote from: ALAN_BR on September 24, 2010, 02:08:19 PM

I am sure a script can detect itself,
and can even copy itself,
but I would expect the O.S. to consider the file in use if it tried to move or delete itself.

Alan

I was remembering past experiences before CMD.EXE and before Windows 98,
possibly back in the days of DOS v3.?,
and I learnt then to expect grief from a *.BAT script if it tried to alter itself.
I assumed the same was true now.

My more recent experience with XP is that the O.S. may complain that a file is in use when I try to delete it,
so I thought my old memories still applied.

Sorry

Regards
Alan

Hello all.
Been COMING to this site for YEARS for answers.

I do a lot of 4chan surfing an even have an auto download tool (beware it CARES less what it grabs lol)

so I have alot of mix file types I'd like a bat to send to their own folders.
I'm  using win7 (netbook)

I thought this would work for sure

echo on
move *.JPG C:\Users\******\Documents\Batch Testing 2\File Sort testing
pause

I'm getting " Cannot move multiple files to a single file "

I had a FEELING to try another drive so I plugged my flashdrive in an it worked fine.

does the C drive stop such ?
Try This


move *.JPG C:\Users\******\Documents\"Batch Testing 2"\"File Sort testing"\*.* Quote

C:\Users\******\Documents\Batch Testing 2\File Sort testing

Does this folder actually exist?

Try This


move *.JPG C:\Users\******\Documents\"Batch Testing 2"\"File Sort testing"\*.*

The quotes need to go around the whole path

Code: [Select]move *.JPG "C:\Users\******\Documents\Batch Testing 2\File Sort testing"
this should do it
Graham

Hello EVERYBODY,

I need your help. I have created a batch file that I make ftp to my server and I transfer some files, ONE time per month. I have scheduled this batch using the scheduled tasks of windows xp. The script works fine but I have a secure problem. The PASSWORD is visible!!

I give to you the commands that I use:

FTP -s:ftpwlk.txt env.meteo.noa.gr

this command open a txt file that contains the following details

"username"
"password"
binary
prompt n
cd stations/seli
mput C:\transfer.wlk\*.*
quit

There is any way to keep the password INVISIBLE?You could get your batch to prompt for the password, or protect the directory that the batch executes from so that only you can see itnowadays the secure way to transfer files is through SSH protocol. Try using SFTP/SCP for file transfer. You can set up passwordless keys so you don't have to hard code any password in your batch files.

I needed help with a question for my class, QBasic Programming. This is the question.

If you have the book its on page 118 number 4

4. Write a program to LIST several ACTIVITIES and the number of calories expended during 15, 30, and 60 minutes of each activity. Use the following Data:

Activity             Calories Burned per Minute
Sleeping           2.3
Jogging            15.0
Sitting              1.7

Use READ and DATA statements to place the data in variables. Then use commas to space the output so that is looks similar to the following:

Activity          15 Minutes     30 Minutes     60 Minutes
Sleeping         xxx.xx            xxx.xx            xxx.xx
Jogging          xxx.xx            xxx.xx            xxx.xx
Sitting            xxx.xx            xxx.xx            xxx.xxwow, didn't know anyone would still WANT to learn QBasic.  I hope its a free class you are taking, if not, its certainly not worth the school fees you are paying for.well this class i am taking is free and it is just a beginning to comp progQbasic is out of date. Try using a better programming LANGUAGE (eg Python), where you can learn about advance data structures like arrays/hashes/collections and much more.

Code: [Select]print "%-15s%-15s%-15s%-15s" %("Activity","15 min","30 min","60 min")
f=open("file")
f.readline() # get first line
for line in f:
   act, t=line.rstrip().split()
   print "%-15s%-15s%-15s%-15s" %( act,float(t)*15,float(t)*30,float(t)*60 )
f.close()

output

Code: [Select]C:\test>python test.py
Activity       15 min         30 min         60 min
Sleeping       34.5           69.0           138.0
Jogging        225.0          450.0          900.0
Sitting        25.5           51.0           102.0


If you insist on something from M$, try learning vbscript instead. www.network54.com/forum/648955/

Hello fellow msdos coders, I wish I could do this with python or some other uncluttered language, but it has to be dos... I thank you in advance for any input.

Here's the scenario.

I have a large number of Tiff image files in folders and subfolders, and I need to convert them to a different color profile ONLY if they HAPPEN to be with the 'wrong' profile.

I'm CONFUSED as to how the 'for' works, i'd like to get 'secondary' action in my for loop, but can't figure out how

Code: [Select]for /r %%a in (*.tif) do (identify -verbose "%%~FA" >> t.txt)

will print some info (using 'imagemagick') and somewhere in there should (or shouldn't) be a line with "ADOBE RGB" in it

so I should add

Code: [Select]& if find "Adobe RGB" < (output of the 'identify' above)

or something that looks like it

then according to the result

do this:

Code: [Select]convert -profile AdobeRGB1998.icc -profile sRGB.icm %%a sRGB_%%~na.tif

Which is the only bit that I know works =)

If you can help me stitch the whole thing together, I'll give you a million internet hugs =)

Thanks and have a good day

BernieYou could pipe the output of identify to find.exe and use the && (success) operator to decide whether to run convert

Code: [Select]for /r %%a in (*.tif) do identify -verbose "%%~fa" | find "Adobe RGB" && convert -profile AdobeRGB1998.icc -profile sRGB.icm "%%a" "sRGB_%%~na.tif" Quote from: Salmon Trout on September 28, 2010, 11:29:06 AM

You could pipe the output of identify to find.exe and use the && (success) operator to decide whether to run convert

Code: [Select]for /r %%a in (*.tif) do identify -verbose "%%~fa" | find "Adobe RGB" && convert -profile AdobeRGB1998.icc -profile sRGB.icm "%%a" "sRGB_%%~na.tif"

I'd like to copy my newly converted files into a subfolder, unfortunately it gets processed as well, resulting in a neverending loop!

i need to send emails with the help of using batch files. how can i send the mails with batch files.Have you tried the search function on this site, I know it has been answered beforeFor use in batch files you can use Blat or MailSend.

If you have WINDOWS, you can use any of the above or VBScript (already installed) or any other script language you may have downloaded and installed.

If you have Windows 7, you can use any of the above or Powershell (Powershell may have to be activated)

You are limited only by your imagination.

Good luck. I am using mailsend to send out pages to people from a batch file.   It should work for what you want to do. Code: [Select]echo off
cd folderexample
for %%* in (.) do set VAR=%%~n*
for /f %%a in ('time/t') do set vartime=%%a
set body=-body "hello"
set [email protected]
set [email protected]
set subj=-s "Test. FTP.%var%. New Files. %vartime%"
set server=-server smtp.example.com
set user=-u userexample
set pass= -pw passwordexample
C:\VISHU %0 -f %from% -b %to% %subj% %body% %server% %user% %pass%

I hope this will help you.
if do click on thanksthis is what i am using to send alerts.  Download the latest version of mailsend and put it in your windows/system32 dir
this is the command.  Its all one line but broken up here due to cut and paste.  I need to use port 2525 due to my ISP.  Change it to whatever works for you. 

mailsend -d your domain -smtp your SMTP server -port 2525 -starttls -v -f from address to show on email +CC +bc -auth-login -user user on SMTP server -pass "user password" -t to:email address -sub "subject" -M "MESSAGE"




good luck

I picked up this CODE from Salmon Trout from another post.  When I look at files on my desktop the date and time are echoed fine.  When I TRY to look at files on another drive or a server I get no echo at all.

Any thoughts?

echo off
for /f "delims=" %%A in ( 'dir /b /a-d /od c\:docume~1\[username]\desktop\[filename]' ) do (
   set fdate=%%~tA
      )
echo %fdate%I believe the ~t variable modifier only works on local drives. What HAPPENS if you try to get a full DIR listing (not using /b) of the folder? I mean this style of listing...

Code: [Select]Volume in drive C is Win07
 Volume Serial Number is E4DB-A92A

 Directory of C:\

24/09/2010  06:26 PM             1,024 .rnd
19/06/2010  03:16 PM             1,414 backup.log
28/03/2010  10:46 PM               956 dir.txt
06/10/2010  05:35 PM     3,169,705,984 hiberfil.sys
02/01/2010  08:03 PM            57,310 Logon001.jpg
14/03/2010  09:52 PM             1,106 makespecialfolders.bat
03/03/2007  05:44 PM            15,658 mike.jpg
28/03/2010  10:45 PM               870 mike.jpg.lnk
06/10/2010  05:35 PM       314,572,800 pagefile.sys
13/07/2010  06:26 PM       111,562,752 PM11_Pers_full_ea_x64.msi
29/07/2010  10:47 PM                79 whatever.scf
              12 File(s)  3,595,930,401 bytes
               0 Dir(s)  72,403,623,936 bytes freeWhen I get the full listing I have the file names and dates and TIMES as you have shown.  When I use the /b switch I just get the names. Quote

When I get the full listing I have the file names and dates and times as you have shown.

Hello. I SOMETIMES boot my computer from a live PC-DOS 7.1 CD, but I've noticed that I can't USE 'SET /P' to take input from the user. When I TRY using 'CHOICE' it just says "Bad command or file name.' How can I do this?

Please HELP!
Thanks,
phillid

RIght now I am using wireless on my WIndows XP. THis started happening recently when I switched over to RR cable from dial-up. THis is a 3 yr OLD Toshiba laptop. I have spent the last 4 weeks dealing with techs from both companies(RR & Toshiba) and the problem is still erratic. Sometimes it works and sometimes it doesn't. I have done all of their suggestions like going thru the ipconfig---release---and renew stuff. I went thru the one of taking out the battery, shutting it off, pushing the off swicth for 15 seconds waiting and putting it all back together. I tried a different Ethernet cord and it worked for about three days. I also did the RR thing of disconnecting the laptop power source/modem and turning it back on after counting the required number of seconds. I was about to try black magic when I ran across this site (I was learning about external commands). Retirement sucks when I cannot use my internet. Help. Please.Road Runner, not so beep beep?   

Does the RR cable run through the telephone exchange?
I assume the 'modem' is actually a wired router?

I SUGGEST first looking under your router admin gateway.
To go to that your'll need to type '//' (without quotes) and the router's IP address in your web-browser and enter your admin details. Read the manual that came with the router if stuck.

Under connection details, you should see 'Uptime', 'Bandwidth (Up/Down)', etc...

Find 'Line Attenuation (Up/Down)' and 'SN Margin', ensure the [dB] doesn't change a lot when refreshing that page.

You might also want to check:
Loss of Signal / Power (Local/Remote)
FEC, CRC, and HEC Errors (Up/Down)

Depending on your router model, they should be all on the same page. Post the results here if possible and note any continous changes on refreshing that page.


If you have a noisy line, another way of testing this is pick up the phone and dial just one number to clear the dial tone and LISTEN for STATIC or noise.  Noise on the line hugely decreases internet performancee and it get's too much, the line will cut and attempt to reconnect with another IP address. This might be your issue?

It seems Variables I declare within a FOR loops (or if statements) are getting FORGOTTEN about RIGHT away. The %%A of the FOR head works fine throughout the loop but a simple

SET TEST=%%A

will vanish...

Any idea why?Please show your script.He's deleted his acoount; I expect he found out about DELAYED expansion.

Looking for a way to pull a directory out of the PATH environmental VARIABLE. Guess I'm more so looking for the drive letter. I know my path will CONTAIN \vision\bin ... I was thinking I could do a FOR loop but I'm just not getting it at midnight. Help is appreciated.

Code: [Select]for /F "tokens=1-26 delims=;" %%a in ('echo %PATH% ^ FIND /I "\vision\bin"') do set direct=%%a
I figured I would use delims=; to separate each path out, but then again maybe that is my problem that when I set direct %%a isn't my path? I'm not sure.

Nevermind ... I got something to work.

Code: [Select]ECHO off
setlocal enabledelayedexpansion
 for %%G in ("%PATH:;=" "%") do (
    echo %%G | find /I "\vision\bin" >nul
    if !errorlevel! EQU 0 set direct=%%G
 )
setlocal disabledelayedexpansion
if "%direct%"=="" ECHO direct equals nothing & pause
set direct=%direct:"=%
set direct=%direct:~0,9%
echo "%direct%"
Pause

Hi, I'm not an expert in MS-DOS, that's the reason of my question. How could I PUT a conditional question in a DOS batch?

For example:

Would you like to execute the next process? Y/N

Best regards.several options; the "easiest" is to use pause:

Code: [Select]ECHO OFF
pause To process the next item, press any key. To Cancel, Press Control+Break.

REM etc..

or, use CHOICE:

Code: [Select]ECHO OFF
REM CLEAR DONEXT:
set DONEXT=
:RECHOICE
choice Would you like to execute the next process?
IF ERRORLEVEL==2 GOTO PRESSEDN
IF ERRORLEVEL==1 GOTO PRESSEDY
ECHO Please Enter Y OR N.
GOTO RECHOICE
:PRESSEDN
REM N was pressed in CHOICE.
SET DONEXT=N
GOTO ENDING
:PRESSEDY
REM Y was pressed
SET DONEXT=Y
:ENDING

REM return to caller.


I wrote the second one with the intent that it may be used as "module" SORT of of fashion; that is, it may be called from multiple locations in the same batch file. You can of course paste this in if there is only a single location, but otherwise, you would need to make it a new BAT file- say, "DOCHOICE.BAT" or something.

Then, in the main batch, you would simply do:

Code: [Select]REM check if we should execute the next process...
DOCHOICE
if %DONEXT%==Y GOTO GOTONEXT
if %DONEXT%==N GOTO NONEXT

You would of course define the GOTONEXT label to continue the process, and NONEXT to abort the procedure or display a warning like "not all PROCESSES run" or whatever, depending on your use case.

You'll note something particularly rare these days, is that I was able to provide a batch that actually used only DOS features, and didn't try to suggest "YOU CAN USE SET /P" or something stupid like that. That sort of annoys me when I see folks asking for help with DOS and then self-proclaimed "Batch masters" coming in with their advice that requires NT extensions. This is especially annoying since the original poster probably doesn't even know about these extensions and therefore will try to follow their advice. I've seen 3 PAGE threads here where poor folks are led on a wild-goose chase while the "batch master" tries to figure out why set /p doesn't work.

I'll SHUT up now.Thanks a Lot!

Problem is:
 when I tried to copy files to c:/Program Files/Folder. got the error message as
E:\SomeDirectory\Patches>copy *.* C:\Program Files\Destination\
The syntax of the COMMAND is incorrect.
CODE:
Code: [Select]cd E:\SomeDirectory\Patches
copy *.* %VALUE%I believe it because of space between Program Files.
In to the other destination all files were copied ok.
How can I solve this problem?I found it!
If you using path to TWO word name folder just put it between " "
In my case it looks like
Code: [Select]"C:\Program Files\iWay60\"

Hi there,

I can see the "duration" (length of the video) for each of our .wmv files in windows explorer by turning on that column, but can't find how to GET that into a text file. We have hundreds and hundreds of files that we need the duration for, and obviously we don't want to have to type it all in by hand when the information is displayed right there in front of us.

I've tried .js as well, but am stumped. My .bat file currently looks like this:

dir /n /a /-p /o:gen >filelisting.txt

This allows me to capture most of the information I need and port it over to our database, but lacks the duration info.

Note that I did come across something called "verbose" (/v) that is supposed to list more information, but the batch file fails when I add it in, and I'm not even sure that would show the duration.

Help? The information you see in Windows Explorer about multimedia files (duration, bitrate, etc) is not available to the command prompt, certainly not via DIR. There is no /V switch for DIR.

But you can use ffmpeg to provide multimedia information, and find to isolate the line with the duration information.

http://www.ffmpeg.org/

Example 1. Use ffmpeg with the -i option to get information about a file

Code: [Select]C:\Users\Public\VIDEOS\Sample Videos>ffmpeg -i wildlife.wmv
FFmpeg version SVN-r23418, Copyright (c) 2000-2010 the FFmpeg developers
  built on Jun  2 2010 04:12:01 with gcc 4.4.2
  configuration: --target-os=mingw32 --enable-runtime-cpudetect --enable-avisynth --enable-gpl --enable-version3 --enable-bzlib --enable-libgsm --enable-libfaad
 --enable-pthreads --enable-libvorbis --enable-libtheora --enable-libspeex --enable-libmp3lame --enable-libopenjpeg --enable-libxvid --enable-libschroedinger --
enable-libx264 --extra-libs='-lx264 -lpthread' --enable-libopencore_amrwb --enable-libopencore_amrnb --enable-librtmp --extra-libs='-lrtmp -lssl -lcrypto -lws2_
32 -lgdi32 -lwinmm -lcrypt32 -lz' --arch=x86 --cross-prefix=i686-mingw32- --cc='ccache i686-mingw32-gcc' --enable-memalign-hack
  libavutil     50.16. 0 / 50.16. 0
  libavcodec    52.72. 1 / 52.72. 1
  libavformat   52.67. 0 / 52.67. 0
  libavdevice   52. 2. 0 / 52. 2. 0
  libavfilter    1.20. 0 /  1.20. 0
  libswscale     0.11. 0 /  0.11. 0

Seems stream 1 codec frame rate differs from container frame rate: 1000.00 (1000/1) -> 29.97 (30000/1001)
Input #0, asf, from 'wildlife.wmv':
  Metadata:
    SfOriginalFPS   : 299
    WMFSDKVersion   : 11.0.6001.7000
    WMFSDKNeeded    : 0.0.0.0000
    IsVBR           : 0
    title           : Wildlife in HD
    author          :
    copyright       : ┬® 2008 Microsoft Corporation
    comment         : Footage: Small World Productions, Inc; Tourism New Zealand | Producer: Gary F. Spradling | Music: Steve Ball
  Duration: 00:00:30.09, start: 8.000000, bitrate: 6977 kb/s
    Stream #0.0: Audio: wmav2, 44100 Hz, 2 channels, s16, 192 kb/s
    Stream #0.1: Video: vc1, yuv420p, 1280x720, 29.97 tbr, 1k tbn, 1k tbc
At least one output file must be specified
Example 2. Note that ffmpeg outputs info text to stderr so to pipe to find we need to redirect stderr to stdout using 2>&1

Code: [Select]C:\Users\Public\Videos\Sample Videos>ffmpeg -i wildlife.wmv 2>&1 | find "Duration"
  Duration: 00:00:30.09, start: 8.000000, bitrate: 6977 kb/s
You can redirect the information to a file, and use standard batch or vbscript methods to process the information.








vbscript
Code: [Select]Set objFS = CreateObject("Scripting.FileSystemObject")
Set objPlayer = createobject("wmplayer.ocx.7")
strFolder="c:\videos"
Set objFolder = objFS.GetFolder(strFolder)
For Each strFile In objFolder.Files
If objFS.GetExtensionName(strFile) = "mp3" Then    
strFileName = strFile.Path
WScript.Echo objPlayer.mediaCollection.add(strFileName).duration
End If
NEXT
objPlayer.close

Code: [Select]c:\test> cscript //nologo myscript.vbs
Does that work for .wmv's or just .mp3's?why don't you try it out? Quote from: Helpmeh on September 15, 2010, 08:55:13 PM

Does that work for .wmv's or just .mp3's?

vbscript
Code: [Select]Set objFS = CreateObject("Scripting.FileSystemObject")
Set objPlayer = createobject("wmplayer.ocx.7")
strFolder="c:\videos"
Set objFolder = objFS.GetFolder(strFolder)
For Each strFile In objFolder.Files
If objFS.GetExtensionName(strFile) = "mp3" Then    
strFileName = strFile.Path
WScript.Echo objPlayer.mediaCollection.add(strFileName).duration
End If
Next
objPlayer.close

Code: [Select]c:\test> cscript //nologo myscript.vbs

What KINDS of limits can be put on opening batch FILES? I want to MAKE a .BAT that can ONLY be opened by another, SPECIFIED .BAT file. I don't even want the file to be readable from notepad. How would I do this? And is it possible to limit whether a file will open in some programs, but not others? Quote

I want to make a .BAT that can ONLY be opened by another, SPECIFIED .BAT file.

I don't even want the file to be readable from notepad.

And is it possible to limit whether a file will open in some programs, but not others?

Like the subject says I'm having a hard time understanding the syntax of batch files. This one in particular from what I understand is quite simple but I'm having a *censored* of a time figuring it out. I'm just trying to turn off the echo of all commands in the batch program, set the background color to bright white, and the foreground color to black, specify a setting in the Windows environment for the DIR command so it displays directories and files one SCREEN at a time, in order by filename and then clear the screen.

Any pointers?Unfortunately, you worded your question in such a way that it looks exactly like a homework assignment. Homework assignments do a number of things, including TESTING, for the teacher's information, your understanding of the course material you have already been exposed to and your ability to perform research.  If we do this work for you, the teacher will think you are having no PROBLEMS and you will never get the remedial help you so obviously NEED. My advice is to study the materials given you by your teacher. If you still do not understand this (very) simple TASK, consult your teacher for guidance.

I need to check 10 different Source directories for files and move them to 10 different DESTINATION directories. However files over 50Mb I need to move to a BigFile directory and rename the EXTENSION to *.big. I'm new/rusty to batch files but I've created the following script that I can't SEEM to get working correctly. I'm using it in a windows environment.



echo on

setlocal

set /p directory1=D:\receivingdir\2.16.840.1.113883.3.105.102

set /a size=52428800

set /p newdirectory1=D:\processingdir\Sources\2.16.840.1.113883.3.105.102\In

set /p newdirectory2=D:\BigFileTransport

for %%q in %directory1% do if %%~zq lss %size% move %%q %newdirectory1%


for %%q in %directory1% do if %%~zq geq %size% move %%q %newdirectory2%

pause


Any ideas?Lose the /p switch from SET. For details of usage of SET command, type SET /? at the prompt.

If any filenames are likely to have spaces you should use quotes

e.g.

Code: [Select]move "%%q" %newdirectory1%
FOR syntax needs correction

Code: [Select]for /f "delims=" %%q in ( ' dir /b /a-d "%directory1%\*.*" ' ) do if %%~zq lss %size% move "%%q" %newdirectory1%

THANKS Salmon!

I've been getting these error MESSAGES, using Scheduled Tasks to do Check Disk and Defrag on my two HARD drives:

5/18/10 it did not Defrag C:, got exit code of 0x6

9/21/10 It did not Check Disk D:, cannot lock current drive, volume dismounted, all opened handles to this volume are now invalid

I think I just need to disable some services, then it will work.  Everything I've figured out is here, I think I'm close:

http://www.codeproject.com/Questions/117564/DOS-commmands-to-disable-re-enable-non-MS-Services.aspx?display=Print

This is what I have that needs to be modified somehow.  The code just flashes on the screen.  Thank you for your input.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

sc config avg9wd start= disabled
sc config CTAudSvcService start= disabled
sc config nvsvc start= disabled

ECHO y|CHKDSK D: /X/R
ECHO y|CHKDSK C: /R

C:\WINDOWS\system32\defrag.exe d: -v>"c:\Documents and Settings\Administrator\Desktop\defrag d.txt"
C:\WINDOWS\system32\defrag.exe c: -v>"c:\Documents and Settings\Administrator\Desktop\defrag c.txt"

sc config avg9wd start= auto
sc config CTAudSvcService start= auto
sc config nvsvc start= auto

SHUTDOWN -rI PUT my conclusion here at the bottom of this page.

http://www.codeproject.com/Questions/117564/DOS-commmands-to-disable-re-enable-non-MS-Services.aspx

It does not appear to me that a DOS command can disable some Services

******************************************************************

Control Panel \ Network Connections \ [right-click] Local Area Connection 5 \ Disable

Start \ Run \ msconfig \
Services tab \ [check] Hide All Microsoft Services \ Disable All \ Apply
Startup tab \ Disable All \ Apply
Close \ Restart

Then let Scheduled Tasks run the following bat file at 1:00 AM, on the third Tuesday of every month, view the RESULTS in the AM.

--------------------------------------------------------

C:\WINDOWS\system32\defrag.exe c: -v>"c:\Documents and Settings\Administrator\Desktop\defrag c.txt"
C:\WINDOWS\system32\defrag.exe d: -v>"c:\Documents and Settings\Administrator\Desktop\defrag d.txt"

ECHO y|CHKDSK C: /R
ECHO y|CHKDSK D: /X/R

SHUTDOWN -r

Hi Friend,

Is there any possiblity to time stamp the text file.

For e.g.

I am having text file named as a.TXT.
I need to rename this file with date and time b_08062008_10AM.txt

Please help me to resolve this issue.

Thanks,
Vinoth Sorry, but the Ren(rename) command DOESNT accept variables so if you tried to rename a.txt to %DATE%.txt, you would recieve an error message saying "The syntax of the command is incorrect" but you can post a timestamp in the txt file. I provided the batch program as a TXT file, open it and Save it as a BAT file. Once again, Im sorry but i hope this helps your problem.   



[recovering disk space -- attachment deleted by admin]on my computer ren works with variablesIt does on mine. The reason for macdad's error is that he does not realise that the date & time variables contains / and : characters that are illegal in a file NAME.

so you can remove them

Code: [Select]S:\>ren hello.txt hello-%date:/=-%-%time::=-%.txt

S:\>DIR hello*
 Volume in drive S is USBHD
 Volume Serial Number is 2C51-AA7F

 Directory of S:\

06/08/2008  17:03                 8 hello-06-08-2008-17-08-39.28.txt

Dias i separated the backslashes from the date and time variables in the batch program i included in this and the earlier post. but yes when i tried it on command prompt(not in a batch file) i forgot to seperate the backslashes.

[recovering disk space -- attachment deleted by admin]Thanks guys , this is just the solutution I was looking for.

I run sofware updates most days and the setup program overwrites the install log.  I could never check if the LAST 5 or 10 updates were all sucessful, just the last update. Now I can copy the log file to another folder with a timestamp in the filename ! Brilliant.

Is it POSSIBLE to check for a double quote at the END of a string?

Reason is, I've created a batch file where users drag and DROP a folder onto the batch file and it uses that as a parameter.

If the folder has a space it encloses it in double quotes, I can strip them off with the SET COMMAND...but if there is no space then it doesn't enclose it in quotes.

Code: [Select]set StartFolder=%1
if '%StartFolder%==' goto NoFolder
set tmpstr=%StartFolder:~-1%

rem *** If last char is double quote, strip them off - '" = Single the double quote***
if '%tmpstr% == '" set StartFolder=%StartFolder:~1,-1%

set tmpstr=%StartFolder:~-1%
rem *** If last char is not backslash, ADD one ***
if '%tmpstr% NEQ '\ set StartFolder=%StartFolder%\


How can I check if the parameter has quotes?Solved it by adding a ^ before the double quote...

Code: [Select]set StartFolder=%1
if '%StartFolder%==' goto NoFolder
set tmpstr=%StartFolder:~-1%

rem *** If last char is double quote, strip them off - '" = Single the double quote***
if '^%tmpstr% == '^" set StartFolder=%StartFolder:~1,-1%

set tmpstr=%StartFolder:~-1%
rem *** If last char is not backslash, add one ***
if '%tmpstr% NEQ '\ set StartFolder=%StartFolder%\
 You do know that the tilde variable modifier strips off any surrounding quotes from parameter strings?

If %1 is a passed parameter string, then %~1 is that same string but without any surrounding double quotes. (If no quotes are present then %1 and %~1 are identical)

For full details of variable modifiers see the FOR documentation e.g. by typing FOR /? at the prompt.

I have a batch file that reads
Copy TEMPORARY\%1  Directory 1
Copy temporary\%1  Directory 2
and so on
for 65 directories (!)

What this does is to take ALL the FILES in the folder called temporary and copy them to Directory 1 and to Directory 2 and so on.

Now, the complication is that the folder called temporary has a subdirectory called Documents with 20-25 files in it.
I wiuld like to know what the syntax is for
a) MD New Directory in Directory 1 and in 2 and so on
b) copy the 20-25 files into it
and - hopefully - all that with ONE command.

Any ideas?



Thanks!




I would go with XCOPY or ROBOCOPY, in your batch file. QUOTE from: Mute on October 19, 2010, 12:03:26 AM

I would go with XCOPY or ROBOCOPY, in your batch file.

i want to create a batch file that will copy my emials and put them in TH foler they belong can you help?thanks ron Quote from: ron57 on October 18, 2010, 02:15:38 AM

i want to create a batch file that will copy my emials and put them in th foler they belong can you help?thanks ron

can i just copy the emails to a misc folder then sort them out from there?can you send me a batch file that will copy those emails to any folder?thanks ron

Is there a WAY that I can CHANGE the date on my PC when I run a certain program?

For example, I want to run this COMMAND "date 01-01-2009" whenever I launch one of my applications.

Is there a way I can ATTACH this to the shortcut of my program.Is this to defeat a trial PERIOD?

All the examples I have found are like this:

Dim oShell
Set oShell = WScript.CreateObject ("WSCript.shell")
oShell.run "cmd /K CD C:\ & 7z a E:\ZipOut1 C:\TempBase"
Set oShell = Nothing

I would like to run several 7z commands in succession using CSCRIPT, but without creating a separate window for each one, and ideally without creating any new windows at all.
Code: [Select]
wscript.echo "Running 3 7zip operations"
wscript.echo
Run "7z a s:\ZipOut1 s:\Test-777\*"
Run "7z a s:\ZipOut2 s:\Test-777\*"
Run "7z a s:\ZipOut3 s:\Test-777\*"
wscript.echo
wscript.echo "Completed 7z operations"
wscript.echo
wscript.echo "Files produced:"
wscript.echo
Run "cmd /c dir s:\Zipout*"
wscript.echo
wscript.echo "Done"

' Runs an external program and pipes its output to
' the StdOut and StdErr streams of the current script.
' Returns the exit code of the external program.
Function Run (ByVal cmd)
Dim sh: Set sh = CreateObject("WScript.Shell")
Dim wsx: Set wsx = Sh.Exec(cmd)
Do
   Dim Status: Status = wsx.Status
   WScript.StdOut.Write wsx.StdOut.ReadAll()
   WScript.StdErr.Write wsx.StdErr.ReadAll()
   If Status <> 0 Then Exit Do
   WScript.Sleep 10
   Loop
Run = wsx.ExitCode
End Function


Code: [Select]Running 3 7zip operations


7-Zip 4.65  Copyright (c) 1999-2009 Igor Pavlov  2009-02-03

Scanning

Updating archive s:\ZipOut1.7z

Compressing  Readme.txt
Compressing  Windows Active Boot Disk.vmx
Compressing  Windows Active Boot Disk.vmxf

Everything is Ok

7-Zip 4.65  Copyright (c) 1999-2009 Igor Pavlov  2009-02-03

Scanning

Updating archive s:\ZipOut2.7z

Compressing  Readme.txt
Compressing  Windows Active Boot Disk.vmx
Compressing  Windows Active Boot Disk.vmxf

Everything is Ok

7-Zip 4.65  Copyright (c) 1999-2009 Igor Pavlov  2009-02-03

Scanning

Updating archive s:\ZipOut3.7z

Compressing  Readme.txt
Compressing  Windows Active Boot Disk.vmx
Compressing  Windows Active Boot Disk.vmxf

Everything is Ok

Completed 7z operations

Files produced:

 Volume in DRIVE S is USB-1
 Volume Serial Number is 2C51-AA7F

 Directory of s:\

24/10/2010  04:17 PM             1,561 ZipOut1.7z
24/10/2010  04:17 PM             1,561 ZipOut2.7z
24/10/2010  04:17 PM             1,561 ZipOut3.7z
               3 File(s)          4,683 bytes
               0 Dir(s)  156,771,778,560 bytes free

DoneI have tidied things up a bit; also I show how to use QUOTES around paths/filenames with SPACES. Inside strings, quotes need "escaping". That is,  to get one quote mark inside a VBScript string, you need two in the code that produces the string.

Code: [Select]wscript.echo "Running 3 7zip operations"
Run "7z a ""S:\Test\Batch\After 16-10-2010\vbs-samewindow\7zip Archives\ZipOut1.7z"" ""S:\Test\Batch\After 16-10-2010\vbs-samewindow\Folder with spaces\*"""
Run "7z a ""S:\Test\Batch\After 16-10-2010\vbs-samewindow\7zip Archives\ZipOut2.7z"" ""S:\Test\Batch\After 16-10-2010\vbs-samewindow\Folder with spaces\*"""
Run "7z a ""S:\Test\Batch\After 16-10-2010\vbs-samewindow\7zip Archives\ZipOut3.7z"" ""S:\Test\Batch\After 16-10-2010\vbs-samewindow\Folder with spaces\*"""
wscript.echo "Done"

Function Run (ByVal cmd)
Set sh = CreateObject("WScript.Shell")
Set wsx = Sh.Exec(cmd)
Do
   Status = wsx.Status
   WScript.StdOut.Write wsx.StdOut.ReadAll()
   WScript.StdErr.Write wsx.StdErr.ReadAll()
   If Status <> 0 Then Exit Do
   WScript.Sleep 10
Loop
Run = wsx.ExitCode
End Function

I have a value "00000000" without quotes where I am adding a 1 to any of the positions if a value has changed in an input file but in some cases I will end up with a value of "00130012" but what I would like my end result to be is only 0(unchanged) or 1(changed) in any position ... in other works if the value is greater then 1 I want to change it back to a 1. I'm trying to figure out if the easiest way to do this would be a replace function of some SORT? I'm thinking there would have to be something simpler then a doing a split and checking each value. Or instead of the above is there a way to check the position of a digit within the value to see if ALREADY 1, if it is don't add again. I COULD do 8 counters for each position that if greater then 0 add 1 to the position but keeping track of a bunch of counters seems like a lot of work. why don't you show us your code so far? That would save one *censored* of a lot of time asking questions. Why don't you, instead of adding 1 to a position, check if the digit in that position is already changed to 1 and if it is, leave it alone?

Ended up using counters to track if I had already added a 1 to that position. Not sure how to go about checking if the position already has a 1 within a number.

Didn't post the code as it is quite messy and very much spaghetti code. Not really sure yet how to clean it up into tidy functions but at least it works and does what I want for now. I'll still posted if you CARE to see as I'm always interested in learning a cleaner meaner approach. Quote from: nothlit on October 29, 2010, 01:30:52 PM

Ended up using counters to track if I had already added a 1 to that position. Not sure how to go about checking if the position already has a 1 within a number.

Vista Home edition:
I WROTE a simple batch file as follows to copy a group of dll & ocx files from a USB drive to my hard drive, and then register them individually.

Code: [Select]copy "\MiscDLLs\*.*" "C:\MyProgram\"

regsvr32.exe "C:\MyProgram\ccrpFD.ocx"
regsvr32.exe "C:\MyProgram\comct232.ocx"
regsvr32.exe "C:\MyProgram\msvbvm50.dll"
regsvr32.exe "C:\MyProgram\richtx32.ocx"

When I run the batch file with the routine double-click, the copy command is successful, but ... the four regsvr32.exe commands fail.
So ... I tried Right-click - "Run as Administrator". This time the four files were each registered successfully. (Note that the four files had already been copied to the destination folder.)

But, here's the weird part, I WANTED to test the batch file again from the beginning so I deleted the four files from MyProgram and tested the batch file again. It failed!

After repeated testing, I discovered that when the batch file was "Run as Administrator" the copy command failed and then the four regsvr32.exe commands would also fail because the four files were not available to be registered. Yet, when run as normal with the double-click the copy command worked every time. (but ... the four regsvr32.exe commands fail.)

So here's the question: "Why does the copy command fail when "Run as Administrator" is used?
I assume that there must be a syntax error involed, but OK, I may have partially figured out the answer.

In the copy cmd: Code: [Select]copy "\MiscDLLs\*.*" "C:\MyProgram\"I intentionally left out the drive letter of the USB drive because the drive letter will vary from one machine to another. Normally, "DOS"(or Windows CMD) looks on the current drive and fills in the current drive letter completing the path for me. (This works every time when the batch is run normally.)

The error that I am receiving is: Quote

The SYSTEM cannot find the path specified.

Hi,

I want to download a xls that is LOCATED on a webpage.
I USE  rundll32 to OPEN a SHORTCUT referring to the xls and I'm arriving on the "file download" screen that asks me if i want to open or save the file.

Is is possible the i can save the file to specific location WITHOUT the screen?

Kind Regards

Koen

I GOT the following code:

Code: [Select]for /f "tokens=*" %%c in ('dir "C:\Source FOLDER" /a:-d /s /B') do MOVE /y "%%c" "C:\Destination folder"

rd /s /q "C:\Source folder"

It empties all files from the Source folder as well as its sub folders.
It then deletes the Source folder and its remaining subs.

How can I tell it to create the destination folder if it doesn't already exist prior to moving the files? Code: [Select]if not exist "C:\Destination folder" md "C:\Destination folder"Right, but where in that first line would I put it?You would put it before the first line, which will now be the second line.
Right...
Stupid me...


I was THINKING it needed to be in the middle somewhere since the code had already grabbed the files out of their folders...If you want to move a file from folder A to folder B, it is necessary to first ensure that folder B exists. Before you even start.Yeah, brain fart on my part I suppose...

In my defense, I copy/pasted the code from elsewhere...

Hi CH,

Im not sure if people will be able to help on my query.

CURRENTLY, we have a particular scope that is constantly getting full... we have also amended the lease time to try and refresh it quicker than others...

Im just wondering... because most of these devices are infact offline and taking valuable leases is there any command I can run to tell me the offline ones?

Currently, what im doing is exporting the devices to a .txt file and then replacing with the built in 'Replace' feature in notepad to create: PING ADDRESS HERE -N 1

The above would then process all the devices so I can paste it into CMD and then one by one tell me which one responds or which ones dont of which I then delete...

Its just a query... but would be great if theres a quicker way.

Thank you.Hi,

Can't you use a program like netscan? this SCAN's all the ip aresses in a range.

Kind regards

KoenIt's not clear what you are trying to do.  Are you an ISP?  Why are you concerned about leases?  What kind of devices are you dealing with?