Greets to all!
I am involved with the radio club at the Battleship New Jersey museum-ship in Camden, NJ (http://www.nj2bb.org/), and we have 4 stations in the club. Currently they are logging with an OLD Win-XP setup - one PC at each station. Aside from being tied to old logging programs, and the security issues of Windows, the logging data has to be collected from each PC and consolidated on another box in the secretary's machine.
Switching these boxes to Linux may have many benefits - but the big quesiton is: Can one mySQL db be used by all 4 stations? And how is the contents of the log viewed? They curently pull summary info from the logs to put up a list of the number of QSO's done by each member.
Would a custom app be needed to create reports from the DB or is that part of the system - assuming mutlple operators can send to DB.
It would seem that a Windows machine could acess the server via an ODBC connection and generate reports that way. Has this been done? Info and ideas welcome! :-)
=Alan R.
Sun, 2014-11-02 19:06
#1
Can CQR be used by multiple operators at one location?
Hi Alan,
yes, you can use cqrlog on multiple machines but there could be a problem with configuration. When you change something like window position, it will be the same on all computers. The same with keying device and TRX control. There is a way how to have different CAT interface on each computer but CW keying device has to be the same.
When you open CQRLOG, there is log list window with checkbox on the top - Save log data to local machine. After you uncheck it, database connection preferences will appear.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Thanks Petr - Sounds like this might not be such a good thing for our club setup. I like the the general layout and all, but each station has to be pretty much independant. Each station has it's own radio & PC.
=Alan R.
But there is a way... . You can create three different logs, create view in database and use it to export data. Once you have data in database, you can do whatever you want :).
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
There is no problem with different radio, problem will be if the staion has different screen resolution etc. I want to fix this problem and store some configuration to local files (window positions, radio, cw interface etc.).
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
"I want to fix this problem and store some configuration to local files (window positions, radio, cw interface etc.)."
Yes please! I use two machines, both connected to the same MySQL database. This works well as I have rigctld controlling the radio, so they can both have the same information. But the screen size and displayed windows on both machines are different.
Another thing to consider for multiple computers, some things are local that IMHO should not be - for example I get prompted to update QSL Managers and DXCC on both computers, even though they're updating the same database.
DXCC prompt has to be on both computers because cqrlog uses local files and also data stored in database. The database contains only reference tables but all other data are used directly from text file on local machine. It's much faster.
QSL managers database is stored in a mysql table and there is no need to download it twice. I'll fix it. If you have any ideas what should be changed to work on two computers, please let me know. Thank you!
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com