Dev {Tricks}

You are here: Home / Archives for Wordpress / Plugins

by

PopUp on WordPress with plugin

Generally we use two types of popup.

  1. On page landing popup
  2. On click popup

There are many plugins those can be used for these purpose. But you can check below two plugins.

For on page landing popup, we can use “Popup Builder” plugin. This plugin can also be connected with “Contact Form 7”.

For on click popup, we can use “Popup Maker“. This plugin can also be connected with “Contact Form 7”.

 

by Leave a Comment

Migrate Large WordPress sites with Duplicator plugin.

We will do the task with wordpress duplicator plugin.

Step One: Current Hosting

  1. Make Zip archive of all files and folders.
  2. Download it to your PC or you may copy the zip file to the targeted hosting location using Cron Jobs [Follow this].
  3. Install Duplicator plugin (https://wordpress.org/plugins/duplicator/)
  4. Create New Database Only Package with Duplicator.
    • Goto Duplicator ❯ Packages ❯ click “Create New” button
    • On Step 1 Setup ❯ Archive ❯ check “Archive Only the Database”
    • Build package then download installer and archive files

Step Two: Targeted new hosting

  1. Upload the downloaded zip file or or you may copy the zip file from current hosting to the targeted hosting location using Cron Jobs [Follow this].
  2. Extract the zip file to targeted location. After extraction, remember to remove or delete the zip file from targeted location.
  3. Upload the duplicator archive zip and installer.php. DO NOT extract the zip.
  4. Create a new database and connect user to it. Save database name, database user name and password.
  5. Point your website to new hosting by changing nameservers. It may take 15minutes to 72hours to propagate the change.
  6. After propagation, you can browse installer.php. Ignore override warning.
  7. Click next and put host (localhost), database name, user, password. Test database.
  8. Click next and install database.
  9. Now login to your wordpress admin with current username and password.
  10. That’s all.

 

by Leave a Comment

Create Spreadsheet. How to get Google Sheet as json file?

  1. Create spreadsheet at https://docs.google.com/spreadsheets/u/0/
  2. Publish the created spreadsheet on the web.
  3. You will get spreadsheet url at google drive like https://docs.google.com/spreadsheets/d/15w2MY4pmzHmS8zC6X-EVxEGCtAVeUsFNJwrPu0/edit#gid=8699371
  4. Using the spreadsheet url you can get json endpoint file as follows
    https://spreadsheets.google.com/feeds/cells/YOURGOOGLESHEETCODE/SHEETPAGENUMBER/public/full?alt=json
  5. Replace
    YOURGOOGLESHEETCODE with 15w2MY4pmzHmS8zC6X-EVxEGCtAVeUsFNJwrPu0
    SHEETPAGENUMBER to 1
  6. Now the url will look like https://spreadsheets.google.com/feeds/cells/15w2MY4pmzHmS8zC6X-EVxEGCtAVeUsFNJwrPu0/1/public/full?alt=json
  7. Browse the final url and you will get json.

Thanks

by Leave a Comment

How to get Google Spreadsheet ID and sheet ID?

Google Spreadsheet ID and Google Sheet ID can be find easily in doc url.

https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=sheetId

https://docs.google.com/spreadsheets/d/this-is-spreadsheet-id/edit#gid=this-is-sheet-id

Read more at https://developers.google.com/sheets/api/guides/concepts#sheet_id