<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://communities.bentley.com/cfs-file/__key/system/syndication/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>Kirk Peterson's Communities Activities</title><link>https://communities.bentley.com/members/3a169855_2d00_43d6_2d00_4844_2d00_bc00_2d00_adc49cb7b4ad</link><description>Recent activity for people in Kirk Peterson's community</description><dc:language>en-US</dc:language><generator>Telligent Community 12</generator><item><title>Flow idea #3: Send Automatic Notifications about New Documents</title><link>https://communities.bentley.com/products/betas/projectwise-design-integration-connector-for-microsoft-flow-early-access/b/pw-integration-connector-blog/posts/flow-idea-3-send-automatic-notifications-about-new-documents</link><pubDate>Tue, 08 Jan 2019 16:27:21 GMT</pubDate><guid isPermaLink="false">6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:9d5c9c3b-207c-4076-ad5d-b2014e7dd5fc</guid><dc:creator>Audrius.Pundzevicius</dc:creator><description>&lt;p&gt;&lt;span&gt;Teams often need to know when important events, such as creation of new documents or document state changes, happen in their projects. In this article we will demonstrate how to create flow to do it. &lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;First, we must create a saved search in ProjectWise that returns documents of interest. In this example we will use a saved search that finds recently created documents. This is not a limit. A search can be a complex as the team needs it to be!&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Next, we will create a flow that sends email notification about new items from the search. Here is an algorithm:&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;span&gt;Run the saved search every hour to find documents modified during last 24 hours (or any interval longer than notification period).&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span&gt;Notify users about documents that were created since the last run of this flow. To do this, flow will save date and time of the last run in ProjectWise. It will use this time to list only documents created after previous run.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;h2&gt;&lt;span&gt;ProjectWise Configuration&lt;/span&gt;&lt;/h2&gt;
&lt;p&gt;&lt;span&gt;We use ProjectWise sample datasource for this example. We added a global saved search to the project. In this example it returns documents created using last 24 hours in Work Area BSI400:&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/1526.1.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;We have added a document &amp;lsquo;Last run time&amp;rsquo; Under 99_Automation folder to store timestamp of the last run:&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/3683.2.png" /&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;h2&gt;&lt;span&gt;The Flow&lt;/span&gt;&lt;/h2&gt;
&lt;p&gt;&lt;span&gt;The complete flow is shown in screenshots below. &lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Note that for ProjectWise actions to work, the work area connection needs to be associated with ProjectWise Could project. &lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;The flow starts with recurrence trigger. &lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x240/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/8463.3.png" /&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;The next two actions are for getting date and time for the last run and the current run:&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;span&gt;The &amp;ldquo;Find a document by path or GUID&amp;rdquo; gets properties of a document used to store time of previous run. &lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span&gt;The &amp;ldquo;Compose&amp;rdquo; step saves current time in time zone of ProjectWise server. The expression is: &lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;&lt;span&gt;&amp;nbsp;&lt;img alt=" " src="/resized-image/__size/1040x240/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/1538.4.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Notice that in this case time zone of ProjectWise server is already UTC, so there will be no change to time stamp. If, for example, ProjectWise server was in US East Coast then the third parameter would have to be &amp;lsquo;Eastern Standard Time&amp;rsquo;. For complete list of time zone names see &lt;a href="https://msdn.microsoft.com/en-us/library/gg154758.aspx"&gt;https://msdn.microsoft.com/en-us/library/gg154758.aspx&lt;/a&gt; .&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&amp;nbsp;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/4353.5.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/6320.6.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;The next action runs a saved search and finds all new documents. If this flow ran recently, then it may include documents about which it has already sent a notification. We will filter the list in a following step.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/0143.7.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;To avoid double notification, we use &amp;lsquo;Filter array&amp;rsquo; action to select only documents that were created after last run, i.e. all cases when last run timestamp is less than document creation date.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;To build this action:&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;span&gt;Add Body from &amp;lsquo;Find documents by saved search&amp;rsquo; action into &amp;lsquo;From&amp;rsquo; field&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span&gt;In the first field select description field from &amp;lsquo;Find document by path or GUID&amp;rsquo; action&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span&gt;In the second field choose any operator, e.g. Contains&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span&gt;In the third field select Creation time from saved search results&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span&gt;Then go to advanced mode and edit expression to have &amp;ldquo;@less&amp;rdquo; operation instead.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;&lt;span&gt;&amp;nbsp;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/6472.8.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Initialize a variable to store HTML for email body and begin a table. It will be used in the if statement below. The &amp;lsquo;Description&amp;rsquo; field is from &amp;lsquo;Find document by path or GUID&amp;rsquo; action.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/5824.9.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Next, add a condition. The flow will send email only if filtered array is not empty. The expression in the first field is: &lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/7080.10.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/8156.11.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/1122.12.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;The first step in the Yes branch is to add a line for each document.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;/span&gt;&lt;span&gt;First add action &amp;ldquo;Append to string variable&amp;rdquo;. Flow will automatically add &amp;lsquo;Apply to each&amp;rsquo; after referring to any property from the filtered array. &amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Note that the properties used in &amp;lsquo;Append to string variable&amp;rsquo; must be taken from the filtered array and not from the saved search action.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/5481.13.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Lastly add actions to append end of the table and send the email. &lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;In this example the email is sent to a single fixed recipient. This flow could be easily improved to read list of recipients from an excel spreadsheet or configuration document properties. Such improvement would allow to update list of recipients without modifying the flow. We kept a single fixed email address for simplicity.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/2768.14.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;The &amp;ldquo;No&amp;rdquo; branch of condition has no actions.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/0636.15.png" /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Now the last step in this flow. Save time of this run that was retrieved in earlier &amp;lsquo;Compose&amp;rsquo; action.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;img alt=" " src="/resized-image/__size/1040x0/__key/communityserver-blogs-components-weblogfiles/00-00-34-38-81/2703.16.png" /&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;The end.&lt;/span&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>OpenBuildings - after changing a part, a way to reload all associated models or saved views?</title><link>https://communities.bentley.com/products/building/building_analysis___design/f/aecosim-speedikon-forum/201933/openbuildings---after-changing-a-part-a-way-to-reload-all-associated-models-or-saved-views</link><pubDate>Tue, 18 Aug 2020 13:18:29 GMT</pubDate><guid isPermaLink="false">6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:ad466d58-ab48-4c8e-849c-0b39a2ba5ca4</guid><dc:creator>Kirk Peterson</dc:creator><description>&lt;p&gt;hello everyone -&amp;nbsp;&lt;/p&gt;
&lt;p&gt;I had a question from our OPB team, and they are wonder that after changing a part, is there an &amp;quot;easy&amp;quot; way to reload all associated models and/or views?&lt;/p&gt;
&lt;p&gt;thanks!&lt;br /&gt;Kirk Peterson&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>PW Flow error</title><link>https://communities.bentley.com/products/betas/projectwise-design-integration-connector-for-microsoft-flow-early-access/f/discussions/189912/pw-flow-error</link><pubDate>Thu, 12 Dec 2019 18:23:20 GMT</pubDate><guid isPermaLink="false">6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:3a529cd8-f595-400d-acdf-968aee22057e</guid><dc:creator>Kirk Peterson</dc:creator><description>&lt;p&gt;I am starting my own flow, as follows:&lt;/p&gt;
&lt;p&gt;&lt;img src="/resized-image/__size/320x240/__key/communityserver-discussions-components-files/343624/pastedimage1576174858313v1.png" alt=" " /&gt;&lt;/p&gt;
&lt;p&gt;Further FYI - the datasource is located in our Bentley hosted environment.&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;The PW-Find document by search isn&amp;#39;t working, and it gives the error as follows:&lt;/p&gt;
&lt;p&gt;&lt;img src="/resized-image/__size/320x240/__key/communityserver-discussions-components-files/343624/pastedimage1576174906195v2.png" alt=" " /&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;I am hoping someone can explain the error, and how to fix it.&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;thanks,&lt;/p&gt;
&lt;p&gt;Kirk&lt;/p&gt;
&lt;p&gt;&lt;br /&gt;&lt;br /&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>Let me Help You</title><link>https://communities.bentley.com/achievements/687f4b6d-e18a-4e55-836c-49926ca2c9d9</link><pubDate>Thu, 21 Nov 2019 06:32:12 GMT</pubDate><guid isPermaLink="false">6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:565311e8-335c-4f77-87ce-3f9863dc5831</guid><dc:creator /><description>Answer a question that is verified as helpful or correct.</description></item><item><title>question for a Flow+PW newbie</title><link>https://communities.bentley.com/products/betas/projectwise-design-integration-connector-for-microsoft-flow-early-access/f/discussions/188013/question-for-a-flow-pw-newbie</link><pubDate>Mon, 04 Nov 2019 16:35:09 GMT</pubDate><guid isPermaLink="false">6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:e010b0c8-c525-4db0-bf69-a9cdd59ad4a8</guid><dc:creator>Kirk Peterson</dc:creator><description>&lt;p&gt;hello everyone - I am trying a form of &amp;quot;hello world&amp;quot; with PW and Flow.&amp;nbsp;&lt;/p&gt;
&lt;p&gt;What would this error mean?&lt;/p&gt;
&lt;p&gt;&lt;img src="/resized-image/__size/320x240/__key/communityserver-discussions-components-files/343624/pastedimage1572885321355v1.png" alt=" " /&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>Starting to play with Flow and PW ... error</title><link>https://communities.bentley.com/products/betas/projectwise-design-integration-connector-for-microsoft-flow-early-access/f/discussions/174265/starting-to-play-with-flow-and-pw-error</link><pubDate>Fri, 25 Jan 2019 16:49:51 GMT</pubDate><guid isPermaLink="false">6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:337b0c5e-8519-4cda-b27c-b901bbd84e78</guid><dc:creator>Kirk Peterson</dc:creator><description>&lt;p&gt;Hello - I have started to play around with MS Flow and PW.&amp;nbsp; I was trying to use the &amp;quot;Create a new document&amp;quot; action, and I get this error:&lt;/p&gt;
&lt;p&gt;&lt;img alt=" " src="/resized-image/__size/640x480/__key/communityserver-discussions-components-files/343624/PW_5F00_Flow_5F00_Error.JPG" /&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>Ask A Question II</title><link>https://communities.bentley.com/achievements/cd3cd235-25c1-476e-bb88-33a5705ca45a</link><pubDate>Fri, 28 Jul 2017 09:20:05 GMT</pubDate><guid isPermaLink="false">6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:d7335784-c3b6-4732-8e2f-e5cb19319679</guid><dc:creator /><description>Ask 10 questions in a forum.</description></item><item><title>Ask A Question I</title><link>https://communities.bentley.com/achievements/460ac7df-7ccc-4c42-a204-9e05eef3be09</link><pubDate>Fri, 28 Jul 2017 00:46:04 GMT</pubDate><guid isPermaLink="false">6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:a9bf5498-460a-48ea-80aa-f4cfd973461f</guid><dc:creator /><description>Ask a question in a forum.</description></item><item><title>ExportToExcel Transform in I-model Transformer</title><link>https://communities.bentley.com/products/microstation/f/fileformats-forum/101092/exporttoexcel-transform-in-i-model-transformer</link><pubDate>Fri, 19 Sep 2014 07:02:31 GMT</pubDate><guid isPermaLink="false">6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:39fea07e-28f5-4bed-b29e-3ca490d5c30b</guid><dc:creator>Mona Lisa Nuera</dc:creator><description>&lt;p&gt;I have a problem, everytime I executed a ExportToExcel Transform it will throw me an error. See below (red text):&lt;/p&gt;
&lt;p&gt;&lt;span style="color:#ff0000;"&gt;&lt;strong&gt;2014-09-19 15:20:22,435 ExportToExcel: Failed to locate primary schema Test20140919.01.00 in I-model C:\Users\Administrator\Desktop\20140919\TestOnly_Output_Part2.i.dgn&lt;/strong&gt;&lt;br /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;I already placed my excel file, primary and supplementary schema file in that location.&lt;/p&gt;
&lt;p&gt;My primary and Supplementary Schema was created thru Excel Configuration in I-model Transformer (Tools &amp;gt; Excel Configuration)&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;I don&amp;#39;t know what is/are the cause(s) of that error. And what is the best solution.&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;Your response is highly appreciated.&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;Thank you.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item></channel></rss>