Let me preface this with this: Michael, you've been a tremendous help - I think you've written the entire script, just about.
So of course, I have one more problem.
If anyone can point me in the right direction....
The preferred first / last name is working perfectly.
Testing if the user already exists, then adding a letter to the first name
and testing again (so if cgmail already exists, I use cagmail).
The problem is when I export the user name and other information back to HR.
I need MISUSERNAME to be either the one that worked, or null or "Manually
create"...
It's always first initial / last name.
I am attaching a copy of the script, if anyone has a few minutes to look it
over.
Thanks all!
On Thu, Jul 11, 2013 at 2:07 PM, Candee <can...@gmail.com> wrote:
> Yes! I think I got it - thank you!
> I missed the '' :)
>
> That parts working, so I can start messing with the rest.
> Of course, as soon as I'm finished they'll change the requirements.
> :(
> thank you *so* much!!
>
>
> On Thu, Jul 11, 2013 at 1:54 PM, Michael B. Smith
> <mich...@smithcons.com>wrote:
>
>> You didn’t do it exactly the way I showed. J****
>>
>> ** **
>>
>> You have to create the variable FIRST with an assignment and then assign
>> it further within the if/then/else blocks. Otherwise, scoping rules make
>> the variable disappear.****
>>
>> ** **
>>
>> *From:* listsad...@lists.myitforum.com [mailto:
>> listsad...@lists.myitforum.com] *On Behalf Of *Candee
>> *Sent:* Thursday, July 11, 2013 1:46 PM
>>
>> *To:* powershell@lists.myitforum.com
>> *Subject:* Re: [powershell] Re: Create users in AD with multiple if /
>> then conditions****
>>
>> ** **
>>
>> I'm having a heck of a time today - I have to stop with the tab button -
>> sorry...****
>>
>> You cannot call a method on a null valued expression.****
>>
>> $SAM = $givenname.substring <<<< (0,1) + $SN****
>>
>> invalidoperation: (Substring:string) [], runtimeException****
>>
>> FullyQualifiedErrorId : InvokeMethodonNull****
>>
>> ** **
>>
>> On Thu, Jul 11, 2013 at 1:43 PM, Candee <can...@gmail.com> wrote:****
>>
>> That makes more sense, doesn't it?****
>>
>> Thanks Michael.****
>>
>> Now I'm getting this error:****
>>
>> ****
>>
>> You cannot call a method on a null-valued expression****
>>
>> ****
>>
>> ** **
>>
>> On Thu, Jul 11, 2013 at 1:22 PM, Michael B. Smith <mich...@smithcons.com>
>> wrote:****
>>
>> $givenName = ‘’****
>>
>> If( -not [String]::IsNullOrEmpty( $_.PreferredFirstName ) )****
>>
>> {****
>>
>> $givenName = $_.PreferredFirstName****
>>
>> }****
>>
>> Else****
>>
>> {****
>>
>> $givenName = $_.FirstName****
>>
>> }****
>>
>> ****
>>
>> Etc.etc.etc.****
>>
>> ****
>>
>> *From:* listsad...@lists.myitforum.com [mailto:
>> listsad...@lists.myitforum.com] *On Behalf Of *Candee
>> *Sent:* Thursday, July 11, 2013 1:05 PM
>> *To:* powershell@lists.myitforum.com
>> *Subject:* Re: [powershell] Re: Create users in AD with multiple if /
>> then conditions****
>>
>> ****
>>
>> Sorry,****
>>
>> First name = real first name (ie William)****
>>
>> Preferred first name = nickname (ie Bill)****
>>
>> Last name = real last name (ie Smith, Jr)****
>>
>> Last name preferred = ie Smith (no Jr).****
>>
>> ****
>>
>> So, the two preferreds have to be checked first.****
>>
>> if preferred first name is blank, I need to use the real first name****
>>
>> If the last name preferred is blank, I need to use the real last name.***
>> *
>>
>> ****
>>
>> Once I have those, I can create the display name, email address, etc.****
>>
>> (I had the script working with just first name / last name, but these
>> additional preferred columns changed that).****
>>
>> ****
>>
>> Right now, I'm gettng:
>> Unexpected token 'sn' in expression or statement****
>>
>> ****
>>
>> Parser error: (sn:string) [], parentcontainserrorrecordexception****
>>
>> ****
>>
>> ****
>>
>> On Thu, Jul 11, 2013 at 12:45 PM, Trevor Sullivan <tsul...@gmail.com>
>> wrote:****
>>
>> Can you clarify on “can’t seem to get it to work?” What are you trying to
>> achieve? What are the results of your command? What differs between the
>> actual results, and the intended results?****
>>
>> ****
>>
>> Cheers,****
>>
>> *Trevor Sullivan*****
>>
>> ****
>>
>> ****
>>
>> *From:* listsad...@lists.myitforum.com [mailto:
>> listsad...@lists.myitforum.com] *On Behalf Of *Candee
>> *Sent:* Thursday, July 11, 2013 11:40 AM
>> *To:* powershell@lists.myitforum.com
>> *Subject:* [powershell] Re: Create users in AD with multiple if / then
>> conditions****
>>
>> ****
>>
>> Let's try this again:****
>>
>> Import-csv $newusers |foreach {****
>>
>> If ($_.preferredfirstname -eq $null -and $_.lastnamepreferred -eq
>> $null) { $givenname = $_.firstname $sn = $_.lastname}****
>>
>> ****
>>
>> elseif (($_.preferredfirstname -ne $null -and $_.lastnamepreferred -eq
>> $null) {$givenname = $_.preferredfirstname $sn = $_.lastname}****
>>
>> elseif (($_.preferredfirstname -eq $null -and $_.lastnamepreferred -ne
>> $null) {$givenname = $_.firstname $sn = $_.lastnamepreferred}****
>>
>> ****
>>
>> Etc, through the rest.****
>>
>> Thanks all,****
>>
>> Candee****
>>
>> ****
>>
>> On Thu, Jul 11, 2013 at 12:35 PM, Candee <can...@gmail.com> wrote:****
>>
>> Hello,****
>>
>> I need to import users from a csv from HR.****
>>
>> There are multiple fields for both first name and last name.****
>>
>> I can't seem to get it to work.****
>>
>> This is what I have so far - if anyone can offer assistance, it's much
>> appreciated.****
>>
>> ****
>>
>> Import-csv $newusers |foreach {****
>>
>> ****
>>
>> ****
>>
>> ****
>>
>> ****
>>
>> ================================================
>> Did you know you can also post and find answers on PowerShell in the
>> forums?
>> http://www.myitforum.com/forums/default.asp?catApp=1 ****
>>
>>
>> ================================================
>> Did you know you can also post and find answers on PowerShell in the
>> forums?
>> http://www.myitforum.com/forums/default.asp?catApp=1 ****
>>
>> ****
>>
>>
>> ================================================
>> Did you know you can also post and find answers on PowerShell in the
>> forums?
>>
>>
================================================
Did you know you can also post and find answers on PowerShell in the forums?
http://www.myitforum.com/forums/default.asp?catApp=1
Import from Epicor.docx
Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document
