We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Exchange 2007 Userdefines Parameters in powershell
Posted on 2012-12-21
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:
extensionAttribute1
userdefinedAttribute1
BenutzerdefiniertesAttribu
...
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 $_.BenutzerdefiniertesAttr
With that I always the error:
+ FullyQualifiedErrorId : NamedParameterNotFound,Mic
The csv-file looks like this:
Nachname,Vorname,Name,Anze
TestNachname,TestVorname,K
(of course just one test argument).
Any ideas. I'll appreciate your suggestions :).
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:
extensionAttribute1
userdefinedAttribute1
BenutzerdefiniertesAttribu
...
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 $_.BenutzerdefiniertesAttr
With that I always the error:
+ FullyQualifiedErrorId : NamedParameterNotFound,Mic
The csv-file looks like this:
Nachname,Vorname,Name,Anze
TestNachname,TestVorname,K
(of course just one test argument).
Any ideas. I'll appreciate your suggestions :).
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
8
7-
2
- +1
19 Comments
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?
Active 4 days ago
New-MailContact does not have parameter for custom attributes you need to add Set-MailContact for that..
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.
KES-Liste1.csv
Import-Script-KES.ps1.txt
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.
KES-Liste1.csv
Import-Script-KES.ps1.txt
Active 4 days ago
Try somthing like..
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" |
Set-MailContact -customAttribute1 $_.BenutzerdefiniertesAttribut1 -CustomAttribute2 $_.BenutzerdefiniertesAttribut2 -CustomAttribute3 $_.BenutzerdefiniertesAttribut3}
@subsun: I'll try that - should this work (attached File)????
Import-Script-KES-Variante.ps1.txt
Import-Script-KES-Variante.ps1.txt
Active 4 days ago
It should work.. or you can just pipe the New-MailContact output to Set-MailContact as I mentioned in above comment..
You can also use your script this way.
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"
Set-MailContact -Identity $_.Anzeigename -CustomAttribute1 $_.BenutzerdefiniertesAttribut1 -CustomAttribute2 $_.BenutzerdefiniertesAttribut2 -CustomAttribute3 $_.BenutzerdefiniertesAttribut3
}
The problem you are running into is the customattribute is not a valid parameter for new-mailcontact. You will need to do that piece using the Set-mailcontact. So create your contacts first, then use the set-mailcontact parameter to set the customattribute fields.
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.
Ok. I'll try later cause on the move right now. Will give you feedback.
Active 4 days ago
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..
$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.
@Subsun: Your Solution worked for this Problem but
@all:
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 $_.BenutzerdefiniertesAttr
}
the values in the KES-Liste.csv are this
Nachname,Vorname,Name,Anze
Sample_N,Sample_SN,KES Sample_N Sample_SN,KES Sample_N Sample_SN,Sample_N@hotmail
With that I get the following hint:
WARNUNG: Der Befehl wurde erfolgreich abgeschlossen, es wurden jedoch keine
Einstellungen von 'domain.local/OU_Sample/KE
Which means something like:
Warning: The command was completed successful, although no settings of 'domain.local/OU_Sample/KE
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.
@all:
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 $_.BenutzerdefiniertesAttr
}
the values in the KES-Liste.csv are this
Nachname,Vorname,Name,Anze
Sample_N,Sample_SN,KES Sample_N Sample_SN,KES Sample_N Sample_SN,Sample_N@hotmail
With that I get the following hint:
WARNUNG: Der Befehl wurde erfolgreich abgeschlossen, es wurden jedoch keine
Einstellungen von 'domain.local/OU_Sample/KE
Which means something like:
Warning: The command was completed successful, although no settings of 'domain.local/OU_Sample/KE
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.
Active 4 days ago
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"
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
Active 4 days ago
Thanks.. You may post the link to the follow-up question here, so that it will be easy for us to find it..
Featured Post
The IoT market is growing at a rapid pace and manufacturers are under pressure to quickly provide new products. Can you be sure that your devices do what they're supposed to do, while still being secure?
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Windows 10 came with a lot of built in applications, Some organisations leave them there, some will control them using GPO's. This Article is useful for those who do not want to have any applications in their image (example:me).
In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center.
Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center.
Navigate to the Organization >> Ad…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync.
To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 15 hours left to enroll
Earn Certification
MTA Server Fundamentals Exam 98-365
$59.00$53.10
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.