Save New User Information

Question

We have a script the send an HTML email to HR with new user information upon creation is there a way to take that HTML email and create a word document that saves to a folder as well? I can provide the script if needed.

Comments

Hello,

Yes, it is possible. However, there are a lot of known issues when working with Microsoft Office Word from PowerShell and for some of them there are no fixes/workarounds. That is why, we recommend you to save the notification text to a CSV file. Please, specify the solution you prefer and post here or send us (support[at]adaxes.com) the script you currently have.

If there is anything else except for saving the details to a file that you need added to the script, please, provide us with details.

---

We are using the following code to copy new user info into a txt file and it was working great until we change our Direct and Fax number formatting from 1234567890 to (123) 456-7890. Is there a way to still use something like this and keep the new number formatting?

#File Path 
$filePath = “New User Sheets\%physicalDeliveryOfficeName%\New User Info - %firstname% %lastname%.txt"

#Tie Properties to Variables
$DID = %telephoneNumber%
$Fax = %facsimileTelephoneNumber%
$Copitrak = %pager%
$Extension = %ipPhone%

# Format Fax, DID and Copitrak Fields
If ($DID -eq "" ) {$DID2= "N/A"} Else {$DID2 = $DID}
If ($Fax -eq "") {$Fax2= "N/A"} Else {$Fax2 = $Fax}
If ($Copitrak -eq "") {$Copitrak2= "N/A"} Else {$Copitrak2 = $Copitrak}
If ($Extension -eq "") {$Extension2= "N/A"} Else {$Extension2 = $Extension}

#Write Output
Write "User Information" | Out-File -FilePath $filePath
Write "Full Name: %name%" | Out-File -FilePath $filePath -Append
Write "Username: %username%" | Out-File -FilePath $filePath -Append
Write "Password: %unicodePwd%" | Out-File -FilePath $filePath -Append
Write "Email: %mail%" | Out-File -FilePath $filePath -Append
Write "Job Title: %title%" | Out-File -FilePath $filePath -Append
Write "" | Out-File -FilePath $filePath -Append
Write "Phone Information" | Out-File -FilePath $filePath -Append
Write "Extension: $Extension2" | Out-File -FilePath $filePath -Append
Write "Direct Dial Number: $DID2" | Out-File -FilePath $filePath -Append
Write "Fax Number: $Fax2" | Out-File -FilePath $filePath -Append
Write "Copitrak Code: $Copitrak2" | Out-File -FilePath $filePath -Append
Write "" | Out-File -FilePath $filePath -Append
Write "The user was added to the following groups:" | Out-File -FilePath $filePath -Append

# Get Group Memberships
$groupGuids = $Context.TargetObject.GetEx("adm-DirectMemberOfGuid")

foreach ($groupGuidBytes in $groupGuids)
{
    # Bind to the group
    $groupGuid = New-Object "System.Guid" (,$groupGuidBytes)
    $groupGuid = $groupGuid.ToString("B")
    $groupPath = "Adaxes://<GUID=$groupGuid>"
    $group = $Context.BindToObject($groupPath)

    # Write Group Output
    Write $group.Get("name") | Out-File -FilePath $filePath -Append
}

Answer 1

Hello,

Yes, it is possible. You will just need to place the value references used to specify values of variables into quotes. We updated the script for you, find it below.

#File Path 
$filePath = "New User Sheets\%physicalDeliveryOfficeName%\New User Info - %firstname% %lastname%.txt"

#Tie Properties to Variables
$DID = "%telephoneNumber%"
$Fax = "%facsimileTelephoneNumber%"
$Copitrak = "%pager%"
$Extension = "%ipPhone%"

# Format Fax, DID and Copitrak Fields
If ($DID -eq "" ) {$DID2= "N/A"} Else {$DID2 = $DID}
If ($Fax -eq "") {$Fax2= "N/A"} Else {$Fax2 = $Fax}
If ($Copitrak -eq "") {$Copitrak2= "N/A"} Else {$Copitrak2 = $Copitrak}
If ($Extension -eq "") {$Extension2= "N/A"} Else {$Extension2 = $Extension}

#Write Output
Write "User Information" | Out-File -FilePath $filePath
Write "Full Name: %name%" | Out-File -FilePath $filePath -Append
Write "Username: %username%" | Out-File -FilePath $filePath -Append
Write "Password: %unicodePwd%" | Out-File -FilePath $filePath -Append
Write "Email: %mail%" | Out-File -FilePath $filePath -Append
Write "Job Title: %title%" | Out-File -FilePath $filePath -Append
Write "" | Out-File -FilePath $filePath -Append
Write "Phone Information" | Out-File -FilePath $filePath -Append
Write "Extension: $Extension2" | Out-File -FilePath $filePath -Append
Write "Direct Dial Number: $DID2" | Out-File -FilePath $filePath -Append
Write "Fax Number: $Fax2" | Out-File -FilePath $filePath -Append
Write "Copitrak Code: $Copitrak2" | Out-File -FilePath $filePath -Append
Write "" | Out-File -FilePath $filePath -Append
Write "The user was added to the following groups:" | Out-File -FilePath $filePath -Append

# Get Group Memberships
$groupGuids = $Context.TargetObject.GetEx("adm-DirectMemberOfGuid")

foreach ($groupGuidBytes in $groupGuids)
{
    # Bind to the group
    $groupGuid = New-Object "System.Guid" (,$groupGuidBytes)
    $groupGuid = $groupGuid.ToString("B")
    $groupPath = "Adaxes://<GUID=$groupGuid>"
    $group = $Context.BindToObject($groupPath)

    # Write Group Output
    Write $group.Get("name") | Out-File -FilePath $filePath -Append
}