Function import-fileset
{
[CmdletBinding()]

param ([string] $fileset)

if (${env:ProgramFiles(x86)}){$path = 'C:\Program Files (x86)\sims\SIMS .net\deployfileset.exe'} else {$path = 'C:\Program File\sims\SIMS .net\deployfileset.exe'}

$files = @("c:\shared\sims\connect.ini","d:\shared\sims\connect.ini")
foreach ($file in $files)
{
    $user = "westfield"
    if (test-path $file -ErrorAction SilentlyContinue)
    {
        $lines = gc $file
        foreach ($line in $lines)
            {
               if ( $line | select-string -pattern "servername")
                {
                    $servername = $line.split("=")
                    $var =  "Server:"+$servername[1]
                    write-verbose $var

                }
                if ( $line | select-string -pattern "database")
                {
                    $db = $line.split("=")
                    $var2 = "db:"+$db[1]
                    write-verbose $var2

                }

            }




    # check DM"
    $result = & "C:\Program Files (x86)\SIMS\SIMS .net Document Server\dmconfig.exe" /T | select -last 1
    if ($result -eq "Server is running")
    {write-verbose "DmConfig responded OK"} else {write-verbose "DmConfig responded OK"}
    $key = "HKLM:\SOFTWARE\Westfield\Stationdetails"
    # transpose schoolnumber
    $value = (get-itemproperty -path $key -Name SchoolID).SchoolID
    if ($value.Length -eq '5')
        {
            write-verbose "Schoolnumber identified as $value"
        } else {
            Write-Warning "Schoolnumber lookup failed"
            # look to see if first 5 digits of computername are numbers, and if so, try that.
            $var = $env:COMPUTERNAME
            $snip =  $var.Substring(0,5)

            # Not all schoolnumbers are numbers, but most are ...
            Add-type -AssemblyName microsoft.visualbasic
            if ([microsoft.visualbasic.information]::IsNumeric($snip) -eq $true)
                {
                    Write-verbose "Found a number in the computername - valid number"
                    $value = $snip
                }
                    else
                {
                    if ($snip.substring(0,2) -eq "LG")
                        {
                            write-verbose "Found a LG number in the computername - valid number"
                            $value = $snip
                        }else {
                            write-verbose "Was not able to find a number in the registry or the servername."
                        }

                }
        }

    # Number found, now need to transport
    $pw = @()
        if ($value)
        {

            for ($test = 0; $test -lt 5; $test++)
            {
                $num = $value.Substring($test,1)
                $letter = [char](96 + $num)
                $pw+=$letter
            }
            $string =$pw[0]+$pw[1]+$pw[2]+$pw[3]+$pw[4]
            write-verbose "Transposed password is $string"
            $pwd = "west$string"
            write-verbose "full password is $pwd"
        }
    # call command
    $myserver= $servername[1]
    $mydb=$db[1]
    write-verbose "Attempting with: /server=$myserver /database=$mydb /user=$user /password=$pwd /fileset=$fileset /debug /validate"
    & "C:\Program Files (x86)\SIMS\SIMS .net\DeployFileset.exe" /server=$myserver /database=$mydb /user=$user /password=$pwd /fileset=$fileset /debug /validate
        }
    }
}
import-fileset -fileset 'C:\Users\Administrator\Desktop\1003-statutoryreturns-autumn2018_fileset\1003-StatutoryReturns-Autumn2018_Fileset.mfs'  -verbose