• Mr.Muliebris

My creative pursuits are on hold until further notice, as the saying goes. Got a lot of stuff going on...

In the meantime there are a few updates to the site, aside from a big rewrite under the covers

Hoping to be back soon!

  • Mr.Muliebris

Today marks the long-overdue release of a fresh update of the www.mrmuliebris.com website. Along with new images and galleries, it has been restructured under the covers to use a database, as trailed in this earlier blog. The new look Galleries page offers more information about the galleries on offer and now offers a search feature.

To reduce the number of pages, the site has been converted to use a database. I've written this blog to summarize how it was done for those of you who use Wix and might want to do something similar.

Just a quick note about terminology. Wix lets you build what it calls dynamic pages. Dynamic pages are essentially templates that can be connected to a database you create.

Previously the site had nearly 60 static pages, most of which were collections of images, one per collection. Now there are just nine pages on the site. Two of these are dynamic. Those two dynamic pages replace 50 static, hard-coded pages.

The basic structure of the site is simple. My galleries are themed collections of images. Galleries might be collections themed by a set with one model, such as the new Behind the scenes gallery; more whimsically, such as Art is a lie (Photoshop manipulations); or show uncensored social media posts. Galleries and images are stored in two database tables. There are over 50 gallery records and 884 image records at the time of writing.

Wix has a relatively easy to use interface for creating and maintaining the data. That said, data entry was the most time-consuming part of the conversion job. I tried to automate it. Wix says Excel .csv files can be used to import data. However, the data is in Lightroom, and in its wisdom, Adobe has not seen fit to provide a way to output metadata in tabular form. None of the third-party tools available quite did what I wanted. That meant I had to populate the tables manually using copy and paste. I got occasional timeouts updating tables but it wasn't a big deal. Given my day job and domestic obligations, I managed one collection of images a day - which took 50 days, at about 10 to 30 minutes a go! It was a tedious job. I made it even more boring by deciding to add alt-text to the images to improve the site's SEO. Here's hoping, anyway.

By default, Wix assumes an index -> item relationship when creating dynamic pages. A musician might create many albums, for example. Providing you establish a link using a key in the data structure, Wix creates a template index page that links to a template item page. Wix calls the index 'Galleries(All)'. Wix calls the item page template 'Galleries (Title)'.

However, Wix doesn't currently provide a drag and drop template means of populating an item Galleries(Title) page with an embedded set of images -- or, at least, not in the way I wanted it to look. It's a third level of embedded structure, as it were. This is equivalent to not allowing an automatic way of showing all the songs on an album that a musician creates.

This is where Wix's terminology can get confusing, by the way. In the basic template environment, Wix provides multiple options for displaying sets of images on a static page. But it calls them… "Galleries". Technically, it means Image Galleries.

I happen to like the grid version best, but none of the Image Galleries worked properly on a dynamic item page straight out of the box. I wanted the user to be able to expand each image to see the accompanying text and credits. However, all 884 images showed in the Image Gallery on each Galleries(Title) page, irrespective of the gallery.

I needed to be able to tell the Grid Pro Gallery embedded on the page to only show the images relevant to the collection gallery.

To get this working, I had to get to grips with the Corvid by Wix extension. Basic Wix is a template site builder for people who don't want to code. Corvid by Wix allows a novice like me to program extra functions into the template site using Javascript. Javascript is a programming language that allows you to code features on web pages. I last programmed about thirty years ago, so it took a little getting used to, but there is plenty of support available online. I found Wix's support good too, although there were some frustrating things Corvid by Wix and Wix can't do easily, such as link from an image in one gallery to another. I think I'd have to build an image display function myself, which is beyond me right now.

To get just the correct images for one of my individual galleries to show on Galleries(Title) page, I found this video by Alex. I created the Image database schema with a single key, a code for the gallery title. The Corvid by Wix Javascript code loops through the Image table to filter images with the right key. The page code also hides or shows a blog button and lets the user go back to the index. The code looks like this:

Because the galleries and images are stored in a database, the site can now support search, filter and sorting features.

The code is adapted it from this video by Wix and supporting forum entry.

Was it worth it? Well, I had no choice as the site will otherwise likely exceed the 100 page limit Wix imposes on static pages. It has been a lot of work. While frustrating at times, I found it fun, but I'm weird like that. The advantage is the site now is easier to maintain than it used to be. Putting a new gallery up is considerably easier and less prone to human error - it's just data entry.

Contact me if you want to know more.

  • Mr.Muliebris


Rotkäppchen [Little Red Cap]


by Jacob and Wilhelm Grimm

as retold by Mr. Muliebris

Once upon a time there was a sweet young woman. Everyone who saw her liked her, but most of all her grandmother, who did not know what to give the girl next. Once she gave her a little cap made of red velvet. Because it suited her so well, and she wanted to wear it all the time, she came to be known as Little Red Cap.      One day her mother said to her, "Come Little Red Cap. Here is a piece of cake and a bottle of wine. Take them to your grandmother. She is sick and weak, and they will do her well. Mind your manners and give her my greetings. Behave yourself on the way, and do not leave the path, or you might fall down and break the glass, and then there will be nothing for your grandmother. And when you enter her parlour, don't forget to say 'Good morning,' and don't peer into all the corners first."      "I'll do everything just right," said Little Red Cap, shaking her mother's hand.      The grandmother lived out in the woods, a half hour from the village. When Little Red Cap entered the woods a woodsman she did not know came up to her. He was wearing a fine sheepskin coat. She looked down at her shoes and did not see that he stared at her in a wicked manner. She did not know what a beast he was, and was not afraid of him.      "Good day to you, Little Red Cap."      "Thank you, woodsman."      "Where are you going so early, Little Red Cap?"      "To grandmother's."      "And what are you carrying under your apron?"      "Grandmother is sick and weak, and I am taking her some cake and wine. We baked yesterday, and they should be good for her and give her strength."      "Little Red Cap, just where does your grandmother live?"      "Her house is good quarter hour from here in the woods, under the three large oak trees. There's a hedge of hazel bushes there. You must know the place," said Little Red Cap.      The woodsman thought to himself, "Now this sweet young thing is a tasty bit of skirt. You will have your wicked way with her after you rob the old woman. You must be sly, and you can catch them both." He walked along a little while with Little Red Cap, then he said, "Little Red Cap, just look at the beautiful flowers that are all around us. Why don't you go and take a look? And I don't believe you can hear how beautifully the birds are singing on the path. You are walking along as though you were on your way to school. It is very beautiful in the woods."      Little Red Cap opened her eyes and when she saw the sunbeams dancing to and fro through the trees and how the ground was covered with beautiful flowers, she thought, "If I take a fresh bouquet to grandmother, she will be very pleased. Anyway, it is still early, and I'll be home on time." And she ran off the path into the woods looking for flowers. Each time she picked one she thought that she could see an even more beautiful one a little way off, and she ran after it, going further and further into the woods.      The woodsman ran straight to the grandmother's house and knocked on the door.      "Who's there?"      "Little Red Cap. I'm bringing you some cake and wine. Open the door."      "Just press the latch," called out the grandmother. "I'm too weak to get up."      The woodsman pressed the latch, and the door opened. He stepped inside, went straight to the grandmother's bed, put a rag in her mouth, tied her up and stuffed her in a cupboard. Then he took off his sheepskin coat, put on her clothes, put her cap on his head, got into her bed and pulled the curtains shut.      Little Red Cap had run after the flowers. After she had gathered so many that she could not carry any more, she remembered her grandmother. Just then a she-wolf stepped out of the dark woods carrying a knife in its muzzle. Little Red Cap fell to the ground in fear. The she-wolf dropped the knife on the ground and spoke. "Do not be afraid of me, Little Red Cap. My prey consists of deer, boar and moose. The monster is the woodsman who chops down the forest and takes advantage of young women. This knife belongs to him, my dear. I found it in his nearby camp. Take it with you when you visit your grandmother and be careful." With that, the she-wolf loped back into the forest. Trembling, Little Red Cap picked up the knife, and then continued on her way to her house.      Little Red Cap found, to her surprise, that the door of her grandmother's house was open. She walked into the parlour, and everything looked so strange that she thought, "Oh, my God, why am I so afraid? I usually like it at grandmother's." She called out, "Good morning!" but received no answer. Then she went to the bed and pulled back the curtains. Grandmother was lying there with her cap pulled down over her face and looking very strange.      "Oh, grandmother, what big ears you have!"      "All the better to hear you with."      "Oh, grandmother, what big eyes you have!"      "All the better to see you with."      "Oh, grandmother, what big hands you have!"      "All the better to grab you with!"      "Oh, grandmother, what a horribly big mouth you have!"      "All the better to kiss you with!"      The woodsman had scarcely finished speaking when he jumped from the bed with a single leap and chased Little Red Cap out into the forest. He ripped off Little Red Cap's apron and dress. Pulling at his breeches, he shouted, "Oh, Little Red Cap, look what a big -- " but before he could finish, Little Red Cap pulled out the knife she had been carrying. The woodsman laughed and lunged at her again, but cut open his hand. Again he grabbed at her, leaving a bruise and a bloody hand print upon her body, but this time the knife pierced his heart and he fell down dead. Little Red Cap ran back into grandmother's house and climbed into the bed. She began to cry very loudly.      The she-wolf was just passing by. She saw the woodsman lying there. "So here I find you, you old sinner," she said. "I have been hunting for you a long time." It occurred to her that the woodsman might have harmed the grandmother and Little Red Cap but that both might still might be rescued. She thought, "The young woman is crying so loudly. You had better see if something is wrong with her." The she-wolf stepped into the parlour.      She found grandmother inside the cupboard and used her big teeth to cut grandmother's bonds. Grandmother thanked the she-wolf with a hug. "Oh, I was so frightened! It was so dark inside the cupboard!" And then Little Red Cap came out from under the covers alive, but hardly able to breathe because of her ordeal. She saw that it was the she-wolf and thanked her for the knife.      The three of them were happy. The she-wolf ate the woodsman. The grandmother ate the cake and drank the wine that Little Red Cap had brought. Little Red Cap put on the woodsman's warm sheepskin coat. And Little Red Cap told everyone she knew about the woodsman's wicked ways, so that other sweet young women -- and wicked woodsmen -- would learn from the story. THE END

Composite image. Original photograph: Canon 5D Mark III in manual mode, mixed natural and artificial light, 1/125 sec, aperture f/8.0, ISO 100, 85mm.  With thanks to model Elilith, producer Dan Hostettler (Prague).

Copyright © 2019 - 2020 by Mr.Muliebris. All rights reserved.