PowerShell script to load Jurisdiction data into GNAF

load_jurisdiction_data.ps1

Param(
  [string]$serverName,
  [string]$databaseName,
  [string]$jurisdictionFilesPath,
  [string]$jurisdictionName
)

$filter = $jurisdictionName+"_*.psv"

Get-ChildItem $jurisdictionFilesPath -Filter $filter |
Foreach-Object {
    $tableName = $_.name.Replace($jurisdictionName+"_", "").Replace("_psv.psv", "")
    write-host "Procesing" $_.Name "into table" $tableName
    bcp $tableName in $_.FullName -d $databaseName -S $serverName -t"|" -c -T -F 2
}