Feb 8, 2017 ·
1 minute read
BASH
Check out this BASH snippet to get the headers from a CSV file and give you the column numbers
Jan 23, 2017 ·
2 minute read
PHP
Recently I ran into an issue with a upload issue in Akeneo when trying to include an image with a product, however the issue could happen with any PHP script. I had provided a file path of /path/to/file.jpg in the upload, but was getting an error message of Attribute or field "picture" expects a valid pathname as data, "/tmp/path/to/file.jpg" given (for setter media) I was surprised to see that the path had been changed to /tmp/path/to/file.jpg, but a put a copy of the file into the /tmp/ directory and tried again.
Read On →
Jan 20, 2017 ·
2 minute read
phpstorm
Workflow Recently I have been writing a number of internal scripts that interface with one of our databases to check a few things. A lot of the time we use PhpMyAdmin or the standard Mysql command line client where necessary but there is a better and more reliable way to fire queries to the database. Enter PHP Storm. PHP Storm and MySQL PHPStorm has been extended so much over the years that it can be used for fully fledged raw SQL on it’s own which can be very handy.
Read On →
Jan 17, 2017 ·
1 minute read
Marketing
Recently I had to try and fix a number of issues with a client’s Google Adwork conversion tracking and Universal Analytics. To better help in debugging I discovered a plugin from Google themselves for Chrome that does some basic validation on any tracking tags in the page, this also includes tags loaded through Google Tag Manager and the Tag Manager loader itself. From here I quickly found that the wrong parameters were being passed to the Tag Manager data layer (and as a result to Ad Words) making it a simple issue to fix without having to wait for Adwords/Analytics to update.
Read On →
Jan 16, 2017 ·
1 minute read
MySQL
I recently had the issue that the root user for a MySQL installation had their password expire. Apparently this is a fairly new MySQL feature which is designed to improve security and assist with meeting PCI-DSS requirements. However for this development box, it is not really necessary so I would prefer to disable. The issue became apparent when trying to log into phpmyadmin and seeing the error message: “#1862 - Your password has expired.
Read On →
Jan 12, 2017 ·
1 minute read
misc
If you want to quickly capture your screen on Fedora follow these steps: Go to the following download link for VokoScreen sudo dnf install path/to/rpm Run VokoScreen And that’s it!
