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)

Anselm Lingnau

I just fixed a bug in the database that in some cases – mostly solo artists and newly-added bands – prevented albums and recordings from being credited to the respective artists on their »Person« pages. Thanks to Heiko Schmidt and Eric Ferguson for bringing it to my attention (with some persistence).

database

· · Posted by Anselm Lingnau · 22 May 2014 14:19

Anselm Lingnau

Eric's cribs are now imported correctly (some were missed because of a change in the source data format, instead being made part of the preceding crib). On top of that we now distinguish between »checked by Eric himself« and »checked by somebody else too«.

This is in the aftermath of the dance-intensity debate as per this thread on the Strathspey list, which introduced »per-turn« dance intensity in addition to Eric's »per-dance« dance intensity.

database

· · Posted by Anselm Lingnau · 1 May 2014 1:28

Anselm Lingnau

Version Q of Eric's SCD Cribs has now been imported into the database (thanks Eric!). I'll see what I can do about the EPUB and Kindle e-book versions but don't hold your breath.

database

· · Posted by Anselm Lingnau · 24 April 2014 14:17

Anselm Lingnau

I just posted a rough to-do list for the database. As the list itself says, there are no guarantees that any of the items of the list will actually ever be tackled, nor should the position of items within the list be construed as any kind of priority ordering.

database

· · Posted by Anselm Lingnau · 24 April 2014 14:15 (last edited on 24 April 2014 14:18)

Anselm Lingnau

The dances in the user-rated ranking list now display the usual dance type, set shape, and source information. This was a five-line hack that I just added, prompted by a query in the SCD teachers' Facebook group where somebody asked for the »top 20 Drewry dances«. It is now easy to find these according to the user ratings (or indeed the top 20 dances for any dance author) simply by putting the author's name into the »filter« box at the top right of the table. (Although to be sure this will also catch dances where the search term occurs in the title, like Tribute to John Drewry, so if any of these are popular enough you will need to exclude them yourself.)

For our more technical-minded readers, the reason why this hasn't been added before is that the rating system implementation is generic and supports ratings of any database object (not just dances). It can generate links to the detail pages for all of these objects but so far didn't include supplementary info. On the other hand, adding that info is important for dances (a) to enable tricks like the one mentioned above, and (b) because some dance names have been used more than once, and it would be inconvenient to have to check the details page to see which dance was actually meant. So a special case is warranted here.

database

· · Posted by Anselm Lingnau · 23 April 2014 12:21

Anselm Lingnau

just released an optical make-over for »crib sheets«, both on the »Cribs« tab of a dance list and in the corresponding PDF output. This should look a lot less ragged, and the weird issue with the descriptions of a crib showing up before a page break and the bar numbers after should also be fixed.

In the PDF output, it is now possible to select whether all items should be numbered, none, or whether just dances should be numbered and non-dance items, like »Interval«, not (in which case extras are numbered separately, as in »16, 17, E1, E2, 18«).

database

· · Posted by Anselm Lingnau · 12 March 2014 17:45 (last edited on 13 March 2014 0:04)

See more stuff