Station Data Block and Extra Sensors

[Gary]

Hi,

I have an extra temperature sensor and a humidity sensor and these are working in their respective "extra sensor" blocks and they are visible via the "Edit Data Extra Sensors" in the Database section on the Control Panel.

I use the Station Data block and notice the Extra Sensors are not shown there.

Does anyone know how to get the extra sensors displayed in the Station Data block?


Thanks

[davidefa]

You can try this version of station data block, it supports the extra sensors: viewtopic.php?p=11888&hilit=stationData#p11506

[Gary]

Hi,

Thank you that works very well indeed! I didn't see your post when I searched the Forum earlier - my bad.

Reading the whole post that you referenced made me really appreciate all the effort you have made to make this work so well.

Kind regards,

Gary

[Gary]

Now I have the extra sensors installed and displayed nicely, I want to delete the data that got created before the extra sensors were put in their final position.
I can see that I can use "Database Editing - Extra Sensors" to edit/delete each 5 minute entry for the extra sensors.
However, as I have about 15 days of data I want to delete, removing each 5 min entry is going to take some time - not to say tedious!

Is there another way to select/bulk delete these entries?

Thanks in advance for any help.

[davidefa]

The easiest option is to edit the database directly in phpmyadmin ( via the control panel of your hosting provider ).
You can execute a query like this ( before executing the query is a good practice to test it by pressing the 'simulate query' button ):

Code: Select all

DELETE FROM `alldataExtra` WHERE `DateTime` >= '2023-12-07 00:00:00' and `DateTime` <= '2023-12-08 00:00:00'; 

Or you can see the affected rows by querying:

Code: Select all

SELECT * FROM `alldataExtra` WHERE `DateTime` >= '2023-12-07 00:00:00' and `DateTime` <= '2023-12-08 00:00:00';

Substitute the two dates with the starting and ending dates ( the format is YYYY-MM-DD HH:MM:SS )

P.S.
As this may be 'destructive' a backup of the database/table maybe a good idea

phpmyadmin3.png (155.19 KiB) Viewed 827 times

[Gary]

Hi there,

Thank you again for your detailed explanation and guidance.

I followed your steps and managed to delete the unwanted entries perfectly and easily.
The screenshot and command syntax you provided really made the process straightforward.
I did make a backup too - just in case i messed up!

I really appreciate your help!

Merry Christmas!

Gary