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
    Parents
    • 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

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

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

    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