Ways to modify or manually edit log files
3 posts · Closed
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 log file?
(Because I forgot to backup NetWorx data before a clean OS installation.)
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 ('[color=red]John Smith[/color]', cast(julianday('[color=red]2017-01-30[/color]')-julianday('1899-12-30') as integer), 0, [color=red]322122547200[/color], 0, 0);
Below is an example of doing in SQLiteSpy:
[image: https://i.imgur.com/JLFJdYg.png]
Thanks, Andrew.