Hi,
by looking the usage report there are some days with strange higher traffic. Is there a way to fix those days? It ruins the whole statistic.
SoftPerfect NetWorx
Disproportionate traffic
Started by thark
Disproportionate traffic 15 November 2015, 21:55 |
Registered: 8 years ago Posts: 2 |
Re: Disproportionate traffic 15 November 2015, 22:47 |
Admin Registered: 18 years ago Posts: 3 519 |
Most likely all or parts of your usage records are incorrect. Please see this article and select a single adapter to monitor.
Re: Disproportionate traffic 17 November 2015, 23:48 |
Registered: 8 years ago Posts: 2 |
All time I used Networx it was working with these (attachment) settings, only these 4 days are incorrect, there is no way to fix these? Everything else is fine.
Trying to export as csv, "correct" or lower these values will end up by importing it with:
'Date' is not a valid date
By deleting the second line
Date Received Sent Total Dial-up
the next error shows up:
'Total' is not a valid date
Hmm...
Trying to export as csv, "correct" or lower these values will end up by importing it with:
'Date' is not a valid date
By deleting the second line
Date Received Sent Total Dial-up
the next error shows up:
'Total' is not a valid date
Hmm...
Re: Disproportionate traffic 18 November 2015, 13:30 |
Admin Registered: 18 years ago Posts: 3 519 |
CSV report isn't designed to be re-imported. There is also no way to edit usage records from NetWorx. You can directly edit the database though, for which:
Hope that's not too hard to follow
- 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 whose records you want to delete.
DELETE FROM usage WHERE date('1899-12-30', '+' || DAY || ' days') = 'YYYY-MM-DD'
- Run the following query in SQLiteSpy replacing YYYY-MM-DD with the year, month and day you want to insert data, X with the number of bytes you want to record as download and Y with the number of bytes you want to record as upload.
INSERT INTO usage VALUES ((SELECT USER_NAME FROM usage LIMIT 1), julianday('YYYY-MM-DD') - julianday('1899-12-30'), 0, X, Y, 0)
Hope that's not too hard to follow