Author: Gavin Simpson

  • Exporting/Importing Woocommerce Orders with SQL 2020

    Covers WordPress version 5.3.2 No matter how you use the SQL, be it on the command line, PhpMyAdmin or PHP, These are just the SQL commands needed. There are 4 tables invlovled not counting the variable product data. I’ll be adding that as soon as a get a free moment. wp_posts wp_postmeta wp_woocommerce_order_items wp_woocommerce_order_itemmeta wp_posts…

  • Sharing a Viynl Cutter over the Network in Linux

    This setup works for a cheap Chinese no name brand Cutting Plotter I use. On the host PC add a new printer and set the printer model to “Raw Queue“ Set the device URI to, for example, serial:/dev/ttyUSB0?baud=9600. This assumes the servial device is attached to USB port 0. Make sure it is shared. On…

  • Setting up Inkscape for use with a Vinyl Cutter using Inkcut

    Step 1 Download and install the InkCut Extension from the InkCut sourceforge page. Step 2 Install the following linux libraries : Using InkCut to perform the cut Step 1 Select the objects you wish to cut Step 2 Ungroup the selected objects Step 3 Go “Path->Object to Path” Step 4 Go “Path->Union” Step 5 Extensions->Cutter/Plotter->Inkcut…

  • Raspberry PI Setup

    use GParted to format SD to win32. sudo dd bs=4M status=progress if=~/Downloads/2018-06-27-raspbian-stretch.img of=/dev/sdc; sync NB note /dev/sdc, not /dev/sdb1. i.e. Must point to physical device, not partition. Edit config.txt on the SD to set hdmi hot plug support. put sd in the pi, plug in kb and monitor and boot. after install and upgrade process…