Anselm Lingnau

In the dance database, video comments are now displayed in the video modal. This closes a long-standing issue which made video comments virtually useless. (There is still no convenient way of editing video comments after the fact except through the Django admin interface, but that's a project for another day.)

database

· · Posted by Anselm Lingnau · 14 September 2015 12:01

Anselm Lingnau

I didn't mention it before but since yesterday we're officially at MiniCribs 25.06. Thanks to Keith Rose for pointing out an error in the importer routine.

database

· · Posted by Anselm Lingnau · 14 August 2015 23:59

Anselm Lingnau

MiniCribs in the Strathspey SCD Database are now up to version 25.05!

database

· · Posted by Anselm Lingnau · 15 June 2015 13:41

Anselm Lingnau

“Activity flags” for Person records in the database (i.e., whether somebody is a dance author, publisher, tune composer, or recording musician) are now set automatically according to the content of the database (i.e., a person counts as a dance author if and only if there are dances in the database that are credited to them). This is intended to avoid problems where editors add people to the database without checking the appropriate boxes, which means that the corresponding tabs on the person's detail page will not be active.

This is more subtle than it seems because we need to take into account that someone can be a dance author by virtue of being part of a group of people (with a separate database entry) who co-devised a dance (and so on for the other entry types).

The activity flags for all Person entries in the database are updated once a day (night, really). For the time being, activity flags can still be set manually on a person's entry in the administration UI, but will be overwritten on the next update.

As a fringe benefit, it is now possible to edit group membership information in the administration UI. This functionality has been long overdue and is now finally available.

database

· · Posted by Anselm Lingnau · 14 March 2015 19:32 (last edited on 14 March 2015 19:34)

Anselm Lingnau

MiniCribs in the Strathspey SCD DB are now up to version 25.03.

database

· · Posted by Anselm Lingnau · 3 March 2015 9:49

Anselm Lingnau

The database now has the current version of MiniCribs. There were some minor problems with the update process that needed to be sorted out, most of which had to do with the Django 1.7 update, and that resulted in a fairly long delay. But I hope that future updates will proceed a lot faster!

The automated import process manages to connect approximately 97% of the 4500+ cribs to the corresponding dances in the database. The vast majority of the remaining cribs belongs to dances that we don't yet have in the database; we're working on getting these added, and at that point they will hopefully also be imported correctly.

database

· · Posted by Anselm Lingnau · 13 February 2015 14:37 (last edited on 13 February 2015 14:38)

Anselm Lingnau

Videos for dance lists are back! In the Strathspey SCD Database, You can now select the “Videos” tab on a dance list detail page and see videos for all the dances that have them.

Generally, the video shown for a dance is the one with the highest quality level. If there are several videos at the highest quality level for that dance (e.g., several “Good” ones when no “Demonstration quality” video exists) then one of those is chosen at random.

Eventually we want to introduce an “Editor's Pick” badge where we explicitly designate one of the available videos as the preferred one to be used in contexts like the dance list “Videos” tab.

database

· · Posted by Anselm Lingnau · 1 February 2015 15:50

Anselm Lingnau

Dance lists in the database now are no longer automatically made “active” when they are edited. Instead there is a “Make List Active” button near the “Edit List” button on a list's detail page which you can use to make a list active.

The “active” list is the one that gets dances added to it via the “Add to List” button on a dance's detail page. If you create a new list that list is still implicitly made active; the only change is that editing a list doesn't make that list active.

The reason for the change is that I'm looking through previous class logs to find dances for our upcoming ball – which if the ball list is active is easy because you can click on a dance and from its detail page add it to that list. However, if for any reason you edit a previous class log (e.g., to make it public) then that list used to become active, so you had to go back to the ball list to make that active again, etc., which was annoying.

Note that you can edit a list whether or not it is active, so you don't need to make it active just to edit it. Also note that you don't need to explicitly make list A inactive before making list B active.

database

· · Posted by Anselm Lingnau · 24 November 2014 14:39

Anselm Lingnau

In the database, complex search operations for dances or recordings will now try to handle articles automagically. This means that if you're searching for something like “The Reel of” this used to return nothing because the database stores articles at the end of the title, as in “Reel of the 51st Division, The”. This change means that if a name query starts with an article, the database now also searches for titles with the article at the end (in effect, for a search for “The Reel of”, the database will also return titles matching the regular expression “^Reel of.*, The$”). I hope that this will lead to more predictable results.

In many cases it may be more advisable to simply leave the article off. This is because if you're searching for recordings for “A Trip to Bavaria” you will be missing a few recordings that are titled simply “Trip to Bavaria”.

database

· · Posted by Anselm Lingnau · 12 November 2014 18:26

Anselm Lingnau

Here's another innovation for you: Dance lists may now have dates! With hindsight this is something that I should have added ages ago (but didn't because, reasons). What this gives you in the short term is the capability of specifying the date that a dance list applies to (e.g., the date the class took place, or the date the function is going to be at). The date of a list is displayed on its details page as well as on list overview pages, and list overview pages allow you to restrict the lists shown to a specific (possibly open-ended) date range.

This should make it more convenient to find dance lists for specific functions. There are a few other neat and useful ideas that we could use the dance lists for, so stay tuned.

I have added dates to most of the dance lists that had something resembling a date in their names. You may want to check whether these are correct for all your lists; the process was a little quick and dirty and I may have missed some corner cases.

database

· · Posted by Anselm Lingnau · 5 November 2014 18:48 (last edited on 5 November 2014 18:50)

See more stuff