Hi Joe,
No worries on the reply; I know you and Steve have been hard after this
new decoder stuff, which is far more important.
I've been playing with Python Scripts and such; creating tables, queries
and things for WSJT, but nothing with WSJT-X. I was toying with an Idea
of add a contest logging for WSJT (VHF+ / EME contests) that would
procedure the Cab file and real time contest scoring.
I also looked at how SQLite could be used to augment WSPR (staging
uploads to WSPRNet, personal decode DB's, and FMTests data storage).
There's so many possibilities it's hard to stay focused on one Idea ;-)
More to the point, No, I don't have anything that is presentable as of
yet. My biggest challenge with WSJT-X is C++, I'm struggling with
getting the basics down.
73's
Greg, KI7MT
On 10/20/2015 14:05, Joe Taylor wrote:
> Hi Greg,
>
> I intended to respond to this message of yours some weeks ago, but
> apparently forgot to do so.
>
> Basically, I think it's a good idea to look carefully at possible use of
> SQLite for several tasks in WSJT-X: logging and a replacement for
> CALL3.TXT are two good possibilities.
>
> Have you gone any further with the idea?
>
> -- Joe, K1JT
>
> On 8/18/2015 1:43 PM, KI7MT wrote:
>> 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
>
> ------------------------------------------------------------------------------
> _______________________________________________
> wsjt-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/wsjt-devel
>
------------------------------------------------------------------------------
_______________________________________________
wsjt-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wsjt-devel
