By Mario Iocco<\/em><\/p>\n\n\n\n By Shreyas Bhagwat<\/em><\/p>\n\n\n\n SOLIDWORKS Rx Extended Logging Data<\/strong><\/p>\n\n\n\n When performing a SOLIDWORKS Rx Problem Capture, you may have noticed the option \u2018Include extended logging data\u2019. When \u2018Include extended logging data\u2019 is enabled, SOLIDWORKS Rx logs disk and CPU activity (performance profiling data) and packages that data with other information for you to send to SOLIDWORKS Technical Support. This option creates a Windows Performance Analyzer Trace (*.ETL) file, which is useful for diagnosing startup problems, machine-specific issues, and performance related problems.<\/p>\n\n\n\n This option is disabled by default in SOLIDWORKS i.e. the Rx Problem Capture does not capture performance profiling information. The information is logged only if the option is enabled.<\/p>\n\n\n\n For some computers, either you may notice, this option is greyed out or you get an error\/warning message saying \u2018Extended logging cannot be enabled on this computer due to missing windows settings\u2019. This error is usually the result of missing prerequisite of SOLIDWORKS \u2013 \u2018Windows Performance Toolkit\u2019 or WPT.<\/p>\n\n\n\n The WPT installs three performance-monitoring tools:<\/p>\n\n\n\n Use either the Windows Performance Analyzer tool or the GPU View tool to view the*.ETL files. For more information about the WPT software, see the \u201cWPT Technical Reference\u201d at the following link.<\/p>\n\n\n\n By James Falconer<\/em><\/p>\n\n\n\n The report tool in SOLIDWORKS PDM Professional allows users users to create, save, and print detailed information about files from the Microsoft SQL database. It is a great substitute to use instead of SQL server management studio for the extraction of information from a database. Instead of wasting time by manually searching which ProjectID value corresponded to the PDMWorks folder in SQL Server Management Studio, we can instead utilize the power of Report arguments. This is quite useful, and can make life easier for both the programmer and the end user.<\/p>\n\n\n\n In the Arguments section we declare two variables. One called pProjectID of predefined type ProjectID, and another named FileExtension of predefined type String.<\/p>\n\n\n\n [<\/strong><\/p>\n\n\n\n ProjectID pProjectID [1] [Select folder. E.g \u201c$\\Documents\u201d, or browse for folder.]<\/strong><\/p>\n\n\n\n String FileExtension [1] [Enter extension of files to list, e.g. \u201cdoc*. Use \u201c%\u201d for wildcard.]<\/strong><\/p>\n\n\n\n ]<\/strong><\/p>\n\n\n\n After we define these two arguments, next we\u2019ll need to modify the sql query that we pasted from SSMS. Instead of using the value 7, we substituted the variable pProjectID, surrounded by curly brackets. Next, instead of the percent symbol wildcard we had previously defined we insert the variable Filextension with curly brackets. This is shown within the red box highlights below.<\/p>\n\n\n\n This will now give the user the power to dynamically choose what values to use as query parameters. In this case which folder to search for, and which filetype to display.<\/p>\n\n\n\n <\/strong>The query below is extracted from the same report \u2018File details of all files in a project\u2019. I red boxed two important components of the query. In this query we want to view the file details of all files within the PDMWorks folder. First we figure out from the database which ProjectID is the PDMWorks folder, which turns out to be 7. Then we use the % symbol to choose all filetypes. This gives us the 5 results on the bottom.<\/p>\n\n\n\n Dynamic Arguments in Action<\/strong><\/p>\n\n\n\n The following screenshot illustrates running the report \u2018File details of all files in a project\u2019 which uses dynamic arguments. When you run the report a window will pop up which asks for the name of the folder to run the report, or you can manually browse to it. In this case we selected the browse ellipses.<\/p>\n\n\n\n Then we select the file extension to list. In this case we used the % wildcard.<\/p>\n\n\n\n Once we select the file extension the Report Generator presents the result set, as shown below. The results correspond exactly to the much more rigidly designed original SQL query.<\/p>\n\n\n\n Shown below is the listing of predefined variables. These are the variables we referenced within curly brackets in the sql section, and defined within the arguments section. Fortunately they are self-explanatory. For example, FileID is the numerical value for each file stored within the vault, UserID is the userid value, ProjectID is the numerical value for the folder, etc.<\/p>\n\n\n\n Also note the rules for argument definition.<\/p>\n\n\n\n The SOLIDWORKS PDM Admin Guide goes through another example, of more complexity, and is helpful for anyone wanting to provide this powerful feature to their users.<\/p>\n\n\n\n By Rohit Magar<\/em><\/p>\n\n\n\n SOLIDWORKS Manage needs to synchronize to the vault database to import many details of the vault including users, groups, folder structures, variables and permissions.<\/p>\n\n\n\n While working in SOLIDWORKS Manage, \u201cEnable Synchronization and get all SW PDM objects\u201d is only visible after the PDM Object has been created and used where a manual synchronization of the PDM object is required in order to ensure everything is updated between SOLIDWORKS Manage and PDM. This option is used to enable the SQL Database Triggers between the SOLIDWORKS PDM and SOLIDWORKS Manage SQL Databases.<\/p>\n\n\n\n How to run a synchronization of a SOLIDWORKS PDM object:<\/strong><\/p>\n\n\n\n Within SOLIDWORKS Manage go to Options > Administrative Options,<\/p>\n\n\n\n SOLIDWORKS Manage Administrative Options > Structures > Documents & Records > Select the PDM Object > Edit using RMB or double click.<\/p>\n\n\n\n SOLIDWORKS PDM Configuration Wizard > Connection.<\/p>\n\n\n\n Methods to perform synchronization:<\/strong><\/p>\n\n\n\n Show synchronization steps. Use this setting to display each step of the synchronization. This can be helpful to better understand the progress for larger SOLIDWORKS PDM Professional vault databases that may take several hours for the synchronization to complete.<\/p>\n\n\n\n Quick Synchronization method:<\/strong><\/p>\n\n\n\n If the option \u2018show synchronization steps\u2019 is not selected, this is also known as \u201cQuick Synchronization\u201d method. Clicking the \u2018Enable Synchronization and get all SW PDM objects\u2019 button will first prompt the user to confirm this method, it will then disable all objects on this page, show the start time and start the synchronization. When completed it will show the end time. This procedure may take from seconds to hours, depending on the size of the PDM Vault.<\/p>\n\n\n\n Standard Synchronization method:<\/strong><\/p>\n\n\n\n If the option \u2018show synchronization steps\u2019 is selected, new tab will open. This tab by default selects all items on the list. Select or unselect options as required and click \u201cSynchronize\u201d button.<\/p>\n\n\n\n The Standard method gives more flexibility when only a specific folder needs to be synchronized or certain procedures. Both methods perform the same actions, if all items are selected in the Standard method. If all items are selected then the Quick method will be faster.<\/p>\n\n\n\n When I connect to a 3DEXPERIENCE\u00ae R2022 On Cloud platform in mainland China with the Collaborative Designer for SOLIDWORKS role, why does the \u2018MySession\u2019 app not load?<\/strong><\/p>\n\n\n\n The behavior occurs when using the SOLIDWORKS\u00ae 2021 SP5.1 or SOLIDWORKS 2022 SP0.0 software. To get more information, see Solution ID: S-079550<\/a><\/p>\n\n\n\n Why can I not rename components in the SOLIDWORKS\u00ae FeatureManager\u00ae design tree? Using the SOLIDWORKS\u00ae PDM 2021 SP4.1 and SP5.1 software, what could cause Windows\u00ae File Explorer to crash when I add, check in or undo check out certain PDF files in a file vault view?<\/strong><\/p>\n\n\n\n The SOLIDWORKS\u00ae PDM 2021 SP4.1 and SP5.1 client software could have stability problems in Windows\u00ae File Explorer when you work with PDF files in a file vault view. To get more information, see Solution ID: S-079532<\/a><\/p>\n\n\n\n Is there an example of a validation of the displacement results of a cantilever beam with a nonsymmetrical cross section?<\/strong><\/p>\n\n\n\n![\"\"](\"http:\/\/blogs.solidworks.com\/tech\/wp-content\/uploads\/sites\/4\/Master-Image.jpg\")
<\/a><\/figure>\n\n\n\nSOLIDWORKS RX Extended Logging Data<\/strong><\/h1>\n\n\n\n
<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\nSOLIDWORKS PDM Report Query Arguments<\/strong><\/h1>\n\n\n\n
Reports utilize the read-only subset of DML in Microsoft T-SQL, which means there is no risk that a user will make a change in the database from writing or running these scripts.
Another advantage to running reports is that we can utilize the power of Report Query Arguments. This capability allows us to dynamically choose values to use as query parameters. This is very, very useful, and makes life easier for both the programmer and the end user.
Detailed information on how to use and create reports can be found in the SOLIDWORKS PDM Administration Guide, under Chapter 3 (Vaults). The example we will discuss can be found in the PDM installation directory; C:\\Program Files\\SOLIDWORKS PDM\\Report Examples 1.crp
The following image shows a basic structure of a query. This article will focus on Step 6, the query argument tool that Prompts the User for input.<\/p>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\nHow to perform a synchronization between SOLIDWORKS Manage and SOLIDWORKS PDM?<\/strong><\/h1>\n\n\n\n
<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\nNoteworthy Solutions from the SOLIDWORKS Knowledge Base<\/strong><\/h1>\n\n\n\n
<\/strong>After installing the 3DEXPERIENCE\u00ae add-in, the SOLIDWORKS\u00ae option \u2018Allow component files to be renamed from FeatureManager tree\u2019 (\u2018Tools\u2019 > \u2018Options\u2019 > \u2018System Options\u2019 > \u2018FeatureManager\u2019) appears inactive. To get more information, see Solution ID: S-079536<\/a><\/p>\n\n\n\n