How to build a batch file?

[RikHess]

We are moving from using bar codes on our event badges to using mag-cards. The vendor has provided a utility where a one line command can pass the information to the mag-card printer for each card. We only will use this for the 1-off on-location cards.

I can build the command line in my Stored Procedure, but running the command using xp_cmdshell is not working. I have set the rights for advanced options and command shell.

My next thought is to build a BAT file containing the data command, then executing that file.

Can someone help me with build this file? I feel like I'm close, but it is frustrating to not be able to get this last step to work.

If you would like more info, just ask.

Thank you.

 

[RiverGuy]

I can build the command line in my Stored Procedure, but running the command using xp_cmdshell is not working. I have set the rights for advanced options and command shell.

Did you try full-qualifying the path of the executable in your statement? What I mean is instead of SomeCommand.exe trying C:\VendorsSoftwarePath\SomeCommand.exe

 

[simian101]

Plese show an example of your command.

Simi

 

[RikHess]

This is the basic command line I built (data modified for security):

c:\windows\clientconsole "192.168.20.150" "09TexAnnMtg~2549~Lana~Green~Guest~Complex Community~ ~ ~ ~ ~ ~ ~(555)550-9126~(555)550-9128~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~EOR"

Basically it calls the vendor program "clientconsole" and provides two string parameters -- the IP address of the printer and a tilde delimited string of badge variables for the mag card.

This project is being delayed a bit as we work out the actual setup of the network we will be using for the event.

Thanks for the help!