1. Attachments are working again! Check out this thread for more details and to report any other bugs.

Hybrid Assistant Database Manager.

Discussion in 'Prius OBDII Third-Party Apps' started by The Tramp, Nov 8, 2023.

  1. The Tramp

    The Tramp Italian Prius Expert

    Joined:
    Jan 8, 2006
    364
    38
    0
    Location:
    Turin, Italy
    Vehicle:
    2020 Prius PHV
    Model:
    N/A
    Teaser...

    [​IMG]

    Can merge from many phones.

    Under development (very early stage)
     
  2. The Tramp

    The Tramp Italian Prius Expert

    Joined:
    Jan 8, 2006
    364
    38
    0
    Location:
    Turin, Italy
    Vehicle:
    2020 Prius PHV
    Model:
    N/A
    Project follow up:

    [​IMG]
    The [Import] button allows you to import any hybridassistant database:

    [​IMG]
    You can choose whether to append data or erase and rewrite.

    [​IMG]
    Then you can choose a car to view:

    [​IMG]
    You can select a row and see the details:

    [​IMG]
    You can also choose multiple rows to see the trips combined:

    [​IMG]
    In this example, my return trip from my holidays:

    [​IMG]

    To do now: some cool charts.

    Any ideas and suggestions are greatly appreciated.
     
  3. vvillovv

    vvillovv Senior Member

    Joined:
    Mar 19, 2013
    3,898
    1,338
    1
    Location:
    NY
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Plus
    How much of the data base gets imported? only the local data base on our phones or the whole server side reports data base?
    Is there a way to drill down into the traction pack tests?
     
  4. The Tramp

    The Tramp Italian Prius Expert

    Joined:
    Jan 8, 2006
    364
    38
    0
    Location:
    Turin, Italy
    Vehicle:
    2020 Prius PHV
    Model:
    N/A
    I download the DB from the phone to the PC.
    Then I Import all the available data into my DB, creating extra tables cars and modelname. This is to allow to import from different phones.
    I am planning to allow to download the Gooogle Earth file and attaching it on by Database.
    As for the reports, I am thinking of replicating them so I can do them on the fly and joining trips together.

    Having a PHEV, I don't think I can do tests on the traction battery, se my DB is empty. But I can put it on the todo list, but I need data to work on.
     
    #4 The Tramp, Nov 17, 2023
    Last edited: Nov 17, 2023
  5. vvillovv

    vvillovv Senior Member

    Joined:
    Mar 19, 2013
    3,898
    1,338
    1
    Location:
    NY
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Plus
    Thanks for the details about what you're working on and how the date integrate from phone to computer.
    The reason I asked about the traction pack tests is that I've read a post or two here at priuschat that some owners like the format of Hybrid Assistants traction pack info better than DrPrius battery health check tests.
    I've have both DrPrius and Hybrid Assistant on my phone, except after Hybrid Assistants last upgrade I get a warning about my old ODB11 adapter and less data available on it's dashboard.
    Since my daily use computer runs Linux, I have to jump to some extra hoops to read reports. One reason I'm interested in your work. Thanks again.
     
  6. The Tramp

    The Tramp Italian Prius Expert

    Joined:
    Jan 8, 2006
    364
    38
    0
    Location:
    Turin, Italy
    Vehicle:
    2020 Prius PHV
    Model:
    N/A
    Ahem, my work runs on Windows... :) But I'm sure it works under Wine.
    If I get some data, I can develop something re: the traction battery analisys.
     
    vvillovv likes this.
  7. The Tramp

    The Tramp Italian Prius Expert

    Joined:
    Jan 8, 2006
    364
    38
    0
    Location:
    Turin, Italy
    Vehicle:
    2020 Prius PHV
    Model:
    N/A
    Ladies and Gentlement, here is my first chart!

    How it was presented from HA' report:
    [​IMG]

    And how I've done it:
    [​IMG]
     
  8. The Tramp

    The Tramp Italian Prius Expert

    Joined:
    Jan 8, 2006
    364
    38
    0
    Location:
    Turin, Italy
    Vehicle:
    2020 Prius PHV
    Model:
    N/A
    One advantage that my program has is that I can group trips to cover the whole trip

    [​IMG]

    In this example, my vacation towards Apulia via scerery routes.

    Unfortunately there are holes where I was not driving.

    [​IMG]

    So I added the option to have the Y axis by distance,, and not time.

    [​IMG]

    Happy with this result, I will move forward with other charts.
     
  9. The Tramp

    The Tramp Italian Prius Expert

    Joined:
    Jan 8, 2006
    364
    38
    0
    Location:
    Turin, Italy
    Vehicle:
    2020 Prius PHV
    Model:
    N/A
    Second chart is ready!



    From...

    [​IMG]



    To...

    [​IMG]