How to call a cmd file within python script

Question

This is the python script will do. The question is how to call the external cmd file within the function?

Read a CSV file in the directory.
If the content in 6th column is equal to 'approved', then calls an external windows script 'TransferProd.cmd'

.

def readCSV(x):
    #csvContents is a list in the global scope that will contain lists of the  
    #items on each line of the specified CSV file
    try:
        global csvContents
        file = open(csvDir + x + '.csv', 'r')      #Opens the CSV file
        csvContents = file.read().splitlines()     #Appends each line of the CSV file to csvContents
        #----------------------------------------------------------------------
        #This takes each item in csvContents and splits it at "," into a list.
        #The list created replaces the item in csvContents
        for y in range(0,len(csvContents)):
            csvContents[y] = csvContents[y].lower().split(',')
        if csvContents[y][6] == 'approved':
            ***CALL TransferProd.cmd***
            file.close()
        return
    except Exception as error:
        log(logFile, 'An error has occurred in the readCSV function: ' + str(error))
        raise

There are many solutions. Look at some questions on SO like stackoverflow.com/questions/89228/… and also look at doughellmann.com/PyMOTW/subprocess — pyfunc
– pyfunc, Commented Dec 6, 2011 at 21:48

Snago · Accepted Answer · 2011-12-06 21:50:35Z

4

Take a look at the subprocess module.

import subprocess
p = subprocess.Popen(['TransferProd.cmd'])

You can specify where you want output/errors to go (directly to a file or to a file-like object), pipe in input, etc.

answered Dec 6, 2011 at 21:50

Snago

735 bronze badges

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

3 Comments

DIY Believer Over a year ago

How to specify where the TransferProd.cmd is located? Shold I use os.chdir(cmdDir) or passing in directly in [D:

DIY Believer Over a year ago

in [D:\cmdDir\TransferProd.cmd]?

Snago Over a year ago

Either method should work (as long as you remember to put ' around the command in the second method: ['D:\cmdDir\TransferProd.cmd'])

user1076371 · Accepted Answer · 2011-12-06 21:49:42Z

1

import os
os.system('TransferProd.cmd')

This works in both unix/windows flavors as it send the commands to the shell. There are some variations in returned values though! Check here.

answered Dec 6, 2011 at 21:49

user1076371

1616 bronze badges

2 Comments

DIY Believer Over a year ago

How to specify the directory path for the TransferProd.cmd? Can os.chdir(cmdDir) or directly pass it in the code?

Alyssa Haroldsen Over a year ago

I'd try to stay away from os.system. Unless you're using hardcoded strings, your program can be very susceptible to injection. Example: os.system('./somescript' + filename) and the input provided is file.txt; rm -rf ~. It is useful if it's just a short little burst of a programming script, though, no denying that.

ILYA Khlopotov · Accepted Answer · 2011-12-06 21:52:36Z

0

If you don't need output of the command you could use: os.system(cmd)

The better solution is to use:

from subprocess import Popen, PIPE
proc = Popen(cmd, shell = True, close_fds = True)
stdout, stderr = proc.communicate()

answered Dec 6, 2011 at 21:52

ILYA Khlopotov

7453 silver badges5 bronze badges

Collectives™ on Stack Overflow

How to call a cmd file within python script

3 Answers 3

3 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related