How to add bulk external nodes

#******* SET IP ADDRESS TO NPM SERVER YOU WANT TO CREATE NODES ON******

$OrionServer="X.X.X.X"

#******* Set path to CSV file containin node names *****

# The CSV file should have THREE COLUMNS

# The FIRST column should have a header cell called "NodeName"

# The cells below are the names of the external nodes to create

# The SECOND column should have a header cell called "IPA"

# The cells below it should have the IP addresses associated with each of the nodes to create

# The THIRD column should be called "Load"

# The cells below this should contain a "Y" for each node you wish to create

# (This allows you to have one big list but not create them all at the same time if you don't want to)

$nodeListFile="FULL FILE PATH HERE\externalNodesList.csv"

#**** The script will ask for credentials.  Must have Node Manager rights*****

$creds=Get-Credential

$swis=Connect-Swis -Credential $creds -Hostname $OrionServer

try {$nodes=Import-Csv $nodeListFile}

catch {Write-Host "Could not import file.  Check path and type";Break}

ForEach ($externalnode in $nodes)

{

    $externalNodeName=$externalnode.nodename

    $externalIpAddress=$externalnode.ipa

    if ($externalnode.Load -eq 'Y')

    {

        $nodeExists = Get-SwisData $swis "SELECT Uri FROM Orion.Nodes WHERE Caption='$externalNodeName'"

        if (-not $nodeExists)

        {

            Write-Host "Creating node:"$externalNodeName

            # add the external node

            $newNodeProps = @{Caption = $externalNodeName;Vendor="Placeholder";IPAddress = $externalIpAddress;EngineID = 1;ObjectSubType = "ICMP";External=$TRUE;}

            $newNodeUri = New-SwisObject $swis -EntityType "Orion.Nodes" -Properties $newNodeProps

            $newNode = Get-SwisObject $swis -Uri $newNodeUri

            # ********* SET CUSTOM PROPERTIES********

            # ****Change / add custom property names and values in line below*****

            $customProps = @{CUSTOM_PROPERTY_NAME_1="Value 1";CUSTOM_PROPERTY_NAME_2="Value 2"}

            # build the URI for Custom Properties access

            $customPropsUri = $newNodeUri+"/CustomProperties";

            # Set the custom property

            Set-SwisObject $swis -Uri $customPropsUri -Properties $customProps

            # WAIT 1 SECOND (To avoid overloading NPM server.  Can be removed)

            Start-Sleep -Milliseconds 1000  

        }

        else

        {

            Write-Host "Node already exists:"$externalNodeName  

        }

    }

    else

    {

        Write-host "Skipping node: $externalNodeName"

    }

}