Due to Tribon (M1, M2, M3) software retirement, the Tribon related marine design forum support has been discontinued.

If you are SP3D, SM3D or Smart3D user or administrator and have some experience working in GWS environment, let us know your opinion about it. Is it trouble less or are there any dificulties while excahnging data between different sites?

Post . . . → Read More: GWS – Global Work Share “to be or not to be”]]> We are doing study about different GWS installations and the users experience.

If you are SP3D, SM3D or Smart3D user or administrator and have some experience working in GWS environment, let us know your opinion about it.
Is it trouble less or are there any dificulties while excahnging data between different sites?

Post your comments here.

I will start with two listings:

ZWCAD - The closest AutoCAD experience and functionalities only at around one-fifth (1/5th) of its price. ZWCAD is a cost-effective, DWG file format compatible CAD solution for the AEC and MCAD industries. Basic drafting . . . → Read More: AutoCAD LT (2D) alternative]]> What other 2D CAD system would you recommend for final drawings touch up?

I will start with two listings:

ZWCAD - The closest AutoCAD experience and functionalities only at around one-fifth (1/5th) of its price.
ZWCAD is a cost-effective, DWG file format compatible CAD solution for the AEC and MCAD industries. Basic drafting functionalities such as creating and editing 2D geometric objects, dimensioning, 3D solid modeling, plotting and file sharing …

With Solid Edge Free 2D Drafting, you can stop paying for upgrades and subscriptions. Packed with 2D translators and import wizards, this free software is perfect for reading AutoCAD data with import support for fonts, color schemes, model space and Color 7. You can even download free updates. So stop paying, but continue to make use of 2D legacy data and share native drawings with suppliers for design review or manufacturing.

While Solid Edge 2D is completely FREE and is able to directly open and save in DWG format, there are a few things to consider. SOme rawing objects created in AutoCAD may not look the same when the DWG is loaded in Solid Edge. The working space, commands , buttons, etc are quite different comparing to AutoCAD. Object created with white color on white background do not automatically appear in black color like in AutoCAD but instead disappear on the screen and also can't be printed.

ZWCAD looks exactly like AutoCAD. Let say 95% the same. However, it is not completely free, but quite less expensive compareing to AutoCAD.

Looking for more suggestions from you.

What CAD/CAM system will replace (or have replaced) Tribon in your office?

Smart Plant/Marine 3D software require the SQL servers where projects/plants database is located to be registered on each client workstation. In the software version up to 9.1 HotFix: ANY it is required to have also SQL 2005 client installed on the workstation.

Writing . . . → Read More: List registered SQL servers using C#]]> Applicable to: SmartMarine 3D, SmartPlant 3D using SQL 2005 client

Smart Plant/Marine 3D software require the SQL servers where projects/plants database is located to be registered on each client workstation. In the software version up to 9.1 HotFix: ANY it is required to have also SQL 2005 client installed on the workstation.

Writing an external add-on software that need to access SQL database (relax – access it read only, creating some kind of reports for example) it woould be useful to get a list of registered servers available to the particular client where the software will be used.

An easy way is to use Microsoft.SqlServer.Management.Smo namespace. Example code follows.

using Microsoft.SqlServer.Management;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Smo.RegisteredServers;

private void Form1_Load(object sender, EventArgs e)
        {

            RegisteredServer[] rsvrs = SqlServerRegistrations.EnumRegisteredServers();

            String localserver = System.Environment.MachineName;

            foreach (RegisteredServer rs in rsvrs)
            {
                string svrname = rs.ServerInstance.Replace(".", localserver)
                                                   .Replace("(local)", localserver)
                                                   .Replace("localhost", localserver);

// Add SQL servers name to checked list box control
if (cklbServers.CheckedItems.Contains(svrname) == false)
                    cklbServers.Items.Add(svrname, CheckState.Unchecked);
            }

        }

To work the above code needs the following DLL to be registered in the C# project

Location: C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies

C# project references

C# project References for enumerating registered SQL servers

Applicable to: SmartPlant 3D , SmartMarine 3D and Smart 3D design systems.

Create equipment list including equimpment description. The information is stored in two different tables in projects' (plants' ) database – XXXX_MDB. The table view JNamedItem contain all items names and their IDs – . . . → Read More: Smart Marine 3D beginners SQL quick start]]> Some simple SQL queries that can help new users start faster.

Applicable to: SmartPlant 3D , SmartMarine 3D and Smart 3D design systems.

Create equipment list including equimpment description. The information is stored in two different tables in projects' (plants' ) database – XXXX_MDB. The table view JNamedItem contain all items names and their IDs – oid. The equipment data is read from JEquipment. Table view JEquipment has information for the equipment ID but not for its name. Read ItemName from JNamedItem and match the object IDs 'oid' from both tables views.

Example SQL query:

SELECT ItemName, Description

FROM

JEquipment eqp,

JNamedItem nam

Where

eqp.oid=nam.oid

Order by 

ItemName

See also how to create SQL filter for use in SM3D (SP3D) workspace. The filter lists all objects created or modified during the last few hours.

Product: SmartMarine 3D, SmartPlant 3D (SM3D, SP3D)

Task: Get list of deleted objects by specific user or/and on specific date and time A list of the deleted objects is avalable from project’s Reports database ( xxxx_RDB ).

Use SQL Server Managment Studio to execute the following SQL query on the . . . → Read More: SmartMarine 3D – Get list of deleted objects by user, date and time]]> DB platform: MS SQL server

Product: SmartMarine 3D, SmartPlant 3D (SM3D, SP3D)

Task: Get list of deleted objects by specific user or/and on specific date and time


A list of the deleted objects is avalable from project’s Reports database ( xxxx_RDB ).

Use SQL Server Managment Studio to execute the following SQL query on the project’s RDB

SELECT     oid, DeletedBy, DateDeleted, DBType
FROM         JDeletedObjects
WHERE     (DateDeleted > CAST(’2011-11-10 06:00:00′ AS datetime)) AND (DateDeleted < CAST(’2011-11-10 09:00:00′ AS datetime))
ORDER BY DateDeleted

In SQL Manager, right click on the database name and select “New Query” command. Then in the query window, paste the above code and modify the data and time accordingly. When ready, right click and select “Execute”.

Note: The time used to store objects in SQL is the GMT time. If your local time zone is GMT+N hours, to get corect results from the SQL query, the time specified in the query has to be (minus) -N hours and vice versa, if your local time is GMT-N hours, then add N hours to the time specified in the query.

In the example screenshot below the users’ names are deleted from the image.

Note, the history stored in RDB JDeletedObjects will be dismissed on performing database maintenance using the option “Delete database objects that users have deleted from model”.

When you download, copy, run or use by any other way, any of the applications listed above, you automatically agree to the following terms and conditions Check also what to expect when the time limited license expire.