Good morning, Good afternoon or good evening. My name is Bill Degregorio, an welcome to the project ways administrators fig. So our first of the year so it's still appropriate. I think to say happy new year. As you can see by the invites that you've received and you know you kind of waiting in a little lobby. Before we got started we have switched platforms. For the past few years we were using Adobe Connect. We did switch over to on 24th. This is our first well this is my first. Uh. Session of any kind using on 24 so I will apologize in advance for any mistakes hiccups that we have. I'll do my best we're all going to kind of learn together. Hopefully, what you're all seeing is a view of the PowerPoint that says, Projectwise administrators. Sig January 2020. Uh. I'm going to advance the slide and just give a little overview about. On 24. So there might be a couple of seconds delay, so I'll just talk a little slower for the moment. But you should have what you should see some options down on the bottom of your screen. That will give you the ability to. Look at the Q&A to C attendee list. And what not so feel free to do that. Hopefully you're all looking at an audience view or alive, you that has this presentation. If you've got any problems. There's a QA window. You should be able to put any questions that you have in that QA window. There should be an option down at the bottom for Q&A. So I would recommend that everybody just kind of. Set that up and put it there. A couple tips and again, I'm still learning some of these so it's being streamed through my computer. So there's no dial until actually dialing in through teams. Uh but am presenting through on 24. Uh. I'm being told this is very bandwidth intensive So what I've done is I've taken my PowerPoint I've uploaded it. I don't even have a hard wired Internet connection. I'm completely Wi-Fi. At my location and everything's been running great, so far and all the testing that I've done. So so far, so good. Again, if you've got any concerns. If anybody is having an issue hearing me or seeing the slides. Please put a question in the chat window. So I can see that and right now, I do not see any questions. We also have pets again with us Patsy is facilitating me. So Patty I'm not sure if you're seeing anything. OK, I have a question are they on mute, yes, you're on mute. Unfortunately, there is no way for you guys to speak. And look at the list is a couple of people I don't want to hear it now, I'm just kidding. OK, so I think we're going OK. I'm seeing some questions coming in I'm not seeing anything. Kyle's asking is there a location where we could see all the sigs available you talking bout passex. Or. Kyle. Sorry. If so, they're out on the learn server. Now I don't know Patsy. Maybe you can help me on this one. Where will the recordings be posted moving forward with on 24 maybe you want to answer that one in the chat window. Perhaps. And can they see other attendees if you will a path you will have the option to click the attendees button down at the bottom and see other attendees? Like I can. Betty. Hi bill, sorry for the delay there. I yes, I you see that a couple of people saying that they're having some audio issues. Your audio is coming in loud and clear so it's doing great. It is possible that some people may be having some bandwidth issues. So we would recommend that she shut down any unnecessary. Applications so that you're not taxing your system that should that should help if not sometimes it will help to exit. And re enter the system also would like everyone to know that today's session is being recorded, and will be available approximately 2 hours after this session. So if you are running into any issues. Please know that she will have an opportunity to see the video in its? Entire T later today. OK. Uh. Just getting back to Kyle very quickly OK, so for upcoming. Let's hold that I'm going to talk a little bit about that towards the end of the presentation. So let's put that on what about the questions Patsy can they can all the attendees see all the questions that people are asking through the QA view? Actually, with the new interface. No everyone does not have the ability to see the questions that others are entering. Now that is a functionality that we may try to implement are moving forward, but right now they can. Only see the questions that they enter an any responses that we replied to them individually. You can if someone has a question. You can restate it verbally and then respond to it, so does that help. Yep, that helps great that might be something we want to add so just you know moving forward, Let's. Put that recommendation forward if we can so I don't know if I was the user. I'd want to see what other people are asking. OK. So a little bit, but we're going to cover today. So we did a little bit of a non 24 overview. Probably interject here and there, some points, about this. Uh primary. Feature for today is Zach Kerr. It's a project system architect. He is out of our Melbourne, Australia office currently. On site in Japan, so real. Thank you to Zack. It's midnight for him right now, so appreciate you joining. He's going to do a presentation. We're targeting this at about 30 to 35 minutes tops on some automation. That Zach is done for projectwise in SharePoint. When Vax finished I'm going to give an update on the accelerate conferences. And then maybe we can do a overview of some of the questions that may or may not be coming up in the chat window. So Zach I will pass the baton to you. Alrighty, thank you bill I am going to go ahead and. Share my screen. Which hopefully everyone will get in a moment? Well, I'm coming on Staten hopefully. Sorry that just wanna make sure pedal. Yeah, I don't see anything yet. Now I may have a delay. Now I got it. Can somebody just put something in the chat window acknowledging that they can see it? Thank you to whomever put that in the chat window much appreciate it. Alright well in that case, I think I think I will just kick off if I good unless there's a. Flurry of questions coming through bill about not being able to see the screen, then I am going to proceed. Yeah, everything looks OK, Martinez is come back, said yes, he can see it so. Alright let's go thanks Mightiness Alright so. Uh as bill said what I am going to go through today is how to copy over some documents. And the metadata from projectwise into SharePoint. I'm sorry I'm going to be using this. They'll be 2 modules that I'm using in PowerShell. I'll be using PowerShell to do it. If I didn't already say that so the first module that I'm going to be using is. PWPSDAB, which I think everyone is probably familiar with already. And the second module that I'm going to be using is this SharePoint. PNP PowerShell online. Now there actually some different versions of this. Available so you are going to want to check. What version of share point you want to connect to as this URL which is in the file which I'm told we can. Upload is part of the resources for when this is when this presentation is available for on-demand so you'll be able to access that link there. But if you are using SharePoint 2013. Sixteen 19, there are specific versions for that. Or I'm using a SharePoint online as part of Office 365, so the version of the module. I'm using is. Obviously this online version at the Top here. Now you don't have to worry about the command. Let's that I'm going to be using being different between each one of these modules if you're using a different version. From my understanding of what actually differs between these it's built using the what's called the share point client side. Object model and that is. On the back end and that's different between each one of these but the command. Let's that they publish into the module should be. Actually, the same now I've tried in the past to use a 2016 module with an online version of. Share point and also vice versa. They have worked some things have worked some things have failed. Some things have halfed worked so if you do. Have the you know if you're able to try and make sure that you use the correct version of this module for whichever version of? Of share point you're going to be using that. So they are the 2 main resources that I'm going to be using the other main resources of course. Project Wise I have. I'm just connecting to one of our decide data sources and there are some documents that I have set up here. Previously, that pretty standard, they have you know just three attributes and you know some names and files attached? And then also. The SharePoint site. And this is just a demonstration SharePoint site that I set up for for these kinds of things. I'm so there's not really much going on here we can. Come and check out the site contents. And you will see that there's really not much there are a couple of lists. And a couple of document libraries, most of this is just generic SharePoint deployment stuff. I think only this generic library in generic list and this project wise work area, or the ones that have been added. But what we're going to go through and do today is we're going to add a generic list and also a document library. And if you don't know the difference between those the generic list is kind of just rows of metadata. For information there are no documents. Tide to that whereas the document library you still have those same rows of metadata, but you also have. Documents Tide to that as well, and my apologies if there are any share point with his gurus admins. In the room and I have messed up the difference between those 2. I am not a SharePoint expert. By any means. That being said. Let's uh. Let's kick this off. I'm going to import these 2 modules first you should see a bunch of command. Let's come through. For for the SharePoint module there are quite a few in there. And then the next thing I'm going to do is set some variables, so I have my credentials here. I'm going to go ahead and make a credentials object. I'm actually just going to make the one credential object because both my project wise login an my SharePoint login. A tide to my Bentley account. So I'm only going to use the one credential for this obviously if you have separate ways of authenticating against. Share point and your project wide starter source. Then you might need to go back and create create 2 sets of credentials here for this. So the next is my SharePoint URL which I've just taken you to before this is exactly what I typed. In Uh, In the URL bar at the Top of the browser to take me there. I'm I'm setting a working directory and this is not so much for the metadata, but when we do the files. I need a working directory to export documents from Projectwise or to copy out documents and Projectwise, which I then. Upload into SharePoint. I'm there are probably ways that you could do this without having a working directory. I think if you were going to. Stream it in. Using some other kind of method. Maybe if you are getting the file using WSG or something like that. You might be able to skip that but I think we're going to stick to using PWPSD. Be today, it 'cause I think it's the most the most well known of these PowerShell automation tools. Um. Next we have our list name and now library name so they said. We're going to create one list, which is just to have house metadata. Basically, I'm going to just have the list of documents and it's. Their metadata document properties and attributes show up. And the next one is going to be the library what we will populate exactly the same metadata. We're also going to upload the files there as well so that they are visible in SharePoint. Remember laughing that I have is. My data source. Which if you've used PWPSDAB before you will certainly be familiar with? So I'm going to go ahead and define all those that's great. And will minimize these 2 and now the first step in this project is going to in this process is going to be connecting to both of these so. I'm going to take this off and then we can discuss it while it's connecting so the command let. I'm using for for share point is this connect PNP online. I have to give it my SharePoint URL an I have to give it my credentials object that I. Just created before and I'm also specifying this return connection switch. Which means that it's actually returning my connection object here? So you can see if I put this, if I put this in the console window down below. It's got some details about that. That connection object here for some of the command. Let's in this SharePoint. PNP module you can actually specify the. Connection that you're using which is why I have returned, it here, so that I can then specify it. When I make those calls in those commandlets later on. And we can see if we check this text here. That I have successfully connected to share point and that I have also successfully logged into projectwise my apologies about this. Green on blue coloring here that seems to have happened today and I'm not sure why. I know it's a little bit difficult to read all right, so we have successfully connected to both systems. So. Now, what I'm going to go through and do is return. Some documents from projectwise with their metadata. So I will again run this while we talk about it so. The documents that I'll be returning just the documents that were in this folder here in Zach door code testing. Which is what I showed you previously? Dot code testing so I'm returning. These 4 documents. I am also getting their attributes and every bit of metadata that I can get with those. And we can see that we've found for documents down the bottom here, which is perfect. That's what we were expecting. Then, what I'm doing for this is I am getting out the properties. Unique ways to the properties that's returned with that document object. And I am also getting out a list of. The attributes. That are in that environment. And this is because if you notice before when we were in SharePoint. I don't actually have any destination. To these documents to go into at the moment, so I'm going to go through the process of creating both that generic list. And the document library. And in order to do that. I need to create the columns in those you know the metadata fields that I want to populate so. I'm going to use a combination of the document property. Let's say descripcion and the type. What is description gone so if I have description here than the type is string so I'm going to use a combination of those, 2 pieces of information to define. Those columns or I believe that called fields in SharePoint. So we have our documents back returned, which is great. And now that we've done that I'm going to go through and create our SharePoint lists and libraries. So both of these are done using this new PNP list. Command let here so if each of these I've given. The title, which I've given a list name in the library name to each one an I'm using a template for each of them now these are generic. Share point templates. I think they just come as part of the again part of the SharePoint deployment. So the Top one which is basically our metadata rose is the generic list. And our bottom one which is out is our list with also with documents attached is out document library. And that actually creates a document folder on the back end. I am using the on just going to run this here. I'm using this on quick launch switch, which means that. It's going to show up. On the left hand side here in the quick launch. I don't have to go into the site contents to look at it. And then I'm also specifying my connection object that I returned before so both of these is run down here and. It doesn't look like we've got any errors for that, so if I come back an refresh this page. I should be able to see fantastic so we have our. Share point demo list. And now share point in my library. And it would give this a second to load up. We should see that both of these are totally empty. I don't have any. Any daughter in them or any columns fields beyond our what's created initially so yeah, we have title. For our list, and I think that name in library, but this is all we have said perfect. So we successfully created our list. Now. The next thing that I'm going to go and do here is this little type conversion and this is because. What we call a quid with a lowercase G in projectwise is equipped with capital G in SharePoint a string gets mapped. Text into gets mapped integer and there are a whole bunch of these mappings. Which actually if you want to see what's available in SharePoint? You can check this link out here in case you have other data types that you want to. Import these are all D the options that you have. And this is going to bring up my first kind of gotcha point with using the SharePoint modules. They are case sensitive, which if you are not used to using? Something that is case sensitive you know like Linux or maybe something in C sharp or something like that, if you're only using? PowerShell then you know, often you can get away with things being case, insensitive that is not the case with this SharePoint module. An I have definitely spent way too long trying to figure out why something is not working before I figured out that it was actually case sensitive so. Keep an eye on that. If you do have some problems returning things or getting things into that SharePoint site to try and uh. Have a look at your your parameters that you're specifying and make sure that they are matching perfectly including. Capitalization of lettuce. All right, so we've done our mapping, so now, what I'm going to do is the property and the attributes list that I just returned before I'm basically going to loop through. Each one of these and I am going to add that field to SharePoint so for the properties. I'm not going to Add all the document properties. I just want. Name description file name. Quid. Update date and the document you RN. So that's what I'm coming through in doing here, I'm going to. Use the add PNP Field command, let and I'm supplying the list name and. The display name of the property, so this is what the column is going to say, and then the internal name. Which in share point you can have an attribute that has a different internal name to display name which for me gets very confusing. So I'm going to keep those exactly the same for simplicity sake. And then I'm going to use my type conversion table and the information that I mentioned before. With the type information returned in these properties to create the to specify the type of these fields. I'm going to add it to the default view, which means it's going to be available in uh. It's going to be visible straight away. I don't need to expand document like or list properties or anything like that to see these columns, there going to be visible straight away. And then I'm also again specifying their connection so I'm going to run through. Each of these. And we should see. Two of each one because we're doing exactly the same list of metadata for both the generic list and the library. So we can see these being created here, which is great. This is exactly what we would expect to see. And we are almost through the attributes and if we come back into. Our SharePoint site now and if I refresh this page. I can see that I now have a whole bunch more information available. To import here for each item in this list. Which is exactly what we wanted? An exactly the things that we said that we were going to map from Projectwise. We should see the same thing in. The share point library as well. Exactly the same list great. So we have successfully now created that list and library. An added the fields to it of the correct type now that we have done that. We are going to go through and. Copy over some documents so I'm going to. Run this one here while we talk about it. So what I'm doing here for each of My 4 documents that I returned before. I am coming through an I'm just making a hashtable Here of metadata. That I want to copy over so this one is for the generic list. And I'm using my name description file name etc. From the document properties that I'm getting from Projectwise, the title is actually like a default property on the. Share point generic list so I'm just populating that with the document name. So that's where I'm defining my properties. And then for my attributes here my environment attributes I'm looping through each one of the attributes that is returned with those documents. And I am adding that attribute to this list of metadata as well. So I can actually return here, the last. Set of metadata for the last document so you can see what it looks like. So I can see that I have my properties basically all here. And then I have my attributes. Down here, but I'm supplying these are part of the same list 'cause. It's not broken up that same way in SharePoint. And then I am using this command. Let's here, which is add PNP. List item, which makes sense. We're adding an item to a list. So we're giving it the list name. Then this values parameter. We are specifying our metadata hashtable, so it's going to go ahead an update. Every single one of these that it can find in there. And. We are specifying our SharePoint connection. Now I've gotten out null here because I notice for me that I was getting a warning back with this sometimes. That something hasn't worked, even though everything had worked. 100%. You know, there was nothing missing all the information was there. It was more of a warning, but it was stopping this loop here was exiting from the loop so. You could probably use a silently continue or something like that here. I've just put out null here 'cause That's what I chose to do when I put this together. So this one is actually done. And I didn't need to refresh this in share point so if I'm. We're looking at our generic list now. And we can see that we've got this same information from Projectwise. In here and you can see these titles. Uh. The same. As what I have here. And we can check out attribute daughter as well to make sure that's all the same. They're all basically just random strings. I've been random integers. So it's going to be kind of difficult to. Remember all of those in match them against this. But this looks about right. Can see our filenames match and now names match everything looks great in here? And we have our list of metadata. Which could be useful for for several reasons? So that's done. Now we're going to go ahead and we're going to do the same thing all almost exactly the same thing for the document so I'm going to go ahead and actually. Joann open up. My SharePoint demo working directory so this is the folder that I specified as my working directory. The Top of the script. So I'm gonna come up an again loop through for each document run this while we talk about it. An I'm defining my metadata again in exactly the same way. I'm just not including the title this time, 'cause It's not included. I'm not document library in SharePoint. But what we're doing down here instead of just adding a list item. I am checking out, the documents 1st and I'm actually performing a copy out. This command that can be a little bit confusing to look at with the way that it's worded. But I'm just passing through the document for this iteration. I'm specifying that I want it copied out and the folder that I want it. Copied out too even though it says export folder. And if specified no reference is not that it matters. Because these particular documents don't have any so we should see. These documents getting exported here, which is exactly what we see great. And then I am. From the SharePoint side, using this ad PNP file. So I'm specifying my part here, which is my working directory and then my document file name. Uh the folder and this is where I want it to go in SharePoint. So I'm giving it my library name because the folder gets created for that document library when you make 1. My list of metadata is being supplied for the values parameter, so I'm going to get all that metadata. That I had 4 come through and again, SharePoint Connection in my out null for reasons that I explained. Just before. So if we head back over to share point now after that's run. And we look at our demo library. And maybe I will need to refresh this. Great to hear that demo library and we can see that again all of. Our metadata has come through the same way that it did for a generic library, not for a generic list. Sorry. But we also have the files here as well, so I can go up and open one of these. So I can see this is a not empty PDF. I could open up one of these word documents as well. Can see that it's not empty it has been changed? It's got some more changes fantastic so these documents? Along with the metadata have now been successfully copied over from projectwise into SharePoint. Which is pretty cool? I think? Um. So now that we've done that and we've handled the initial case. I want to take some time and. Handled case of. Updating those documents so. I am going to simulate these updates. I mean, these updates for many of you would be happening as part of regular usage of your. Projectwise system, but for me, I'm just going to go through and make some changes for these and I'm actually going to. Comment out this list of attributes and uncomment out this one. Just so that it's easier to see this set of attributes here gets a random integer. This set of attributes gets a random string so I'm going to use the random string so it's easier to tell that these have actually changed. So all I'm doing in this step is I am looping through my documents again. I'm actually going to. Clear my working directory. Before I do this so I'm checking out, the document here. I'm actually exporting it and I'm doing a managed export. I'm not. I'm not going to open this up in Projectwise and do it. And then I've just put a button here to give me some time to go through and make some changes. Through that file before I go through and check it back in and then at the end of this loop, I am. Updating my document attributes with these attributes that I see here so I'm going to go through and run this loop. So the document should be checked out. And once it checked out, we should get this popup, which is going to tell us to click OK. When this document here has been edited so if I flick over to projectwise I can see actually that. This document is locked 'cause it is exported. To my machine, it is now he'll So I am going to go through. And just make some changes in these. Even more changes. For our live demo. And I'm going to try and save this and it's going to tell me that I can't because it is read only. I'm going to save it there. And then I will actually. Delete this Top one and I'm just going to rename the second one so I'm effectively replacing the file though. With this updated one. And now I'm going to come back to PowerShell and I'm going to hit OK. And so this should disappear from my working directory. Which it has an if I come back over here and refresh it. It's also check back in over here and we can see that the next one is being checked out. I'm not actually going to update this one 'cause it's a PDF. And I'm not going to update the other two either. I just wanted to do this as an example, so this always with the one at the end I will not update. And the old days with the 2:00 at the end. I will not update either. But we can see each of these getting exported intern. And again, you guys you guys don't actually have to do this step. If you don't want this is really just for testing purposes for Maine. We come back over here, we can see for the ones who refresh this again that have already been updated. That we can see. But the attributes over here have all switched from random integers to random strings, so that part of it. This worked. And this should be the last import. Fantastic. So that's completed we've done our simulated changes so. Someone, who's gone and made changes in product wise and we now want to update this list in SharePoint with those values. And the new document. So what I'm going to do is basically the first step that we did again. I'm going to go and return. These documents from project lives because they have been updated so the document. Objects that I have on my machine. Currently, I'm now out of date. So I'm going to return these documents. I now have them in memory and I'm also going to return the current list. Items from SharePoint for the list. Now this is be cause when you down here. When we use. This set PNP list item. When we specify which item we want to update we need to give it an ID as share point ID. And I'm going to use this list here. To match the document Guidan Projectwise against the document grid of the list items stored in SharePoint, so I'm going to go. I had him return this year, so that I have this for my mappings. And then I'm basically doing exactly an actually we can see here if I return this, but it's a lot of information, we can see? Before items that I've got in share point here in the IDs that they have with them so. What I'm going to do now for this actual update step is pretty similar to what we did in the first instance, where we copied them up there in the 1st place. Any go through in this case for the my document properties. The only thing I actually want to update. Is the update date because none of the other ones have changed that I had selected 2 to move over there? And, of course I'm going to re add over my attribute so that they will all be random strings instead of random. Integers. And then I'm using the set. PNP list item and I am giving it to lift. For the identity so this is the idea that at once I am. Matching. Against my list items here where these grids are equal. I am giving it my metadata values and my SharePoint connection so I will go ahead. And run this. And because this one here is only the generic list. San not the document library. This one is not actually going to do the files. But if we flip back over to share point. And load up out there my list. We should see. These. Now reflect what's currently in Projectwise, which is our new set of? Can you set of attributes as random strings? And we can also see that the document update date is 17 for the first 234 AM. Which is? The time on my local machine here. So that all looks great that looks exactly how we wanted to so now we're going to again do the same thing for the document library except slightly different. We're going to need to check out the documents again because we need that file to upload into SharePoint. And in this case, I'm just using the add PNP file again actually going to add it straight over the Top of the other one because I think it matches these. Based on On file name up there so the old file will get replaced with a new one. It's not going to add. And you are a new item into that list. So I will go ahead and run this. And then this AFS GGG SG-1 is the document that we updated when we checked out to simulate al. Changes to the file. So once this is finished when we go back into share point we should be able to see that. Not only is that metadata updated. But that file has also updated as well. So that has now finished which is fantastic. Let's click over to our library and. It will just refresh this to make sure that it has come through. Well attributes of updated which looks perfect. Out document update times have updated which looks great. And if I open up. This document here. We should see that we have our. Even more changes for our live SharePoint demo. Which is what we would expect to see so again? Success in that front we have now successfully updated our generic list items and also add document library items as well as their file. In share point so we have synchronized information from projectwise into SharePoint and that was what I wanted to show you guys and that was actually. Pretty much the last thing that I wanted to show you guys about this, the last thing is if. You are doing this just as testing purposes like I am. I'm going to clean up my work afterwards, so I'm actually going to remove both of those lists that I've created. I'm just hitting the 4th thing, so I don't have to. Confirm it. And then if I come back over to share point once that's done everything will be. Gone if I refresh this. I'm going to get a 404 yeah. So if I wipe this off. And just come back to the SharePoint. Side at its root we will see that both that list in that library. I'm missing from the quick launch an if we checking the site contents. We can see that there are not there either. That has all been deleted. So that is that's the end of what I would like to show you guys, I am. Going to stop sharing my screen. Thank you for watching. I hope that you got something out of that something useful out of that. You can always feel free to reach out to me if you have got some more questions about that. But for now, I will stop sharing and I will pass it over to bill. Thanks again thanks X. Thanks Zach can you Zach can you hear me? I can I can. So there's a couple of questions in the chat window uhm. Laura from imitation was asking are what you're showing the direct links are they actual documents in Projectwise. Or they copies of what is in projectwise? So there will be copies of what is in Projectwise Becaus? We have, we've seen did over there, Essentia Lee. What you can do and what I have seen some people do is they will just copy the URL. Over or a link to the project Wise Web link or something like that, so that people can click on that. And take them to the actual source document in this case, it is just a copy of the document from Projectwise. So you may want to do some settings in SharePoint, where it's read only or something like that, you know. Obviously it would have a It's used case not being the single source of truth. I've been share point there. I'm committed I can see some other questions coming through please. Cool, cool so. I can see a what have I got here. So can you use this process with other cloud sharing services like box for example uhm? My. Without knowing for sure because I would need to check obviously on each of those different technologies, but I would say. Yes, you may not be able to do it all through PowerShell. You can you can obviously extract a lot of information from projectwise using PowerShell, but depending on the destination platform? You may have to use some other some other kind of technology to get that in there. If box has a PowerShell Module then I imagine you would be able to do it in very, very similar way that I've just done this one. All right uhm what else we got here does this work, the other way around share point to Projectwise. So yes, you would be using some different command. Let's I think instead of. Instead of using the get from Projectwise side in the add to share point you would basically just do that the other way around. Where you would get from SharePoint and add to projectwise but there are also other ways that you could do that. If you're looking to go from SharePoint to projectwise you could use. Share point to trigger a flow, which you could use to then do a bunch of actions in Projectwise, based on. On any amount of logic you apply to that flow. You could also call an automation object or PowerShell script from flow and. And do it that way so you don't have to do it with PowerShell just like this from SharePoint. You certainly can, but there are. Obviously other options that you can do as well. So this is another one about SharePoint Project Wise. Kind of deal with new versions of the same file so. What I have done in this would depend on your requirements of what needs to be displayed in SharePoint? What I have seen done in the past? Is people really only wanted the latest version of the file in share point. So it was just getting. Basically written over, said it was always the latest version of the document in SharePoint. So both the metadata in the file would be updated to reflect. The latest fashion I am sure that there is a way where you could do it, so that it is not. Overriding the previous version. I'm not super familiar with how versioning works in share point so. I'm going to go with the dependes on that one, but Yes, it, you can you can have it handled versions? Hum. Sorry this one is a bit of a long one here. OK and you're going to have to. I don't have to reach out for this one later, I think. Will take this one off line? Why don't want to restate the question for those that can't hear it? I can't read it. Uh yeah, sure so this one is just about. Using the flow and. An PowerShell automation. 2. Put things into projectwise from SharePoint. But I'm not. I'm not actually sure I understand the question and it's entirely so I can't I can't answer it. Can we create directory's on projectwise from SharePoint? Uh. I would say yes if what you mean is like you have some kind of trigger in in SharePoint or let's say you have. I don't know I'm trying to think of an example workflow for this you've got something in SharePoint and someone. Takes a box and says Hey this is approved. This project is approved, whatever it is approved, you could use that. To trigger a flow, which would go and create a folder in Projectwise or actually trigger any number of actions to happen in Projectwise. I think that's what you mean by creating a directory in there, so yes, we could definitely do that. From SharePoint. There's another question earlier about managing JS files in the same way as Reformats. As well. So can you manage GIS files this way OK? I I don't know that I fully understand that question you could certainly copy them over to share point in the same way. Assuming that share point is able to. To handle those files, I don't I don't know. I don't know how to answer the question beyond that. The Protein Wise Command. That doesn't really care what you export from Project Wise. And I think you know they would just depend on the metadata that that you put into SharePoint on the opposite side. If you want to go into that in more detail. I have a more specific question maybe you can. We can reach out off to this. OK, what else we got some more coming through. No so the checkout example was not to make SharePoint the authoring at the checkout example was just for me to simulate some actual some actual usage in the project wise system like in a real world scenario, obviously. You guys don't have static data sources. People are logging in making changes. All the time to document whereas I don't have that, so I was just. Exporting that document and making a change on my system and then importing it back in to simulate some changes there, but Definitely using product wise is the authoring after it was not to illustrate using SharePoint for authoring documents. Um what about references in Projectwise are they copied out so I specifically used the no references switch on my. Copy out. Command let there, but you can copy out references as well. Yes. Um can I share the script after the event? Yes. So we will upload the script as part of the resources that are available. In this presentation when it goes to on demand mode. So when you when you log in to view that there will be a list of resources and I've. I haven't actually used it myself, but I presume that you can download those so yes, you will have you will have the script there? OK, So what have we got here is it possible to create directories copies from local computer to Projectwise SharePoint. For backup reasons for non integrated products. So. To create directory copies from local computer 2 projectwise I'll share point. I mean, yeah, you. You certainly could like if you had a folder on a on your local machine on a network drive somewhere that you wanted to either. Add you know replicate in Projectwise or replicate in share point you could certainly use this same, the same kind of methodology to do that. If that's if that's what you're looking to do. It shouldn't matter if the product that those files are associated with his integrated on not. You just need to push them into each system basically but yes, you could do that in the same way. All right uhm could I please share the links to the PS commands in library specific to projectwise uhm. Yeah, I assumed by that you mean the PWPSDAB stuff I will add. A link to the communities page and some other useful information for that in this script before I attach it. To this presentation to the on demand stuff. OK, in some of the other questions. Some of the ones that may take a little bit longer to answer or if you've got to do some research we can. Throw those on communities. And then we can do a back and forth there, too if that helps. Sure, sure. OK, so thanks again Zach and again. Thank you given the time zone. Challenges that were experiencing for you. I appreciate you staying up late and doing this presentation. No, not at all, I appreciate everyone's time and listening thank you. Thank you very much. OK, so I'm just going to closeout and now I'm up in the live view. Window. So we've gone through some questions like I said, we can, we can post some of these on communities. If it requires a longer thread or we need to get other people involved. Uh. Moving forward accelerate. 2020 Vegas Conference registration is now open. So pretty excited about that again. It's April 21st and 22nd. Uh. So. Here's a little bit of A. Idea of what you're going to see what the conferences for you know. In short a lot of you have been to conferences before. There are going to be. It's 2 days, 2 rooms. There are going to be leadership tracks. There's going to be technical it tracks. We've got quite a bit of an agenda that's been put together it's pretty final. I am involved with that. What we're doing now before we post it is just making sure we've got the presenters down and we've got the descriptions laid out. Pretty well, hopefully with the next couple of days will have that all finalized. It will be up and available but you can register. Uh. I'm pretty excited about it because I get to work with you guys and see you guys, but some of the tracks are going to be kind of interesting I think. So hope to see you all there. We are looking for a couple of more users that would be willing to present. So if anybody within the organizations think that they've got something that they can share they would like to share. And it would serve the community would love to hear from you. We've got a couple we'd like to get you know, one or 2 more so you can reach out to me directly. Build tidy Gregoria bentley.com. And let me know. There is also going to be we haven't announced the dates yet in May, there will be a. Separate accelerate conference in London. For those of you on this call that are over in Europe. I'm hearing it's going to be early May, same format. So it's essentially going to be the same sessions, there might be 1 or 2 differences. But most of it is going to be the same don't know the exact dates yet still waiting to hear back. On that. OK, so. Rolling into the next big. Which will be? February 20th. Put my little bar, there and parentheses 'cause where I'm at probably be pretty cold. Uh that's part one and a three part series on digital automation, which is going to be central to our model composition server. The discussion will range from some intermediate topics over to advanced and some troubleshooting going to be led by RB Parker. So Part 1 will start in February, March and April will be Part 2 and 3 respectively. Moving out in the year. I pulled the consultants ripe old art in our global team when we were putting the agenda together. And asked for some ideas of sessions. As you might imagine, we got quite a response back. So again we're kind of Tide with the number of sessions that we're going to be able to deliver. In Vegas and or London. But there are some excellent topics, there for figs. Another type of accelerate live presentations that we did last year, we did a couple of extra presentations that were. We're live kind of like this session. That we just didn't have room for some kind of parsing that list going over. So I'll have more of an update I'm hoping on the next call what I'll be able to do. My goal is at some point within the next month or 2 is to kind of give everyone a formal schedule. Of what's going to be coming for the year. Might help you plan a little bit more. I'm in particular through succession that is. Important to your organization, the challenge with doing that is, it may have to get switched out. So you know, I don't want to say, Hey, we're doing something in August. It's going to be on. My twin I don't know just picking something and then all of a sudden we have to switch that out, and. People have made plans to attend that but I'm going to try and publish some sort of list on that so. Look for that, like I said the next month or 2. A poll question right so again we can get to the pool question so. If you wanted to take a second and do that. Uh if you want to be contacted by a sales representative this is not a. This is not a sales push that was my first question. I people aren't going to be contacted you know what you want to buy. This is more of informative. Do you need to talk to anyone in sales it could be about anything would be better problem you're having? A contact change general question direction of something if there's any need to have your account manager reach out to you for any reason, it's not. To sell you something. So feel free to. To do that. And that's it. So I want to thank everyone. Thanks for your patience. This is again with my first session. With on 24 hopefully from here on out they'll get a little bit better in a little bit smoother. I think everything went pretty well today, I'm hoping. Um. Again feedback is always welcome again, you feel free to email me directly if you've got any comments. Hey bill this is Patsy? Can I make a quick comment. Absolutely, OK. Thank you just letting everyone know who still online that Billy is in the process of updating their. Event page so if you've visited it the last heir to you may have noticed that it's missing some information. Please bear with us because we're implementing a new system, and it is expected to go live on Friday. And when it does you'll see all the wonderful coming events as well as available on demand videos so I just wanted to. Give people an update on that, so good things are coming. Great, thanks Patty. Alright, thank you. Thank you everyone for attending an will talk to you next month. Have a great day.
This ProjectWise Administrators Special Interest Group virtual workshop demonstrates an automated process to copy files and metadata from ProjectWise Design Integration into SharePoint using PowerShell. Join Bentley’s Bill DiGregorio, along with systems architect Zachary Kerr, as we take an in-depth look into how to copy metadata from SharePoint into ProjectWise Design Integration and more. By session end, you will know how to:
Connect to SharePoint using PowerShell
Return documents from ProjectWise to copy into SharePoint
Create new list/library items in SharePoint corresponding to source ProjectWise documents
Add metadata from ProjectWise to the newly created items in SharePoint
**The webcast will be streamed through your computer, so there is no dial-in number. Please make sure your computer speakers (or headset) are turned on and the volume is set to an audible level so you can hear the presenters. #EVENTHELPURL#