Posts

Posted on

Duplicator – WordPress Plugin

Plugins > Add New > Search Duplicator (by Snap Creek)
Install > Activate
In Left Side Menu of WordPress Click on Duplicator
Create New > Next > Ck Yes and Click Build (If you site exceeds the free version, you may need to pay for this plugin)

Download the Installer & Archive to your computer.
Upload to the root directory of the url where you are moving the site.
Note: quicker upload speed through cPanel File Manager vs FTP client

Then in your browser goto yourdomain.com/installer.php
If you have a current website at this domain, it will overwrite it.
You will see Step 1 (You can view options and make any changes there that you prefer) Click Next
Step 2 Install Database
If you do not already have a database at this location you will need to choose:
Login to your cPanel > MSQL Databases > Create New > enterNameYouChoose > goback >
MySQL Users Add New > websitePrefix_enterNewUserName > Enter password twice > Create User > GoBack
Add User to Database > choose user you just created & then DB you just created > Add
Action > Create New Database > Host localhost > Database yoursitename_db > User createaname > Password CreateAPassword (make sure you save this information for later) > Add > Click All Privileges > Make Changes
Put this information in STep 2 under Basic tab > Validate > Next > OK
Step 3 Update Data > Next
Step 4 > Next

Posted on

All-In-One Migration Hangs at 100%

2 Fixes:

NUMBER 1 Install Older Version

Step 1: Check PHP configuration in your hosting’s Cpanel if “UPLOAD_MAX_FILESIZE” and “POST_MAX_SIZE” are set greater than your file’s size or 512 MB. To get more information you might contact your hosting company.

Step 2: Now you need to install a little bit older version of the All-in-One WP Migration plugin. You can download V7.5 from here.

Step 3: Go to WordPress Dashboard > Plugins > Add New > Upload Plugin > Choose File > Selected All-in-One WP Migration File Extension that you just download > Install Now.

Step 4: After installation is finished, activate the plugin and go to All-in-One WP Migration again and import your .wpress file. Now the problem should be fixed.

This is the first way to fix All-in-One WP migration Stuck at 100%

NUMBER 2 FIX Upload Backup & Restore

Step 1: First of all, export your .wpress file locally using the “Export” option

Step 2: Login to FTP using FileZilla or any other File Transfer Protocol Software to access the hosting files of your live server.

Step 3: Go to the “backup” directory of the All-in-One WP Migration Plugin; wp-content/ai1wm-backups/ and upload your .wpress file

Step 4: Now you need to restore it. Go to your WordPress Dashboard > All-in-One WP Migration > Backups, and you will find your .wpress file which is available there. Click on the “Restore” option
Step 5: After some time, you will get the below popup. Click on “Proceed” to continue:
Step 6: After a few minutes later, everything is done!:

How to Fix All-in-One WP Migration when Stuck at 100%?
Posted on

Google reCaptcha v3 on NON-WP sites

  1. Make sure you are logged in to your gMail
  2. Register your website & get your key
    GoTo: http://www.google.com/recaptcha/admin
    Click the + in top right to create new
    Type in the Website Name
    Choose v3
    Type in the Domain
    You will be admin
    Agree to Terms
    Submit
  3. You now have a site key & secret key
  4. In form html page header:
    <script src=”https://www.google.com/recaptcha/api.js?render= put your site key here “></script><script>    grecaptcha.ready(function () {        grecaptcha.execute(‘ put your site key here ‘, { action: ‘contact’ }).then(function (token) {            var recaptchaResponse = document.getElementById(‘recaptchaResponse’);            recaptchaResponse.value = token;        });    });</script>
  5. In form html page above </form>
    <input type=”hidden” name=”recaptcha_response” id=”recaptchaResponse”>
  6. In your php processing script:

<?php // Check if form was submitted:
if ($_SERVER[‘REQUEST_METHOD’] === ‘POST’ && isset($_POST[‘recaptcha_response’])) {

// Build POST request:
$recaptcha_url = 'https://www.google.com/recaptcha/api/siteverify';
$recaptcha_secret = 'Your secret key here';
$recaptcha_response = $_POST['recaptcha_response'];

// Make and decode POST request:
$recaptcha = file_get_contents($recaptcha_url . '?secret=' . $recaptcha_secret . '&response=' . $recaptcha_response);
$recaptcha = json_decode($recaptcha);

// Take action based on the score returned:
if ($recaptcha->score >= 0.5) {
  // multiple recipients
  $to  = 'mary@dossdesigns.com' . ', '; // note the comma
  // if you want to cc others $to .= 'email@yahoo.com';

  // subject
  $subject = 'Website Inquiry Form';

  // get variables from form
  $email = $_REQUEST ['email'];
  $name = $_REQUEST ['name'];
  $street = $_REQUEST ['street'];
  $city = $_REQUEST ['city'];
  $state = $_REQUEST ['state'];
  $zip = $_REQUEST ['zip'];
  $phone = $_REQUEST ['phone'];
  $comments = $_REQUEST ['comments'];



  // message
  $message = '
  Name:    '.$name.'

  Email    '.$email.'

  Address:    '.$street.', '.$city.', '.$state.'  '.$zip.'

  Phone    '.$phone.'

  Comments    '.$comments.'

  ';

//Put your html for your thank you below here


Most From: https://codeforgeek.com/google-recaptcha-v3-tutorial/

Posted on

Setup SSL inMotion

Login to AMP –> WHM –> List Accounts –> cPanel of domain to secure
Under Security –> SSL/TLS status –> Run Auto SSL

Next…. You will have to force browsers to use the https
IF you have a handwritten website:
Download .htaccess from your public_html folder
Add this code at the top of the file

RewriteCond %{REQUEST_URI} !^/[0-9]+\..+\.cpaneldcv$RewriteCond %{REQUEST_URI} !^/\.well-known/pki-validation/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$RewriteEngine On RewriteCond %{HTTP_HOST} ^example\.com [NC]RewriteCond %{SERVER_PORT} 80 RewriteRule ^(.*)$ https://www.example.com/$1 [R=301,L]

**Replace example with your domain
Upload .htaccess back to your server

IF you have a WordPress site:
Login to your WP dashboard –> Plugins –> “Add New”

Search “Really Simple SSL” –> It will be by Really Simple Plugins
Install Now –> Activate –> Go ahead, activate SSL! (it may ask you to login again)

Posted on

New Google Analytics to WordPress

October 2020 Google updated Analytics to version 4. AND Of course they have moved things!!! Ugh
Login to your Gmail and then go to Google.com/analytics

  1. Sign in to your Analytics account.
  2. Click Admin.
  3. Select an account from the menu in the ACCOUNT column.
  4. Select a property from the menu in the PROPERTY column.
  5. Choose Data Stream Webpage
  6. Tagging Instructions Choose Globle Tag and Copy
  7. Go to your WordPress –> Plugins –> new search for insert header footer (by ) Install & Activate
  8. Go to Settings –> Insert Headers and Footers –> Scripts for Footer & paste the code from Google Analytics

    BUT a bunch of things are missing!!!!!! To force analytics to use version 3….
    1. Click Add Property
    2. Enter Property Name
    3. Enter Time Zone
    4. SELETCT CREATE A UNIVERSAL ANALYTICS PROPERTY
    5. Enter URL
    6. CHOOSE CREATE A UNIVERSAL ANALYTICS PROPERTY ONLY!!!!!
    Now your Audience & Acquisition & Behavior Folders are all back!! Yea!

The only updated source I could find was this…..thankfully!

Posted on

Facebook Upload Customer List for Audience

Copied from: https://www.facebook.com/business/help/170456843145568?id=2469097953376494

Since FB keeps changing the layout – these links take you directly to the page you need to be….

Before you begin

Prepare your customer list in advance

To make a Custom Audience from a customer list, you provide us with information about your existing customers and we match this information with Facebook profiles. The information on a customer list is known as an “identifier” (such as email, phone number, address) and we use it to help you find the audiences you want your ads to reach.

Your customer list can either be a CSV or TXT file that includes these identifiers. To get the best match rates, use as many identifiers as possible while following our formatting guidelines. You can hover over the identifiers to display the formatting rules and the correct column header. For example, first name would appear as fn as a column header in your list.

Alternatively, we have a file template you can download to help our system map to your identifiers more easily. (You can upload from Mailchimp as well.)

Next steps

  1. Add your customer list: You can create your Custom Audience in Ads Manager. Once in your account, go directly to Audiences, then go to Create Audience > Custom Audience > Customer list
  2. Prepare your customer list: Select the identifiers to include, then add the customer list you want to use for your new Custom Audience and give it a name.
  3. Review your customer list: Confirm that you mapped your identifiers correctly or check to see that all errors are resolved. You’ll get one of the following notifications:
    • The green checkmark symbol means your identifiers were mapped correctly and are ready to be hashed, then used for the matching process.
    • The yellow exclamation symbol  means either that you chose not to include certain identifiers or that some identifiers need to be manually updated. You have higher chances of getting a better match rate to build your audience if you make the corrections before uploading your file.
  4. Upload your customer list: Once your list has been added and is ready for use, select Upload and Create.

Learn more

How to Edit a Custom Audience from a Customer ListHow to Share Custom Audience ListsBest Practices for Preparing Customer Information

This video helps then to create a look a like audience and then add it to your existing ad

Posted on

Excel Delete Duplicates Between Tables

Table 1 – Original
Table 2 – Bounce List from VoilaNorbert

In Table 2 note the cell range ie.A2 to A998
Highlight emails in Table 1 (click on first, hold Ctrl, and click on last)
Conditional Formatting –> New Rule –> Use a formula to determine which cells to format

=countif(‘Table 2’!$A$2:$A$998,A2)>0
Format –> Fill –>choose a color –> ok –> ok

Note:
Replace above table names with whatever you have named your tables
May need to go in and fix rule is not showing properly
On Table 1 click Conditional Formatting –> Manage Rules
Make sure the formula is typed in correctly

Next, Sort so the highlighted or clear cells are on top
Sort & Filter –> Custom Sort –> Sort By A or Email Addresses (let excel expand the filter so all rows are moved together) –> Cell Color –> No Color or Choose a color to be on top
This way you can delete all the duplicates easily once they are grouped together.

Posted on

Captcha

Register Domain at Google. https://contactform7.com/recaptcha/

Using Contact 7 form on WordPress, goto integration and enter the site key & secret key you created above.

Done!

Posted on

Responsive Tables

<style type=”text/css”>
table {
border: 1px solid #ccc;
border-collapse: collapse;
margin: 0;
padding: 0;
table-layout: fixed;
width: 100%;
}

table tr {
background-color: #f8f8f8;
border: 1px solid #ddd;
padding: .35em;
}

table th,
table td {
padding: .625em;
text-align: center;
}


@media screen and (max-width: 800px) {
table thead {
border: none;
clip: rect(0 0 0 0);
height: 1px;
margin: -1px;
overflow: hidden;
padding: 0;
position: absolute;
width: 1px;
}

table tr {
border-bottom: 3px solid #ddd;
display: block;
}

table td {
border-bottom: 1px solid #ddd;
display: block;
text-align: right;
}

table td::before {
content: attr(data-label);
float: left;
}
}
</style>

Next the table (you only have to add percentages if you want and only to the thead – it will carry through)

<caption>
Enter Caption
</caption>
<thead>
<tr>
<th scope=”col” width=”10%”> </th>
<th scope=”col” width=”10%”>Price</th>
<th scope=”col” width=”17%”>Bed/Bath</th>
<th scope=”col” width=”17%”>SqFt</th>
<th scope=”col” width=”29%”>Address</th>
<th scope=”col” width=”17%”>MLS</th>
</tr>
</thead>

And you can add labels if you wish:

<td data-label=””>