Link to home
Start Free TrialLog in
Avatar of konga-frites
konga-fritesFlag for Germany

asked on

Exchange 2007 Userdefines Parameters in powershell

Hi @all. One more silly question just before Christmas :):
I have an Exchange 2007 installed in German.
I have to import quite a lot of external contacts which should then be member of a dynamic distribution list. The argument for the membership should be a keyword in the user defined parameters (1-15) of the contact.
my problem is, that i don't know the exact expression for the argument in the powershell. i tried the following list:

The powershell command I run is this:
Import-Csv d:\import\KES-Liste1.csv | ForEach {New-MailContact -LastName $_.Nachname -Firstname $_.Vorname -Name $_.Name -DisplayName $_.Anzeigename -ExternalEmailAddress $_.ExterneEMailAdresse -Alias $_.Alias -OrganizationalUnit "pizh.local/KES" -customAttribute1 $_.BenutzerdefiniertesAttribut1 -CustomAttribute2 $_.BenutzerdefiniertesAttribut2 -CustomAttribute3 $_.BenutzerdefiniertesAttribut3}

With that I always the error:
+ FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.Exchange.Management.RecipientTasks.NewMailContact

The csv-file looks like this:
TestNachname,TestVorname,KES TestNachname TestVorname,KES TestNachname TestVorname,,KESTestNachnameTestVorname,,KES,
(of course just one test argument).

Any ideas. I'll appreciate your suggestions :).
Avatar of Rajitha Chimmani
Rajitha Chimmani
Flag of United States of America image

From the contents of csv that you posted it looks like there is some mismatch in the last three columns. Can you attach the values in your question in a csv file?
New-MailContact does not have parameter for custom attributes you need to add Set-MailContact for that..
Avatar of konga-frites


here you are, 9 field definitions and 9 arguments (the last is emty! -> just a comma)
The problem doesn't seem to be the number of arguments, defined or not, it is the wrong name of the parameter which expresses the user defined attributes in exchange.
Avatar of SubSun
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@subsun: I'll try that - should this work (attached File)????
It should work.. or you can just pipe the New-MailContact output to Set-MailContact as I mentioned in above comment..
Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Gah, got ninjaed. Well, what he said.
So do I get you right: the ps keeps the arguments and the csv in memory until the console is closed?
Ok. I'll try later cause on the move right now. Will give you feedback.
If you assign it to a variable then yes.. For example
$temp = Import-Csv d:\import\KES-Liste1.csv
then $Temp will save the information until you close the console or re-assign it. You can also change the scope of variable in PowerShell..
Hey guys - thanks for your help. As there are holidays and my family and I are on break till new year. I'll test immediately after back in business. So far - happy new year.
No problem, take your time...  Have a safe, happy and successful New Year :)
@Subsun: Your Solution worked for this Problem but

I have now another "problem" with altering existing records.

If I want to change for multiple users one value of a field according the value in an ascii export from another tool.

So the command in the ps I use is this:

Import-Csv d:\import\KES-Liste.csv | ForEach
    Set-MailContact -Identity $_.Alias -CustomAttribute1 $_.BenutzerdefiniertesAttribut1

the values in the KES-Liste.csv are this
Nachname,Vorname,Name,Anzeigename,ExterneEMailAdresse,Alias,Organisationseinheit,Benutzerdefiniertes Attribut 1,Benutzerdefiniertes Attribut 2,Benutzerdefiniertes Attribut 3
Sample_N,Sample_SN,KES Sample_N Sample_SN,KES Sample_N Sample_SN,,KOESample_NSample_SN,OU_Sample,Unit_1,Unit_2,Unit_3

With that I get the following hint:

WARNUNG: Der Befehl wurde erfolgreich abgeschlossen, es wurden jedoch keine
Einstellungen von 'domain.local/OU_Sample/KES Sample_N Sample_SN' geändert.

Which means something like:
Warning: The command was completed successful, although no settings of  'domain.local/OU_Sample/KES Sample_N Sample_SN' were changed.

No more hints from the ps why nothing was changed. The values in the csv are definitely different to them in the AD.

Some more hints????

Tanks a lot in advance.
If this is a different problem then I would suggest you to open another question for it.. ;-)

BTB.. What if you run the command manually for one user? before running the command check the users attribute and make sure it's not same..
Set-MailContact -Identity KOESample_NSample_SN -CustomAttribute1 "Unit_1"
This works fine :) - but as you suggested I'll open another question for that :) - fairness first! of course
Thanks.. You may post the link to the follow-up question here, so that it will be easy for us to find it..
as subsun was the first he deserved the lion's share. but there were also Rajitha14 and GusGallows who had the same problem-solving approach.this should also be rewarded :).

Hope you guys are satisfied with that :).