Set-PWDocumentState / Messaging services

would regular email work instead of projectwise messaging?  PowerShell 5.1 has Send-MailMessage and the PSCX module has Send-SMTPMail. You could use that to send notifications from the script.

Just to follow up I have found a way with the help of someone to do all of this in Powershell. Basically have the powershell script flip the states and create the email!! Very cool stuff.

d

Feel free to share your script. It may help someone else.

Here you go. Our need is to send an email to a specific user on a schedule, a list of any email that is in a predefined folder. We have email getting dumped directly into ProjectWise automatically. The user then moves the email as needed once notified. We run this every 2 hours. And yes most of this came from a fine Bentley systems engineer! Still tweaking the formatting but this works like a charm!

d

Add-Type -AssemblyName System.Web

$Sourcefolder = "Folder\needed to process"

##Email Section
$HTMLBody = @()
$Header = @"
<style>
body { background-color:#FFFFFF;
font-family:Tahoma;
font-size:12pt; }
h3, h4 {text-align:center;}
td, th { border:1px solid black;
border-collapse:collapse; }
th { color:white;
background-color:black; }
table, tr, td, th { padding: 2px; margin: 0px }
table { width:95%;margin-left:5px; margin-bottom:20px;}
</style>
"@
$HTMLBody += $Header
$HTMLBody += '<h3>ProjectWise Document Report</h3>'

$HTMLBody += "<h4>Email currently in ProjectWise:</h4>"

$HTMLBody += Get-PWDocumentsBySearch -FolderPath $SourceFolder -GetVersionsToo -JustThisFolder -GetAttributes -Slow | Select FileUpdateDate, OldDescription, OldName | ConvertTo-HTML -Property @{Label="Email Date"; Expression={$_.FileUpdateDate}},' ',@{Label="Email Description"; Expression={$_.OldDescription}},@{Label="Email Message"; Expression={$_.OldName}} | Out-String

$HTMLBody = [System.Web.HttpUtility]::HtmlDecode($HTMLBody)

Send-MailMessage -From "noreply@xxxx.ca" -To "xxxxxxx@xxxxxx.ca" -Subject "Email Report" -Body "$HTMLBody" -SmtpServer "smtp.xxxxx.ca" -BodyAsHTML

Undo-PWLogin