PWPS_DAB_ChangeLog.txt
2018-05-30 Version 1.5.9.0
General Note: Regular users can now log in via New-PWLogin and use the cmdlets if they are members of a group called "PowerShell Users". Use -NonAdminLogin switch with New-PWLogin. Changed cmdlets: Export-DataTableToSQLiteDB now supports -Append and -Overwrite switches. All SQLite DB cmdlets should now support 64-bit. 2018-05-20 Version 1.5.8.0 Changed cmdlets: Get-PWStorageAreaReport - Added SQLite output option. New-PWLogin - Adjusted behavior of DoNotCreateWorkingDirectory switch. Works a bit more logically now. 2018-05-17 Version 1.5.7.0 Added cmdlets: Get-PWMonthlyCheckoutsByProject - reports using audit trail document checkouts per user per project per month. Get-PWDMOutgoingTransmittals - reports all outgoing transmittals for the given projects. Save-PWDMOutgoingTransmittal - Save transmittal to disk. Get-PWDMIncomingSubmittals - reports all incoming submittals for the given projects. Save-PWDMIncomingSubmitals - Save submittal to disk. Set-PWDocumentUserListAccess - Apply access mask for a user list to a set of documents 2018-05-15 Version 1.5.6.0 General Note: User must be in Admin or Restricted Admin group. Our intent has always been that PowerShell manipulation of datasources required a user with elevated privileges. Changed cmdlets: Get-PWDSConfigEntry does not require a login. Get-PWCurrentDatasource does not require a login. 2018-05-11 Version 1.5.5.0 General Note: NOW COLLECTING CMDLET-LEVEL USAGE DATA LIKE PROJECTWISE EXPLORER DOES Added cmdlets: Remove-PWFolderSecurity - Export-DataTableToSQLiteDB Update-PWDocumentOwner Update-PWStatistics - Update the stored statistics Changed cmdlets: New-PWInputOutputPerformanceReport - now records datasource statistics Get-PWStatistics - Now returns all the datasource statistics Various help file fixes 2018-04-18 Version 1.5.4.0 Added cmdlets: Add-PDFQRCode - Stamp a file from disk with QR Code. Set-PWFolderOwner - reset folder owner Remove-PWFolderSecurity - remove folder security Changed cmdlets: Add-PWPDFQRcode - added parameters 2018-04-18 Version 1.5.3.0 Added cmdlets: Set-PWDocumentGroupAccess - sets group access for an array of documents. Changed cmdlets: Get-PWFolderSecurity, Update-PWFolderSecurity and Remove-PWFolderSecurity updated to include datasource default security. New-PWFolder will now use storage from existing parent and does not require storage to be passed. 2018-04-10 Version 1.5.2.0 Added cmdlets: Get-PWMembers - list members of a group or userlist. New-PWApplication Remove-PWApplication Get-PWManagedWorkspaceConfigBlocks - returns configuration settings blocks for all or a selected managed workspace type Set-PWManagedWorkspaceForFolders - adds configuration settings block associations for selected managed workspace type to input folder(s) Remove-PWManagedWorkspaceAssociationFromFolders - removes the specified configuration settings block of specified managed workspace type from input folder(s) Remove-PWManagedWorkspaceAssociationsFromSubFolders - removes ALL configuration settings block associations from all sub-folders of the input folder(s) Set-PWApplicationExtensions - set extensions for applications. Copy-PWDocumentSecurity - copy document security from a template to a set of input documents Changed cmdlets: New-PWFolder - added -Description parameter. Copy-PWFolder - added -IncludeDocumentAttributes switch. 2018-04-07 Version 1.5.1.0 General Notes: Added logic to attempt to prevent fatal errors when running in 64-bit as we know certain things won't work (like anything to do with CONNECTED projects). Added cmdlets: Copy-PWDocumentsBetweenDatasources - copy documents from one datasource to another. 2018-04-05 Version 1.5.0.0 General Notes: This module should now load in both 32-bit and 64-bit PowerShell. Some functionality is not yet supported in 64-bit and we're adding warnings as we discover what is not supported. General functionality seems to be there (thus change of minor version to 1.5). Changed cmdlets: New-PWLogin - added -LoadWRE switch to support loading Workflow Rules Engine. Made change to NOT load WRE by default. Added cmdlets: Set-PWSession - switch between active login sessions. Get-PWSessions - list the active sessions. Get-PWFoldersImmediateChildren - Gets the immediate child folders for the specified folder. Convert-PWRichProjectToFolder - Converts a rich project (WorkArea) and sub-rich projects to folders. 2018-03-26 Version 1.4.0.0 Changed cmdlets: New-PWLogin - added -BentleyIMS switch to support IMS logins Get-PWOutgoingTransmittalsReport - change output to data table array in addition to spreadsheet Merge-PWPDFs, Split-PWPDFs, Add-PWPDFQRCode - changed underlying PDF library (thus change of minor version to 1.4) 2018-03-16 Version 1.3.27.0 Added cmdlets: Get-PWDocumentCaptionFromAI - use Microsoft's Computer Vision AI Service to label photos 2018-03-06 Version 1.3.26.0 Changed cmdlets: Get-PWRichProjectReport and New-PWRichProjectsFromSpreadsheet - now support exporting and importing CONNECTed Project links. Convert-PWAccessMaskToString - added additional mask values. Remove-PWEmptyFolders - added a -RemoveRichProjects switch to control rich project removal. Will now leave empty rich projects by default. 2018-03-06 Version 1.3.25.0 Changed cmdlets: New-PWPowerShellScript - Added three more common script types (Archive Full, Archive Export and Archive Import) in addition to the Default. Export-PWAccessControlToExcel - fixed bug with resolving projectstructure.xlsx Added cmdlets: New-PWView, Get-PWRichProjectProperties, Get-PWStandardViewColumns, Get-PWEmptyLeafFolders, Remove-PWEmptyFolders 2018-03-01 Version 1.3.24.0 Added functions: ConvertTo-DataTable - converts arrary of DataRows (or any object type) to a DataTable. Changed cmdlets: Updated all the Audit Trail cmdlets to clean up the output, include options to support pipeline input of documents and folders and support XLSX and SQLite output. 2018-02-22 Version 1.3.23.0 Added cmdlets: Set-PWAttributeGeneralSettings, Set-PWAttributeDefaultValueSettings, Set-PWAttributeUpdateValueSettings, Get-PWAttributeValueListFixedList, Set-PWAttributeValueListSettings, Set-PWAttributeEditingSettings, Set-PWAttributeExtraValuesSettings, New-PWInterface, Get-PWInterfaceGUIDefinition, Add-PWAttributeToInterface, Set-PWInterfaceGUILabel, Set-PWInterfaceGUILabelFont, Set-PWInterfaceGUIPrompt, Show-PWInterfaceGUIDefinition, Get-PWFonts Changed cmdlets: Update-PWDocumentFile (added -RemoveFile switch), Get-PWEnvironments, New-PWEnvironment, Add-PWEnvironmentColumn, Copy-PWEnvironmentColumn, Get-PWEnvironmentColumns, Export-PWAccessControlToExcel (fixed bug with SS3/SS4 support) 2018-02-12 Version 1.3.22.0 Changed functions: Save-ClearTextToEncryptedFile - Changed to enhance secure handling of the clear-text password. 2018-02-09 Version 1.3.21.0 Added cmdlets: Get-PWConnectorToken - Generates token for use with WSG and PW Connector web service New-PWDocumentViaWSG – Uses PW Connector which is a web service that wraps WSG to create a new document. No support for attributes yet. Added functions: Save-ClearTextToEncryptedFile, Save-SecureStringToEncryptedFile, Get-SecureStringFromEncryptedFile, Get-ClearTextFromEncryptedFile - utility functions for managing PowerShell secure password storage. 2018-02-06 Version 1.3.20.0 Changed cmdlets: New-PWInputOutputPerformanceReport - BIG BUG FIX: the -FileSizeK parameter was getting ignored (was defaulting to 1K), but is working now. Added -NoCleanup switch if you want to look at the files yourself. Get-PWDocumentAuditTrailRecords – Added action description. Get-PWFolderAuditTrailRecords – Added action description. 2018-02-06 Version 1.3.19.0 Added cmdlets: Copy-PWConnectedProjectSettings - copies settings from on connected project to another emulating what you can do on the DM copy settings page Show-PWFolderBrowserDialog – Show a dialog to select a folder. Selected folder can be stored in a variable or used on the pipeline. Show-PWDocumentSelectiongDialog – Show a dialog to select one or more documents. Selected documents can be stored in variable or used on the pipeline. Show-PWDatasources – Shows a list of the avilable datasources. 2018-02-01 Version 1.3.18.0 Added cmdlets: Get-PWInterfaceGUIDefinition – returns the GUI definition(s) for the specified environment/interface combination. Set-PWInterfaceGUILabel – Adds a label to the specified environment/interface/attribute combination. Set-PWInterfaceGUILabelFont – Sets the label font for the specified environment/interface/attribute combination. Set-PWInterfaceGUIPrompt – Adds a prompt to the specified environment/interface/attribute combination. Get-PWFonts – returns a list of available fonts on the current system. Changed cmdlets: New-PWRichProjectsFromSpreadsheet (added -ProjectTypes parameter to allow for processing of subset of worksheets) 2018-01-29 Version 1.3.17.0 Changed cmdlets: Add-PWEnvironmentColumn (fixed problem where Administrator didn't work right after adding column) 2018-01-26 Version 1.3.16.0 Changed cmdlets: New-PWDocumentComment (more bug fixes and help update), New-PWInputOutputPerformanceReport (bug fixes), Add-PWSavedSearch (added support in -SearchName for naming searches with full path (e.g. Search Folder\Sub-Folder\SearchName), changed manifest 2018-01-25 Version 1.3.15.0 (manifest file changes) 2018-01-25 Version 1.3.14.0 Added cmdlets: New-PWWorkflowWithStates, New-PWPowerShellScript Changed cmdlets: Remove-PWFolder (added help and fixed support for -FolderPath parameter), New-PWDocumentComment (bug fixes and added support for documents objects from pipeline), New-PWInputOutputPerformanceReport (reports results to a web service now, use -OptOutOfCentralReporting if you don't want to participate. Idea is to collect performance data centrally and allow users to report on their results), Set-PWFolderView (added -PreviewPaneVies parameter), Get-PWFolders (added View and PreviewPaneView properties) 2018-01-22 Version 1.3.13.0 Changed cmdlets: Get-PWMonthlyLogins and Get-PWMonthlyLoginsDataTable (fixed another bug with Oracle and backup audit trail table), Get-PWOutgoingTransmittalsReport (fixed assembly loading), Get-PWReferenceFiles (now uses -ReferenceLevel parameter) 2018-01-10 Version 1.3.12.0 Changed cmdlets: Get-PWMonthlyLogins and Get-PWMonthlyLoginsDataTable (fixed bug with Oracle and backup audit trail table), Update-PWSQL (changed -SecretPassword to SecureString), Export-PWAccessControlToExcel (fixed bug when template not in standard location) 2018-01-05 Version 1.3.11.0 Added cmdlets: Get-PWStorageAreaReport, Get-PWFolderAuditTrailRecords Changed cmdlets: Get-PWMonthlyLogins and Get-PWMonthlyLoginsDataTable (fixed bug with SQL Server and backup audit trail table), Show-PWPS_DABChangeLog (added -ShowAll switch, now only shows top 20 lines by default) 2017-12-20 Version 1.3.10.0 Added cmdlets: Set-PWDocumentApplication Changed cmdlets: Update-PWEnvironmentColumnWidth (changed to use VARCHAR2 for Oracle and NVARCHAR for SQL instead of NCHAR), Get-PWMonthlyLogins (add -WholeYear switch, always includes backup audit trail table now) Export-PWDocuments (made some tweaks), Import-PWDocumentsBySpreadsheet (now supports the case where file names were changed in the version stack. Still requires that document names be the same through the stack.) 2017-12-18 Version 1.3.9.0 Changed cmdlets: Request-PWRemoteScriptExecution (Fixed service installer link in help. Should be https://pwstoragesouthcentralus.blob.core.windows.net/public/PWScriptMonitorSvcSetup.zip) 2017-12-18 Version 1.3.8.0 Added cmdlets: Request-PWRemoteScriptExecution Changed cmdlets: New-PWDocument (Added -Application switch for creating new documents) 2017-12-12 Version 1.3.7.0 Added cmdlets: Save-PWEnvironmentViewScript 2017-12-08 Version 1.3.6.0 Added cmdlets: Get-ReferencedByReportForDocuments, Get-PWDocumentsBySearchWithReturnColumns, Get-PWFolderDocumentSize Changed cmdlets: Get-PWDocumentsBySearch (add -ReturnDataTable switch), New-PWInputOutputPerformanceReport (added support for testing a subset of storages) 2017-11-21 Version 1.3.4.0 Added cmdlets: Show-PWPS_DABChangeLog, Get-PWUserListByMember Changed cmdlets: Get-PWDSConfigEntry (bug fix), Copy-PWFolder (added -IncludeWorkspaceProfile switch) 2017-11-21 Version 1.3.3.0 Changed cmdlets: Import-PWDocumentsFromArchive and Export-PWDocumentsToArchive -- added support for empty folders and folder descriptions. 2017-11-21 Version 1.3.2.0 Changed cmdlets: Fixed bug where paths to searches were not respected. 2017-11-21 Version 1.3.1.0 General Change: Updated to be delivered via PowerShell Gallery. Add cmdlets: Get-PWSavedSearches Changed cmdlets: Generally updated the cmdlets that take Saved Search names as parameters to support using a path and the -Personal switch for personal searches. 2017-11-09 Version 1.2.26.0 Add cmdlets: New-PWDocumentComment Changed cmdlets: Save-PWDocumentReport (Added -AppendToXLSX switch), New-PWInputOutputPerformanceReport (changed dates to be formatted consistently across worksheets). 2017-10-26 Version 1.2.25.0 Changed cmdlets: Updated Excel file support. 2017-10-24 Version 1.2.24.0 Changed cmdlets: Bug fixes with regard to the folder object. Update-PWFolderSecurity should work now. 2017-10-18 Version 1.2.23.0 Changed cmdlets: Added -DoNotCreateWorkingDirectory switch for New-PWLogin. (was creating issues for users managing a lot of different datasources from the same machine). 2017-10-16 Version 1.2.22.0 Add cmdlets: Get-PWReferenceCountReportForDocuments (simpler report than Get-PWReferenceReportForDocuments where just the master document details and the count of its unique references are returned). Changed cmdlets: Added NestedReferenceCount member to the document object. All of the cmdlets that return document objects and support the -GetAttributes switch will now return the count of references if you include the -GetAttributes switch. (Get-PWDocumentsBySearch). 2017-10-13 Version 1.2.21.0 Add cmdlets: Add-PWSavedSearch. Changed cmdlets: Get-PWReferenceFiles, Get-PWReferenceReportForDocuments, Get-PWReferenceReportForFolder (fixed all of these to get all nested reference, support SQLite and DataTable output). Import-PWDocumentsFromArchive (fixed a problem with imports to Oracle datasources) 2017-10-11 Version 1.2.20.0 Add cmdlets: Submit-PWDocumentToPrint, Merge-PWPDFs, Split-PWPDFs, and Add-PWPDFQRCode. Changed cmdlets: Export-PWDocuments (added pipeline support for documents. This is really a copy-out with metadata). 2017-10-04 Version 1.2.19.0 Changed cmdlets: Get-PWReferenceReportForDocuments and Get-PWReferenceFiles (fixed to resolve nested references correctly). Set-PWRichProjectResource (added support for setting rendition profiles) 2017-10-04 Version 1.2.18.0 Added cmdlets: Export-PWTagMappings, Import-PWTagMappings, Get-PWTagSets, Remove-PWTagSet Changed cmdlets: Add-PWTagEnvironmentAttribute (updated type handling and format string generation) 2017-10-02 Version 1.2.17.0 Added cmdlets: Add-PWTagSet, Add-PWTags, Add-PWTagDocumentProperty, Add-PWTagFolderProperty, Add-PWTagProjectProperty, Add-PWTagEnvironmentAttribute 2017-09-27 Version 1.2.16.0 Added cmdlets: Remove-PWSavedSearch Changed cmdlets: New-PWInputOutputPerformanceReport (added Verbose messaging, added a column to the storage performance report table) Get-PWDocumentAuditTrailRecords (added IncludeSecondaryTable switch) 2017-09-17 Version 1.2.15.0 New example scripts: ScanRefs.ps1, CreateDatasource2.ps1 (updated), CreateODBC64.ps1, ImportData.ps1 Added cmdlets: Set-PWUserWorkingDirectory, Get-PWUserWorkingDirectory, Add-PWUserToGroup, Get-PWUsersInGroup, Get-PWGroupName, Get-PWUserListNames, Get-PWUsersInUserList, Add-PWUserToUserList, Remove-PWUserFromUserList, Remove-PWUserFromGroup, New-PWUserSimple, Set-PWUserAdminRights, Import-PWAAMFile, Export-PWAAMFile 2017-09-11 Version 1.2.14.0 Changed cmdlets: CheckOut-PWDocuments (changed copy out behavior to always include references unless -NoReferences flag is set) Update-PWPropagateProjectPropertiesToSubProjects (allows passing regular folder. Rich project not required. Added verbose messages.) New-PWInputOutputPerformanceReport (added table with individual storage area i/o details) 2017-09-06 Version 1.2.13.0 Changed cmdlets: Get-PWOutgoingTransmittalsReport (fixed another possible bug) 2017-09-05 Version 1.2.12.0 Added cmdlets: Add-PWPicklist, Get-PWPickList, Export-PWPickList, Import-PWPickList, Get-PWPickListItems, Remove-PWPickListItems, Remove-PWPickList Changed cmdlets: Get-PWOutgoingTransmittalsReport (fixed possible bug) Access control cmdlets reworked to accept pipeline input of an array of folders as returned from Get-PWFolders, etc. 2017-08-23 Version 1.2.11.0 Changed cmdlets: New-PWRichProject, New-PWRichProjectsFromSpreadsheet, New-PWRichProjectsFromDataTable (made more changes to workflow inheritance) 2017-08-23 Version 1.2.10.0 Added cmdlets: Get-PWError (Takes Error Number gives, description) Get-PWProjectTemplates (List the Project Templates) Changed cmdlets: New-PWRichProject, New-PWRichProjectsFromSpreadsheet, New-PWRichProjectsFromDataTable (updated all 3 to replicate workflow security properly and create new, project-specific user lists) 2017-08-22 Version 1.2.9.0 Added cmdlets: Add-PWDocumentsWithCode (Create abstract documents with document code applied) Changed cmdlets: Update-PWDocumentFile (Added -NewFileName and -UseDocumentName parameters to rename file when replacing it) 2017-08-21 Version 1.2.8.0 Added cmdlets: Add-PWFileTypeAssociation (For Indexing, Property extraction and thumbnails) Changed cmdlets: Get-PWUserByLastLogin (updated to use audit trail truncation table in addition to active audit trail table) New-PWRichProject (updated to replicate workflow security) 2017-08-18 Version 1.2.7.0 Changed cmdlets: Save-PWDocumentReport (fixed date handling for AuditTrailRecordsStart and AuditTrailRecordsEnd parameters) 2017-08-15 Version 1.2.6.0 Added cmdlets: Set-PWDocumentFileUpdateTimeToNow, Add-PWMemberToGroup, Add-PWMemberToUserList Changed cmdlets: Add-PWConnectedProject (updated to support Connected Project creation without connecting to PW Project), New-PWDMTransmittal (updated help) 2017-08-09 Version 1.2.5.0 Changed cmdlets: Update-PWEnvironmentCopyData, Update-PWEnironmentColumnName, Update-PWEnvronmentColumnWidth - Changed column name validation logic because this was found to be unreliable Get-PWEnvironments, Get-PWEnvironmentColumns, Add-PWEnvironmentColumn - Changed column name display logic to support the above changes 2017-08-08 Version 1.2.4.0 Changed cmdlets: Save-PWDocumentsReport - Added AuditTrailRecordsStart and AuditTrailRecordsEnd parameters - Added support for SQLite output. Will output SQLite database for any extension that's not .xlsx Get-PWDocumentsReportDataTable - Added AuditTrailRecordsStart and AuditTrailRecordsEnd parameters 2017-07-28 Version 1.2.3.0 Changed cmdlets: Export-PWAccessControlToExcel - Added better help information. - Added better error / verbose messaging. - Added ValidateSet for ExportFileExtension to limit input to xlsx or csv. Import-PWAccessControlFromExcel - Added better help information. - Added better error / verbose messaging. Set-PWUserListOwners - Added better error / verbose messaging. - Added ValidateSet for OwnerType to limit input to u, ul, user, and userlist. Set-PWGroupOwners - Added better error / verbose messaging. - Added ValidateSet for OwnerType to limit input to u, g, ul. 2017-07-26 Version 1.2.2.0 Added cmdlets: Set-PWFolderRenditionProfile, Get-PWFolderRenditionProfile. Changed cmdlets: Remove-PWDocuments (added -UserSoftDelete parameter). 2017-07-24 Version 1.2.1.0 Changed cmdlets: Update-PWFolderSecurity (changed some document security handling), Copy-PWDocumentsBySearch & Remove-PWDocumentsBySearch (added help), CheckIn-PWDocumentsOrFree (added 0 file size check), Get-PWFolderTreeDocumentSize (fixed a bug) 2017-07-19 Version 1.2.0.0 Added cmdlets: Add-PWTestDocuments, Add-PWTestDocumentsInFolders, Export-PWDocumentsToArchive, Export-PWDocumentsToDataSet, Import-PWDocumentsFromArchive, New-PWInputOutputPerformanceReport, Select-PWSQLDataTableToSQLite Changed cmdlets: New-PWEnvironmentsReport (added SQLite output support), CheckOut-PWDocuments (-CopyOut now defaults to working directory, added -NoReferences and -RemoveCopies switch), Update-PWDocumentProperies and Update-PWDocumentAttributes (added -ReturnBoolean switch to test for failed updates), Update-PWFolderSecurity (internal fixes) |