Monday, May 31, 2021

Sendy Conjobs

 Cron job setup instructions appears in Sendy where appropriate:

  1. When you are at the ‘Define recipients’ page and you will see the cron job setup instructions note in a yellow box at the bottom (screenshot → http://go.sendy.co/sfO6HC)

  2. Inside any lists, click on the 'Autoresponders' button at the top right and you'll be shown the cron job setup instructions (screenshot → http://go.sendy.co/ASYhGx)

  3. When you're at the import CSV page, you'll see the cron job setup instructions in a yellow box (screenshot → http://go.sendy.co/F7iGZq)

  4. Inside any segments, you'll see the cron job setup instructions in a yellow box at the bottom (screenshot → http://go.sendy.co/IAE1aa)

For Example:


Cronjobs:
1. */5 * * * * php/home/u587798747/domains/domian.com/public_html/sendy/scheduled.php > /dev/null 2>&1

2. */1 * * * * php /home/u587798747/domains/domian.com/public_html/sendy/autoresponders.php > /dev/null 2>&1

3. */1 * * * * php /home/u587798747/domains/domain.com/public_html/sendy/import-csv.php > /dev/null 2>&1

4. */15 * * * * php /home/u587798747/domains/domain.com/public_html/sendy/update-segments.php > /dev/null 2>&1

Sunday, May 16, 2021

Upgrade PHP 7.3, 7.4 or 8.0 on CentOS 8

Install Remi Release repo and clear cache:

yum -y install http://rpms.remirepo.net/enterprise/remi-release-8.rpm && yum clean all


Install PHP packages version 7.3/7.4 /or 8.0:

yum -y install php73-php-{cli,pdo,fpm,zip,gd,xml,mysqlnd,opcache} 

yum -y install php74-php-{cli,pdo,fpm,zip,gd,xml,mysqlnd,opcache} 

yum -y install php80-php-{cli,pdo,fpm,zip,gd,xml,mysqlnd,opcache}

Saturday, May 1, 2021

How to extract Gmail, Yahoo, Hotmail, Live etc. in excel:

 (Suppose you applied the following formula in D column)

=RIGHT(A2,LEN(A2)-SEARCH("@",A2))

Now to the next of D column you can write following formula to separate specific ESP

=if(d2=”gmail.com”,”Gmail”,if(d2=”live.com”,”Live”,if(d2=”hotmail.com”,”Hotmail”,if(d2=”yahoo.com”,”Yahoo”,if(d2=”aol”,”Aol”)))))


How to extract a substring that comes after or before a specific symbol like @ in excel?

Use the following formula:

=RIGHT(A2,LEN(A2)-SEARCH("-",A2))
Before
=LEFT(A2,LEN(A2)-SEARCH("-",A2))

Extract Domain from email in Excel or Google sheet

  =TEXTAFTER( A2 , "@") or, =MID(A1, FIND("@", A1) + 1, LEN(A1) - FIND("@", A1))