How to edit the usage report to correct an error

Started by rioborg

rioborg

How to edit the usage report to correct an error 24 April 2016, 12:56

I noticed there's an error in my usage report on three consecutive months.

Aug/Sep/Oct of 2014

SoftPerfect support forum

How can I fix this?

Reply Quote

Andrew

Re: How to edit the usage report to correct an error 24 April 2016, 16:54

Admin
Registered: 18 years ago
Posts: 3 519

You can either leave it as it is, or delete the erroneous records.

Although there is no way to edit usage records from NetWorx, you can directly edit the database:

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 before which you want to delete records. For example, this will delete all records prior to 2015:
```
  DELETE FROM usage WHERE date('1899-12-30', '+' || DAY || ' days') < '2015-01-01'  
```

Reply Quote

Print view of this page

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:

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:

How to edit the usage report to correct an error

Software Products

Online Store

Help & Support

Download

SoftPerfect