Unable to calculate cost of some charges about teslamateagile HOT 11 CLOSED

That's perfect, thank you. I'll take a look and see what went wrong here.

from teslamateagile.

That would be slightly embarrassing if I am not on the latest release. Let me double check that later when I get home.

from teslamateagile.

Hi, would you mind exporting that particular charging process and associated charges table records to CSV and send them over? There shouldn't be any personal data but please verify and strip any out first before you do.

from teslamateagile.

I would love to do that. If only I knew how. Can you give me a short "how to"?

from teslamateagile.

I've provided a short how to on another issue before, see if this helps if not I'll be happy to walk you through it: #17 (comment)

from teslamateagile.

Never used pgAdmin before, or even logged into the database. But for some reason it just worked. Amazing. I have attached the .csv file. Let me know if it is not what you asked for.

data-1685037097905.csv

from teslamateagile.

Nice! That's one part of what I need, the other is the entries from the charges table for that charging_process_id

The query should be SELECT * FROM charges WHERE charging_process_id = 452

from teslamateagile.

Like so?
data-1685041452114.csv

from teslamateagile.

Okay it looks very similar to an issue I recently-ish pushed a fix for with version v1.11.3

Can you verify that you're on that version? If you're on an older one I suspect that will be why 😄

I ran your data through the latest code and it successfully retrieved all the price data (note my testing VAT and fixed prices will be different from yours):

  23/05/23 10:00:00 +00:00 - 23/05/23 11:00:00 +00:00 - 0.24781250
  23/05/23 11:00:00 +00:00 - 23/05/23 12:00:00 +00:00 - 0.18171249375
  23/05/23 12:00:00 +00:00 - 23/05/23 13:00:00 +00:00 - 0.05166250250
  23/05/23 13:00:00 +00:00 - 23/05/23 14:00:00 +00:00 - 0.03295000125
  23/05/23 14:00:00 +00:00 - 23/05/23 15:00:00 +00:00 - 0.11925000250
  23/05/23 15:00:00 +00:00 - 23/05/23 16:00:00 +00:00 - 0.48752498625

from teslamateagile.

Updated to latest release (1.11.3) and now all charges calculates correctly.

from teslamateagile.

Great to hear, thanks for the confirmation! 🙂

from teslamateagile.