Variable usage in batch file

Question

I'm working with a fairly simple batch file in Windows 7, where I want to be able to define a few variables and then use them in a command. This is the code I have so far:

@ECHO OFF
set $servertype=IIS
set $servername=MJNHNX4
set $folder=C:\Logfiles
set $database=Perfmoncounters
if $servertype=IIS 
   C:\Program Files (x86)\Log Parser 2.2\logparser.exe "Select * into IISCounters from "$folder\IIS_Log.csv"" -i:CSV -o:SQL -server:$servername -database:$database -driver:"SQL Server" -fixcolnames:ON -createTable:ON
if $servertype=SQL
   C:\Program Files (x86)\Log Parser 2.2\logparser.exe "Select * into SQLCounters from "$folder\SQL_Log.csv"" -i:CSV -o:SQL -server:$servername -database:$database -driver:"SQL Server" -fixcolnames:ON -createTable:ON
if $servertype=Client
   C:\Program Files (x86)\Log Parser 2.2\logparser.exe "Select * into ClientCounters from "$folder\Client_Log.csv"" -i:CSV -o:SQL -server:$servername -database:$database -driver:"SQL Server" -fixcolnames:ON -createTable:ON

However when I run it, it says "=IIS was unexpected at this time". Is my If statement badly formatted?

foxidrive · Accepted Answer · 2013-05-31 14:40:19Z

1

This is untested but includes some elements to fix the syntax and make the tests more robust.

@ECHO OFF
set $servertype=IIS
set $servername=MJNHNX4
set $folder=C:\Logfiles
set $database=Perfmoncounters
if "%$servertype%"=="IIS" (
   "C:\Program Files (x86)\Log Parser 2.2\logparser.exe" "Select * into IISCounters from "$folder\IIS_Log.csv"" -i:CSV -o:SQL -server:$servername -database:$database -driver:"SQL Server" -fixcolnames:ON -createTable:ON
)
if "%$servertype%"=="SQL" (
   "C:\Program Files (x86)\Log Parser 2.2\logparser.exe" "Select * into SQLCounters from "$folder\SQL_Log.csv"" -i:CSV -o:SQL -server:$servername -database:$database -driver:"SQL Server" -fixcolnames:ON -createTable:ON
)
if "%$servertype%"=="Client" (
   "C:\Program Files (x86)\Log Parser 2.2\logparser.exe" "Select * into ClientCounters from "$folder\Client_Log.csv"" -i:CSV -o:SQL -server:$servername -database:$database -driver:"SQL Server" -fixcolnames:ON -createTable:ON
)

answered May 31, 2013 at 14:40

foxidrive

41.4k11 gold badges61 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sean Long Over a year ago

I accepted this answer, but there were a couple of changes needed to make it actually work. Here's the final code that ended up working:

@echo off set $servertype=IIS set $servername=MJNHNX4 set $folder=C:\Logfiles set $database=Perfmoncounters set $logparser=C:\Program Files (x86)\Log Parser 2.2\logparser.exe if %$servertype%==IIS "%$logparser%" "Select * into IISCounters from %$folder%\IIS_Log.csv" -i:CSV -o:SQL -server:%$servername% -database:%$database% -driver:"SQL Server" -fixcolnames:ON -createTable:ON

FarmerGedden · Accepted Answer · 2013-05-31 14:40:16Z

0

It sounds from the error as though your IF statement is at fault - try using

if $servertype==IIS

since == is used for comparisons.

Source: http://www.robvanderwoude.com/ntif.php

answered May 31, 2013 at 14:40

FarmerGedden

1,20011 silver badges23 bronze badges

Comments

Bathsheba · Accepted Answer · 2013-05-31 14:40:40Z

0

enter code hereYour notation is a little off.

To set, use set servertype=IIS

Note the spacing, the single = and lack of $.

To use, use %ISS%.

Note that %0 to %9 are the command line arguments to the batch file.

An if statement requires ==; e.g. if %variable%==2

answered May 31, 2013 at 14:40

Bathsheba

235k35 gold badges376 silver badges504 bronze badges

Comments

Magoo · Accepted Answer · 2013-05-31 14:43:20Z

0

The correct syntax is

if %$servertype%==IIS command

%var% returns the value of variable var

== is a valid equivalence oprator for strings

The command must start on the same line as the IF

The "full filename" (from the drive specifier C: to the end of the executable name .exe) must be quoted using rabbits-ears (")

answered May 31, 2013 at 14:43

Magoo

80.8k8 gold badges68 silver badges92 bronze badges

Collectives™ on Stack Overflow

Variable usage in batch file

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related