{"id":33505,"date":"2023-10-13T00:59:28","date_gmt":"2023-10-13T04:59:28","guid":{"rendered":"https:\/\/blogs.solidworks.com\/tech\/?p=33505"},"modified":"2023-10-13T01:05:32","modified_gmt":"2023-10-13T05:05:32","slug":"solidworks-support-monthly-news-october-2023","status":"publish","type":"post","link":"https:\/\/blogs.solidworks.com\/tech\/2023\/10\/solidworks-support-monthly-news-october-2023.html","title":{"rendered":"SOLIDWORKS\u00ae Support Monthly News &#8211; October 2023"},"content":{"rendered":"<p>Hello to all,<\/p>\n<p>Welcome to the new edition of the SOLIDWORKS\u00ae Support Monthly News! This monthly news blog is co-authored by members of the SOLIDWORKS\u00ae Technical Support teams worldwide. <strong>Here is the list of topics covered in this month&#8217;s Blog :<\/strong><\/p>\n<ol>\n<li>\n<h2><span style=\"color: #ff6600\"><strong>Taking control of the SOLIDWORK<span style=\"color: #ff6600\">S<\/span><\/strong><\/span><strong><span style=\"color: #ff6600\">\u00ae<\/span> <\/strong><span style=\"color: #ff6600\"><strong>PDM login dialog prompts<\/strong><\/span><\/h2>\n<\/li>\n<li>\n<h2><span style=\"color: #ff6600\"><strong>In <\/strong><strong>SOLIDWORKS<\/strong><strong>\u00ae <\/strong><strong><span style=\"color: #ff6600\">Flo<\/span>w Simulation, how do I define the direction of rotation and the swirl for Axial fans?<\/strong><\/span><\/h2>\n<\/li>\n<li>\n<h2><span style=\"color: #ff6600\"><strong>SOLIDWORKS<\/strong><strong>\u00ae <\/strong><strong><span style=\"background: white\"><span style=\"color: #ff6600\">PD<\/span>M Report Generator Dynamic Arguments<\/span><\/strong><\/span><\/h2>\n<\/li>\n<li>\n<h2><span style=\"color: #ff6600\"><strong>3DEXPERIENCE <\/strong><strong>SOLIDWORKS<\/strong><\/span><strong><span style=\"color: #ff6600\">\u00ae<\/span> <\/strong><span style=\"color: #ff6600\"><strong>&#8220;Rename title&#8221; VS &#8220;SW Title&#8221;.<\/strong> <\/span><\/h2>\n<\/li>\n<\/ol>\n<hr \/>\n<h1><span style=\"color: #003366\"><strong>1.Taking control of the <\/strong><strong>SOLIDWORKS<\/strong><strong>\u00ae <\/strong><strong><span style=\"color: #003366\">PD<\/span>M login dialog prompts<\/strong><\/span><\/h1>\n<p><em>&#8211; by Tor IVEROTH<\/em><\/p>\n<p>If you have used SOLIDWORKS\u00ae PDM on a system for a while, you may find that sometimes a PDM log in prompt to one or more vault views on the system shows up \u2013 Even though you had no intention to access or log in to that particular vault.<\/p>\n<p>These login prompts also seem to have a habit of showing up when least expected. Some examples where a login prompt may show are:<\/p>\n<ul>\n<li>Starting a new email in Outlook.<\/li>\n<li>Changing name of a folder completely unrelated to the vault view.<\/li>\n<li>Running a Windows search.<\/li>\n<li>Typing a path in the File Explorer address bar.<\/li>\n<li>Starting up a new File Explorer after a reboot.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33540 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-150-615x461.png\" alt=\"\" width=\"615\" height=\"461\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-150-615x461.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-150-300x225.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-150-728x546.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-150.png 765w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p>And if the login prompt for some reason does not show up modally, the prompt might show behind other application windows or on another monitor \u2013 the process that triggered the login prompt would wait until you acknowledge the login dialog. So for example, if you open File Explorer which in turn triggers a login prompt that is not displayed, to the end user this may seem as if Explorer now hangs. Explorer has not really frozen, but it is waiting for the user input. As this image illustrates, the login prompt is not initially visible until you ALT+TAB to display it.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33507 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-140-615x302.png\" alt=\"\" width=\"615\" height=\"302\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-140-615x302.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-140-300x147.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-140-768x377.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-140-728x357.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-140.png 1405w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p>Depending on the environment, there are even reports of some situations (often with Windows 11) where the prompt is not shown at all. With the characteristics of Explorer behaving as if it has stopped working.<\/p>\n<p><strong>You may ask, why is this happening?<\/strong><\/p>\n<p>A file vault login prompt will show when you are not logged in and there is an application on the system that requests access to the files or folder paths within a local file vault view. The login is needed to get the up to date information from the vault database for the file, and potentially cache a copy.<\/p>\n<p>This will most often happen when you use File Explorer to browse into a vault view, in which case PDM logically will show a prompt for you to log in. However, the login prompt may also be triggered in many other circumstances. For example:<\/p>\n<ul>\n<li>When you use the File, Open or Save dialog from within an application and the last saved path points to the vault view.<\/li>\n<li>When Windows File Explorer tries to display recently accessed files or folders that includes paths under a vault view.<\/li>\n<li>When the Windows desktop search index scans the vault view folders, and thereby triggers the login prompt when you are requesting information involving a vault view path \u2013 such as typing values into the File Explorer address bar.<\/li>\n<\/ul>\n<p>To close the login prompt you would proceed with the login. The prompt will then not show again until you log out, or restart the SOLIDWORKS PDM process (edmserver.exe). If you do not want to log in, you have the option of exiting the dialog and a message informs you that this will disable the login prompt until you explicitly log in.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33508 size-full\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-126.png\" alt=\"\" width=\"609\" height=\"351\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-126.png 609w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-126-300x173.png 300w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/p>\n<p>If you exit the login and thereby <em>suppress<\/em> the login dialog, it will remain suppressed from all future requests from processes that scans the vault view. However, as soon as you exit the PDM process via the tray icon, or edmserver.exe is killed, or system is restarted, the prompt will show again.<\/p>\n<p><strong>How to avoid the prompts?<\/strong><\/p>\n<p>To date, there have been no viable option to persistently suppress the login dialog (and remain logged out) for a vault view. While some systems only shows prompts when accessing a view, others may show them more frequently and unexpected.<\/p>\n<p>Some options to reduce the frequency of the login prompts:<\/p>\n<ul>\n<li><strong>Use automatic login<\/strong>:When any process accesses a vault view, PDM automatically logs in to the view. The setting can be controlled via the administration tool, local settings, automatic login.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33509 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-115-615x354.png\" alt=\"\" width=\"615\" height=\"354\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-115-615x354.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-115-300x173.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-115-728x419.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-115.png 739w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/li>\n<li><strong>Set view to offline: <\/strong>An offline view will not prompt for login until it is set to online again. The offline\/online flag is stored in the registry &#8211; so you could create a .reg file that sets the value to offline, and another to online. When user wants vault access, run the online reg file first.\u00a0 When disconnecting from the view, run the offline reg file. You could even have it run the offline reg file on system startup to ensure it is always starting offline.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33510 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-97-615x218.png\" alt=\"\" width=\"615\" height=\"218\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-97-615x218.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-97-300x106.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-97-768x272.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-97-728x258.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-97.png 1460w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/li>\n<li><strong>Disable Outlook Attachment menu<\/strong>.<br \/>\nIf login prompts show each time you open Outlook or create a new email, disable the setting that is outlined in Knowledge Base article <span style=\"text-decoration: underline\"><a href=\"https:\/\/support.3ds.com\/knowledge-base\/?q=docid:QA00000121507\">QA00000121507<\/a>.<\/span><\/li>\n<li><strong>Clear recent accessed locations<br \/>\n<\/strong>The Quick access menu in File Explorer has settings to disable or clear recently accessed files. Changing those may reduce the frequency of the login prompts.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33511 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/6-67-505x615.png\" alt=\"\" width=\"505\" height=\"615\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/6-67-505x615.png 505w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/6-67-246x300.png 246w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/6-67.png 518w\" sizes=\"auto, (max-width: 505px) 100vw, 505px\" \/><\/li>\n<\/ul>\n<p><strong>Clear recent accessed locations<br \/>\n<\/strong>The Quick access menu in File Explorer has settings to disable or clear recently accessed files. Changing those may reduce the frequency of the login prompts.<\/p>\n<p>A new feature to control the display of the login prompt is introduced in SOLIDWORKS PDM 2023 SP4 \u00a0and 2024 SP0.<\/p>\n<p>You can now fully control if the login prompt should show, or remain suppressed until you explicitly select to login. This means that no process will trigger the login prompt automatically, thereby avoiding unwanted prompting.<\/p>\n<p><strong>To suppress the login prompt for a vault, on a 2023 SP4 or later client<\/strong><\/p>\n<ol>\n<li>Open the registry editor.<\/li>\n<li>Browse tob: HKEY_CURRENT_USER\\SOFTWARE\\SolidWorks\\Applications\\PDMWorks Enterprise\\Vaults\\[vaultname]<\/li>\n<li>Create a new DWORD (32-bit) value named <strong>DisableAutoLoginPrompt<\/strong><\/li>\n<li>Set value to <strong>1<\/strong>\u00a0 (1=on, 0=off)<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33512 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/7-57-615x232.png\" alt=\"\" width=\"615\" height=\"232\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/7-57-615x232.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/7-57-300x113.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/7-57-768x289.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/7-57-728x274.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/7-57.png 956w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/li>\n<li>Repeat with each vault view you wish to suppress the login prompt.<\/li>\n<li>Restart system (or exit SOLIDWORKS PDM via tray icon and restart Explorer.exe process via Task Manager.<\/li>\n<\/ol>\n<p>From now on, the prompt will only appear when you right-click the vault view or tray icon and select Log In.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33513 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-44-615x182.png\" alt=\"\" width=\"615\" height=\"182\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-44-615x182.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-44-300x89.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-44-728x216.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-44.png 743w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p><strong>Notes on the new feature<\/strong><\/p>\n<ul>\n<li>The setting is defined per current user profile and per vault.<\/li>\n<li>When enabled, the setting will supersede the automatic login (if enabled).<\/li>\n<li>Exiting PDM via the tray icon, or logging out will suppress the login prompt again.<\/li>\n<\/ul>\n<hr \/>\n<h1><span style=\"color: #003366\"><strong>2. In SOLIDWORKS\u00ae Flow Simulation, how do I define the direction of rotation and the swirl for Axial fans?<\/strong><\/span><\/h1>\n<p><em>&#8211; by Julien BOISSAT<\/em><\/p>\n<p>The direction of rotation of fans affects the direction of the downstream swirl. The swirl is responsible for the helicoidally shape of the trajectory of fluid particles. The direction of rotation of the fan determines the direction the helix winds in.<\/p>\n<p><strong>Swirl from Axial fans in SOLIDWORKS<\/strong><strong>\u00ae<\/strong><strong> Flow Simulation<\/strong><\/p>\n<p>SOLIDWORKS\u00ae Flow Simulation considers swirl automatically for the <strong>Axial<\/strong> and <strong>Radial<\/strong> fan types. For the general <strong>Fan Curve<\/strong> type of fan, you define the swirl manually. For more information, see <a href=\"https:\/\/support.3ds.com\/knowledge-base\/?q=docid:QA00000105645\">QA00000105645<\/a>.<\/p>\n<p>In the SOLIDWORKS\u00ae Flow Simulation software, when you define an <strong>Axial<\/strong> fan, you can set the <strong>Direction of rotation<\/strong> to <strong>Clockwise<\/strong> or <strong>Counterclockwise<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33515 size-full\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-147.png\" alt=\"\" width=\"553\" height=\"420\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-147.png 553w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-147-300x228.png 300w\" sizes=\"auto, (max-width: 553px) 100vw, 553px\" \/><\/p>\n<p>The <strong>Clockwise<\/strong> direction of rotation corresponds to a clockwise swirl downstream of the fan, when you view the face selection in <strong>Faces Fluid Enters the Fan<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33516 size-full\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-141.png\" alt=\"\" width=\"576\" height=\"250\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-141.png 576w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-141-300x130.png 300w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/p>\n<p>The <strong>Counterclockwise<\/strong> direction of rotation corresponds to a counterclockwise swirl downstream of the fan, when you view the face selection in <strong>Faces Fluid Enters the Fan<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33518 size-full\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-127.png\" alt=\"\" width=\"576\" height=\"256\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-127.png 576w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-127-300x133.png 300w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/p>\n<p><strong>Estimation of the amount of swirl<\/strong><\/p>\n<p>It is possible to estimate the swirl of gas just after an axial fan with the following relation:<\/p>\n<p><strong>V<\/strong><strong><sub>fi <\/sub>= <\/strong><strong>\u0394P<\/strong><strong><sub>total\u00a0 <\/sub>\/ (<\/strong><strong>\u03a1 * R<\/strong><strong><sub>eff <\/sub>*\u00a0<\/strong><strong>\u03c9 * eff)<\/strong><\/p>\n<p>Where:<\/p>\n<p><strong><sub>\u0394Ptotal<\/sub><\/strong><sub>\u00a0 <\/sub>is the\u00a0 total pressure drop on the fan.<\/p>\n<p><strong>\u03a1<\/strong>\u00a0is the\u00a0 gas density.<\/p>\n<p><strong>R<\/strong><strong><sub>eff<\/sub><\/strong> is the characteristic radius of the fan. A common value is R<sub>eff<\/sub> = \u00bd * (Outer radius + Hub radius).<\/p>\n<p><strong>\u03c9<\/strong>\u00a0is the angular velocity of the fan.<\/p>\n<p><strong>eff<\/strong> is the efficiency of the fan. A typical value is \u00bb 80%.<\/p>\n<p><strong>V<\/strong><strong><sub>fi<\/sub> <\/strong>is the velocity of the gas in the circumferential direction.<\/p>\n<p>&nbsp;<\/p>\n<p>You can then calculate the angular velocity of the gas w<sub>Flow<\/sub> with this formula:<\/p>\n<p><strong><sub>\u03c9Flow<\/sub> = V<\/strong><strong><sub>fi<\/sub> \/ R<\/strong><strong><sub>eff<\/sub><\/strong><\/p>\n<p>Numerical application for the model in attachment:<\/p>\n<p><strong>D<\/strong><strong>P<\/strong><strong><sub>total<\/sub><\/strong><sub>\u00a0 \u00a0= <\/sub>72.5 Pa<\/p>\n<p><strong>\u03a1<\/strong><sub>\u00a0= <\/sub>1.19 kg\/m^3<\/p>\n<p><strong>R<\/strong><strong><sub>eff<\/sub><\/strong><sub> = <\/sub>0.056 m<\/p>\n<p><strong>\u03c9<\/strong><sub>\u00a0= <\/sub>298.45 rad\/s<\/p>\n<p><strong>Eff<\/strong> = 0.8<\/p>\n<p><strong>V<\/strong><strong><sub>fi<\/sub><\/strong><sub> = <\/sub>4.556606 m\/s<\/p>\n<p><strong>\u03c9<sub>Flow<\/sub><\/strong><sub>\u00a0= <\/sub>81.36796 rad\/s<\/p>\n<p>A plot of the angular velocity confirms the estimation of \u03c9<sub>Flow\u00a0 <\/sub>is correct:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33517 size-full\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-116.png\" alt=\"\" width=\"566\" height=\"262\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-116.png 566w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-116-300x139.png 300w\" sizes=\"auto, (max-width: 566px) 100vw, 566px\" \/><\/p>\n<hr \/>\n<h1><span style=\"color: #003366\"><strong>3.<span style=\"background: white\">SOLIDWORKS<\/span>\u00ae<span style=\"background: white\"> PDM Report Generator Dynamic Arguments<\/span><\/strong><\/span><\/h1>\n<p><em>&#8211; by James FALCONER<\/em><\/p>\n<p><strong>What is a PDM Report?<\/strong><\/p>\n<p>SOLIDWORKS\u00ae PDM extends the capabilities of the client interface by allowing users to create, save, and print detailed information about files from the Microsoft\u00ae SQL database. The report generator uses the DML subset of Microsoft T-SQL, which is the read-only collection of commands that make this a powerful and safe tool to use.<\/p>\n<p>The SOLIDWORKS PDM report generator is found in the Microsoft\u00ae Windows Explorer Interface, under the Tools menu, when navigating within the PDM Vault.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33519 size-full\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-148.png\" alt=\"\" width=\"517\" height=\"540\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-148.png 517w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-148-287x300.png 287w\" sizes=\"auto, (max-width: 517px) 100vw, 517px\" \/><\/p>\n<p><strong>How to Modify, or create a Report<\/strong><\/p>\n<p>The sample file, which has several excellent examples, is located in the installation folder of PDM : <em>C:\\Program Files\\SOLIDWORKS Corp\\SOLIDWORKS PDM<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33520 size-full\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-142.png\" alt=\"\" width=\"941\" height=\"91\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-142.png 941w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-142-300x29.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-142-615x59.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-142-768x74.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/2-142-728x70.png 728w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/p>\n<p>To test and become familiar with the tool, you can import the Report Examples file. Once you import the .CRP file the tool will remember the queries you imported automatically until you delete the queries from the tool.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33521 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-128-615x365.png\" alt=\"\" width=\"615\" height=\"365\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-128-615x365.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-128-300x178.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-128-768x455.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-128-728x432.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-128.png 1243w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p>Use any text editor to modify the sample file, such as Notepad. Here I am using Notepad++, but all you need is an editor that can save ANSI formatted text files. The easiest way to get started creating reports is to open the sample \u2018Report Examples 1.crp\u2019 file. You can see how the file is formatted and you can begin to get familiar on how it functions. Make sure you perform a SAVE AS before making any changes because you want to keep the original WORKING queries without corrupting them.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33522 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-117-615x469.png\" alt=\"\" width=\"615\" height=\"469\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-117-615x469.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-117-300x229.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-117-768x586.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-117-728x555.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/4-117.png 1287w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p><strong>Creating a SQL query<\/strong><\/p>\n<p>If you\u2019ve never written SQL queries, or if you\u2019re unfamiliar with SQL Server Management Studio, then we recommend working with someone who is familiar before opening a PDM database. We never recommend performing any unapproved action that performs a change on the database. Remember, you can only use the read-only subset of DML to write these Report queries.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33523 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-98-615x236.png\" alt=\"\" width=\"615\" height=\"236\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-98-615x236.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-98-300x115.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-98-768x295.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-98-728x279.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5-98.png 1343w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p>The query above is extracted from the report \u2018<strong>File details of all files in a project<\/strong>\u2019 to create a stand-alone query inside SQL Server Management Studio. I red-boxed two important components of the query. In this query we want to view the file details of all files within the Speaker folder. First we figure out from the database which ProjectID contains the Speaker folder, which turns out to be 11. Then we use the % symbol to choose all filetypes. This gives us the 5 results on the bottom.<\/p>\n<p>The sample file has most of the commonly used tables which you will use to make report tables. Look through them, write down which tables were used to output what information. This is much better than going table by table in a database.<\/p>\n<p><strong>Variable Declaration: Can prompt for user input<\/strong><\/p>\n<p>Instead of wasting time searching for which ProjectID value corresponded to the Speaker folder, as we did in the example above, we can instead utilize the power of Report arguments. This is very, very useful, and makes life easier for both the programmer and the end user.<\/p>\n<p>Let\u2019s take a look at the query named \u2018<strong>File details of all files in a project<\/strong>\u2019 in the Report Examples file.<\/p>\n<p><span style=\"color: #000000\">\u00a7Arguments<\/span><\/p>\n<p>[<\/p>\n<p>ProjectID <strong>pProjectID<\/strong> [1] [Select folder. E.g &#8220;$\\Documents&#8221;, or browse for folder.]<\/p>\n<p>String <strong>FileExtension<\/strong> [1] [Enter extension of files to list, e.g. &#8220;doc*. Use &#8220;%&#8221; for wildcard.]<\/p>\n<p>]<\/p>\n<p>In the <em>Arguments<\/em> section of the query we declare two variables. One called <strong>pProjectID<\/strong> of predefined type ProjectID, and another named <strong>FileExtension<\/strong> of predefined type String.<\/p>\n<p>After we define these two arguments, next we\u2019ll need to modify the sql query that we created inside SQL Server Management Studio (SSMS). Instead of using the value 9, we substituted the variable pProjectID, surrounded by curly brackets. Next, instead of the percent symbol wildcard we had defined before we insert the variable Filextension with curly brackets. This is shown within the red box highlights below.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33524 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5.1-615x141.png\" alt=\"\" width=\"615\" height=\"141\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5.1-615x141.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5.1-300x69.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5.1-768x176.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5.1-728x167.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/5.1.png 1128w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p>This will now give us the power, and ultimately the user power, to dynamically choose what values to use as query parameters. (In this case which folder to search for, and which filetype to display).<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33525 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/6-68-615x272.png\" alt=\"\" width=\"615\" height=\"272\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/6-68-615x272.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/6-68-300x133.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/6-68-768x340.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/6-68-728x322.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/6-68.png 1243w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p>Here I show the two dynamic arguments in action. This prompts the user to select a folder in which to perform the search. I simply click on the Speaker folder.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33526 size-full\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/7-58.png\" alt=\"\" width=\"497\" height=\"308\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/7-58.png 497w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/7-58-300x186.png 300w\" sizes=\"auto, (max-width: 497px) 100vw, 497px\" \/><\/p>\n<p>Next, it gives us a choice for what file extension to search for. I typed in the percentage sign, which is the wildcard. The result list is shown on the bottom, which corresponded to results from the much more rigidly designed original SQL query from SQL Server Management Studio.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33527 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-45-615x148.png\" alt=\"\" width=\"615\" height=\"148\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-45-615x148.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-45-300x72.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-45-768x185.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-45-728x176.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/8-45.png 1219w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/>The Admin guide also has some excellent examples describing dynamic arguments. The following example is not as elegant, but it shows a more difficult substitution. In the larger redboxed Arguments section we declare the variable <strong>TheGroupID<\/strong> of type GroupID. <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33528 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/9-31-615x414.png\" alt=\"\" width=\"615\" height=\"414\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/9-31-615x414.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/9-31-300x202.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/9-31-768x517.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/9-31-728x490.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/9-31.png 930w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p>On the bottom we show the original SQL, which had rigidly defined the query to only use GroupID 2, but the report query instead utilizes dynamic assignments, which is shown in the curly brackets above. The G.GroupID, TheGroupID, =, OR} simply means that it will find an OR match from the input the user inputted.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33529 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/10-25-615x274.png\" alt=\"\" width=\"615\" height=\"274\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/10-25-615x274.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/10-25-300x134.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/10-25.png 647w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p>The SOLIDWORKS PDM Administration guide lists all the predefined argument types you can use for dynamic arguments. As well as the rules you need to follow to make them work properly.<\/p>\n<hr \/>\n<h1>4. <strong><span style=\"color: #003366\">3DEXPERIENCE SOLIDWORKS &#8220;Rename title&#8221; VS &#8220;SW Title&#8221;<\/span> <\/strong><\/h1>\n<p><em>&#8211; by Ankit GUPTA<\/em><\/p>\n<p>To modify the title of a physical product, we have multiple options like <strong>Rename Title<\/strong> from Feature manager tree and the <strong>SW Title<\/strong> in the <strong>save to 3DExperience<\/strong> dialog box.<\/p>\n<h3><span style=\"color: #003366\"><strong>Rename Title<\/strong><\/span><\/h3>\n<p>When we rename title from Feature manager tree and save it to platform then the <strong>component name<\/strong> and <strong>title<\/strong> will be same as \u201cRename_Title&#8221;. However, the filename remains default &#8220;part1\u201c<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33531 size-large\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-149-615x137.png\" alt=\"\" width=\"615\" height=\"137\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-149-615x137.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-149-300x67.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-149-768x172.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-149-728x163.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/1-149.png 917w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/p>\n<p><strong>Rename title<\/strong> command renames <strong>Title<\/strong> and <strong>Component Name<\/strong> only. However, if you try to save the part locally after using rename title command, then the same is applied to filename (you can make changes to the file name as per requirement ). Filename is generated only once when the file is being saved to the platform and cannot be changed later.<\/p>\n<p>Please refer the following <strong>video<\/strong> for visual demonstration:<\/p>\n<div style=\"width: 1140px;\" class=\"wp-video\"><video class=\"wp-video-shortcode\" id=\"video-33505-1\" width=\"1140\" height=\"641\" preload=\"metadata\" controls=\"controls\"><source type=\"video\/mp4\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/Rename_Title.mp4?_=1\" \/><a href=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/Rename_Title.mp4\">https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/Rename_Title.mp4<\/a><\/video><\/div>\n<h3><span style=\"color: #003366\"><strong>SW Title<\/strong><\/span><\/h3>\n<p><strong>SW Title<\/strong> gives us the capability to make changes to the title if there are components with same details already present on platform. This will allow users to avoid the need to revisit and revise the title.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-33533\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-129-300x93.png\" alt=\"\" width=\"300\" height=\"93\" srcset=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-129-300x93.png 300w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-129-615x191.png 615w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-129-768x239.png 768w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-129-728x226.png 728w, https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/3-129.png 1206w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Now, if you have created a new part and have not saved locally, it means that the file name has not been generated and fixed yet. Therefore, when you apply some name in &#8220;SW Title&#8221; the same will be applied to <strong>Component Name<\/strong> and <strong>Filename<\/strong> as well.<\/p>\n<p>Please refer the following <strong>video<\/strong> for visual demonstration:<\/p>\n<div style=\"width: 1140px;\" class=\"wp-video\"><video class=\"wp-video-shortcode\" id=\"video-33505-2\" width=\"1140\" height=\"641\" preload=\"metadata\" controls=\"controls\"><source type=\"video\/mp4\" src=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/SW_Title.mp4?_=2\" \/><a href=\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/SW_Title.mp4\">https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/SW_Title.mp4<\/a><\/video><\/div>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hello to all, Welcome to the new edition of the SOLIDWORKS\u00ae Support Monthly News! This monthly news blog is co-authored by members of the SOLIDWORKS\u00ae Technical Support teams worldwide. Here is the list of topics covered in this month&#8217;s Blog<\/p>\n... <a href=\"https:\/\/blogs.solidworks.com\/tech\/2023\/10\/solidworks-support-monthly-news-october-2023.html\">Continued<\/a>","protected":false},"author":625,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2498,21,2798,497],"tags":[2967,874,68],"class_list":["post-33505","post","type-post","status-publish","format-standard","hentry","category-3dexperience","category-solidworks","category-solidworks-pdm","category-solidworks-support-monthly-news","tag-3dexperience-solidworks","tag-pdm","tag-solidworks-support"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/33505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/users\/625"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/comments?post=33505"}],"version-history":[{"count":8,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/33505\/revisions"}],"predecessor-version":[{"id":33541,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/33505\/revisions\/33541"}],"wp:attachment":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/media?parent=33505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/categories?post=33505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/tags?post=33505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}