Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cleanup functionality to delete data of not more existing datapoints #247

Open
5G7K opened this issue May 3, 2022 · 4 comments
Open

Cleanup functionality to delete data of not more existing datapoints #247

5G7K opened this issue May 3, 2022 · 4 comments

Comments

@5G7K
Copy link

5G7K commented May 3, 2022

Over years I have deleted many data points with activated logging or logging for datapoints has been deactivated.
Result: Many unnecessary entries in my SQL-DB (>1Mio)

An integrated maintenance functionality/archiving would be very nice. Maybe with auto-backup before deleting.

Following script analyzes these datapoints and I have enhanced this to delete these datapoints.
My old idea was to use this functionality: #207
An easy to use build-in functionality would be very nice.

Thank you!

@Apollon77
Copy link
Contributor

Admin5 should have exactly that already build in. Did you tried that? (But no auto backup). But in fact yes you need to activate logging for a datapoint because else meta data are missing

@Apollon77
Copy link
Contributor

PS: For other maintenance (especially of old, already deleted datapoints it will be very hard to offer something in a UI form without huge efforts ... So only a "delete data of all currently not active datapoints" I could imagine

@Apollon77 Apollon77 reopened this May 3, 2022
@5G7K
Copy link
Author

5G7K commented May 3, 2022

Can you give me a hint where I can find some information for "Admin5 should have exactly that already build in. Did you tried that?"

I'm not familiar with adapter development, but maybe it's just a button "Delete unused data" which calls the mentioned js-script in background?

@Apollon77
Copy link
Contributor

open the custom settings of a datapoint where you can edit the settigs, go on the page with the data list and there should be buttons for it ... need to check Admin UI too

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants