Exporting / importing the blacklist

[sba923]

Hi,

I would like to export my current blacklist to my PC, add a number of wildcard entries gathered from various places, and then import the modified list back.

Can this be done?

So far, I've been able to extract the backlist from the SQlite database in a backup, so I should be able to edit that, create an updated backup file, and restore that, but I'm wondering whether there's a less contrived way...

 

[admin]

Hi,

I would like to export my current blacklist to my PC, add a number of wildcard entries gathered from various places, and then import the modified list back.

Can this be done?

So far, I've been able to extract the backlist from the SQlite database in a backup, so I should be able to edit that, create an updated backup file, and restore that, but I'm wondering whether there's a less contrived way...

Hi!

Unfortunately, there is currently no simple built-in way to export, edit, and import the blacklist.
I would have suggested working with the SQLite database from the backup, but you’ve already figured that out yourself

 

[sba923]

That has worked, with an AI-generated INSERT statement containing a list of NL UK FR nuisance blocks (here it is, for those interested -- note that the ID has to start at 1+your current highest ID):

INSERT INTO bwDB (id, phone, type, name, comment) VALUES
(33, '+44121790*', 1, 'Birmingham (DIDWW VoIP block)', NULL),
(34, '+44151947*', 1, 'Liverpool (DIDWW VoIP block)', NULL),
(35, '+44161394*', 1, 'Manchester (DIDWW VoIP block)', NULL),
(36, '+44113328*', 1, 'Leeds (DIDWW VoIP block)', NULL),
(37, '+44141530*', 1, 'Glasgow (DIDWW VoIP block)', NULL),

(38, '+44203807*', 1, 'London (Magrathea VoIP block)', NULL),
(39, '+44203966*', 1, 'London (Magrathea VoIP block)', NULL),
(40, '+44330127*', 1, 'UK National (Magrathea VoIP block)', NULL),
(41, '+44330998*', 1, 'UK National (Magrathea VoIP block)', NULL),

(42, '+447400*', 1, 'UK Mobile‑looking VoIP (Wavecrest/Bandwidth)', NULL),
(43, '+447450*', 1, 'UK Mobile‑looking VoIP (Wavecrest/Bandwidth)', NULL),
(44, '+447451*', 1, 'UK Mobile‑looking VoIP (Wavecrest/Bandwidth)', NULL),
(45, '+447460*', 1, 'UK Mobile‑looking VoIP (Wavecrest/Bandwidth)', NULL),
(46, '+447480*', 1, 'UK Mobile‑looking VoIP (Wavecrest/Bandwidth)', NULL),

(47, '+4470*', 1, 'UK Personal Redirect (high‑risk scam range)', NULL),
(48, '+4484*', 1, 'UK Service‑charge numbers (spam/scam)', NULL),
(49, '+4487*', 1, 'UK Service‑charge numbers (spam/scam)', NULL),
(50, '+44900*', 1, 'UK Premium‑rate (fraud)', NULL),

(51, '+3185*', 1, 'NL VoIP business (telemarketing)', NULL),
(52, '+3188*', 1, 'NL Corporate VoIP (telemarketing)', NULL),
(53, '+3197*', 1, 'NL M2M/VoIP (misused for spam)', NULL),
(54, '+3120218*', 1, 'Amsterdam (VoIP spam block)', NULL),
(55, '+3110808*', 1, 'Rotterdam (VoIP spam block)', NULL),

(56, '+33970*', 1, 'France VoIP (nuisance)', NULL),
(57, '+33972*', 1, 'France VoIP (nuisance)', NULL),
(58, '+33974*', 1, 'France VoIP (nuisance)', NULL),
(59, '+33975*', 1, 'France VoIP (nuisance)', NULL),

(60, '+33899*', 1, 'France Premium‑rate (fraud)', NULL),
(61, '+33890*', 1, 'France Premium‑rate (fraud)', NULL);

after adding this to the table, recreating a (zip format) .gzz file and restoring from there, I got what I wanted

View attachment 265
Would the "restore" operation work if the zipfile would contain only the bwDB file?

 

[admin]

That has worked, with an AI-generated INSERT statement containing a list of NL UK FR nuisance blocks (here it is, for those interested -- note that the ID has to start at 1+your current highest ID):

INSERT INTO bwDB (id, phone, type, name, comment) VALUES
(33, '+44121790*', 1, 'Birmingham (DIDWW VoIP block)', NULL),
(34, '+44151947*', 1, 'Liverpool (DIDWW VoIP block)', NULL),
(35, '+44161394*', 1, 'Manchester (DIDWW VoIP block)', NULL),
(36, '+44113328*', 1, 'Leeds (DIDWW VoIP block)', NULL),
(37, '+44141530*', 1, 'Glasgow (DIDWW VoIP block)', NULL),

(38, '+44203807*', 1, 'London (Magrathea VoIP block)', NULL),
(39, '+44203966*', 1, 'London (Magrathea VoIP block)', NULL),
(40, '+44330127*', 1, 'UK National (Magrathea VoIP block)', NULL),
(41, '+44330998*', 1, 'UK National (Magrathea VoIP block)', NULL),

(42, '+447400*', 1, 'UK Mobile‑looking VoIP (Wavecrest/Bandwidth)', NULL),
(43, '+447450*', 1, 'UK Mobile‑looking VoIP (Wavecrest/Bandwidth)', NULL),
(44, '+447451*', 1, 'UK Mobile‑looking VoIP (Wavecrest/Bandwidth)', NULL),
(45, '+447460*', 1, 'UK Mobile‑looking VoIP (Wavecrest/Bandwidth)', NULL),
(46, '+447480*', 1, 'UK Mobile‑looking VoIP (Wavecrest/Bandwidth)', NULL),

(47, '+4470*', 1, 'UK Personal Redirect (high‑risk scam range)', NULL),
(48, '+4484*', 1, 'UK Service‑charge numbers (spam/scam)', NULL),
(49, '+4487*', 1, 'UK Service‑charge numbers (spam/scam)', NULL),
(50, '+44900*', 1, 'UK Premium‑rate (fraud)', NULL),

(51, '+3185*', 1, 'NL VoIP business (telemarketing)', NULL),
(52, '+3188*', 1, 'NL Corporate VoIP (telemarketing)', NULL),
(53, '+3197*', 1, 'NL M2M/VoIP (misused for spam)', NULL),
(54, '+3120218*', 1, 'Amsterdam (VoIP spam block)', NULL),
(55, '+3110808*', 1, 'Rotterdam (VoIP spam block)', NULL),

(56, '+33970*', 1, 'France VoIP (nuisance)', NULL),
(57, '+33972*', 1, 'France VoIP (nuisance)', NULL),
(58, '+33974*', 1, 'France VoIP (nuisance)', NULL),
(59, '+33975*', 1, 'France VoIP (nuisance)', NULL),

(60, '+33899*', 1, 'France Premium‑rate (fraud)', NULL),
(61, '+33890*', 1, 'France Premium‑rate (fraud)', NULL);

after adding this to the table, recreating a (zip format) .gzz file and restoring from there, I got what I wanted

View attachment 265
Would the "restore" operation work if the zipfile would contain only the bwDB file?

Hi!

I’m glad you got it working.

As for whether restore will work with only the bwDB file in the archive — I’m afraid I don’t have a definite answer.

Could you please try it after making a full backup first? If it doesn’t work, let me know and we can ask the developers to adjust the restore function to support this case.