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

Implement CLI command to precisely delete raw data by date and idsite #6785

Closed
mgazdzik opened this issue Dec 2, 2014 · 4 comments
Closed
Assignees
Labels
c: Usability For issues that let users achieve a defined goal more effectively or efficiently. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone

Comments

@mgazdzik
Copy link
Contributor

mgazdzik commented Dec 2, 2014

There are some Piwik instances that are heavily using Log Analytics/Log Replay feature. However in some cases it's required to delete previously imported data and run import again (i.e. log files were incomplete or corrupted).

It would be great improvement in process, if there could be a CLI method deleting properly raw data from all log_* tables by given date and idsite.
Such command would perform timestamp shift between site timezone and UTC and purge data properly without manual action on admin side.

@mattab mattab added Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. c: Usability For issues that let users achieve a defined goal more effectively or efficiently. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. labels Dec 3, 2014
@mattab mattab added this to the Short term milestone Dec 3, 2014
@mattab
Copy link
Member

mattab commented Dec 3, 2014

Hi @mgazdzik thanks for the suggestion!

@mattab
Copy link
Member

mattab commented Mar 24, 2015

This command logic should reuse the Delete old unprocessed data feature in Privacy manager. Code is in the class LogDataPurger and can be reused/improved to do the job to delete a given date range.

@mattab mattab modified the milestones: Piwik 2.14.0, Short term Apr 9, 2015
@mattab
Copy link
Member

mattab commented Apr 9, 2015

Moved to 2.14.0 - first i suggest we maybe look at existing bug #7180

@mattab
Copy link
Member

mattab commented Jun 16, 2015

This will be documented in a new FAQ, see #8118

mattab pushed a commit that referenced this issue Jun 16, 2015
Fixes #6785, #7180 add log delete command and make log deletion delete only based on time and not idvisit.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
c: Usability For issues that let users achieve a defined goal more effectively or efficiently. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Development

No branches or pull requests

3 participants