How change the "since" date in usage report
Started by Mateuszek53
Mateuszek53
How change the "since" date in usage report 20 December 2020, 20:15 |
Re: How change the "since" date in usage report 21 December 2020, 12:13 |
Admin Registered: 10 years ago Posts: 889 |
In your case this date is incorrect for some reason, as NetWorx didn't even exist at that time. Sometimes BIOS can add a date record like that.
While the usage records cannot be edited in NetWorx, you can edit the database directly. To delete that odd date:
- Download SQLiteSpy.
- Launch it, and load the NetWorx database file located in %ALLUSERSPROFILE%\Application Data\SoftPerfect\NetWorx.
- Run the following query in SQLiteSpy replacing YYYY-MM-DD with the year, month and day of the latest record you want to delete:
DELETE FROM usage WHERE date('1899-12-30', '+' || DAY || ' days') = 'YYYY-MM-DD'
That is, to delete that erroneous date record, use:
DELETE FROM usage WHERE date('1899-12-30', '+' || DAY || ' days') = '2001-01-01'
After the erroneous record has been deleted, restart NetWorx and the "since" should change to a newer date, which should be a real date from your actual NetWorx usage.
Mateuszek53
Re: How change the "since" date in usage report 21 December 2020, 22:06 |
Re: How change the "since" date in usage report 21 December 2020, 22:51 |
Admin Registered: 18 years ago Posts: 3 519 |
Mateuszek53
Re: How change the "since" date in usage report 22 December 2020, 08:55 |
- Open SQLiteSpy
- File > Open Database at C:\ProgramData\SoftPerfect\NetWorx\Networx.db
- Paste the code: DELETE FROM usage WHERE date('1899-12-30', '+' || DAY || ' days') = '2020-12-10'
- Execute > Execute SQL
- Close the app > getting "This SQL was modified : DELETE FROM usage WHERE , Save changes" > YES
- App wants to create a new SQL file
- Networx.db does not seem to be overwritten, which means my modification didn't work.
Mateuszek53
Re: How change the "since" date in usage report 22 December 2020, 09:09 |
I thought I could change the date to my own, but this is deleting command only. That's why it didn't work for me when I was trying to plug in my new date.
Now I deleted the 2001-01-01. After that, I have 2018-03-28 as the oldest date. Which command do I need to use to make it 2020-12-10?
Re: How change the "since" date in usage report 22 December 2020, 09:32 |
Admin Registered: 18 years ago Posts: 3 519 |
Mateuszek53
Re: How change the "since" date in usage report 22 December 2020, 18:51 |
Re: How change the "since" date in usage report 22 December 2020, 19:09 |
Admin Registered: 18 years ago Posts: 3 519 |
If you want something else there, choose This Year, Last Year or Last Month.
You can also set the Month begins on parameter to 10 in the Advanced Settings, so that your monthly reports begins on that date.
Mateuszek53
Re: How change the "since" date in usage report 22 December 2020, 20:56 |