Disproportionate traffic

Started by thark

thark

Disproportionate traffic 15 November 2015, 21:55

Registered: 8 years ago
Posts: 2

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. laugh

Reply Quote

Attachments:
open | download – NetWorX - TB.jpg (93.2 KB)

Andrew

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.

Reply Quote

thark

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...

Reply Quote

Attachments:
open | download – NetWorX - Settings.jpg (53.1 KB)

Andrew

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:

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 wink

Reply Quote

Print view of this page

Reply to this topic

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

Be polite.
Do not spam.
Write in English. If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

Disable BBcode in this message Disable smileys in this message

Help information

Spam prevention: please enter the following code in the input field below.

 **    **  **      **  **        **     **  **    ** 
 ***   **  **  **  **  **        **     **  **   **  
 ****  **  **  **  **  **        **     **  **  **   
 ** ** **  **  **  **  **        *********  *****    
 **  ****  **  **  **  **        **     **  **  **   
 **   ***  **  **  **  **        **     **  **   **  
 **    **   ***  ***   ********  **     **  **    **

Enter the code:

Message:

Disproportionate traffic

Reply to this topic

Software Products

Online Store

Help & Support

Download

SoftPerfect