X6100 sqlite DB. Commands to change CW memory, VFO memory, CW filter bandwidth etc.

x6100_sqlite.txt

# using ssh or console, login to your X6100


#  stop GUI  
[root@XIEGU-x6100:/root]#  /etc/init.d/S99userappstart  stop
Stopping user app daemon: stopped /usr/app_qt/x6100_ui_v100 (pid 248)
OK

# recently monit introduced, now stop/start as below:
[root@XIEGU-x6100:/]# cat ./etc/monitrc
set daemon 30
check process x6100_ui_v100
    matching "x6100_ui_v100"
    start program = "/usr/share/support/userapp start"
    stop  program = "/usr/share/support/userapp stop"





# modify database table

[root@XIEGU-x6100:/root]# cd /usr/app_qt/

[root@XIEGU-x6100:/usr/app_qt]# sqlite3 xparam.db
SQLite version 3.32.3 2020-06-18 14:00:33
Enter ".help" for usage hints.

# example 1: modify CW message text 
sqlite> UPDATE wparam SET  pv = "CQ 44 DE AA9AA/p AA9AA/p +K"  WHERE pname = 'msg04';
sqlite>
# NB. adjust parameters of UPDATE command with your test.  Column pname values can be "msg01" to "msg05"  ( 1st - 5th message)

# example 2: modify CW filter width  ( it will be 2000Hz, from 400 to 2400)
update wparam set pv='400|2400' where pname='text_cwflt_3_2';
update wparam set pv='400|2400' where pname='text_cwflt_3_1';
update wparam set pdef='400|2400' where pname='text_cwflt_3_2';
update wparam set pdef='400|2400' where pname='text_cwflt_3_1';

# ".quit"   to exit sqlite
sqlite>  .quit

#  (re)start GUI  and check new CW messages or new CW filter3 
[root@XIEGU-x6100:/root]#  /etc/init.d/S99userappstart  start
Starting user app daemon: OK
[root@XIEGU-x6100:/root]#



#  VFO memories can also be modified
INSERT INTO memory VALUES('M0002','3560000,0,3,0,0','7050055,2,3,0,0','exa','');

content or vfo memories stored in "memory" table



# dumping DB content
sqlite> .output dump.txt
sqlite> .dump
sqlite> .quit



Content of SQLITE dump:

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE bandstack(ch TEXT PRIMARY KEY, vfoa TEXT, vfob TEXT, chtag TEXT, flags TEXT);
INSERT INTO bandstack VALUES('M0000','503000,0,0,0,0','503000,0,0,0,0','','');
INSERT INTO bandstack VALUES('M0001','1801000,0,0,0,0','1801000,0,0,0,0','','');
INSERT INTO bandstack VALUES('M0002','2500000,6,3,0,0','2500000,6,3,0,0','','');
INSERT INTO bandstack VALUES('M0003','3800000,0,3,0,0','3800000,0,3,0,0','','');
INSERT INTO bandstack VALUES('M0004','4500000,6,3,0,0','4500000,6,3,0,0','','');
INSERT INTO bandstack VALUES('M0005','5400000,0,3,0,0','5400000,0,3,0,0','','');
INSERT INTO bandstack VALUES('M0006','6999000,4,3,0,0','6999000,4,3,0,0','','');
INSERT INTO bandstack VALUES('M0007','7072000,4,3,0,0','7072000,4,3,0,0','','');
INSERT INTO bandstack VALUES('M0008','10099000,2,3,0,0','10099000,2,3,0,0','','');
INSERT INTO bandstack VALUES('M0009','10119000,2,3,0,0','10119000,2,3,0,0','','');
INSERT INTO bandstack VALUES('M0010','13999000,2,3,0,0','13999000,2,3,0,0','','');
INSERT INTO bandstack VALUES('M0011','14000000,2,3,0,0','14000000,2,3,0,0','','');
INSERT INTO bandstack VALUES('M0012','14581000,6,3,0,0','14581000,6,3,0,0','','');
INSERT INTO bandstack VALUES('M0013','18100000,4,0,0,0','18100000,4,0,0,0','','');
INSERT INTO bandstack VALUES('M0014','20500000,6,3,0,0','20500000,6,3,0,0','','');
INSERT INTO bandstack VALUES('M0015','21024800,2,3,0,0','21024800,2,3,0,0','','');
INSERT INTO bandstack VALUES('M0016','22500000,6,3,0,0','22500000,6,3,0,0','','');
INSERT INTO bandstack VALUES('M0017','24897200,2,3,0,0','24897200,2,3,0,0','','');
INSERT INTO bandstack VALUES('M0018','25500000,6,3,0,0','25500000,6,3,0,0','','');
INSERT INTO bandstack VALUES('M0019','28146300,2,0,0,0','28146300,2,0,0,0','','');
INSERT INTO bandstack VALUES('M0020','30500000,6,3,0,0','30500000,6,3,0,0','','');
INSERT INTO bandstack VALUES('M0021','51000000,2,3,0,0','51000000,2,3,0,0','','');
INSERT INTO bandstack VALUES('M0022','55000000,6,3,0,0','55000000,6,3,0,0','','');
CREATE TABLE memory(ch TEXT PRIMARY KEY, vfoa TEXT, vfob TEXT, chtag TEXT, flags TEXT);
INSERT INTO memory VALUES('M0000','14024500,2,3,0,0','7050000,0,3,0,0','','');
CREATE TABLE atunetwork(freq TEXT PRIMARY KEY, network TEXT, reserve1 TEXT, reserve2 TEXT);
INSERT INTO atunetwork VALUES('f0281','0,0,0','','');
INSERT INTO atunetwork VALUES('f0140','0,0,0','','');
INSERT INTO atunetwork VALUES('f0362','0,0,0','','');
CREATE TABLE vfoa(pname TEXT PRIMARY KEY, ptag TEXT, pv TEXT, pdef TEXT, pprop TEXT, pfmt TEXT);
INSERT INTO vfoa VALUES('agc','AGC','3','3','1,1,0,3','s,OFF,SLOW,FAST,AUTO');
INSERT INTO vfoa VALUES('att','ATT','0','0','1,1,0,1','s,OFF,ON');
INSERT INTO vfoa VALUES('freq','FREQ','14078000','14270000','10,0,50000,55000000','d, ');
INSERT INTO vfoa VALUES('mode','MODE','2','2','1,1,0,7','s,LSB,LSB-DIG,USB,USB-DIG,CW,CWR,AM,NFM');
INSERT INTO vfoa VALUES('pre','PRE','0','0','1,1,0,1','s,OFF,ON');
CREATE TABLE vfob(pname TEXT PRIMARY KEY, ptag TEXT, pv TEXT, pdef TEXT, pprop TEXT, pfmt TEXT);
INSERT INTO vfob VALUES('agc','AGC','3','3','1,1,0,3','s,OFF,SLOW,FAST,AUTO');
INSERT INTO vfob VALUES('att','ATT','0','0','1,1,0,1','s,OFF,ON');
INSERT INTO vfob VALUES('freq','FREQ','7050000','7050000','10,0,50000,55000000','d, ');
INSERT INTO vfob VALUES('mode','MODE','0','0','1,1,0,7','s,LSB,LSB-DIG,USB,USB-DIG,CW,CWR,AM,NFM');
INSERT INTO vfob VALUES('pre','PRE','0','0','1,1,0,1','s,OFF,ON');
CREATE TABLE wparam(pname TEXT PRIMARY KEY, ptag TEXT, pv TEXT, pdef TEXT, pprop TEXT, pfmt TEXT);
INSERT INTO wparam VALUES('affftave','AF FFT AVE','0','0','1,0,0,10','d, ');
INSERT INTO wparam VALUES('affftref','AF FFT REF','0','0','1,0,-20,20','d,dBFs');
INSERT INTO wparam VALUES('agchang','AGC HANG','0','0','1,0,0,1','s,OFF,ON');
INSERT INTO wparam VALUES('agcknee','AGC KNEE','-60','-60','1,0,-100,-60','d,dB');
INSERT INTO wparam VALUES('agcslope','AGC SLOPE','6','6','1,0,0,10','d,dB');
INSERT INTO wparam VALUES('atue','ATUE','0','0','1,1,0,1','d, ');
INSERT INTO wparam VALUES('auxiqen','IQ OUT EN','0','0','1,1,0,1','s,OFF,ON');
INSERT INTO wparam VALUES('bias_drive','DRIVE BIAS','450','450','1,0,0,650','d, ');
INSERT INTO wparam VALUES('bias_final','FINAL BIAS','650','650','1,0,0,900','d, ');
INSERT INTO wparam VALUES('bllevel','BL LEVEL','6','5','1,1,1,10','d, ');
INSERT INTO wparam VALUES('bsmode','BANDSTACK','0','0','1,0,0,1','s,HAM BAND,ALL BAND');
INSERT INTO wparam VALUES('bten','BLUETOOTH ENABLE','0','0','1,1,0,1','s,OFF,ON ');
INSERT INTO wparam VALUES('chge','CHARGER','1','1','1,0,0,1','s,OFF,ON');
INSERT INTO wparam VALUES('chnum','CHANNEL','0','0','1,0,0,9999','d, ');
INSERT INTO wparam VALUES('cmpe','CMPE','0','0','1,1,0,1','d, ');
INSERT INTO wparam VALUES('cmplevel','CMP LEVEL','0','0','1,0,0,3','s,OFF,1:2,1:4,1:8');
INSERT INTO wparam VALUES('cwtone','CW PITCH','800','800','10,0,400,1200','d,Hz');
INSERT INTO wparam VALUES('cwtrain','CW TRAINER','0','0','1,1,0,1','s,OFF,ON');
INSERT INTO wparam VALUES('cwvol','CW VOLUM','10','10','1,0,0,32','d, ');
INSERT INTO wparam VALUES('dnfcnt','DNF CENTER','1000','1000','50,0,100,3000','d, ');
INSERT INTO wparam VALUES('dnfe','DNF ENABLE','0','0','1,0,0,1','s,OFF,ON ');
INSERT INTO wparam VALUES('dnfwidth','DNF WIDTH','50','50','1,0,10,100','d, ');
INSERT INTO wparam VALUES('fftave','RF FFT AVE','0','0','1,0,0,10','d, ');
INSERT INTO wparam VALUES('fftdec','FFT SPAN','0','0','1,0,0,1','s,100k,50k');
INSERT INTO wparam VALUES('fftref','RF FFT REF','0','0','1,0,-10,+10','d,dBm');
INSERT INTO wparam VALUES('fltgrp_am','AM FILTER GROUP','0','0','1,1,0,2','d, ');
INSERT INTO wparam VALUES('fltgrp_cw','CW FILTER GROUP','0','0','1,1,0,2','d, ');
INSERT INTO wparam VALUES('fltgrp_nfm','NFM FILTER GROUP','0','0','1,1,0,2','d, ');
INSERT INTO wparam VALUES('fltgrp_ssb','SSB FILTER GROUP','0','0','1,1,0,2','d, ');
INSERT INTO wparam VALUES('handle_f1','HANDLE F1','0','0','1,0,0,4','s,PRE,ATT,AGC,TS-,TS+ ');
INSERT INTO wparam VALUES('handle_f2','HANDLE F2','0','0','1,0,0,3','s,NR,NB,DNF,CW TRAINER ');
INSERT INTO wparam VALUES('hmicg','H-MIC GAIN','10','10','1,0,0,36','d, ');
INSERT INTO wparam VALUES('imicg','I-MIC GAIN','10','10','1,0,0,36','d, ');
INSERT INTO wparam VALUES('kimb','IAMBIC MODE','1','1','1,1,0,1','s,IAMBIC-A,IAMBIC-B');
INSERT INTO wparam VALUES('km','KEYER MODE','0','0','1,1,0,2','s,MANUAL,AUTO-LEFT,AUTO-RIGHT');
INSERT INTO wparam VALUES('kr','CW RATIO','3','3.0','0.1,0,2.5,4.5','1.1f, ');
INSERT INTO wparam VALUES('ks','KEYER SPEED','15','15','1,0,5,50','d,WPM');
INSERT INTO wparam VALUES('ling','LINE IN LV','10','10','1,0,0,36','d, ');
INSERT INTO wparam VALUES('lock','LOCK','0','0','1,1,0,1','d, ');
INSERT INTO wparam VALUES('loutg','LINE OUT LV','10','10','1,0,0,36','d, ');
INSERT INTO wparam VALUES('mdmmode','MODEM MODE','2','0','1,1,0,2','s,BPSK,RTTY,CW ');
INSERT INTO wparam VALUES('menuidx_dispsettings','DISP SETTINGS','6','0','0,0,0,100','d, ');
INSERT INTO wparam VALUES('menuidx_key','MENU INDEX CW/KEYER SETTING','0','0','0,0,0,100','d, ');
INSERT INTO wparam VALUES('menuidx_radiosetting','MENU INDEX RADIO SETTING','0','0','0,0,0,100','d, ');
INSERT INTO wparam VALUES('menuidx_radiosetting1','RADIO SETTING1','3','0','0,0,0,100','d, ');
INSERT INTO wparam VALUES('menuidx_radiosetting2','RADIO SETTING2','0','0','0,0,0,100','d, ');
INSERT INTO wparam VALUES('micsel','MIC SEL','2','2','1,0,0,2','s,BUILT-IN,HANDLE,AUTO');
INSERT INTO wparam VALUES('modemafc','MODEM AFC','0','0','1,1,0,1','s,OFF,ON ');
INSERT INTO wparam VALUES('modemen','MODEM ENABLE','0','0','1,0,0,1','s,OFF,ON ');
INSERT INTO wparam VALUES('modemfc','MODEM FC','1000','1000','1,0,500,2500','d, ');
INSERT INTO wparam VALUES('modemsql','MODEM SQL','0','0','1,0,0,100','d, ');
INSERT INTO wparam VALUES('monilevel','MONI LEVEL','0','0','1,0,0,100','d, ');
INSERT INTO wparam VALUES('msg01','MSG01','X6100','X6100','0,0,0,0','d, ');
INSERT INTO wparam VALUES('msg02','MSG02','','','0,0,0,0','d, ');
INSERT INTO wparam VALUES('msg03','MSG03','','','0,0,0,0','d, ');
INSERT INTO wparam VALUES('msg04','MSG04','','','0,0,0,0','d, ');
INSERT INTO wparam VALUES('msg05','MSG05','','','0,0,0,0','d, ');
INSERT INTO wparam VALUES('nbe','NB ENABLE','0','0','1,0,0,1','s,OFF,ON ');
INSERT INTO wparam VALUES('nbthr','NB LEVEL','0','10','1,0,0,100','d, ');
INSERT INTO wparam VALUES('nbw','NB WIDTH','10','10','1,0,0,100','d, ');
INSERT INTO wparam VALUES('nre','NR ENABLE','0','0','1,0,0,1','s,OFF,ON ');
INSERT INTO wparam VALUES('nrthr','NR DEPTH','0','0','1,0,0,60','d, ');
INSERT INTO wparam VALUES('pskrate','PSK RATE','0','0','1,0,0,2','s,PSK31,PSK63,PSK125 ');
INSERT INTO wparam VALUES('pttmode','PTT MODE','0','0','1,0,0,1','s,NORMAL,TOGGLE');
INSERT INTO wparam VALUES('pwrsync','PWR SYNC','2000000','2000000','1000,0,500000,2200000','d, ');
INSERT INTO wparam VALUES('qsktime','QSK TIME','100','100','10,0,0,1000','d,ms');
INSERT INTO wparam VALUES('rfg','RF GAIN','97','50','1,0,10,100','d,%');
INSERT INTO wparam VALUES('rit','RIT','0','0','10,0,-1500,1500','d, ');
INSERT INTO wparam VALUES('rmagcmp','RX MAG COMP','0','0','1,0,-10000,10000','d, ');
INSERT INTO wparam VALUES('rphscmp','RX PHS COMP','0','0','1,0,-60000,60000','d, ');
INSERT INTO wparam VALUES('rttyrate','RTTY RATE','0','0','1,0,0,9','s,45,45.45,50,56,75,100,110,150,200,300 ');
INSERT INTO wparam VALUES('rttyshift','RTTY SHIFT','0','0','1,0,0,9','s,23,85,160,170,182,200,240,350,425,850 ');
INSERT INTO wparam VALUES('rxvol','RX VOLUM','0','30','1,0,0,50','d, ');
INSERT INTO wparam VALUES('sple','SPLE','0','0','1,0,0,1','s,OFF,ON');
INSERT INTO wparam VALUES('spmode','S/P MODE','0','0','1,0,0,1','s,SPEAKER,EAR PHONE');
INSERT INTO wparam VALUES('sqlthr','VOICE SQL','0','0','1,0,0,100','d, ');
INSERT INTO wparam VALUES('swrs_span','SWR SCAN SPAN','0','0','1,0,0,4','s,x1,x2,x3,x4,x5 ');
INSERT INTO wparam VALUES('swrs_spd','SWR SCAN SPEED','1','0','1,0,0,3','s,1000,2000,5000,10000 ');
INSERT INTO wparam VALUES('text_amflt_1_1','AM FILTER 1-1','-4500|4500','-4500|4500','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_amflt_1_2','AM FILTER 1-2','-4500|4500','-4500|4500','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_amflt_2_1','AM FILTER 2-1','-3000|3000','-3000|3000','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_amflt_2_2','AM FILTER 2-2','-3000|3000','-3000|3000','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_amflt_3_1','AM FILTER 3-1','-1500|1500','-1500|1500','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_amflt_3_2','AM FILTER 3-2','-1500|1500','-1500|1500','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_btdevice','BLUETOOTH DEVICE','','','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_cwflt_1_1','CW FILTER 1-1','550|1050','550|1050','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_cwflt_1_2','CW FILTER 1-2','550|1050','550|1050','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_cwflt_2_1','CW FILTER 2-1','675|925','675|925','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_cwflt_2_2','CW FILTER 2-2','675|925','675|925','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_cwflt_3_1','CW FILTER 3-1','725|875','725|875','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_cwflt_3_2','CW FILTER 3-2','725|875','725|875','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_nfmflt_1_1','NFM FILTER 1-1','-7500|7500','-7500|7500','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_nfmflt_1_2','NFM FILTER 1-2','-7500|7500','-7500|7500','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_nfmflt_2_1','NFM FILTER 2-1','-5000|5000','-5000|5000','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_nfmflt_2_2','NFM FILTER 2-2','-5000|5000','-5000|5000','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_nfmflt_3_1','NFM FILTER 3-1','-3500|3500','-3500|3500','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_nfmflt_3_2','NFM FILTER 3-2','-3500|3500','-3500|3500','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_ntp_server1','text_ntp_server1','pool.ntp.org','','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_ntp_server2','text_ntp_server2','asia.pool.ntp.org','','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_ssbflt_1_1','SSB FILTER 1-1','150|2850','150|2850','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_ssbflt_1_2','SSB FILTER 1-2','150|2850','150|2850','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_ssbflt_2_1','SSB FILTER 2-1','300|2700','300|2700','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_ssbflt_2_2','SSB FILTER 2-2','300|2700','300|2700','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_ssbflt_3_1','SSB FILTER 3-1','600|2400','600|2400','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_ssbflt_3_2','SSB FILTER 3-2','600|2400','600|2400','0,0,0,0','d, ');
INSERT INTO wparam VALUES('text_wifiap','WIFI AP','','','0,0,0,0','d, ');
INSERT INTO wparam VALUES('tfi','TWINE FILTER INDEX','0','0','1,1,0,1','d, ');
INSERT INTO wparam VALUES('ts','TUNE STEP','3','2','1,1,1,3','d, ');
INSERT INTO wparam VALUES('txiofs','TXI DC OFFSET','0','0','1,0,-10000,10000','d, ');
INSERT INTO wparam VALUES('txpwr','TX POWER','3','5.0','1.0,0.0,0.1,10.0','1.1f,W');
INSERT INTO wparam VALUES('txqofs','TXQ DC OFFSET','0','0','1,0,-10000,10000','d, ');
INSERT INTO wparam VALUES('vi','VFO INDEX','0','0','1,1,0,1','d, ');
INSERT INTO wparam VALUES('vm','VFO/MEMO','0','0','1,1,0,1','d, ');
INSERT INTO wparam VALUES('voxag','VOX ANTI-G','0','0','1,0,0,100','d,%');
INSERT INTO wparam VALUES('voxdly','VOX DELAY','100','100','100,0,0,2000','d,ms');
INSERT INTO wparam VALUES('voxe','VOX ENABLE','0','0','1,1,0,1','d, ');
INSERT INTO wparam VALUES('voxg','VOX GAIN','50','50','1,0,0,100','d,%');
INSERT INTO wparam VALUES('wfref','WF REF','0','0','1,0,-10,+10','d,dBm');
INSERT INTO wparam VALUES('wifien','WIFI ENABLE','1','0','1,0,0,1','s,OFF,ON ');
INSERT INTO wparam VALUES('xit','XIT','0','0','10,0,-1500,1500','d, ');
COMMIT;


###  other stuff
.headers ON


##  CW filter

sqlite> select * from wparam where pname='text_cwflt_3_2';
pname|ptag|pv|pdef|pprop|pfmt
text_cwflt_3_2|CW FILTER 3-2|725|875|725|875|0,0,0,0|d,


update wparam set pv='425|2075' where pname='text_cwflt_3_2';
update wparam set pv='425|2075' where pname='text_cwflt_3_1';
update wparam set pdef='425|2075' where pname='text_cwflt_3_2';
update wparam set pdef='425|2075' where pname='text_cwflt_3_1';

hi branko,
vielen dank für deine Ausarbeitung.
Die sql abfragen sind sehr hilfreich!!
Ich suche die Parameter des ATU. Ich möchte die Parameter von L/C der ATU auswerten.
Ich denke es wird "nur" ein Hex wert ausgegeben, die kann man als Richtwert versuchen zu "interpretieren" .
Ziel ist das verhalten der ATU mit unterschiedlichen Antennen und Bänder zugestehen.
Hast du eine Idee wie ich an diese Werte komme, in der sqlite scheinen sie nicht zustehen.
Ich vermute das der STM32 den ATU steuert? kann man den abfragen?

schon mal vielen Danke für eine Zeit
73 de dl2dbg Uli

in table memory
VFO memories can also be modified
INSERT INTO memory VALUES('M0002','3560000,Mode,3,0,0','7050055,Mode,3,0,0','exa','');
Mode numbers as following:
0=LSB;1=L-DIG;2=USB;3=U-DIG;4=CW;5=CW-R;6=AM;7=FM(narrow)

many thanks vy 73 de DL1KV Kevin