ENOVIA SmarTeam Excel Add-in Problems
ENOVIA SmarTeam has a number of integrations to third party software applications like CAD, Microsoft Word, and Microsoft Excel. Occasionally, after installing SmarTeam Editor with the Microsoft Excel Add-in or PLMDB Add-in for Excel, the add-ins may not appear when loading Microsoft Excel. This can happen to either add-in, or both at the same time. Luckily, one solution to this problem is relatively simple – although it does involve the Windows Registry. Continue Reading
The Macmillan dictionary defines surface area as the total area of a surface or surfaces, especially the outside surfaces of an object. If we apply this definition to the world of IT security, it refers to the amount of exposure a system has to potential attackers. In Microsoft SQL Server, there are a number of services, ports, and connections that can be configured to control how much “surface area” is exposed. 
SmarTeam Specification Links are a special type of link between Items and the Documents that describe or specify them in ENOVIA SmarTeam. These links are important to the item-centric functionality of the ENOVIA SmarTeam BOM module. The idea behind the special link is that you can enforce rules that control the lifecycle of the Item based on the state of the specified Documents. For instance, you can prevent an Item from being promoted if a related specifying Document is not Released first. These links are great, but how can you search and find them? 
If you’ve ever tried to pack up and move a SQL Server database from one computer to another, you’ve probably noticed that the permissions and users won’t line up between the two machines. Even if you create accounts with the same usernames on the target machine, the users from one SQL Server are not recognized by the other. As a result, you receive error messages like, ‘Login failed for user USERNAME’. 
We regularly have clients ask us what information they should gather concerning a support issue, prior to calling the Razorleaf helpdesk. So we thought it made sense to answer that question publicly. Here’s how you can “help us, help you.” 
Have you ever wanted to globally replace one value with another inside of a database? Have you ever wanted to globally alter string data, replacing one word with another in a database? If so, the SQL Replace statement could be just what you’re looking for! It allows you to search for one string within another and either remove the string or replace it with a different string. The Replace() statement is available for use on most major database management systems in use today, including Microsoft SQL Server and Oracle. 
During a recent SmarTeam implementation, we encountered an issue when using Microsoft BizTalk Server to exchange data between ENOVIA SmarTeam and an ERP system. A couple of simple SmarTeam configuration changes later, and the problem was solved. Here’s the scenario:
