Schedule CSV import error

Question

Hi, I'm following the guide about scheduling a user import from a CSV file: Schedule Import of Users from CSV

but I get the following 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. Stack trace: at <ScriptBlock>, <No file>: line 7".

Any help would be much appreciated.

Dario

Comments

Hello,

Could you, please, post here or send us (support[at]adaxes.com) an example of the CSV file you are using for import? Also, please, provide us with the full script you are using.

---

Hi,

the script is pretty basic:

==================== Import-Module Adaxes

$file = "C:\temp\users.csv" $targetDN = "%distinguishedName%" $domain = $Context.GetObjectDomain($targetDN)

Import-CSV $file | New-AdmUser -Path $targetDN -AdaxesService localhost -Server $domain

The csv file is as follows:

Thank you

Dario

---

Hello Dario,

Thank you for the provided details. The script and the CSV file look correct. Could you, please, post here or send us (support[at]adaxes.com) a screenshot of the Scheduled Task you created with the Activity Scope? We need something like the following:

---

Hi, here's the screenshot

Answer 1

Hello Dario,

Thank you for the provided screenshot. The Scheduled Task looks correct. For the import to work, please, make sure that columns in the CSV file are separated by commas, not semicolons.

Also, the Name parameter is required when executing the New-AdmUser cmdlet. You need to add the column with the name header to the CSV file. Alternatively, you can replace the cn header.

Comments

Hi,

that solved the error but now I get a new one:

Thank you

Dario

---

Hello Dario,

Most probably, the error occurs because one of the values in the CSV file is not specified correctly. It should work fine with the properties displayed in the screenshot you provided earlier. Did you add new columns to the file? If so, please, make sure that the values in the columns are correct. For example, such an error can occur if you add the manager column to the CSV file and the values in the column are not distinguished names (DN).

---

Well if I save the script i get a warning on exit and also inside the debugger I get an error on the -path parameter

Thank you

---

Hello Dario,

The script is correct. It is just that the cmdlet data is not loaded yet and that is why you get the error and the cmdlet parameters get underlined. You can see the data being loaded in the bottom left corner of the script editor.