====== Manage Asset Inventory Themes - Client/Server ====== This page documents only additional information for use of Asset Inventory in Client/Server. \\ It is recommended to read first [[224:desktop_ext:asset_inventory:manage_themes|]]. ===== Setup new Master Project ===== === Create Inventory Database === Optionally, you may want to organize each feature extraction project in a separated Inventory Database : - Create Database Structure. Tables will be created by Orbit on Create New Themes. - Setup EOS Database Connection to the newly created Database, see [[224:server:console:resources:database|]]. === Add EOS Resources === Optionally, you may need other GIS reference resources : - Prepare (define Dataset CRS, Legend, ... ) or Optimize resources to be used by Orbit using the Orbit Desktop Client. - Setup EOS Resource Definition, see [[224:server:console:resources:datasets_setup|]]. === Setup EOS Workspace === Optionally, you may want to organize each feature extraction project in a separated Orbit Workspace : - Create new or copy an existing workspace, Extension (Availability and Roles), Resources and Accessibility, see [[224:server:console:workspaces|]]. === Create Inventory Themes ==== Create new Inventory Themes - Close Orbit EOS Console to avoid any EOS Console configuration conflicts! - Start Orbit Desktop Client as Administrator user for both the Asset Inventory and EOS Console, see below "Asset Inventory Roles and Permissions". - Create Themes, see [[224:desktop_ext:asset_inventory:manage_themes|]]. * Select the required database in the final step of the procedure. === Set Theme Permissions === Review Dataset Permissions of newly added Themes. - Setup EOS Resource Definition, see [[224:server:console:resources:datasets_setup|]]. ===== Asset Inventory Roles and Permissions ===== Roles on extensions and permissions on datasets can be managed via the EOS Console, see [[224:server:eos:roles_permissions]]. === Roles on Asset Inventory === * Administrator \\ On top of tools and features available for Users and Operators, the "Administrator" role gives access to the Asset Inventory administration procedures to create, import, export, and remove themes. * Operator \\ On top of tools available for Users, the "Operator" role gives access to the Asset Inventory Procedures to create, edit and remove inventory items. * User \\ The "User" role gives access to the Asset Inventory Tab to search and view inventory items. === EOS Administrator === The Asset Inventory administration procedures, Create, Import, and Remove Theme affect the Orbit EOS configuration. \\ To operate these procedures the user must belong to the EOS usergroup "administrators", see [[224:server:console:index|]]. === File access === At Import and Export Theme the EOS Service requires file access to the selected resource files and/or file directory. Import or Export will be successful if the EOS Service can read the files and directory using the path defined by Desktop Client user. \\ Note mapped network drives are not available to an Operating System service, see [[224:server:eos:service|]] > File Access and Permissions. ===== Asset Inventory Themes and Databases ===== === Inventory databases === Any server side available [[224:technology:core:database_connection|database connection]] can be used as inventory database. No restrictions nor conditions. \\ Define the database connections in the [[224:server:console:resources:database|EOS console > Resources > Databases]]. === Manually Theme Setup === Inventory Themes are special datasets. All "dataset conditions" are automatically fulfilled when using the Asset Inventory administration procedures, see [[224:desktop_ext:asset_inventory:manage_themes|]]. However, it is possible to create and configure manually the Inventory Theme database table scheme. Following conditions must be respected : **Theme Table Scheme** \\ Use the database management tool (Workbench, Navicat, Toad, ...) to update Table Design and Add Table Columns. * Required System Dataset Attribute \\ ''OG_ObBJ_ID'' (integer), ''AIM_CREATE_DATE_TIME'' (string), ''AIM_CREATE_USER'' (string), ''AIM_LAST_MOD_DATE_TIME'' (string), ''AIM_LAST_MOD_USER'' (string), ''AIM_REF_ID'' (string), ''AIM_ANNOTATION'' (string) * Optional Dataset Attributes \\ All Table Columns without the "OG_" or ÄIM_" prefix will be added to the Dataset Attribute Component in Orbit. \\ Attribute Display Name or Rules must be edited directly in the [[224:technology:supported_formats:other:ord|]]. **Theme Declaration** \\ Configure the Dataset as Inventory Theme by adding its internal EOS registry name into the themes.xml configuration file: \\ ''/server/data/datasets/inventories/themes.xml'' **Dataset Legend** \\ Add the dataset (.odb) as Local Resources (not via EOS) to the Orbit Desktop Client and update the Dataset Legend, see [[224:technology:core:local_eos_resources|]]. * To load the odb-resources in the Orbit Desktop Client as a local resource make sure the Database Connection as used by the *.odb file is defined for the Orbit Desktop Client, see [[224:desktop:preferences:database|Database connection]]. * Drag and drop .odb file into Orbit Desktop Client to open, file location : \\ ''/server/data/datasets/inventories'' **Theme Snapshot and Documents** \\ === Snapshots and Documents === Inventory Snapshots and Documents are stored in an open file structure by Inventory Theme and Object ID. \\ The default storage location is : ''/client/data/inventories///'' Storage location and configuration can be adjusted via the according service configuration file((service configuration file : Service configuration updates requires EOS Service restart, see [[224:server:eos:service|]].)). : \\ ''/server/program/services/ext_inventory_suite/properties.ini'' On doing Asset Inventory on large scale (+ 100,000 objects for one Theme) the Theme Snapshot Table can become very large. Indexing database the table columns "Name", "Obj_id" and "Theme" is advised when an Inventory Object insert takes increasingly more time. ===== Convert inventory theme from 3D to 2D ===== A newly created inventory theme is been by default a 3D dataset. All objects will be saved with X,Y and Z. \\ If required it is possible to set the theme to a 2D dataset : === Adjust dataset coordinate model === Edit and adjust the coordinate model tag in the appropriated .odb file from "3D" to "2D" using a text editor. \\ /server/data/datasets/inventories//.odb === Update Z values === Only possible for point datasets. \\ Existing 3D points can be converted into 2D objects by updating their Z values using a database query : Update Set OG_COORD_Z = 0 === Unload dataset ==== Unload the EOS dataset to take advantage of the updated dataset structure, see [[224:server:console:resources:datasets_setup|]]