Create Hull Top Level Elements with DbPrompt

The various Hull data is organized in the databases hierarchy under different top-level elements. For instance all RSOs are organized under an RSO top-level element of type RSO-World (RSOWLD), surfaces under a surface-world and panels are organized under Blocks. For full details on the different top-level elements, please consult the Hull in Dabacon overview.

The various Hull data is also distributed across multiple databases for access-rights and performance reasons. More details on the subject are available in the Administrator User Guide.

DbPrompt is the utility to use to organize your top-level nodes. The tool can be used to interactively create and remove (empty) top-level nodes, export and import definitions on command-line and validate that all necessary top-level elements are in place.

DbPrompt should be used to manage Marine top-level nodes in the DESIgn and MANUfacturing databases.

Example:

dbprompt -proj=XXX -user=SYSTEM -pass=XXXXXX -mdb=/XXX

Figure 4:1. Add a top-level node (RSOWLD)

From DbPrompt, you can export and import top-level node definitions in csv-format, suitable for editing in Excel.

DbPrompt can also be executed on command-line to export and/or import top-level node definitions. The command is then extended by the two optional parameters -in and -out.

Note: The -in parameter is processed before the -out, that means, the csv-file is first imported, before the output csv-file is generated.

Example:

dbprompt -in=top_in.csv -out=top_out.csv -proj=xxx

Figure 4:2. Editing the csv-file using Excel