Gfrktyl

I have a Batch script that calls Python then runs a Python program.

Instead of using a Batch script to do that, I would like to use PowerShell.

I am not a programmer nor scripter and I have Googled and researched without any luck as to how to get the correct syntax.
In testing, I have used a few commands: invoke-item, invoke-command, set- and get-variable, and some others I have forgotten, etc.

Can someone please provide me with the correct PowerShell syntax to call first, the Python executable, then the Python script itself?

The abbreviated Batch script is embedded along with the Python script which works as it should.

Thanks in advance.

echo off



set winpy=C:UsersAIODUDE.AIODUDE-PCDownloadsWPy-3710python-3.7.1.amd64



if EXIST %winpy% (

"%winpy%python.exe" "%~dp0HBSS_XML_Parser_Driver_Action.py" )

Called Python script

import HBSS_Classes, os, HIPS_8_FW_XML_Parser_Action



hbss_parser = HBSS_Classes.HBSSXMLParser()

xmlfiles = 

print('############################')

print('# UNDER ACTIVE DEVELOPMENT #')

print('############################n')

print("HBSS XML PARSER - DEVELOPED BY WADE, TIMOTHY J.")

print("This CLI application will create human readable CSV spreadsheets 

fromn""XML files directly exported from the McAfee ePolicy Orchestrator.")

print("nSupported products:n")

for each_entry in hbss_parser.product_dict:

    print(" " + each_entry)

print(" HOSTIPS_8000_FW")

print("nThe following files will be checked against supported "

  "XML file types:n")

for each_file in os.listdir():

    if each_file.endswith('.xml'):

        xmlfiles.append(each_file)

        print(each_file)

date_check = input("nFor HIPS 8 FW Policies only, would you also like to create an additional n.CSV file containing only new rules created/modified since a given date? n(For all other policies, enter N): Y/N ")

if (date_check.lower().startswith('y')):

    date_input = input("nFile will only contain new rules created/modified sincen MM-DD-YYYY? (include hyphens when entering date value): ")

    sincedate = True

else:

    sincedate = False

begin_check = input("nBegin parsing to CSV? Y/N ")

if (begin_check.lower().startswith('y')):

    hbss_parser.currentDirXMLListBLDR()

    hbss_parser.hbssObjectListBLDR()

    hbss_parser.hbssObjParseToCSV()

    dirfiles = os.listdir()

    for xmlfile in xmlfiles:

        if (xmlfile[:-4] + '_CSV.csv') in dirfiles:

            pass

        else:

            try:

                args = ['HIPS_8_FW_XML_Parser_Action.py', xmlfile]

                HIPS_8_FW_XML_Parser_Action.main(args, True)

                if sincedate:

                    args = ['HIPS_8_FW_XML_Parser_Action.py', xmlfile, date_input]

                    HIPS_8_FW_XML_Parser_Action.main(args, True)

            except:

                pass



else:

    pass

The best way I can think of to get you on the right track is to break down the operation of the batch file in to it's relevant components. This is a very straight forward batch file that executes the python environment and tells it to run a specific script. From looking at the python script it appears the batch file is meant to be run from a folder that contains a python script and one or more .xml files.

echo off

Echo off simply tells Windows to not output each command in the batch file to the screen. It's a cleaner way to run batch files and is present in almost all batch files. This is not necessary with Powershell.

set winpy=C:UsersAIODUDE.AIODUDE-PCDownloadsWPy-3710python-3.7.1.amd64

This command creates a variable named winpy which is equal to the path where your python executable resides.

if EXIST %winpy% (

This is the beginning of an IF statement that first checks if the path you specified for winpy actually exists. If it does, then it runs the code between the two parenthesis.

"%winpy%python.exe" "%~dp0HBSS_XML_Parser_Driver_Action.py" )

This is the line that does the actual work. It starts the python.exe executable with a command line parameter of your current path and the name of the script.

%~dp0 expands to the drive and path that you ran the batch file in.

Therefore, if you name this file mybatch.bat and place it in c:test then these are examples of the command it is running:

Example 1:
If you have a command prompt window open and you are currently in the c:usersyournamedownloads folder and you type in c:testmybatch.bat to execute this batch file, the batch file will run the following command:

"C:UsersAIODUDE.AIODUDE-PCDownloadsWPy-3710python-3.7.1.amd64python.exe" "c:usersyournamedownloadsHBSS_XML_Parser_Driver_Action.py"

Example 2:
If you have a command prompt window open and you are currently in the c:test folder and you type in mybatch.bat to execute this batch file, the batch file will run the following command:

"C:UsersAIODUDE.AIODUDE-PCDownloadsWPy-3710python-3.7.1.amd64python.exe" "c:testHBSS_XML_Parser_Driver_Action.py"

An equivalent Powershell v3 or newer script would look like this:

#Create the $winpy variable with the path to python.exe

$winpy = "C:UsersAIODUDE.AIODUDE-PCDownloadsWPy-3710python-3.7.1.amd64"



#Test if the $winpy path exists

if (test-path $winpy) {

    #Execute python.exe and start the script named 'HBSS_XML_Parser_Driver_Action.py' located in the same directory the powershell script is run from

    & "$($winpy)python.exe" "$PSScriptRootHBSS_XML_Parser_Driver_Action.py"

}