Dev {Tricks}

You are here: Home / Archives for Wordpress

by Leave a Comment

WordPress Theme related Common Issues & Fixes

 

  1. Stylesheet Is Missing
  2. Sample Data Import Errors
  3. Homepage Doesn’t Look Like The Demo
  4. My URL’s Are “Ugly”
  5. My Posts Are Returning 404 Errors
  6. My Menu Is Blank
  7. New Theme Uses Featured Images But I Have a Ton Of Posts Without Them
  8. Slides, Accordions, Toggles, Tabs…Not or Stopped Working!
  9. Styling Changes Aren’t Doing Anything
  10. I’ve Updated My Theme And All My Changes Are Gone!

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