In this tutorial I show you how to download a wordpress website on your local computer and run a mirror copy of it there. This gives you the the ability to test out website ideas privately or ensure that you have a plan B if your website get's hacked. The video below gives you a "look over my shoulders" view as I walk you through the steps. … [Read more...] about How To Backup, Mirror And Run Your WordPress Website Locally
All Articles
Export Table Data From Libre Office Base
In this tutorial we are going to export the contents of the table below to a text file in csv (comma seperated values) format. LibreOffice Base is the free database application that is packaged with LibreOffice, I use it all the time and in my opinion is the only option for quick and dirty database analysis on the Apple Mac platform (which i use). LibreOffice base is also … [Read more...] about Export Table Data From Libre Office Base
Python Create CSV Text File From Tab Delimited
In this tutorial video, I take a file downloaded form a website that is tab delimited and convert it to a comma delimited csv file using a python program that can be called from the command line.This csv file will be imported into LibreOffice base (Free database software for Mac, PC or Linux) for further processing. If you program or write macros in a … [Read more...] about Python Create CSV Text File From Tab Delimited
How to Make A Table In OpenOffice or LibreOffice
In this tutorial I will explain how to create a table in LibreOffice base, a free database application that is available on windows mac and linux. This simple table could be used as a generic table for importing data into your database. Further queries in the database could then transfer data from this table to other parts of the database while changing … [Read more...] about How to Make A Table In OpenOffice or LibreOffice
Question Time – Excel VBA – Consolidate Data From Different Sheets
In this tutorial we are going to merge excel files into one results file for uploading to an accounting system. Get the spreadsheet used in the tutorial above. Also get updates when new blog or video tutorials are released. Submitting... A reader's workflow … [Read more...] about Question Time – Excel VBA – Consolidate Data From Different Sheets