Skip navigation

Click the photo “Puppy Love” above to view the rest of the album.

Click the photo “Puppy Love” above to view the rest of the album.

Kansas City Loose Park 2021

While visiting Kansas City in March of 2021 to celebrate Lori’s birthday, we took a short walk from our rental house to visit Jacob L. Loose Park.

While visiting Kansas City in March of 2021 to celebrate Lori’s birthday, we took a short walk from our rental house to visit Jacob L. Loose Park.

Kansas City Zoo March 2021

We took a trip to Kansas City in March of 2021 to celebrate Lori’s birthday. The Kansas City Zoo was an excellent experience. We especially liked the Elephants and the Llamas.

We took a trip to Kansas City in March of 2021 to celebrate Lori’s birthday. The Kansas City Zoo was an excellent experience. We especially liked the Elephants and the Llamas.

2019 Grand Lake Colorado

Family trip to Grand Lake, CO in October of 2019 to celebrate our 20th wedding anniversary. We stayed at a nice little cabin overlooking Shadow Mountain Lake, which is connected to Grand Lake.

Family trip to Grand Lake, CO in October of 2019 to celebrate our 20th wedding anniversary. We stayed at a nice little cabin overlooking Shadow Mountain Lake, which is connected to Grand Lake.

2019 Des Moines Concors d'Elegance

Walked around and took a lot of car photos at this event. I’ve uploaded a first set, but may add more to the album later.

Walked around and took a lot of car photos at this event. I’ve uploaded a first set, but may add more to the album later.

Yeah, it has been way too long. Here’s some content from a presentation I gave to the local Linux Users’ Group a while back.

Click here to comment on the Google Doc.

Yeah, it has been way too long. Here’s some content from a presentation I gave to the local Linux Users’ Group a while back. Click here to comment on the Google Doc.

Although ReciPants v1.2 is still hosted on SourceForge (and Freecode), it has not been actively developed or updated since 2004. If you search for ReciPants on this blog, you will see that I’ve had some trouble migrating it between servers and keeping it working over the years. I, therefore, finally decided to migrate all of our recipes (close to 500 of them) out of this software and in to the latest stable release of MediaWiki. While I’m probably the last person on earth using this software, I thought I’d share here how I performed the export, just in case I’m not!

MediaWiki allows export and import of pages in XML format. This page on the MediaWiki site was very helpful in providing the required format of this XML file. Additionally, I installed a fresh copy of MediaWiki on my Web server, mocked up a fake recipe page similar to the format I wanted, then exported that page in order to inspect it. One of the main differences I noticed between the example from the MediaWiki site and the actual export I performed was near the <text> tag. In the example, the tag is simply <text>, but I found that my imports using this tag were not getting rendered in my wiki as wikitext. My actual exported page, however, had the following tags preceding the <text> tag and a different <text> tag itself:

<model>wikitext</model>
<format>text/x-wiki</format>
<text xml:space=”preserve”>

That combination of tags resulted in the wikitext being rendered properly. Without them, the raw wikitext was shown in MediaWiki with no LF/CR — very un-readable!

With that information at hand, I set to work creating a script in Perl which would connect to the MySQL recipants database using DBI and extract the various data I wished to export into variables. The main outer loop iterates through the recipes table. Inside that loop, the other tables are queried for the data they hold about the current recipe. Everything is shoved into variables, arrays, or arrays of arrays along the way. At the end of the main loop, the XML for that page is generated.

You can download or view the script source code: rpexport.txt

This is a sample of the XML output, limited to just recipes with “berry” in the name: berry.xml

Although ReciPants v1.2 is still hosted on SourceForge (and Freecode), it has not been actively developed or updated since 2004. If you search for ReciPants on this blog, you will see that I’ve had some trouble migrating it between servers and keeping it working over the years. I, therefore, finally decided to migrate all of […]

Trail_Ridge_Road_01

Lenticular_Rainbow_Curve_02

Bear_Lake_02