Just for kicks ( and learning ), I've been playing with Sqlite3 and
adding support to a WSJT.db in addition too flat files (ALL.TXT,
Loggings, etc) JT and WSPR.
At present, I'm using WSJT for testing and such, but for all you C/C++
dev's, the Sqlite3 API is fairly straight forward.
Maybe this would be a good project for someone ( one of the core
developers ) to take on and add the logging functionality to WSJTX. SQL
is well supported in QT.
I think there's a lot of benefit to having a simple .db file for all
logging. I can't really see any downside to it, it's fast, no server
config needed, it's a single file and there are many Sqlite DB
Applications for browsing data / table structures / SQL statement
generation available for all the Major distributions (Win/*Nix/Mac etc).
I think JT-Alerts uses Sqlite for it's logging ( I'd have to verify that
though ).
Just a thought.
73's
Greg, KI7MT
On 08/18/2015 06:34 AM, Michael Black wrote:
> I use this little utility to find records in all.txt and format them a bit to
> make them easier to view and grep a 2nd time if you want a specific date for
> example.
> It adds the date and lines up the columns better.
> You'll have to change the getenv for Linux. I don't know what it uses.
>
> I also use a batch file to drive this and save a few more keystrokes.
> alltxt w9mdb %1
>
> 73
> Mike W9MDB
>
> #include <stdio.h>
> #include <string.h>
>
> char *strtoupper(char *s)
> {
> char *s2 = strdup(s);
> char *s3 = s2;
> while(*s) {
> *s2++ = toupper(*s++);
> }
> return s3;
> }
>
> int main(int argc, char*argv[])
> {
> if (argc != 3) {
> printf("Usage: %s mycall findcall\n",argv[0]);
> return 1;
> }
> char *mycallsign = strtoupper(argv[1]);
> char *findcallsign = strtoupper(argv[2]);
> char date[4096];
> char path[4096];
> char buf[4096];
>
>
> sprintf(path,"%s/AppData/Local/WSJT-X/ALL.TXT",getenv("USERPROFILE"));
>
> FILE *fp = fopen(path,"r");
>
> while(fgets(buf,sizeof(buf),fp)) {
> if (buf[4]=='-') { // then this is a date
> strncpy(date,buf,11);
> }
> else if (strstr(buf,mycallsign) && strstr(buf,findcallsign)) {
> // non-date line
> if (strstr(buf,"Trans")) { // make this a consistent
> fixed format
> char *p=strtok(buf,":");
> char *p2 = strtok(NULL,"\r\n");
> printf("%s %-36s: %s\n",date,p,p2);
> }
> else {
> char *field1 = strdup(buf);
> char *field2 = strdup(buf);
> field1[4]=0;
> strcpy(field2,&field2[5]);
> printf("%s %s
> %s",date,field1,field2);
> }
> }
> }
> fclose(fp);
>
> return 0;
>
> }
>
> -----Original Message-----
> From: Alan VK2ZIW [mailto:[email protected]]
> Sent: Tuesday, August 18, 2015 5:03 AM
> To: WSJT software development
> Subject: Re: [wsjt-devel] WSJT-X, some s/w little issues
>
> Hi,
>
> Can we have the date in "ALL.TXT" please ?
>
> This is the balloon PS-49 near New Zealand:
>
> bash-4.3$ cat ALL_WSPR.TXT | grep VK3
> 150816 1500 3 -13 -0.2 10.1402676 VK3YT RF15 27 2 1 0
> 150816 2100 2 -21 -0.7 10.1402686 VK3YT RF46 27 0 1 0
> 150816 2200 2 -24 -0.5 10.1402686 VK3YT RF46 27 0 1 0
> 150818 0700 2 -22 -0.1 10.1402676 VK3YT BF86 27 2 2 0
> 150818 0800 1 -24 -0.2 10.1402664 VK3YT BF86 27 1 100 0
> bash-4.3$ cat ALL.TXT | grep VK3
> 0702 -17 -0.1 1004 @ VK3YT1CB38S40
> 0802 -21 -0.1 1004 @ VK3YT1D738RU0
> bash-4.3$ ls -l ALL*
>
<snip>
------------------------------------------------------------------------------
_______________________________________________
wsjt-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wsjt-devel
