LightningROD - Better Charge Logs

[theUNSTABLE]

Project Update:

I've been feeling incredibly frustrated with InfluxDB. Integrating InfluxDB as the storage for charge logs has proven to be challenging...for me. The time aspect of this database has introduces issues with different measurements. Transforming specific values from a single measurement has been problematic. Additionally, I've encountered issues with Grafana being able to display any data from Influx, and I've had issues using Python to properly add the data into Influx through a script with HomeAssistant as the automation.
Example: I have a script to run four hours after a charge, which downloads the charge log and then inserts it into InfluxDB. However, ensuring the script has the necessary Python packages requires more custom integrations, tinkering, and setup for this to properly work... moving me farther away from my goal of making it easier for others.

Considering I have little to no knowledge on Influx and the Flux language, and I'm self taught with programming - I can only do so much with the free version of Chat GPT.

Because I had this working previously with PostgreSQL (and I wouldn't have to use Flux Syntax) I think the best solution is to revert back to PostgreSQL for storage. There will still be a way for logs to be downloaded and stored in a JSON file locally. I will just be using PostgreSQL as my long-term storage. This will be independent from HomeAssistant and still able to be self-hosted. HomeAssistant will just allow for extra automation for the people using it, but it will not be a requirement.

With my limited time and continued frustration of encountering roadblocks, I've found myself discouraged from working on this project. I've also taken on the additional challenge of attempting to improve the FordPass HomeAssistant integration by incorporating EV-specific features. I would love to add the ability to stop and start a charge into HomeAssitant, but it has proven difficult for me. Because of these things any free time I get to work on these two projects has been frustrating and discouraging. My self-taught Python/programming skills and other resources are only carrying me so far.

If anyone proficient in InfluxDB or Flux and is willing to assist in properly setting up data ingestion from a json file to the database I would be happy to learn.

Until then, I would like to get this back into a working functional state so I, and others, can actually use it.

If I have LightningROD working properly, then I can work on issues/feature requests for both projects.




Also Ford has changed their API causing this and the HA integration to break.
However, I do have a developer account now. So when I get more time I'll be poking at that.

Sponsored

 

[theUNSTABLE]

MASSIVE Project Update.

The past few years, have no joke been incredibly stressful with tight timeline after tight timeline with various projects at work. I had a project idea for something I wanted to make for use at work, so all of my free time has been taken up by that.

I've been working on that for months and hit a spot where......it is probably not going to be useful and might not be worth continuing.

However, I learned so much and knew I wanted to get back into bringing my LightningROD project to something I wanted to use. I've been collecting data for a few years in various ways and had so many things essentially duct taped together.

I scrapped every solution I had, and started consolidating all of my data into local CSV files.

First, I started with my charge logs and found sections where I could easily infer some information.

So I took a break from algorithmic data processing and populating and decided to quickly make a `v0.1` of LightningROD that is the starting bones for what I've wanted.

My ultimate goal is to ingest all of my CSV data files and then plum it up to grab specific data from Home Assistant.

After that I want to then support manual CSV upload with automatic parsing to make it simple to ingest data.

Then, finally my ultimate goal is to provide a data source that is not reliant upon the Ford API via some type of OBD reader.

I've purchased a WiCan Pro, and I've been eyeing all of the threads about the PID's and other people also wanting their data, so hopefully that could come sooner rather than later....and be easy.

For now, I just copied over basically everything from my private self-hosted instance to github and setup a pretty site (I wanted to play with github pages).

Still a massive work in progress, and currently only supports CSV data ingestion at build time......but I think I'll be at manual entry soon.

If you have a local copy of your data - or you are not using Home Assistant and have been thinking about it. I would recommend as that is also my next planned step.

Specifically ingesting all of the data from Home Assistant running marq24's fordpass repo.

Let me know what you guys think, what you would like changed, updated, improved, different, etc

https://github.com/SquidBytes/LightningROD

https://squidbytes.github.io/LightningROD/