windows - Batch process all files in directory

Question

Right now i have a batch job I wrote that calls another file and passes in the variables that executable needs to run (password and filename).

Ex:

> cd f:estutils 
> admin import-xml -Dimport.file=f:DBfile1.xml  -Dadmin.db.password=test123

I wrote a job that does this, but found out that there would be multiple files.

The username and password never change but the filename differs for like 15 different xml files--with maybe more coming soon.

The files will always be located in the same folder. Instead of ending up with like 15-20 jobs (one for each file), can I write something that will process each file located in this directory. And either wait till one is completed before the next or I can add a 3 min sleep before it starts the next file.

Answer 1

pushd C:estutils
for %%F in (F:DB*.xml) do (
   admin import-xml "-Dimport.file=%%~dpnxF" -Dadmin.db.password=test123
)
popd

The %%~dpnxF expands to d?rive, p?ath, base?n?ame and e?x?tension of the current file.

If you intend to set and use environment variables (%foo%) in that loop, read help set first before you get into trouble.