Timestamp issue during import

[bubffm]

System Health details

System Information

version	core-2024.12.5
installation_type	Home Assistant OS
dev	false
hassio	true
docker	true
user	root
virtualenv	false
python_version	3.13.0
os_name	Linux
os_version	6.6.66-haos
arch	x86_64
timezone	Europe/Berlin
config_dir	/config

Home Assistant Community Store

GitHub API	ok
GitHub Content	ok
GitHub Web	ok
HACS Data	ok
GitHub API Calls Remaining	5000
Installed Version	2.0.1
Stage	running
Available Repositories	1495
Downloaded Repositories	3

Home Assistant Cloud

logged_in	false
can_reach_cert_server	ok
can_reach_cloud_auth	ok
can_reach_cloud	ok

Home Assistant Supervisor

host_os	Home Assistant OS 14.1
update_channel	stable
supervisor_version	supervisor-2024.12.0
agent_version	1.6.0
docker_version	27.2.0
disk_total	30.8 GB
disk_used	3.8 GB
healthy	true
supported	true
host_connectivity	true
supervisor_connectivity	true
ntp_synchronized	true
virtualization	kvm
board	ova
supervisor_api	ok
version_api	ok
installed_addons	File editor (5.8.0), Get HACS (1.3.1), SQLite Web (4.3.0)

Dashboards

dashboards	2
resources	0
views	2
mode	storage

Recorder

oldest_recorder_run	18. Dezember 2024 um 16:26
current_recorder_run	21. Dezember 2024 um 18:18
estimated_db_size	87.83 MiB
database_engine	sqlite
database_version	3.45.3

Checklist

• I have enabled debug logging for my installation.
• I have filled out the issue template to the best of my ability.
• This issue only contains 1 issue (if you have multiple issues, open one issue for each issue).
• This issue is not a duplicate issue of any previous issues..

Describe the issue

I just set up my power consumtion reader powerfox in HA, which worked fine. Now I want to load up the historic consumption data. When trying to import the csv I prepared, I get an error on the timestamp - which to me looks just fine.

Any idea what might be wrong?

Thanks
Burkhard

Reproduction steps

Double checke date format, cannot see anything wrong with it.

Debug logs

## System Information

version | core-2024.12.5
-- | --
installation_type | Home Assistant OS
dev | false
hassio | true
docker | true
user | root
virtualenv | false
python_version | 3.13.0
os_name | Linux
os_version | 6.6.66-haos
arch | x86_64
timezone | Europe/Berlin
config_dir | /config

<details><summary>Home Assistant Community Store</summary>

GitHub API | ok
-- | --
GitHub Content | ok
GitHub Web | ok
HACS Data | ok
GitHub API Calls Remaining | 5000
Installed Version | 2.0.1
Stage | running
Available Repositories | 1495
Downloaded Repositories | 3

</details>

<details><summary>Home Assistant Cloud</summary>

logged_in | false
-- | --
can_reach_cert_server | ok
can_reach_cloud_auth | ok
can_reach_cloud | ok

</details>

<details><summary>Home Assistant Supervisor</summary>

host_os | Home Assistant OS 14.1
-- | --
update_channel | stable
supervisor_version | supervisor-2024.12.0
agent_version | 1.6.0
docker_version | 27.2.0
disk_total | 30.8 GB
disk_used | 3.8 GB
healthy | true
supported | true
host_connectivity | true
supervisor_connectivity | true
ntp_synchronized | true
virtualization | kvm
board | ova
supervisor_api | ok
version_api | ok
installed_addons | File editor (5.8.0), Get HACS (1.3.1), SQLite Web (4.3.0)

</details>

<details><summary>Dashboards</summary>

dashboards | 2
-- | --
resources | 0
views | 2
mode | storage

</details>

<details><summary>Recorder</summary>

oldest_recorder_run | 18. Dezember 2024 um 16:26
-- | --
current_recorder_run | 21. Dezember 2024 um 18:18
estimated_db_size | 87.83 MiB
database_engine | sqlite
database_version | 3.45.3

</details>

Diagnostics dump

No response

[klausj1]

Most probably the problem is this:

The month (as also the day) must have two digits, and the year 4. Hour and minute 2. So "24.07.2024 09:00" would be correct, check the examples.

[bubffm]

That did the trick ;-) Many thanks.
I can see the imported values when doing a SQL Query against the sensor but they do not (yet?) show up on my Energie card, even after a reboot of HA. Does this take a while or should it update straight away?

Thanks again

[klausj1]

Sorry, I have no idea what the energy card does exactly. I would propose to wait until tomorrow, and if it does not work, ask in the forum.

[bubffm]

Its this screen in HA. But anyway, I'll wait what happens - Thanks

[klausj1]

Did it work?