How to edit SQLite log file

Started by Borea

How to edit SQLite log file   30 January 2017, 14:48

1- Is there any easier way to modify the Log file other than SQLiteSpy?

2- Is there any manual for using the SQLiteSpy software.

3- How can I add a missing day and its data to the Networx's log file?

(Because I forgot to backup Networx data before a clean OS installation.)
SoftPerfect Support forum - Andrew avatar image

Re: How to edit SQLite log file   30 January 2017, 15:34

You can use any editor capable of opening SQLite databases, e.g. SQLiteStudio, DB Browser for SQLite or SQLite Management Studio. All these tools are similar in nature to SQLiteSpy and are not necessarily easier.

I am afraid there is no manual and even if there was, that wouldn't help much. You would need some understanding of relational databases and SQL to be able to modify the NetWorx's database - after all it's not supposed to be edited by user.

Assuming you are already using something to open the database file, run this statement after changing it as required. It will add 300GB of incoming traffic to user John Smith dated Jan 30, 2017:
INSERT OR REPLACE INTO usage (USER_NAME, DAY, HOUR, DATA_IN, DATA_OUT, DIALUP_DURATION)
VALUES ('John Smith', cast(julianday('2017-01-30')-julianday('1899-12-30') as integer), 0, 322122547200, 0, 0);
Below is an example of doing in SQLiteSpy:

SoftPerfect support forum

Re: How to edit SQLite log file   31 January 2017, 15:27

Thanks, Andrew.

Sometimes you can get the answer faster if you try the forum search and/or have a look at the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • 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: