Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum Version 1.7.13.0 of PWPS_DAB just posted to the PowerShell Gallery
    • Sign In

    • Replies 11 replies
    • Subscribers 66 subscribers
    • Views 2355 views
    • Users 0 members are here

    Version 1.7.13.0 of PWPS_DAB just posted to the PowerShell Gallery

    Dave Brumbaugh
    Offline Dave Brumbaugh over 4 years ago
    We just posted version 1.7.13.0 of the #PWPS_DAB #PowerShell module for #ProjectWise to the PowerShell Gallery. To install: Run an Admin session of 32-bit PowerShell v5 and use the cmdlet Update-Module PWPS_DAB (if you already have the module) or Install-Module PWPS_DAB (for a new install). One can run Uninstall-Module PWPS_DAB first just to clean up old installs. VERY IMPORTANT NOTE: This PowerShell Module is not covered under your SELECT Agreement and is not supported via your contractual support channels. Support is only available via the BE Communities site ( communities.bentley.com/.../projectwise-powershell-extensions-forum ).
    • Sign in to reply
    • Cancel
    • Kevin van Haaren
      Offline Kevin van Haaren Mon, Nov 26 2018 6:24 PM

      that's a whole lotta new commands! Do the new SQL commands only work with SQLPS or do they work with the new SqlServer module as well?

      2018-11-26 Version 1.7.13.0
      
      Added cmdlets
      	Convert-ObjectArrayToDataTable
      		Utility cmdlet to convert array of objects to a datatable.  Should perform better and be more reliable than ConvertTo-DataTable (which remains). Now using JSON format to store arrays and collections in the table.
      
      Added functions
      	Write-Log
      		Logging function
      	Get-PowerShellLogsFromPreviousDats
      		collects PowerShell logs
      	Get-WindowsFolderPath
      		open a dialog to select a folder
      	Get-WindowsFilePath
      		open a dialog to select a file.
      	BulkCopy-SQLTable
      		bulk copy a DataTable from PowerShell to SQL Server (requires SQLPS module)
      	Get-SQLDatabase
      		Get databases in a SQL instance. (requires SQLPS module)
      	Get-SQLDataType
      		Get corresponding SQL data type. (requires SQLPS module)
      	Get-SQLTable
      		Gets list of tables from SQL Instance. (requires SQLPS module)
      	New-SQLConnection
      		Connect to SQL Server instance. (requires SQLPS module)
      	New-SQLTable
      		Make a table in SQL to match a given table in memory. (requires SQLPS module)
      	Truncate-SQLTable
      		empties existing table. (requires SQLPS module)
      	Get-PWAuditTrailRecordsFromPreviousDays
      		extracts audit trail records.
      	Copy-PWDocumentToSharePoint
      		copy a document directly from ProjectWise to SharePoint. (requires one of the SharePointPnPPowerShell* modules)
      	Get-SharePointListItem
      		Gets a list item from SharePoint. (requires one of the SharePointPnPPowerShell* modules)
      	New-SharePointConnection
      		connect to SharePoint instance. (requires one of the SharePointPnPPowerShell* modules)
      
      Changed cmdlets
      	New-PWDocumentAbstract
      		resolved issue with -Count parameter.
      	Get-PWMonthlyLogins
      		resolved issue with UserType.
      	Get-PWDocumentsBySearch
      		added -FolderID paramter.
      	Move-PWFolder
      		changed to accept InputFolder object.
      

       

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel
    • Zachary Kerr
      Offline Zachary Kerr Mon, Nov 26 2018 8:39 PM in reply to Kevin van Haaren

      Hey Kevin,

      I think that might be a typo in the change log. The SQL functions leverage the assemblies delivered with the SqlServer module.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel
    • Kevin van Haaren
      Offline Kevin van Haaren Mon, Nov 26 2018 9:51 PM in reply to Zachary Kerr

      Does that mean the new functions are 64-bit only?

       

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel
    • Zachary Kerr
      Offline Zachary Kerr Mon, Nov 26 2018 10:24 PM in reply to Kevin van Haaren

      They run just fine for me using x86 PowerShell. Let me know if you have any problems.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel
    • Kevin van Haaren
      Offline Kevin van Haaren Tue, Nov 27 2018 12:45 PM in reply to Kevin van Haaren

      Change log lists an added function "Write-Log" no help on that and it doesn't show as a command in get-command -Module PWPS_DAB.

       

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel
    >

    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies