Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum Documentation, Cookbook
    • Sign In

    • State Not Answered
    • Replies 4 replies
    • Subscribers 67 subscribers
    • Views 2292 views
    • Users 0 members are here
    • Cookbook documentation PWPowershell

    Documentation, Cookbook

    Robert Biggar
    Offline Robert Biggar over 6 years ago

    I have been staggering through the learning process of Powershell and the ProjectWise extentions...it's progressing but it needs more than the online "get-help".

    I'm assuming (from the amount of posts that "point to the get-help") that there is no real documentation per se.

    It occurs to me that what most of us admin types are looking for is what O'Reilly calls a "Cookbook".

    I don't know about "most people" but I have a thousand tasks and these days uninterrupted programming time is hard to find. Often times, Production comes up with

    problems and  they need a fast fix. in past days I kept a folder full of example code that I could pull from and make slight changes to accomplish a task. then I found the "cookbook" series by O'Reilly Press

    and there was a book you could look up a task...say "processing all the files in a folder" and get a "push" in the right direction. I think this language and especially the PW extension could use a thing like this.

    maybe just an area of example code, not even as sophisticated as a book. but a place where a PW admin can get a snippet and get going in the right direction.

    In a year...most of us will have our own libraries of snippets...but for now at least it is a good opportunity to get everyone who is involved in this "going the right direction".

    my two cents.

    at the moment, I am looking for a way to load attributes for particular files.

    we had files in a different document management system. we had to pull all those files out, put them into ProjectWise and now we have dumped the metadata for these files into excel.

    My original thought was to populate the data via SQL...and that works, but it seems like this may be a good task for PowerShell.

    Anyway,

    I am looking for a way to use Powershell and the PW extensions to load this metadata into the custom attributes table.

    any wisdom or examples "out there"?

    Thank you !!

    Bob

    • Sign in to reply
    • Cancel
    • Kevin van Haaren
      0 Offline Kevin van Haaren Fri, Jul 14 2017 11:06 AM

      Meant to post this the other day, Microsoft has tons of ebooks available for free at:

      https://blogs.msdn.microsoft.com/mssmallbiz/2017/07/11/largest-free-microsoft-ebook-giveaway-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepo/

      If you search for Powershell there are a bunch of books available. I haven't gone through any of them yet but in most of my usage i've been using stuff that was in both Powershell 3, 4 so books for either version should be good.

      I grabbed the Powershell Examples books, the Powershell WMI books and the quick reference books.

      More in depth stuff on the ProjectWise Powershell modules would be nice.

       

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Kevin van Haaren
      0 Offline Kevin van Haaren Fri, Jul 14 2017 11:10 AM

      As for your import document task, there is a Import-PWDocumentsBySpreadsheet command. You'd probably have to write a powershell to manipulate the spreadsheet you have to the format the module wants but might be easier (safer?) than populating sql tables directly.

       

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Robert Biggar
      0 Offline Robert Biggar Fri, Jul 14 2017 2:49 PM in reply to Kevin van Haaren

      Thanks Kevin:

      yeah, I have one book by "Sherif Talaat" and I have had good luck with the "scripting guy" videos for the general Windows Powershell info.

      There is lots of info about Powershell and administering Windows...if you have admin access :- )

      what I'm really looking for is the information on the Projectwise cmdlets. not just browsing the get-help, but more of the "how to" approach the problems and what tools are available and were designed with a specific purpose in mind. really, exactly the information you sent me in the other post...perfect! just a direction...where to start. I have run into a lot of people who have never heard of Powershell, let alone ProjectWise Extentions. My guess is that there is going to be a bunch of people trying to learn this in the near future.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Robert Biggar
      0 Offline Robert Biggar Fri, Jul 14 2017 2:49 PM in reply to Kevin van Haaren

      Like I said..."Perfect!" , Thanks Kevin!

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • 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