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?
SoftPerfect Support forum - Andrew avatar image

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

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:
  1. Download SQLiteSpy.
  2. Launch it and load the NetWorx database file located in %ALLUSERSPROFILE%\Application Data\SoftPerfect\NetWorx.
  3. 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 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:

     

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

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

Message: