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';

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