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)

Anselm Lingnau

I just deployed the long-awaited (or long-feared?) extreme makeover of the SCD database user interface. This should now be more in line with best web design practices for the year CE 2014, and work better not just on PCs, but also on devices with small screens (mobiles).

There are a few small glitches to sort out (mostly to do with videos) and I'll take care of those ASAP – I wanted to get the bulk of the update out in preparation for my talk at the RSCDS Teachers' Conference on Friday.

The changes confine themselves mostly to the appearance of the site; there has been only one significant change to its underlying workings, and that concerns dance lists. Formerly, users would have an implicit dance list (called “WORK”, with asterisks around it, if it showed up anywhere) which would receive dances through “drag and drop”, and could then later be edited and saved as a “named” dance list. The drag-and-drop interface looked neat at first but proved to be problematic in various respects, and has therefore been removed. Right now there are only “named” dance lists, and therefore to start a new dance list you need to create an empty one from the dance list overview or “My Dance Lists”. The most recently created or edited dance list is considered “active”, and if you click on the “Add to List” button on a dance's page then that dance will be added to the “active” list. I hope this avoids problems like the one where if you had the “WORK” list open for editing in one tab and then dragged a dance on it in another tab that didn't show the very latest version of the list as per the editing screen, your edited version would be obliterated :^( (If you edit your active list in one tab and then add a dance to it in another, you still need to re-load the list in the “editing” tab, but you won't lose any dances anymore.)

Do let me know if you notice any problems, or have suggestions for further improvement!

database

· · Posted by Anselm Lingnau · 4 November 2014 12:26 (last edited on 4 November 2014 12:27)

See more stuff