Scheduled User CSV Import Error

Question

Trying to test importing users via CSV. Running into the following error --

Error: The input object cannot be bound to any parameters for the command either because the command does not take pipeline input or the input and its properties do not match any of the parameters that take pipeline input.

Here's the code I'm using --

$file = "c:\test\users.csv"
$targetDN = "%distinguishedName%"
$columnMap = @{
    "Preferred First Name" = "givenName";
    "EmployeeLastName" = "sn";
    "Category_Location" = "physicalDeliveryOfficeName";
    "Category_CostCenter" = "extensionAttribute1";
    "Category_ServiceLine" = "department";
    "Category_JobLevel" = "title";
}

$domain = $Context.GetObjectDomain($targetDN)
$importedUsers = Import-Csv $file
foreach ($user in $importedUsers)
{
    $otherAttributes = @{}
    foreach ($property in $user.PSObject.Properties)
    {
        # Map property name if mapping specified
        if ($columnMap[$property.Name])
        {
            $propertyName = $columnMap[$property.Name]
            $user.PSObject.Properties.Remove($property.Name)            
        }
        else
        {
            continue
        }

        # Get property value
        $value = $property.Value
        if ([System.String]::IsNullOrEmpty($value))
        {
            continue
        }

        $otherAttributes.Add($propertyName, $value)
    }
    try
    {
        $user | New-AdmUser -Path $targetDN -Server $domain `
            -AdaxesService localhost -ErrorAction Stop
    }
    catch [System.Exception]
    {
        $to = "me@company.com"
        $subj = "Failed to Import User from CSV"
        $bodyText = "Adaxes failed to import user " + $user.Name + " from $file."`
            + "`nError: " + $_.Exception.Message
        $bodyHtml = $null
        $Context.SendMail($to, $subj, $bodyText, $bodyHtml)

        $Context.LogMessage($bodyText, "Error")
    }
}

Here's an example CSV (comma separated, not semi-colon). I also tried modifying the CSV by removing any fields not mapped in the Powershell script, but no luck --

Here's my scheduled task --

Answer 1

Hello,

We recommend you to use one of the scripts from the following article in our repository: https://www.adaxes.com/script-repository/import-new-and-updated-users-from-csv-file-s246.htm. It looks like Script 3: Only create new users is exactly what you need. In your case, the $ouDN variable should be set to %distinguishedName%.

$ouDN = "%distinguishedName%" # TODO: modify me

Comments

Thanks.

How would I go about excluding certain columns in the CSV from being processed by the script? Right now the script tries to process every column which spits out the following error -

The following properties are not defined in the directory schema: Scheduled Hours, EmployeeFirstName, Category_HireType, Full or Part Time and Hire Date.

Those columns don't matter for our purposes, so can I just map each of those to $null or something?