Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Data Model and Report implementation

    Scheduled Pinned Locked Moved General
    reporting datdatamodel
    2 Posts 2 Posters 309 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Jürgen FredrikssonJ Offline
      Jürgen Fredriksson
      last edited by Jürgen Fredriksson

      Hej There!

      I'm new to i-doit and want to solve the following problem with it:

      It would be nice if you have some advice for me how to solve that!

      Kind regards

      Datamodel

      My CIs:

      • GNSS Antenna (Serial Number, Manufacturer, Model)
      • GNSS Radome (Serial Number, Manufacturer, Model)
      • GNSS Receiver (IP-Address, Serial Number, Manufacturer, Model)
      • GNSS Firmware (Manufacturer, Version)
      • Default IT-Devices (Router, Switch, UPS, etc., VMServer, PC, Laptop, Handheld)
      • Mountpoint (Code, Coordinates (X, Y, Z))
      • Station (Code, Name)

      My Location:

      • I have several locations where the CIs gonna be located

      My Relations

      • A Location can have multiple Mountpoints
      • A GNSS Antenna is mounted on a Mountpoint, with or without a GNSS Radome
      • A GNSS Antenna/Radome mounting is only valid for a specific time window, until unmounted or changed
      • A Mountpoint can have multiple Stations
      • A GNSS Receiver is related to a Station
      • A GNSS Receiver has Firmware-Updates

      Reporting

      I have to generate a Report in text format which includes information per Station with the following sections:

      • Information about Location (Station -> Mountpoint -> Location)
      • Information about Mountpoint (Station -> Mountpoint)
      • History of all GNSS Antenna/Radome Mountings (Station -> Mountpoint -> GNSS Antenna/Radome mountings)
      • History of all GNSS Receivers separated by Firmware Updates (Station -> GNSS Receiver mountings, GNSS Receiver -> Firmware Updates)

      Example:

      Models

      Location

      • id=Location001, street=Example Street 1, zip=1020, city=Vienna, country=Austria

      Mountpoint

      • id=Mountpoint001, locationId=Location001, x=4149519.51, y=1019509.511, z=4194599.41, code=110AUTM001, inventoryId=49104995, othermeta=...

      Station

      • id=Station001, mountpointId=Mountpoint001, code=VIE1
      • id=Station002, mountpointId=Mountpoint001, code=VIE2

      Manufacturer

      • id=Manufacturer001, name=Leica Geosystems
      • id=Manufacturer002, name=Trimble

      Firmware

      • id=Firmware001, manufacturerId=Manufacturer001, version=9.14
      • id=Firmware002, manufacturerId=Manufacturer001, version=9.15
      • id=Frimware003, manufacturerId=Manufacturer002, version=S1.23

      GNSS Antenna

      • id=GNSSAnt001, snr=LA03914, manufacturerId=Manufacturer001, model=LEICA.AR25.R3, inventoryId=49104996
      • id=GNSSAnt002, snr=LA04121, manufacturerId=Manufacturer001, model=LEICA.AR25.R4, inventoryId=49104997
      • id=GNSSAnt003, snr=123941, manufacturerId=Manufacturer002, model=ZEPHYR2G, inventoryId=49104998

      GNSS Radome

      • id=GNSSRad001, snr=LD49100, manufacturerId=Manufacturer001, model=LEIT, inventoryId=49104999
      • id=GNSSRad002, snr=941010, manufacturerId=Manufacturer002, model=TR01, inventoryId=null

      GNSS Receiver

      • id=GNSSRec001, snr=LR59191, manufacturerId=Manufacturer001, model=GR 30, inventoryId=49105000
      • id=GNSSRec002, snr=5991455, manufacturerId=Manufacturer002, model=Alloy, inventoryId=49105001

      GNSS Antenna/Radome mounting on Mountpoint

      • id=AntRadMount001, mountpointId=Mountpoint001, antennaId=GNSSAnt001, radomeId=null, valid_from=2001-06-30T09:04:05Z, valid_until=2005-09-12T14:12:28Z
      • id=AntRadMount002, mountpointId=Mountpoint001, antennaId=GNSSAnt002, radomeId=GNSSRad001, valid_from=2005-09-12T14:15:00Z, valit_until=null

      GNSS Receiver updates

      • id=RecFirUpdate001, receiverId=GNSSRec001, firmwareId=Firmware001, valid_from=2001-01-04T12:12:43Z, valid_until=2004-04-12T12:00:00Z
      • id=RecFirUpdate002, receiverId=GNSSRec001, firmwareId=Firmware002, valid_from=2004-04-12T12:15:00Z, valid_until=null
      • id=RecFirUpdate003, receiverId=GNSSRec002, firmwareId=Firmware003, valid_from=2006-12-03T07:03:00Z, valid_until=null

      GNSS Receiver mounting on Station

      • id=RecStaMount001, receiverId=GNSSRec001, stationId=Station001, valid_from=2001-01-05T06:00:00Z, valid_until=2019-05-13T12:00:00Z
      • id=RecStaMount002, receiverId=GNSSRec002, stationId=Station001, valid_from=2019-05-13T12:05:00Z, valid_until=null
      • id=RecStaMount003, receiveRId=GNSSRec001, stationId=Station002, valid_from=2019-05-13T12:10:00Z, valid_until=null

      Generated Output

      Station VIE1 (Station001)

      Output_VIE1.png

      Station VIE2 (Station002)

      Output_VIE2.png

      1 Reply Last reply Reply Quote 0
      • Philipp HörselmannP Offline
        Philipp Hörselmann
        last edited by

        Hello @Jürgen-Fredriksson
        are these the information about the CIs etc. which you want to implement into i-doit?
        Are you using i-doit open or i-doit Pro?
        i-doit Pro offers you the possibility to create custom categories, object types and object type groups where you can customize i-doit.

        Best
        Phil

        1 Reply Last reply Reply Quote 0

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        • First post
          Last post