{"action":"created","issue":{"url":"https://api.github.com/repos/caarmen/network-monitor/issues/69","labels_url":"https://api.github.com/repos/caarmen/network-monitor/issues/69/labels{/name}","comments_url":"https://api.github.com/repos/caarmen/network-monitor/issues/69/comments","events_url":"https://api.github.com/repos/caarmen/network-monitor/issues/69/events","html_url":"https://github.com/caarmen/network-monitor/issues/69","id":109857907,"number":69,"title":"Allow changing sort order of data","user":{"login":"ab1jx","id":3131978,"avatar_url":"https://avatars.githubusercontent.com/u/3131978?v=3","gravatar_id":"","url":"https://api.github.com/users/ab1jx","html_url":"https://github.com/ab1jx","followers_url":"https://api.github.com/users/ab1jx/followers","following_url":"https://api.github.com/users/ab1jx/following{/other_user}","gists_url":"https://api.github.com/users/ab1jx/gists{/gist_id}","starred_url":"https://api.github.com/users/ab1jx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ab1jx/subscriptions","organizations_url":"https://api.github.com/users/ab1jx/orgs","repos_url":"https://api.github.com/users/ab1jx/repos","events_url":"https://api.github.com/users/ab1jx/events{/privacy}","received_events_url":"https://api.github.com/users/ab1jx/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-10-05T18:31:25Z","updated_at":"2015-10-07T17:12:02Z","closed_at":null,"body":"I want to plot with Gnuplot, which as I recall basically connects data points in the order in which they appear in the data file.  I want them chronologically sorted, not in order of inverse signal strength or some such.  I gave up and wrote something to preprocess the data anyway because I was having trouble getting the dates and times to work in Gnuplot.\r\n\r\nGreat app though, most of the time my cell signal is at -95 dbm or worse.  The strength varies by itself without even moving the phone.  I'm a ham, and it's good to have something more quantitative than a number of bars.\r\n\r\nSo enhancement, by all means, for this one."},"comment":{"url":"https://api.github.com/repos/caarmen/network-monitor/issues/comments/146265101","html_url":"https://github.com/caarmen/network-monitor/issues/69#issuecomment-146265101","issue_url":"https://api.github.com/repos/caarmen/network-monitor/issues/69","id":146265101,"user":{"login":"ab1jx","id":3131978,"avatar_url":"https://avatars.githubusercontent.com/u/3131978?v=3","gravatar_id":"","url":"https://api.github.com/users/ab1jx","html_url":"https://github.com/ab1jx","followers_url":"https://api.github.com/users/ab1jx/followers","following_url":"https://api.github.com/users/ab1jx/following{/other_user}","gists_url":"https://api.github.com/users/ab1jx/gists{/gist_id}","starred_url":"https://api.github.com/users/ab1jx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ab1jx/subscriptions","organizations_url":"https://api.github.com/users/ab1jx/orgs","repos_url":"https://api.github.com/users/ab1jx/repos","events_url":"https://api.github.com/users/ab1jx/events{/privacy}","received_events_url":"https://api.github.com/users/ab1jx/received_events","type":"User","site_admin":false},"created_at":"2015-10-07T17:12:02Z","updated_at":"2015-10-07T17:12:02Z","body":"I'm not sure it's useful but this is what I had in mind.  There are\nlots of things you can do with Gnuplot, I think books have been\nwritten about it.  This data is for part of a 2 day stretch and it\nshows that at times none of the 4 cell towers plotted gives me a\nusable signal.  That's in October with the leaves on the trees, it'll\nprobably be different in January.\n\nIn sqlite3 (the command line client) I did (for each cell tower):\n\n.output 131778597.csv\n\nselect datetime(timestamp/1000,'unixepoch'), cell_signal_strength_dbm\nfrom networkmonitor where gsm_full_cell_id=131778597 order by\ntimestamp;\n\nThen I ran Gnuplot with this script (note you have to change the\nxrange each time):\n\nreset\nset terminal gif size 1000,700\nset output \"logs.gif\"\nset style data dots\nset timefmt \"%Y-%m-%d %H:%M:%S\"\nset xdata time\nset datafile sep '|'\nset format x \"%d_%H:%M\"\nset xrange[\"2015-10-04 05:50:00\" : \"2015-10-06 13:10:00\"]\nplot '131778597.csv' using 1:2 title '131778597',\\\n '131778962.csv' using 1:2 title '131778962',\\\n '131779032.csv' using 1:2 title '131779032',\\\n '131779038.csv' using 1:2 title '131779038'\n\nLooking at the plot, pick any horizontal position and see where the\nhighest dot plotted is, then read the signal dBm at the left.  In some\nplaces it falls through all of them and at times I see no service at\nall.\n\nIt was the\nselect datetime(timestamp/1000,'unixepoch')\nthat was the most trouble, I had to post a question on Stackoverflow\nabout it.  And it doesn't do what I'd expect, it gives times like\n2015-10-04 08:12:33 but the timefmt line in the Gnuplot script tells\nthat what to expect.\n\n\nOn 10/6/15, Alan Corey <alan01346@gmail.com> wrote:\n> No, it's that it's including fields that don't show in the GUI that's\n> nice.  I might not want to look at them all the time but it's nice to\n> have them.  I didn't try the GPS data.  Around home I don't care about\n> it but I also belong to opencellid.org so I used to run Tower\n> Collector with my phone on my dash when I went somewhere, then upload\n> the results.  Even cell companies don't really know what their own\n> coverage is really like and trying to find out where a tower is\n> located from the number is like pulling hen's teeth.  I attached a CSV\n> from Tower Collector but you need a nasty long (36 characters) key to\n> upload.  Somebody else is collecting data I think too but this is free\n> to the public.  If you sign up you can download the database.  I used\n> a program not really meant for that to plot some.\n>\n> The 4-digit thing might have been an email fluke, I only saw it once.\n>\n> I don't think any sane person would try to remove an external SD card\n> without at least shutting down first.  As of Android 5 apps can't\n> write to external SD probably because Google is trying to promote\n> Cloud storage.  They relented and made it so you sort of can with\n> limitations.  I've got a phone with a 64 gig SD card and I can't\n> install any more apps because it mostly doesn't use it.  I've got 58\n> gigs free on it.\n>\n> I've got an idea for a plot, I want to use different colors for the\n> different cell towers around here and plot points so you can see\n> signal vs time and which tower it came from.  Right now the catch is\n> that when I export your timestamps from sqlite I get numbers like\n> 1444136521233, which looks like a unix time_t but the date in there is\n> Mon Jan 18 22:14:07 2038 so they're way out of range and Gnuplot\n> rejects them.  It's currently 1444167810.  There are 3 extra digits on\n> the end.\n> On 10/6/15, Carmen Alvarez <notifications@github.com> wrote:\n>> Hello.\n>>> Works great, can even get to fields I didn't have in the GUI\n>>\n>> Actually, you should be able to see these fields in the UI too.  In the\n>> log\n>> view, go to menu->Fields to monitor, and you can add or remove the fields\n>> you want to appear in the UI.\n>>\n>>> Notice the 4-digit day of month and also second\n>>\n>> Oops, looks like we have a bug :)  I'll take a look.\n>>\n>>> How about making a new database each day (or week) with the date in the\n>>> file name?\n>>\n>> I'll think about this feature.  For now, there is an option to\n>> periodically\n>> send yourself the export (raw db, excel, whatever format you want) by\n>> e-mail.  I know it's not the same as having them all saved to the SD\n>> card.\n>>\n>>> Bummer about apps not being able to write to external SD in Android 5+\n>>\n>> I'll take a look at this.  I guess the problem with writing the main DB to\n>> a\n>> removable SD card is that if you do remove the card, all the data in\n>> network\n>> monitor will be lost.  Then, I guess if it's still running, the app may\n>> start to write to the \"internal\" SD card.  Then, if you put back in the\n>> removable SD card, the app would need some logic to merge the DB from\n>> both\n>> sources.  I should inform myself more on how apps are supposed to manage\n>> this :)\n>>\n>> Could you share an example of the GnuPlot files you've created?  It might\n>> be\n>> interesting to add a new export format: to make the app export directly in\n>> a\n>> format you can load in GnuPlot directly.\n>>\n>>\n>>\n>> ---\n>> Reply to this email directly or view it on GitHub:\n>> https://github.com/caarmen/network-monitor/issues/69#issuecomment-145966938\n>\n>\n> --\n> Credit is the root of all evil.  - AB1JX\n>\n\n\n-- \nCredit is the root of all evil.  - AB1JX\n"}}