如果参数为真，则通过powershell从txt获取数据。

Question

我有一个powershell脚本，我使用一个批处理文件(具有提升的权限)运行该脚本来安装网络打印机。我已经配置了37个脚本，而这些脚本中的大多数代码都是重复的，所以我尝试制作一个通用脚本，通过包含一个包含所有打印机信息的txt文件来安装打印机的输入空间号。

这是批处理文件：

@echo off
set /p room_number=What is the room number: 

if exist "...\%room_number%.ps1" (
    Powershell.exe -executionpolicy remotesigned -File "...\%room_number%.ps1" "%room_number%"
)
else (
    echo.
    echo Powershell script for the printer in the room you specified has not been configured yet. You will need to add the printer maunally!
    explorer shell:::{A8A91A66-3A7D-4424-8D24-04E180695C7A}
    pause
)

这是我一直在处理的新的txt文件：

roomnumber=1001
prdrloc=hp-lj-m401dn
prdrname=HP LaserJet 400 M401 PCL 6
hostname=TEST1
IP=192.168.7.10
devname=HP LaserJet Pro 400 M401dn-ROOM

roomnumber=1002
prdrloc=hp-lj-m404dn
prdrname=HP LaserJet Pro M404-M405 PCL-6 (V4)
hostname=TEST2
IP=192.168.7.11
devname=HP LaserJet Pro M404dn-ROOM

这是powershell脚本，我试图在其中包含txt文件，但我不知道如何只获取有关我指定的房间的信息。

# Room_number_1001
param($room_number)
$file = "...\printer_info.txt"
foreach($line in (Get-Content $file)) {
    $a = $line.Split("=")
    New-Variable -Name $a[0] -Value $a[1]
}
Get-ChildItem "...\$prdrloc" -Filter *.inf -Recurse | % {pnputil.exe /a $_.FullName}
Add-PrinterDriver -Name "$prdrname" -Verbose
Add-PrinterPort -Name "$hostname" -PrinterHostAddress "$IP" -Verbose
Add-Printer -PortName "$hostname" -Name "$devname" -DriverName "$prdrname"
Set-ItemProperty -Path "HKCU:\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Windows" -Name "LegacyDefaultPrinterMode" -Value 1 -Force
$PrinterName="$devname"
$DefaultPrinter = Get-WmiObject Win32_Printer -Filter "Name='$PrinterName'"
$DefaultPrinter.SetDefaultPrinter()

任何帮助都将不胜感激。谢谢你们。:)

Answer 1

童子军，谢谢你的回答。它并没有完全解决我的问题，但你派我去寻找正确方向的解决方案。我实施了csv的建议。:)

我将张贴我的新批处理文件，csv和powershell脚本，这给我的结果，我需要。

批处理：

@echo off
setlocal enabledelayedexpansion
set /p room_number=What is the room number: 
set /A counter=0

for /f "usebackq tokens=1-6 delims=;" %%a in ("...\printerinfo.csv") do (
    if "%%a" == "%room_number%" (
        set /A counter=1
        Powershell.exe -executionpolicy remotesigned -File "...\printerscript.ps1" "%room_number%"
    )
)
if "%counter%"=="0" (
    echo.
    echo Powershell script for the printer in the room you specified has not been configured yet. You will need to add the printer maunally!
    explorer shell:::{A8A91A66-3A7D-4424-8D24-04E180695C7A}
    pause
)

CSV文件：

room_nmb;prdr_loc;prdr_name;host_name;ip_address;dev_name
1001;hp-lj-m401dn;HP LaserJet 400 M401 PCL 6;TEST1;192.168.7.10;HP LaserJet Pro 400 M401dn-ROOM
1002;hp-lj-m404dn;HP LaserJet Pro M404-M405 PCL-6 (V4);TEST2;192.168.7.11;HP LaserJet Pro M404dn-ROOM

Powershell脚本：

param($room_number)

$roomnmb = @()
$prdrloc = @()
$prdrname = @()
$hostname = @()
$ip = @()
$devname = @()

Import-csv "...\printerinfo.csv" -delimiter ";" |
ForEach-Object {
    $roomnmb = $_.room_nmb

    if ($roomnmb -contains $room_number) {
        $prdrloc = $_.prdr_loc
        $prdrname = $_.prdr_name
        $hostname = $_.host_name
        $ip = $_.ip_address
        $devname = $_.dev_name

        Get-ChildItem "...\$prdrloc" -Filter *.inf -Recurse | % {pnputil.exe /a $_.FullName}
        Add-PrinterDriver -Name "$prdrname" -Verbose
        Add-PrinterPort -Name "$hostname" -PrinterHostAddress "$ip" -Verbose
        Add-Printer -PortName "$hostname" -Name "$devname" -DriverName "$prdrname"
        Set-ItemProperty -Path "HKCU:\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Windows" -Name "LegacyDefaultPrinterMode" -Value 1 -Force
        $DefaultPrinter = Get-WmiObject Win32_Printer -Filter "Name='$devname'"
        $DefaultPrinter.SetDefaultPrinter()
    }
}

干杯伙计。

Answer 2

首先，我会把你的数据放到csv里。在Powershell中维护更容易，使用起来更容易

​

​

$PrinterData = Import-Csv -Path '\path to printer config csv file'
$RoomRequired = '1001'
$PrinterData | Where-Object {$_.RoomNumber -in $RoomRequired} | ForEach-Object {
    Get-ChildItem "...\$_.prdrloc" -Filter *.inf -Recurse | % {pnputil.exe /a $_.FullName}
    Add-PrinterDriver -Name $_.prdrname -Verbose
    Add-PrinterPort -Name $_.hostname -PrinterHostAddress $_.IP -Verbose
    Add-Printer -PortName $_.hostname -Name $_.devname -DriverName $_.prdrname
    Set-ItemProperty -Path "HKCU:\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Windows" -Name "LegacyDefaultPrinterMode" -Value 1 -Force
    $PrinterName= $_.devname
    $DefaultPrinter = Get-WmiObject Win32_Printer -Filter "Name='$Print
}

如果您想要做多个房间，您可以让$RoomRequired成为一个房间号数组，例如$RoomRequired = @("1001","1002")。