{"id":31776,"date":"2022-10-13T01:23:19","date_gmt":"2022-10-13T05:23:19","guid":{"rendered":"https:\/\/blogs.solidworks.com\/tech\/?p=31776"},"modified":"2023-01-11T23:59:30","modified_gmt":"2023-01-12T04:59:30","slug":"solidworks-support-monthly-news-october-2022","status":"publish","type":"post","link":"https:\/\/blogs.solidworks.com\/tech\/2022\/10\/solidworks-support-monthly-news-october-2022.html","title":{"rendered":"SOLIDWORKS\u00ae Support Monthly News – October 2022"},"content":{"rendered":"

Hello to all,<\/p>\n

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’s Blog.<\/strong><\/p>\n

    \n
  1. \n

    How can I apply decal on part face excluding its background color in SOLIDWORKS\u00ae Visualize?<\/span><\/h2>\n<\/li>\n
  2. \n

    Workaround to obtain the reaction moment on a fixed face having SOLID mesh.<\/span><\/h2>\n<\/li>\n
  3. \n

    Overriding quantity using UNIT_OF_MEASURE custom property in PDM.<\/span><\/h2>\n<\/li>\n
  4. \n

    How to ensure a SOLIDWORKS PDM system can reach the correct TCP port of a SQL instance?<\/span><\/h2>\n<\/li>\n<\/ol>\n

    How can I apply decal on part face excluding its background color in SOLIDWORKS\u00ae Visualize?<\/strong><\/h1>\n
    By Vinod KALE<\/em><\/h5>\n

    Recently, there was a requirement where the user wanted to remove the background color of logo from the decal (refer the above image showing white color around text) in SOLIDWORKS\u00ae<\/strong> Visualize.<\/p>\n

    \"\"<\/p>\n

    SOLIDWORKS\u00ae Visualize<\/strong> allows you to generate photo-quality images from the 3D CAD data. If you want to make any changes in the existing image that is not created from Visualize, you have to make use of Photo Editor applications (like Photoshop, Photopea, etc.) and then use that image in Visualize to get the desired output.<\/p>\n

    There are few ways you can insert decal without its background:<\/p>\n

    A. Create a decal with mask in SOLIDWORKS\u00ae > Insert decal on part face > Export the part to Visualize using its add-in.<\/strong><\/p>\n

    \"\"<\/p>\n

    Use following steps to create decal with mask:<\/p>\n

      \n
    1. In the Task Pane in SOLIDWORKS\u00ae<\/strong>, select the Appearances, Scenes, and Decals tab<\/li>\n
    2. Expand Decals and select the decals folder or a folder containing custom decals<\/li>\n
    3. In the lower pane, identify the decal and drag it onto part face<\/li>\n
    4. In the Decals PropertyManager, in the Image tab under \u2018Mask Image\u2019, Click Selective color mask<\/li>\n
    5. Double-click the rectangular boxes to the right of Pick color<\/li>\n
    6. In the Color dialog box, select the color, Click OK<\/li>\n
    7. Items of the selected color are removed from the Decal Preview (but still some background color appear around alphabet)<\/li>\n
    8. Open the decal image in MS Paint<\/li>\n
    9. File > Save the image to \u2018Monochrome Bitmap\u2019 format<\/li>\n
    10. Edit the inserted decal in SOLIDWORKS\u00ae<\/strong> > Select the \u2018Image mask file\u2019 under \u2018Mask Image\u2019 > Browse the mask file (Monochrome Bitmap) > Check \u2018Invert mask\u2019 option > Observe the background color around logo is now removed correctly.<\/li>\n<\/ol>\n

      B. The other way is to use \u2018Online Photo Editor\u2019 to remove background color from the decal image.<\/strong><\/p>\n

        \n
      1. a. Go to Photopea website and launch this online photo editor application<\/li>\n
      2. Open the decal image.<\/li>\n
      3. Create new layer and switch back to the Background layer.<\/li>\n
      4. Click on the \u201cMagic Wand\u201d tool and select the logo related text from the image.<\/li>\n
      5. Switch to \u2018Layer 1\u2019.<\/li>\n
      6. Select the \u2018Paint Bucket Tool\u2019 and click on same alphabet. Observe some text gets added to new layer.<\/li>\n
      7. Switch back to Background layer and repeat steps from \u2018c\u2019 to \u2018e\u2019 to add entire text.<\/li>\n
      8. Once all alphabets are added to new layer, toggle the show\/hide icon in Background layer to confirm that text displays correctly without its background color.<\/li>\n
      9. File -> Export -> Save as PNG. Then use this image when inserting decal on part face in SOLIDWORKS\u00ae<\/strong> Visualize as shown in this image.<\/li>\n<\/ol>\n

        \"\"<\/p>\n

        Workaround to obtain the reaction moment on a fixed face having SOLID mesh<\/strong><\/h1>\n
        By Suresh NIKALAJE<\/em><\/h5>\n

        As we know, it is not possible to get the reaction moment on a fixed face of a solid mesh using the Reaction Force option. In SOLIDWORKS\u00ae Simulation, the nodes of solid elements have no degree of freedom in rotation (have only three translations degrees of freedom), therefore, the nodes on the face of a solid cannot have any nodal reaction moment. The Reaction Moment values are null if the selection is the face of a solid.<\/p>\n

        On the other hand, for the nodes on SHELLS (including sheet metal) and for nodes on BEAMS have 6 degrees of freedom per node (3 translations, 3 rotations). Therefore, you can plot, probe and list the Reaction moment on nodes that belong to shell and beam elements.<\/p>\n

        Even with this limitation of SOLID mesh,<\/strong> do you know the result force PropertyManager allows you to get the reaction moment on a fixed face using the \u2018Free Body Force\u2019 option?<\/p>\n

        If you want the reaction moment on a fixed face in you model, then follow this procedure:<\/p>\n

          \n
        1. Create a \u2018Point\u2019 at the geometrical center of the face. [Go to Insert > Reference Geometry > Point & selects the Center of Face construction method in the PropertyManager]<\/li>\n
        2. If the direction of the reaction moment you want are not aligned with global coordinate system, then create new with the orientation you desired.<\/li>\n
        3. In the Simulation Manager tree, right click on the Results<\/strong> folder and select List Results Force<\/strong><\/li>\n
        4. Select \u2018Free body force\u2019<\/strong> as the option. Select the ‘Point’ you created in the \u2018Vertex of Reference Point for Location of Moment\u2019<\/strong> field, select the newly created coordinate system in the \u2018Plane, Axis or Coordinate System\u2019<\/strong> fields and select the fixed face.<\/li>\n
        5. The magnitude<\/strong> of moment components and resultant are listed in the Free body moment table.<\/li>\n<\/ol>\n

          For example,<\/strong> the expected reaction moment of a cantilever T beam of length L = 2000″ subjected to a force of 100 lbs acting on its free end is 2E+05 Ibf.in<\/strong> as see in following image.<\/p>\n

          \"\"<\/p>\n

          \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Fig 1: Reaction Moment using BEAM mesh<\/em><\/strong><\/h6>\n

          After creating new point at \u2018Point\u2019 at the geometrical center of the T face at fixed end, the Free body moment table shows expected reaction moment as 2 E+05 Ibf.in as shown below.<\/p>\n

          \"\"<\/p>\n

          \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 Fig 2: Reaction Moment using SOLID mesh<\/strong><\/em><\/h6>\n

          Note:<\/strong> To download the \u2018Bending of a T Section Beam\u2019 example model, browse to [drive letter:\\Users\\Public\\Public Documents\\SOLIDWORKS\\SOLIDWORKS version\\samples\\Simulation Examples\\Verification\\Static_8.SLDPRT].<\/p>\n

          Overriding quantity using UNIT_OF_MEASURE custom property in PDM<\/strong><\/h1>\n
          By James FALCONER<\/em><\/h5>\n

          In SOLIDWORKS\u00ae<\/strong>, you can use the BOM Quantity override to display quantities instead of instance counts. A SOLIDWORKS\u00ae<\/strong> PDM computed BOM takes advantage of this feature when you map the part data card to the UNIT_OF_MEASURE property. The custom property UNIT_OF_MEASURE has a surprisingly powerful feature that not everyone may know about.<\/p>\n

          This feature is discussed in the SOLIDWORKS\u00ae<\/strong> PDM Admin Guide, but due to its brevity, could easily be missed:<\/p>\n

          \"\"<\/p>\n

          In SOLIDWORKS\u00ae<\/strong> PDM the quantity value is determined by the instance count of the file. But sometimes you may want to show an amount, such as length or quantity, instead of the instance count. The following steps will show us how PDM computed BOMs can provide a value by using a SOLIDWORKS\u00ae<\/strong> custom property. Let\u2019s start by showing how BOM Quantity override works in SOLIDWORKS\u00ae<\/strong>.<\/p>\n

          For this example we\u2019ll use the basic speaker assembly that is included in most SOLIDWORKS\u00ae<\/strong> installations and found in the folder C:\\Users\\Public\\Documents\\SOLIDWORKS\\SOLIDWORKS 2022\\samples\\tutorial\\PDMWorks. Add and check these files into a PDM vault.<\/p>\n

          Open and check out speaker.sldasm main assembly and add 2 more instances of the magnet file by going to Insert > Component > Existing Part and select magnet.sldprt. Also, add an assembly BOM table. See the quantity value of 3 for magnet. This means there are 3 instances of Magnet in this assembly.<\/p>\n

          \"\"<\/p>\n

          What if we wanted to override each instance with a different base quantity value? <\/strong>Close the assembly. Open and check out the magnet.sldprt file and create a Custom Property value named QT with a value of 100. Note BOM quantity override is by default set to \u2013 None -.<\/p>\n

          \"\"<\/p>\n

          Select BOM quantity: QT as marked below & click OK. (Note BOM Quantity overrides the base quantity value). What this does is that the BOM quantity QT is overridden with the value of 100. These steps will be repeated for each file that needs to show a custom value for its quantity in a BOM. Save & check the file in.<\/p>\n

          \"\"<\/p>\n

          Now, when we reopen the assembly we will see the overridden BOM quantity value of 300.<\/p>\n

          \"\"<\/p>\n

          When this data set is stored in a default SOLIDWORKS\u00ae<\/strong> PDM vault, the default SOLIDWORKS\u00ae<\/strong> part card will automatically use the overridden BOM quantity value and display the 300 value.<\/p>\n

          \"\"<\/p>\n

          So how can we make use of this feature in other files, vaults, and data cards?<\/strong> In the PDM Admin Tool open the Card Editor and select the default SOLIDWORKS Part Data card: The CustomProperty UNIT_OF_MEASURE attribute will need to be used to override quantity value as described previously.<\/p>\n

            \n
          1. Create a variable, named for example \u201cBOM Quantity.<\/li>\n
          2. Add a variable mapping with block \u201cCustomProperty\u201d, the attribute \u201cUNIT_OF_MEASURE and the extension \u201cSLDPRT\u201d. Please note that this will be a read-only variable mapping and you cannot override this value via the data card.<\/li>\n
          3. Add the variable to the SOLIDWORKS\u00ae<\/strong> part data card (.sldprt)<\/li>\n<\/ol>\n

            \"\"<\/p>\n

            If we did not use the UNIT_OF_MEASURE override for the BOM Quantity variable, then we would have seen the regular instance count of magnet.sldprt as seen below (3).<\/p>\n

            \"\"<\/p>\n

            How to ensure a SOLIDWORKS\u00ae PDM system can reach the correct TCP port of a SQL instance<\/strong><\/h1>\n
            By Tor IVEROTH<\/em><\/h5>\n

            In order to communicate with the SQL server and access the file vault database, a SOLIDWORKS\u00ae<\/strong> PDM system establishes an ODBC connection over the TCP protocol to the SQL server instance name that is stored in the registry.<\/p>\n

            The SQL server instance listens on a specific TCP port. If the client system (or a server) cannot find the correct port to communicate over, log in to the vault will fail with various ODBC related communication errors.<\/p>\n

            Some examples of errors<\/strong> that you would encounter if the system cannot reach the SQL server port are:<\/p>\n

            With SOLIDWORKS\u00ae PDM 2020 and later<\/span>:<\/strong> The database access error would reference \u201cODBC Driver 17 for SQL Server\u201d<\/p>\n

            \"\"<\/p>\n

            \"\"<\/p>\n

            With SOLIDWORKS\u00ae PDM 2019 and earlier : <\/span><\/strong>The database access error would reference \u201cODBC SQL Server Driver\u201d.<\/p>\n

            \"\"<\/p>\n

            \"\"<\/p>\n

            Use the following troubleshooting guidelines to address this problem<\/strong>:<\/p>\n

            A \u2013 Start the SQL Server Browser service: <\/strong>The SQL Server Browser Service will broadcast the current SQL ports for each SQL instance on the Server. Make sure the service is started on the SQL server.<\/p>\n

            \"\"<\/p>\n

            B \u2013 Confirm the SQL Server Instance name: <\/strong>The SQL server name will be in the form of a default instance name (SERVERNAME)<\/strong> or a named instance (SERVERNAME\\INSTANCE)<\/strong>.<\/p>\n

            When you create a vault view, or attach to an archive server, the SQL instance name will be stored in the registry. Make note of which SQL server name that the vault is using.<\/p>\n

            The connection details for the local file vault view of the vault:<\/span><\/p>\n

            \u201cDbServer\u201d value under key: HKEY_LOCAL_MACHINE\\SOFTWARE\\SolidWorks\\Applications\\PDMWorks Enterprise\\Databases\\[VAULTNAME]<\/p>\n

            \"\"<\/p>\n

            The connection details for the vault on the archive server:<\/span><\/p>\n

            \u201cDbServer\u201d value under key: HKEY_LOCAL_MACHINE\\SOFTWARE\\SolidWorks\\Applications\\PDMWorks Enterprise\\ArchiveServer\\Vaults\\[VAULTNAME]<\/p>\n

            \"\"<\/p>\n

            The connection details for the Database Server Service:<\/span><\/p>\n

            \u201cServer\u201d value under key: HKEY_LOCAL_MACHINE\\SOFTWARE\\SolidWorks\\Applications\\PDMWorks Enterprise\\MailService<\/p>\n

            \"\"<\/p>\n

            C \u2013 Verify the SQL instance TCP port: <\/strong>You can see what port the SQL server instance is currently listening on via the SQL log file (for more details, refer to Knowledge Base Solution S-051979).<\/p>\n

            In this example, the SQL Server named instance VM-TIV-PDM\\SQLEXPRESS2019<\/strong> is listening on port 55206<\/strong><\/p>\n

            \"\"<\/p>\n

            Alternatively, you can find the current port via the SQL configuration manager, SQL Server Network Configuration, Protocols for SQLSERVERNAME, TCP, IP Addresses.<\/p>\n

            \"\"<\/p>\n

            D \u2013 Make sure the system can reach the TCP port: <\/strong>Now that you know the correct SQL name and SQL port, the client system (or remote server) must be able to communicate over the specific TCP port that the SQL instance listens on. The easiest method to ensure the system can reach the SQL port is to use the SOLIDWORKS\u00ae<\/strong> PDM Connectivity Test Tool. You can find this tool in Knowledge Base Solution S-069274.<\/p>\n

            Run the tool and select the \u201cSQL Server\u201d option. Fill in the hostname of the SQL Server (note that if the SQL Server is a named instance (I.e. VM-TIV-PDM\\SQLEXPRESS2019), you should only fill in the server hostname (i.e. VM-TIV-PDM) in this field. Fill in the port to test (from step C).<\/p>\n

            If the port is accessible, the tool should show a success result.<\/p>\n

            \"\"<\/p>\n

            If the port is inaccessible, the test will fail. You should double check that you are connecting to the correct port (step C) and that the port is not blocked in the network (by firewall rule or similar). For example, this image shows that this system cannot connect to TCP port 42045.<\/p>\n

            \"\"<\/p>\n

            E \u2013 Create an ODBC connection alias: <\/strong>If the SQL TCP port is accessible, but the ODBC connection still fails, you should create an ODBC Alias in order for the system to use the correct port. An ODBC Alias maps the SQL instance name to a specified port number.<\/p>\n

            In this example, the SQL server host (VM-TIV-PDM) and the SQL instance port (55206) can be connected to, but the SQL instance name (VM-TIV-PDM\\SQLEXPRESS2019) cannot be resolved to the proper port. The connectivity test tool will have a similar error that the PDM client log shows.<\/p>\n

            \"\"<\/p>\n

            To create the ODBC Alias:<\/strong><\/p>\n

              \n
            1. Read over the document in Knowledge Base Solution S-042701.<\/li>\n
            2. Focus on the chapter \u201cCreating an ODBC alias when using the using ODBC 17 (msodbcsql17.dll) driver\u201d
              \n
              \n

              \"\"<\/p>\n

              \n<\/li>\n
            3. Create the ODBC alias on the system that cannot establish an ODBC connection with the SQL server instance. Update with the SQL instance name (see step B) and the correct port (step C). For example, the ODBC Alias for an SQL instance named \u201cVM-TIV-PDM\\SQLEXPRESS2019\u201d to port \u201c55206\u201d should look like this under both the 64-bit and 32-bit registry (name should be: VM-TIV-PDM\\SQLEXPRESS2019 and the data value should have: DBMSSOCN, VM-TIV-<\/li>\n<\/ol>\n

              \"\"<\/p>\n

              With the ODBC alias correctly defined, the connectivity test tool should now successfully connect to the SQL instance name, the port and successfully establish an ODBC connection.<\/p>\n

              \"\"<\/p>\n

              The vault should now be accessible via the administration tool or local vault view.<\/p>\n

              \"\"<\/p>\n

              If you are still unable to connect<\/strong>: Go over the chapter \u201cAfter Installing SQL Server Express\u201d in the install guide and make sure remote connections are allowed and that the TCP protocol is enabled.<\/p>\n

              Noteworthy Solutions from the SOLIDWORKS\u00ae Knowledge Base<\/strong><\/h1>\n

              \u00a0\"\" When I use the SOLIDWORKS\u00ae PDM quick search or integrated search functionality, why do the SOLIDWORKS file open or save dialog boxes stop responding (hangs or crashes)?<\/strong>This problem can happen on a SOLIDWORKS\u00ae PDM client workstation if the file type associations for SOLIDWORKS files are incorrect. To get more information, see solution ID: S-079778<\/a><\/p>\n

              \"\"What can I do if every SOLIDWORKS\u00ae Flow Simulation project I run shows a \u2018Preparing model\u2019 Solver Monitor status indefinitely and any FloXpress analysis never finishes the \u2018Meshing in progress\u2019 step? <\/strong>To get more information, see solution ID: S-079776<\/a><\/p>\n

              \u00a0\"\" Is there a SolidPractices document available on the topic of \u201cSOLIDWORKS Toolbox\u201d?<\/strong> The objective of this SolidPractices document is to share information that relates to setting up the SOLIDWORKS\u00ae Toolbox (\u201cthe Toolbox\u201d). To get more information, see solution ID: S-078795<\/a><\/p>\n

              \u00a0\"\"When I click \u2018New Inspection Project\u2019 in the SOLIDWORKS\u00ae Inspection addin toolbar, why is there no template listed from Project Template Selection PropertyManager?<\/strong> To get more information, see solution ID: S-079716<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

              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’s Blog.<\/p>\n... 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":[21,30,497,1577],"tags":[874,893,1082],"class_list":["post-31776","post","type-post","status-publish","format-standard","hentry","category-solidworks","category-solidworks-simulation","category-solidworks-support-monthly-news","category-solidworks-visualize","tag-pdm","tag-solidworks-simulation","tag-solidworks-visualize"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/31776","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=31776"}],"version-history":[{"count":24,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/31776\/revisions"}],"predecessor-version":[{"id":32338,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/31776\/revisions\/32338"}],"wp:attachment":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/media?parent=31776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/categories?post=31776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/tags?post=31776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}