xadammr.au

For the past hour or so I have been troubleshooting a problem with a Visual Basic script in Excel. It iterates through PivotItems in a PivotTable:

Set p_table = ActiveSheet.PivotTables("Audit")
Set p_items = p_table.PivotFields("Primary Location").PivotItems

For Each p_item In p_items
    Debug.Print p_item.Name
Next p_item

The for-loop keeps returning items that are no longer in the source data, and I couldn’t work out why. Turns out, there’s an option in PivotTable Options: Retain items deleted from the data source.

The Smarty pagination system I demoed previously worked great, but it didn’t cache results. But, I’ve made it better.

Some time ago I scoured the internet looking for a way to provide pagination in a Main Index template in Movable Type.

Using Smarty templating, there is an even easier way.

What do I want to accomplish?

• I want to use AddressFinder to auto-fill form fields for an application that requires accuracy of address.
• AddressFinger provides the national lot identifier and lot/plan number which we can use to integrate with our computer-aided dispatch system to associate records with locations.

I went to the NRL today.

In this essay, I will present three reasons why NRL is a game for stupid people.

You can engage Amazon Web Services to host an instance of Movable Type 7. The rates are quite decent: it’s free tier eligible! In fact, an AWS instance of MT is what got me back into the Movable Type ecosystem. And it’s lovely to be back.

Six Apart has two versions of Moveable Type available: nginx and Apache. I chose an nginx instance because I live in 2021, and of course I have a poke around. AWS has a stack of unique stuff associated with their MT install to facilitate the spinup of instances and execution of Perl. They also shipped a Perl module MTDynamicHandler.pm which intrigued me.

Part of what prevented me from playing more with Movable Type recently is my use of nginx and its apparent incompatibility with Dynamic Publishing. Despite a stack of research at the time, I couldn’t work out a way to get nginx to ingest .htaccess and rewrite rules to facilitate dynamic rendering. I could not get my own rewrite rules to work right.

I’ve installed the reCaptcha plugin for Movable Type for spam control.

Unfortunately, when using dynamic publishing, I got a helpful error:

An error occurs.

I’ve been on leave this week, and I’ve been super busy.

• I’ve almost finished the story mode of Tom Clancy’s The Division 2.
• My Chief Financial Officer (a.k.a Chris) has introduced austerity measures due to the SARS-CoV-2 crisis. I’ve cut costs by moving everything into two virtual private s...