Show all posts by user
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
QuoteRodNo idea what a "pragma" was Neither did I even though those setting looked like "Preferences" or "Settings", however it actually has a dictionary definition: programming: (pragmatic information) A standardised form of comment which has meaning to the compiler or some other program. It may use a special syntax or a specific form within the normal comment syn
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
That's good that you kept at it until you found the solution. I have to admit that I had no motivation to get to know that program in depth since I knew of two others that could do what's required. Did you contact the author or discover the solution yourself?
Re: "Ignore LAN traffic" setting became unchecked
8 years ago, by Praxis in NetWorx Forum
W7-64 Pro, did not have your problem The 'exit' worked The box stayed checked Sounds like you may have some other issue that impacts NetWorx
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
You shouldn't attribute human characteristics to inanimate things by saying that databases behave and programs get confused. Programs simply do what their author has defined/designed them to do and databases simply exist as defined by the person creating them. All browsers are programs but not all programs are browsers. Do you say 'browser' when refering to Excel, since Excel lets you browse th
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
Well it might make sense to ask the author of the browser why his program does what it does. Right now all we know is it doesn't work properly and we can guess all kinds of things but he's the one to debug his program
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
QuoteRod Hi again, I opened a copy of Networx.db in the browser and pressed the button and the same thing is happening as with the back-up file. Table: 'usage' Last Record No.: 30, Name, 42404, 22, 0, 0, 0 -------------------------------- Pressed button and got the following error message: Error adding record: CHECK constraint failed: usage (INSERT INTO 'usage' ('USER_NAME','DAY','
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
I decided to see what the sqlitebrowser can do and found that when I tried to add a record to the usage table by clicking on the button that it tries to add/insert a record with incorrect values for record number, day and hour. I have no idea how it picks those values, it certainly doesn't open up an input window to allow me to specify the values which is what I'd expect, so in my opinion the
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
QuoteWith a new database created in the browser, I can manually add records ad infinitum true if you haven't specified a unique index on the database table but not true when there's a unique index specified for the database table... which is what networx is doing with user day hour. Unique means that there cannot be multiple records with the same values in all key fields. J
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
QuoteHope all this makes sense. Yes, now it does. As Andrew points out, sqlite doesn't know about networx and that Netwrx is using hour is a 'time' field, after all the values are simple integers, there's no tell-tale format such as "yyyy.mm.dd.hh.mm.ss". Same for the day field So it simply adds 1 to the hour value in the 'last' record, and that's not wrong for it to do that.
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
Quote That's exactly what I'm doing. are you really sure? "backup.DB" is smaller than "networx.db" on my system Why would you want to modify the backup? Were you intending to import it back into the "main" file?
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
Quote Bearing in mind I know next to nothing about SQLite databases, I think there may be a problem with Networx back-ups which are now in SQLite database format. well it wasn't clear which file that you meant, you said your 'backup' which is a static file concept i.e. at a specific time. and you commented that it was now in the sqlite format. So I assumed that you weren't talking about a 'cop
Re: Auto-increment problem in back-ups
8 years ago, by Praxis in NetWorx Forum
First, you shouldn't be updating your backup file, you should be updating the main file (or a copy). There's only one record per user + day + hour, i.e. that's a 'unique key', you can't have multiple records with the same key so what you're doing is wrong. If you want to 'update' a specific record/unique key then you can do that with sqlite very easily by clicking on the value and then editi
Re: How to remove a bad entry in the usage report?
8 years ago, by Praxis in NetWorx Forum
Or you can edit the individual record(s) and change the value(s) by hour. To gain experience, Close networx, Make a backup copy of the networx.db and Using a program SQLiteSpy.exe from http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index Open the original database Click on the plus sign beside the "usage" table Click on the box beside "Columns" Double cli
Re: Accuracy of usage calculation, reasons for this usage
8 years ago, by Praxis in NetWorx Forum
Quoteit reset to zero yesterday so from 12.00 last night to 07.00 am with only my computer on, using your programme it shows 5.61 GB usage, SKY shows 4GB. If NetWorx is showing 40% higher usage than sky it may mean that you're not measuring the right connection with ignore local traffic set ON. Quotein one month I have used 96 GB and in 7 hours have used 4GB Were you billed for 96GB? If yes, y
Re: Updated NetWorx - lost usage history
8 years ago, by Praxis in NetWorx Forum
Close any programs that automatically download 'stuff', such as e-mail. Don't do this when your AV is scheduled to update... etc. You don't want to lose that history... Then: Double click the Networx install file. When that message pops up and you need to Close the program: right click on the icon in the systray OR left click on the icon in the task bar. Select Exit. Carry on with the inst
8 years ago, by Praxis in NetWorx Forum
was it in use 24 hours per day or do you have your PC either Sleep or Hibernate when you aren't using it all 24 hours per day? if you let it go to sleep, Andrew gave you an answer. if there's any chance you accidentally clicked on the icon and selected ? that would certainly stop networx. but, when you found that data for a couple of days was missing, had you rebooted after those days? i.e
Re: Checking "ignore local traffic" lowers reported traffic usage
8 years ago, by Praxis in NetWorx Forum
Just be aware that, depending on the type of downloads, the percentage may vary by quite a bit. For normal browsing 10% is quite close, but if you're downloading a large installation file, the difference may be 12% or even more. You can use sqlite to make adjustments to the networx.db records to bring them in line with the ISP totals when that happens, but it's 'after the fact'. It's hard to kn
Re: How to make the graph fill the entire square
8 years ago, by Praxis in NetWorx Forum
Hi Andrew, Maybe it would help if, instead of using <ctrl> O, a button is used to access these additional 'Hidden' settings, like the buttons for and . There's enough room on the left side, below 'Volume unit' and above 'Monitored interfaces'. This would avoid the issue of the settings being 'too hidden' since users don't always read the (excellent) Help file instructions even when there
Re: How to make the graph fill the entire square
8 years ago, by Praxis in NetWorx Forum
actually if you set "Overlay desk band numbers" to False it also sets "Display usage summary on the graph" to unticked (= false) so you have to re-tick it if you want the summary numbers on the floating graph. The "Show graph grid and axes" only controls the grid of dots, not the numbers, on the floating graph. You should take some time to become familiar with a
Re: How to make the graph fill the entire square
8 years ago, by Praxis in NetWorx Forum
Press Ctrl + O for hidden settings, scroll down to "Overlay desk band numbers" and change it to 'False'.
Re: New feature: Real-time application monitoring
8 years ago, by Praxis in NetWorx Forum
Ahhh, 'history' was a guess since I saw two apps with traffic and around here it's only ever one at a time such as FF or TB but I never have both going at the same time. So 'real time' really is real time and it's hard to visually track when there's just a little bit of traffic. I'll get it set up when I have something bigger to download and watch. Nice job, thanks, J
Re: New feature: Real-time application monitoring
8 years ago, by Praxis in NetWorx Forum
Hi Andrew, I only see traffic speeds when something is actually happening, I don't get any 'history' as it appears in your screenshot. Question: Since this is now 'real time', the button and the for Automatic Refresh are now redundant, should they be removed? Anyway, much faster than before, which is good. Thanks, J W7SP1-64bit
Re: 1 installed and 2 portable instances get mixed up counts
8 years ago, by Praxis in NetWorx Forum
I solved this. I had had all instances set to NOT load with Windows and instead had put shortcuts in my Startup folder. I just found that the last two updates defaulted to Load with Windows and so I was getting two instances of the Installed running and the 'last one' couldn't use the correct database so it 'found' the database and rules for the first Portable. Once I removed the shortcut from
Re: Grouping applications by date is now available
8 years ago, by Praxis in NetWorx Forum
It's working on my PC, see my post in the other thread about mixing portables and installed versions.
Re: 1 installed and 2 portable instances get mixed up counts
8 years ago, by Praxis in NetWorx Forum
Hi Andrew, This happened again today when I installed the new release. After the reboot I got a pop up stating "Driver operation error" and a second that the "Hot key Ctrl I has already been registered". I believe these are related to one of my two portable instances which I have not run since I first reported this issue. In order to 'fix' this I had to use Taskmgr to stop
1 installed and 2 portable instances get mixed up counts
8 years ago, by Praxis in NetWorx Forum
Hi Andrew, During a cold boot something got confused and my Installed instance started reporting the traffic detected by one of the Portables. As well, a popup claimed that two hot keys had already been registered. My solution was to close the portables then the installed and restart them: first the installed, then the two portables and the correct counts were recorded. I thought that eac
Re: Feature request: Clear application log automatically daily
8 years ago, by Praxis in NetWorx Forum
Thanks Andrew, I see that the documentation that I found was 'wrong' because it specified the use of a "." rather than the "-" which works perfectly. I've changed my bat file to reflect the new code except that I've not used the "-header" spec, I just want the actual data rows. There's a bug in LibreOffice where we're supposed to be able to specify the default fo
Re: Feature request: Clear application log automatically daily
8 years ago, by Praxis in NetWorx Forum
I discovered how to copy the rows from the Application table to a csv file, here's the modified bat file to run daily. Note that I specify a custom folder for the Networx db and the two spreadsheet files so a user will likely need to modify this for their own situation. I kept the spreadsheet names short: NWapps.csv and NWapps.odt. The last one could be NWapps.xls for Office users. cd c:\ @
Re: Feature request: Clear application log automatically daily
8 years ago, by Praxis in NetWorx Forum
If this is really important to you, you can always: Click on the Applications tab and then click the button. Save the file, as type = csv, to your desktop, Close Networx, (you can't open the csv file while it's 'owned' by the running networx.exe) Open the csv file, (this has a HUGE font- Andrew - can you make it smaller?) Copy all appropriate cells (columns & rows) and paste into anot
Re: Clear application log automatically daily
8 years ago, by Praxis in NetWorx Forum
I use Windows 7 Task Scheduler to run these .bat files. Control Panel > Administrative Tools > Task Scheduler The .bat files are in a folder C:\networx_tasks I copied the sqlite3.exe to a folder c:\sqlite3_run Note that I have changed the default folder for the networx database to a different drive/partition so that I can back it up with my other 'data' on a regular schedule. It's n