AgileAdam.com

Adding a “Filter by year” Facet for a Date Field in Apachesolr for Drupal 7

A Drupal 7 site I’m working on makes use of the Apache Solr Search module and FacetAPI. Some of the content has a date field named field_s_date. I was tasked with…

February 28, 2016

Development

Disable Specific States in Ubercart

Here’s a quick example that illustrates how to remove a few State/Province options from the billing and shipping panes of the Ubercart checkout form, as well as the order edit/create form. Please understand there…

February 9, 2012

Development

Private Messages – Moving “Delete” button into “Actions” select list

By default the “Delete” operations will show as a button on Privatemsg‘s message listing page. There is an “Actions” dropdown that includes actions to “mark as read” or “mark as unread”…

May 26, 2015

Development, Tech Tips

Using Dataview with Charts in Obsidian

/ July 28, 2022

Obsidian is my third most used application after Keyboard Maestro and Alfred. I’ve been using the dataview plugin since I got started with Obsidian. It’s an incredible plugin that gives you the ability to treat your notes like database records. In this example I’ll show how I use dataview to make my projects queryable, and then how I use Obsidian-Charts to make some bar charts of this data.

Using Dataview Variables

Here’s an example of a Project file in my Obsidian vault:

read more
Tech Tips

Obsidian Daily Note Implementation v2

/ July 14, 2022
Here’s what my current Obsidian Daily Note looks like:

I’m pleased with this, having come from a pretty bland Daily Note setup prior to this. I’ll explain the setup:

Requirements
- Obsidian
- Daily Notes plugin
- Dataview plugin
- Tasks plugin
- Quick Add plugin (optional, I suppose)
As of July 15, 2022 this only works as expected if you edit in regular source mode, not live preview mode (the live preview won’t show the styling; see https://www.reddit.com/r/ObsidianMD/comments/vz2mw5/comment/ig9g0k9)

Template File

I set up the “Daily notes” plugin as follows:
read more

Tech Tips

Clipboard Manipulation using Keyboard Maestro

/ June 15, 2022

Keyboard Maestro has many triggers; these are responsible for executing macros. One such trigger is “The System Clipboard Changes“. I don’t use it often, despite how incredibly useful it is. It does exactly what it says: if a macro uses this trigger, Keyboard Maestro will execute the macro any time the clipboard content changes (when you “copy” something).

Here’s a quick example showing the usefulness.

There is a specific issue I have with Microsoft Outlook webmail within Google Chrome. Our email system leverages urldefense.com to alter all external links in the interface (see below). If I’m clicking a link, that’s fine, but if I want to copy a link’s URL it’s annoying to have to clean up the URL to remove the urldefense cruft.

BEFORE: https://urldefense.com/v3/__https://someurl.com__;!!LQXXzXo!wt7t_lSnY
AFTER:  xxxxxxxxxxxxxxxxxxxxxxxxxxxx                   xxxxxxxxxxxxxxxxxxxxxx

1 2	BEFORE: https://urldefense.com/v3/__https://someurl.com__;!!LQXXzXo!wt7t_lSnY AFTER: xxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxx

Everything I’ve marked with an “x” is added by urldefense.

The macro is simple. I leverage The System Clipboard Changes trigger to trigger the macro. The macro is inside of a macro group that is only activated for Google Chrome. I use an If Then Else action to determine if the URL is a target for manipulation. Finally, I use a Search and Replace action with some regular expressions to strip off the urldefense cruft.

Tech Tips

Using Keyboard Maestro to Set a Window Size for Recording

/ April 12, 2022
This is a quick one, folks. This simple KM macro sets the front (active) window to a specific size. I use it to prepare a window for screen recording.

Image of Macro:

Text of Macro:

Resize window to 1280×720

Triggered by any of the following:
- The Status Menu is selected
Will execute the following actions:
- Resize Front Window to Pixels
- To: 1280 horizontally, 720 vertically.
- Notify on failure.
read more

Tech Tips

Correcting Date Tags using sed in an Entire Obsidian Vault

/ March 17, 2022

I’ve been using Obsidian for about 8 months. It wasn’t until today that I realized I’ve been using hierarchical tags incorrectly since day one!

The Problem

In my templater templates I was using the following:

#<% tp.date.now("YYYY-MM-DD") %>/<% tp.date.now("YYYY-MM") %>/<% tp.date.now("YYYY") %> #<% tp.date.now("YYYY-MM-DD") %>

1	#<% tp.date.now("YYYY-MM-DD") %>/<% tp.date.now("YYYY-MM") %>/<% tp.date.now("YYYY") %> #<% tp.date.now("YYYY-MM-DD") %>

The result of this is:

#2022-03-17/2022-03/2022 #2022-03-17

1	#2022-03-17/2022-03/2022 #2022-03-17

Unfortunately there are two problems with this. First, there is no need for that extra tag at the end; it’s already covered by the first combo tag.

Second, the hierarchy is backwards! This leads to:

├── 2022-03-16
│   └── 2022-03
│       └── 2022
└── 2022-03-17
    └── 2022-03
        └── 2022

├── 2022-03-16

│ └── 2022-03

│ └── 2022

└── 2022-03-17

└── 2022-03

└── 2022

Houston, we have a problem! What I really was after was a tag structure like this:

└── 2022
    └── 2022-03
        ├── 2022-03-16
        └── 2022-03-17

└── 2022

└── 2022-03

├── 2022-03-16

└── 2022-03-17

The Fix

Thankfully, Obsidian stores all of the files on the filesystem natively, which means you can manipulate them using whatever tools you’d like.

Enter sed, a stream editor. Using sed and find, I was able to quickly resolve both of the issues above.

If I’d taken a little more time I would have handled both problems in one shot, but I did not. I fixed problem 2, then problem 1.

First, I cd’d into the root directory of my vault. Then…

# Find markdown files, feed them to sed,
# edit the file "in place" (modify them directly)

# We use capture groups (the parentheses) to
# essentially reverse the order of the tags
find . -type f -name '*.md' -print0 | xargs -0 sed -E -i "" "s/#([0-9]{4}-[0-9]{2}-[0-9]{2})\/([0-9]{4}-[0-9]{2})\/([0-9]{4})/#\3\/\2\/\1/g"

# Find #YYYY/YYYY-MM/YYYY-MM-DD #YYYY-MM-DD,
# capturing the first tag to "\1"
# Replace with the capture group (thereby dropping the second tag)
find . -type f -name '*.md' -print0 | xargs -0 sed -E -i "" "s/(#[0-9]{4}\/[0-9]{4}-[0-9]{2}\/[0-9]{4}-[0-9]{2}-[0-9]{2}) #[0-9]{4}-[0-9]{2}-[0-9]{2}/\1/g"

# Find markdown files, feed them to sed,

# edit the file "in place" (modify them directly)

# We use capture groups (the parentheses) to

# essentially reverse the order of the tags

find . -type f -name '*.md' -print0 | xargs -0 sed -E -i "" "s/#([0-9]{4}-[0-9]{2}-[0-9]{2})\/([0-9]{4}-[0-9]{2})\/([0-9]{4})/#\3\/\2\/\1/g"

# Find #YYYY/YYYY-MM/YYYY-MM-DD #YYYY-MM-DD,

# capturing the first tag to "\1"

# Replace with the capture group (thereby dropping the second tag)

find . -type f -name '*.md' -print0 | xargs -0 sed -E -i "" "s/(#[0-9]{4}\/[0-9]{4}-[0-9]{2}\/[0-9]{4}-[0-9]{2}-[0-9]{2}) #[0-9]{4}-[0-9]{2}-[0-9]{2}/\1/g"

Finally, I updated all of my templater templates to drop the second tag and fix the first to be in the right order.

Obsidian picked up all of the changes immediately, which were reflected in the tag pane. Much cleaner!

Tech Tips

Editing a DEVONThink Markdown File in VS Code

/ March 16, 2022

This is a sister post to Editing Web Content in VS Code.

This simple macro opens the current file (if Markdown) in VS Code, with the Markdown Preview Enhanced pane open on the right automatically.

read more
Tech Tips

Editing Web Content in VS Code

/ March 11, 2022

Okay, so it’s not quite as amazing as the title suggests, but this solution is worth sharing.

I work a lot in Bookstack. It’s a fantastic documentation system built with Laravel. I edit all pages in markdown. There is a markdown pane on the left and a preview on the right. I love the UI (shown below) but unfortunately I cannot move around in the editor like I can in PHPStorm or VS Code, where I have Vim support.

I have a Chrome extension called Wasavi, which is incredible for editing text areas in an inline virtual Vim window. Unfortunately, though, it doesn’t show realtime feedback in the preview pane until I save and close out of the virtual editor.

It occurred to me it’d be useful to just pop into VS Code quickly to edit the doc, then bring those edits back into the Bookstack editor in Chrome. At first I dismissed the idea as being “too much work.” After thinking about it for a moment, though, I realized I could MacGyver this relatively quickly with my favorite Mac application, Keyboard Maestro.

Here’s what I came up with. As with most things, I am sure I’ll tweak this over time to make it better, faster, less “error”-prone, etc. I have added a README comment and renamed most actions so it’s (hopefully) easy to understand the approach.

read more
Tech Tips

One-handed Gmail Inbox Culling with Keyboard Maestro

/ February 27, 2022
Keyboard Maestro proves, once again, why it’s at the top spot on my most recommended Mac applications list.

My normal procedure for culling (deleting unwanted) emails in Gmail is (with list on left and email preview on right):
1. Open the first email (opens in right pane)
2. If deleting, press “#” (⇧3)
3. Else, if skipping, press “j” to move down to the next email (standard Gmail behavior, I think; and it’s intuitive if you’re used to Vim)
4. Repeat steps 2 and 3.
I realized today how much I dislike hitting “#” with my left hand while browsing with my right.
read more

Development

Testing Cookie Modification in Laravel 8

/ February 4, 2022

If there’s a better way to pass a cookie from one request to another, in a phpunit feature test in Laravel, please let me know! Here’s one way to handle it:

<?php

namespace Tests\Feature;

use Illuminate\Cookie\CookieValuePrefix;
use Tests\TestCase;

class DiveDeeperTest extends TestCase
{

    /**
     * Tests if the diveDeeper route appends the passed value to the cookie arr.
     * @return void
     */
    public function test_it_updates_path_cookie()
    {
        // Post a deeperPath to the diveDeeper route (with a starter cookie).
        // This should append the "deeperPath" value to the "path" cookie array.
        $resp = $this->withCookie('path', serialize(['/']))
            ->post(route('diveDeeper'), [
                'deeperPath' => 'Users'
            ]);

        // Assert that the cookie has been modified.
        $resp->assertCookie('path', serialize(['/', 'Users']));

        // If we make another post request here, it won't include our
        // modified "path" cookie. We have to retrieve it, then pass it
        // through to the next request.

        // Decrypt the cookie (now modified by the diveDeeper route).
        $cookieValue = CookieValuePrefix::remove(app('encrypter')
            ->decrypt($resp->getCookie('path')->getValue(), false));

        // Hit the diveDeeper route again using the modified cookie value.
        $resp = $this->withCookie('path', $cookieValue)
            ->post(route('diveDeeper'), [
                'deeperPath' => 'adam'
            ]);

        // Assert that the cookie has been modified again.
        $resp->assertCookie('path', serialize(['/', 'Users', 'adam']));

        // Etc...
    }
}

<?php

namespace Tests\Feature;

use Illuminate\Cookie\CookieValuePrefix;

use Tests\TestCase;

class DiveDeeperTest extends TestCase

{

/**

* Tests if the diveDeeper route appends the passed value to the cookie arr.

* @return void

public function test_it_updates_path_cookie()

{

// Post a deeperPath to the diveDeeper route (with a starter cookie).

// This should append the "deeperPath" value to the "path" cookie array.

$resp = $this->withCookie('path', serialize(['/']))

->post(route('diveDeeper'), [

'deeperPath' => 'Users'

]);

// Assert that the cookie has been modified.

$resp->assertCookie('path', serialize(['/', 'Users']));

// If we make another post request here, it won't include our

// modified "path" cookie. We have to retrieve it, then pass it

// through to the next request.

// Decrypt the cookie (now modified by the diveDeeper route).

$cookieValue = CookieValuePrefix::remove(app('encrypter')

->decrypt($resp->getCookie('path')->getValue(), false));

// Hit the diveDeeper route again using the modified cookie value.

$resp = $this->withCookie('path', $cookieValue)

->post(route('diveDeeper'), [

'deeperPath' => 'adam'

]);

// Assert that the cookie has been modified again.

$resp->assertCookie('path', serialize(['/', 'Users', 'adam']));

// Etc...

}

Development

Any Random Saturday Using Faker

/ January 5, 2022

Here’s a quick one, folks. I’m using Faker in Laravel factories to generate realistic data. I have a “week end date” field in one of my models that must always be a Saturday. Here’s how I generate a unique random Saturday:

PHP

date('Y-m-d', strtotime('next Saturday ' . $this->faker->unique->date()))

1

date('Y-m-d', strtotime('next Saturday ' . $this->faker->unique->date()))

read more

Using Dataview Variables

Requirements

Template File

The Problem

The Fix