Copy returning mail to cebin.net:

Variant 1 - synchronize imap accounts:  (works only when mail server is installed on destination computer)

cd /home/honza/imapsync-master

./imapsync --host1 imap.vshosting.cloud --user1 projektanti@revelpex.com --password1 xxx --host2 mail.cebin.cz --user2 projektanti@revelpex.com --password2 xxx

Variant 2

Nainstalovat getmail apt-get install getmail6
přihlásit se jako uživatel honza, nastavit  mailbox v .getmail/getmailrc
spustit getmail

https://wiki.archlinux.org/title/Backup_Gmail_with_getmail

Analyze returned emails:
https://libsisimai.org/en/start/#install

/home/honza/sisimail/

Delete mailbox:

server: cebin.info - home/honza/maily/delete_emails.py - pred tim nastavit mailbox a adresar (inbox, trash)

Kdo kliknul na odkaz?

SELECT distinct email FROM nl_clicks WHERE `nl_newsletter_id` = 6

Způsob 2

./luya nlcentercmd/default/clicks 17 > nl17.txt

odstranění duplicit: sort nl17.txt | uniq

Alternativní rozesílání přes mail. program:
https://www.mailerlite.com/

Čištěni

delete from nl_contact_contactlist
where contact_id in (
select
nl_contact_contactlist.contact_id
from
nl_contact_contactlist
left join
nl_contact
on nl_contact_contactlist.contact_id = nl_contact.id
where id is NULL);

Aktuální stav:
jsagency
boftisk
revel
holandskonalodi
faramugo
antikvariatmotyl
babyoffice