vbscript or powershell to install application

Neally · 2018-04-24T15:46:03.000Z

try like so

$machineParams = Import-CSV $filePath | 
where {$_.machineCode -eq "$($env:computername.Substring(3))"} | select param1, param2

$machineParams

tkr99 · 2018-04-24T16:26:51.000Z

thanks neally,

when I run that there is no error,

How it will go for next command

$fileLocation = “C:\Program Files (x86)\Microsoft Visual Studio\2015\IDE\devenv.exe”

if (Test-Path $fileLocation){

Neally · 2018-04-24T16:33:08.000Z

You have to tell it the location

$filePath = "$env:userprofile\desktop\test.csv"
$machineParams = Import-CSV $filePath | 
where {$_.machineCode -eq "$($env:computername.Substring(3))"} | select param1, param2
$machineParams

Neally · 2018-04-24T16:38:30.000Z

tkr99:

How it will go for next command

You put all your code in a file can call is .ps1 , that’s a powershell script, you can then call it from the powershell console

2018-04-24_11-36-41.png800×299 77.2 KB

tkr99 · 2018-04-24T16:47:11.000Z

thanks as a test

$filePath = “C:\Users\params.csv”
where {$_.machineCode -eq “$($env:computername.Substring(3))”} | select param1, param2
$machineParams

$fileLocation = “C:\Program Files (x86)\Microsoft Visual Studio\2015\IDE\devenv.exe”

if (Test-Path $fileLocation){
$Timeout = 10 ## seconds

} else {

$Timeout = 100 ## seconds

}

but, it didnt open up timeout window

Neally · 2018-04-24T16:49:23.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

tkr99 · 2018-04-24T16:51:40.000Z

$filePath = "C:params.csv"
where {$_.machineCode -eq "$($env:computername.Substring(3))"} | select param1, param2
$machineParams

$fileLocation = "C:\Program Files (x86)\Microsoft Visual Studio\2015\IDE\devenv.exe"

if (Test-Path $fileLocation){
$Timeout = 10 ## seconds

} else {

$Timeout = 100 ## seconds

}

tkr99 · 2018-04-24T16:52:27.000Z

sorry for that

Neally · 2018-04-24T16:54:15.000Z

tkr99:

but, it didnt open up timeout window

What’s a ‘timeout’ window?

$timeout is just a variable to powershell, it has no special meaning. you might want to look into ‘start-sleep’ ?

$filePath = "C:\Users\ARAVIND ANCHE\Desktop\TI18\params.csv" 

$machineParams = Import-CSV $filePath | where {$_.machineCode -eq "$($env:computername.Substring(3))"} | select param1, param2
$machineParams # this is just so it shows info on the host

$fileLocation = "C:\Program Files (x86)\Microsoft Visual Studio\2015\IDE\devenv.exe"

if (Test-Path $fileLocation) {
    Write-Output "File exists"
    $Timeout = 10 ## seconds
    # this is command for powershell
    # to pause for some time
    Start-sleep -Seconds 10 
   
}
else {
    Write-Output "File is missing"
    $Timeout = 100 ## seconds
    start-sleep -Seconds 100
    
}

tkr99 · 2018-04-24T17:00:41.000Z

Thanks Nelly, My first part look good. running MSI, exe and cmd like below works? or Am i doing that wrong way

$filePath = "C:\Users\params.csv" 

$machineParams = Import-CSV $filePath | where {$_.machineCode -eq "$($env:computername.Substring(3))"} | select param1, param2
$machineParams # this is just so it shows info on the host

$fileLocation = "C:\Program Files (x86)\Microsoft Visual Studio\2015\IDE\devenv.exe"

if (Test-Path $fileLocation) {
     start-process msiexec.exe -Wait -ArgumentList " /I \\server\share\Sybase.MSI /quiet /norestart "
    start-process msiexec.exe -Wait -ArgumentList " \\server\share\ setup.msi" @machineParams
    start-process "c:\programfiles\app\CFG.exe"
    start-process "cmd.exe" "/c "c:\app\cfg.cmd"
   
}
else {
    Write-Output "File is missing"
    $Timeout = 100 ## seconds
    start-sleep -Seconds 100
    
}

Neally · 2018-04-24T17:05:49.000Z

tkr99:

Thanks Nelly

nkay…

Also you do not mark anything you post as powershell, but text…

tkr99:

I can not test if that would work for you, have you tried it? Run it against a test computer and see?

tkr99 · 2018-04-24T17:15:57.000Z

I will,

I want to know the lines which has start-process, Are they good?

Can I do something like that?

tkr99 · 2018-04-24T17:22:53.000Z

I ran the below code

$filePath = "C:\params.csv" 

$machineParams = Import-CSV $filePath | where {$_.machineCode -eq "$($env:computername.Substring(3))"} | select param1, param2
$machineParams # this is just so it shows info on the host

$fileLocation = "C:\params.csv"

if (Test-Path $fileLocation) {
    start-process "cmd.exe" /c "C:\test.bat"
}
else {
    Write-Output "File is missing"
    $Timeout = 100 ## seconds
    start-sleep -Seconds 100
    
}

The file exits

but i got error

tkr99 · 2018-04-24T17:28:13.000Z

Thanks kelly I removed ?c and it look good

I will add more line for the msi and exe.

Thanks alot

tkr99 · 2018-05-08T15:33:23.000Z

Hello all,

Sorry for the laqte response, we are still working on the parameters and naming convention.

I will get back asap

Regards’

tkr99 · 2018-05-09T13:36:33.000Z

Hello Nelly

we got the csv file, it looks like attached

So when I run on particular machine, it has to check the last 3 numbers and take the details next to it.

Thanks alot

params.txt (74 Bytes)

Neally · 2018-05-10T13:37:44.000Z

I am lost what you need.

Instead of start process, try this:

& cmd.exe /c "c:\test.bat"

tkr99 · 2018-05-10T14:11:53.000Z

Thanks for the reply Neally,We have csv file as attached and I want to install msi using that.

$filePath = "\\server\share\params.csv"
$machineParams = Import-CSV $filePath | where {$_.machineCode -eq "$($env:computername.Substring(6))"} | select param1, param2
$machineParams
start-process msiexec.exe -Wait -ArgumentList " C:\SMB12\setup.msi" @machineParams

So when I run on particular machine, for example

W7SRD102

the script matches the 102 and run with parameters nxt to it in csv file

Parameters.txt (101 Bytes)

Neally · 2018-05-10T16:54:38.000Z

I do not understand., nothing you are referencing has any content to the code?

You posted 2 CSVs

**PC Name,Database ID,Dtabase Name**
W7BRS001,2,AAA002T
W7SRD002,3,BBB001T

**Branch,DATABASE_ID,ODBC_DATABASE_NAME,ODBC_ENGINE_NAME,ODBC_HOST_NAME**
102,1,wwe4564,www002,1.0.0.1

then in your code you are referencing
machineCode → there is no column in your csv called ‘machinecode’ ?
Or ‘param1’ or ‘param2’, so this would not work.

$filePath = "\\server\share\params.csv"
$machineParams = Import-CSV $filePath | where {$_.machineCode -eq "$($env:computername.Substring(6))"} | select param1, param2
$machineParams
start-process msiexec.exe -Wait -ArgumentList " C:\SMB12\setup.msi" @machineParams

Which of those CSVs are you actually using? I’m super confused, sorry.

tkr99 · 2018-05-10T17:44:54.000Z

Sorry Neally,

I attached the csv again

$filePath = "\\server\share\params.csv"
$machineParams = Import-CSV $filePath | where {$_.Branch -eq "$($env:computername.Substring(6))"} | select param1, param2
$machineParams
start-process msiexec.exe -Wait -ArgumentList " C:\SMB12\setup.msi" @machineParams

soo sorry for the confusion.

if I run on a computer W7DDDR102, it should take the parameters next to 102.

previously we use to do manually

Msiexec /L* C:setup.log /qn /I C:\installs\setup.msi DATABASE_ID=1 ODBC_DATABASE_NAME=wwe4564 ODBC_ENGINE_NAME=www002 ODBC_HOST_NAME=1.0.01 NOLAN=1  ALLUSERS=1

Parameters.txt (131 Bytes)