WorksManager

 View Only
Back to discussions
Expand all | Collapse all

Search for Rover head serial number

  • 1.  Search for Rover head serial number

    Posted 08-20-2024 08:02
    Edited by Matt Eklund 08-20-2024 08:07

    I want to do a query by typing in the SN of a rover head or base and having the resulting tablets that have connected to these receivers show up on a list.    The SN is found in the tasklog.txt file in the root of the project when the tablet connects to the device.  This will help in locating which sites the rovers are on if they are moved.

    Report should look something like this:

    I'd also like to have a report that show the last time the tablet synced (site specific), the last tolerance check and corresponding results:

    Comment if you think this would be useful to you as well.


    ------------------------------
    Matt Eklund, PE
    GPS Program Manager
    Sukut Construction
    California, USA
    ------------------------------



  • 2.  RE: Search for Rover head serial number

    Posted 08-29-2024 07:29

    Matt,

    Great Idea. Trimble recently added the IBSS bases to show as reporting and shows firmware and warranty dates as well. What you propose is the only serialized component we are missing in WorksManager and is needed. The satellites need to report correctly but the other info is useful when exporting device list and managing firmware, warranties, tracking, etc.as shown. Sync& accuracy reports would be beneficial too. Thanks for the info and @Vijay Raghunathan can help with consideration.



    ------------------------------
    Vito Patierno
    ------------------------------

    Original Message


  • 3.  RE: Search for Rover head serial number

    Posted 08-29-2024 08:26
    Edited by Matt Eklund 10-02-2024 11:27

    For the reports that you see, those are generated using PowerBI. We wrote script to query the task log.txt starting from the bottom up and look for specific information to write to a CSV table. Then we use powerBI to organize those tables. However, the Access to TCC explore database is spotty at best and the routine breaks quite often and is unreliable. It would be better if Trimble provided API access to their tables so that the customer could query and organize data as they see fit. 

    Sent from my iPhone


    Original Message


  • 4.  RE: Search for Rover head serial number

    Posted 08-30-2024 01:13

    Thank you Vito and Matt for sharing. I will add the request into the backlog.

    On exposing apis, we have an intent, but its going to take a while before its going to be available, and regret inconvenience on that.



    ------------------------------
    Vijay Raghunathan
    ------------------------------

    Original Message