====== Manage Asset Inventory (Client/Server) ====== \\ This page is only relevant for Orbit Asset Inventory in Client Server \\ Equivalent documentation for standalone : [[111:mobile_mapping:desktop:asset_inventory:manage:manage_asset_inventory_sa|]] ===== Setup a new master project ===== === Create Inventory Database === Optionally you may want to create a new separated database to use for a specific data production project. \\ If you do so, establish the EOS database connection to the newly created database via [[111:eos:console:resources:database|EOS Console > Resources > Database Connection]]. === Add EOS Resources === Optionally you may want to add available GIS resources for this project. \\ Add the required resources via [[111:eos:console:resources:datasets_setup|EOS Console > Resources > Datasets]]. === Setup EOS Workspace === Create a new workspace or copy an existing workspace and add the necessary extensions, resources and define the accessibility. \\ [[111:eos:console:users_workspaces:workspace|EOS Console > User and Permissions > Workspace]] === Create new Inventory Themes ==== Start the Orbit Client with administrator permissions on the inventory extensions and create the required themes. \\ Be careful to create these new themes in the required database and workspace (last step of the procedure). \\ [[111:mobile_mapping:desktop:asset_inventory:manage:create_theme|Orbit Client > Procedures > Administration > Asset Inventory > Create New Theme]] Close the Orbit EOS Console before creating new inventory themes. \\ Workspace and dataset configurations will get lost. === Start Production === Restrictions for operators can be set via [[111:eos:console:index|EOS console > Users and Permissions]]. \\ Enjoy data production from Mobile Mapping in Orbit. ;-) \\ ===== Asset Inventory themes and databases ===== === Inventory databases === Any server side available [[111:technologies:basic_concepts:database_connection|database connection]] can be used as inventory database. No restrictions nor conditions. \\ Define the database connections in the [[111:eos:console:resources:database|EOS console > Resources > Databases]]. === Themes === Datasets available for asset inventory are named as "Themes". Only a well defined list of datasets can be used by the asset inventory add, edit and remove item procedures. These conditions are met automatically when using the asset inventory administration procedure "[[111:mobile_mapping:desktop:asset_inventory:manage:create_theme|Create new theme]]". \\ If you are building your inventory database manually, take these conditions into account : * Required dataset attributes : \\ 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) * Themes.xml \\ 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 \\ registry name of the theme * Adding attributes to theme: \\ To add an attribute to an inventory theme in Orbit, open the database management tool (Navicat, Toad,..) and go the table design > add field. Any added field will appear inside the attribute tabel in Orbit. To define specific descriptions for the attributes in Orbit, you need to update the [[111:technologies:basic_concepts:ord|]] of the theme. * Editing the legend of a theme: \\ Open the inventory theme locally in Orbit and open [[111:orbitgis:datasets:legend:index|]] to edit the legend. \\ The legend editor is only available for local resources. Read [[111:technologies:basic_concepts:local_vs_eos|]]. \\ To import the inventory theme locally, drag and drop the [[111:technologies:resources:vector:odb|]] inside Orbit Client: * The file location: /server/data/datasets/inventories * The [[111:orbitgis:preferences:database|Database connection]] in the Orbit Client === Snapshots and Documents === While adding inventory items, Orbit automatically creates and stores a snapshot of all opened mobile mapping views. When using the "Add inventory item" procedure it is also possible to add and manage snapshots and documents. These files are stored by the Orbit client in an open file structure, organized by theme and object id. \\ The default configuration is : /client/data/inventories/// The spatial information of snapshots and the link of snapshots and documents with the inventory object is saved in a separated database table. \\ Up to Orbit version 10.5 all inventory themes used the same "link_photos" and "link_documents" table. From version 11.0 each theme has its own link tables : "_link_photos" and "_link_documents". \\ The default configuration stores these link tables within the same database connection of the inventory theme. If required it is possible to use one central database for all link_photos and link_documents tables. However each inventory theme will have its own link tables within this central database connection. This is required to guarantee database performance on doing inventory on large scale. Default configurations can be adjusted via the service configuration file. Changing any service properties requires an [[111:eos:concepts:service|Orbit service restart]]. \\ /server/program/services/ext_inventory_suite/properties.ini \\ On doing asset inventory on large scale (+ 100,000 objects for one theme) the snapshot table will become very large. Indexing the fields "Name", "Obj_id" and "Theme" is advised when an inventory insert takes increasingly more time. \\ ===== Asset Inventory Extension ===== === Roles on extension === The [[111:eos:concepts:roles_permissions#roles on extensions|]] are managed in the EOS Console. \\ When opening a workspace in the Orbit Client the extension roles for user and workspace will be loaded. **Administrator** \\ With this role, Asset Inventory themes can be created, imported, exported and removed. \\ Access to procedures Administration > Asset Inventory and Asset Inventory. Also Access to the Asset Inventory Search Tab. **Operator** \\ With this roles, Inventory items can be added, edited or removed. \\ Access to procedures for Asset Inventory. Also Access to the Asset Inventory Search Tab. **User** \\ With this roles, Inventory items can be consulted. \\ Access to Asset Inventory Search Tab. ===== Convert inventory theme from 3D to 2D ===== A newly created inventory theme is be 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 : [[111:eos:console:resources:datasets_setup|]] \\