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)

Anselm Lingnau

fixed the state-saving issue for dance list detail pages (and others). This is the problem where one would enter something into the search box on the big dance lists overview screen, and the same search term would then be used to filter the list of dances on a dance list's detail page.

database

· · Posted by Anselm Lingnau · 6 March 2014 19:27

Anselm Lingnau

added support for displaying dance lists from the database on foreign (non-Strathspey) web sites. By means of a very small JavaScript program, administrators of these sites can include »dynamic« dance lists to their sites, for social functions, workshops, and so on. All dances, publications, etc. are linked to their corresponding entries in the database, and there are convenience links to download a crib sheet or diagram sheet or to view videos for the dances on the list (or those that actually have videos, anyway).

I have written a more in-depth article about this, with more details and examples. Do check this out and let me know how you get on!

database

· · Posted by Anselm Lingnau · 28 February 2014 1:13

Anselm Lingnau

posted the newest version of MiniCribs to the Strathspey SCD Database earlier today.

I also changed my automatic notifier to check the new MiniCribs web site, so we shall hopefully see new versions in the database much sooner after they appear on the official site.

database

· · Posted by Anselm Lingnau · 10 February 2014 21:29 (last edited on 14 February 2014 12:52)

Anselm Lingnau

just added a feature to the »Complex Dance Search« form in the dance database which lets you filter the results by lists. In other words, you get to enter the name of a dance list and the result will only contain dances that are in that list and also match all the other criteria that you specified.

What makes this really useful is that the »list name« can actually be a regular expression that matches a number of lists. Hence if you want to see all the reels on (recent) Frankfurt Spring Ball programmes, select »Reel« in the »Type« drop-down and enter »Frankfurt Spring Ball« into the »Lists« field. If you want to see all the three-couple set dances that the Frankfurt SCD Club did in 2013, set up the »Couples« and »Set shape« drop-downs accordingly and put »FSCDC.*2013« (note: »dot-star« – this stands for »any number of arbitrary characters«) into the »Lists« field. Enjoy!

(This feature was suggested by Sir Toby.)

database

· · Posted by Anselm Lingnau · 15 January 2014 12:54 (last edited on 14 February 2014 12:52)

Anselm Lingnau

has now rolled out the first version of collection support for the database. Look for the »Collections« link in the navigation box.

database

· · Posted by Anselm Lingnau · 29 August 2013 10:07 (last edited on 14 February 2014 12:53)

Anselm Lingnau

has added Charles Upton's MiniCribs to the database (this project had been on the back-burner for a very long time).

Now working on letting people set up their own preferences as to which sources for cribs or diagrams they want and in which order. The back-end support for this works already; all that is needed is a convenient way for people to edit their preference lists. The current approach is to add a »Database« tab to users' profiles – this may have the side benefit that more people might discover the social-networking features of the site.

database

· · Posted by Anselm Lingnau · 22 August 2013 13:18 (last edited on 14 February 2014 12:53)

Anselm Lingnau

fixed a few small problems with the diagram sheet feature made available yesterday.

  • The first problem involved dances without diagrams whose titles include special characters like »&«. These require special treatment to prevent LaTeX (the software that creates the diagram sheets) from choking on them. While I thought of doing this for the dance source, I neglected to do the same for the dance title, and this bit somebody trying to generate a diagram sheet for The Flying Ghillies Collection Vol 2, which contains a dance called Sylvander & Clarinda.

  • The second problem surfaced when somebody tried to make a booklet containing just one diagram. The »imposition« process (that places the various booklet pages on the A4 sheet, properly rotated) needs to know how many pages it has to deal with, and we get that information from the log file that LaTeX writes when it creates the actual booklet pages, by looking for the line that says »Output written on … (X pages, Y bytes)« and isolating the page count. Turns out that my code was looking for the »pages« keyword, and TeX, being fastidious about that sort of thing, writes »1 page« if the output consists of only one page, so the page count couldn't be determined in this case.

Both of these issues should now be fixed. Thank you for your indulgence!

database

· · Posted by Anselm Lingnau · 17 August 2013 14:02 (last edited on 14 February 2014 12:53)

Anselm Lingnau

Due to popular demand, I added a cool feature to the Strathspey SCD database: diagram sheets!

If you go to a dance list's »Diagrams« tab, there is now a little form that lets you select either »Two-column sheet« or »8-page booklet«. The former is the standard portrait diagram sheet which is popular, e.g., in Germany, while the latter is a nifty format which with a little folding and one (clearly indicated) cut lets you prepare a sporran-size »booklet« which is easier to handle than a full A4-size sheet. (See here, for example, for assembly instructions.)

In both formats, the dances are numbered for clarity and dances without diagrams are indicated so you won't get confused. Also, if a dance list does not fit on one page it spills over onto additional ones, so with the »booklet« format you get a multi-volume document (!). I tested this with the RSCDS Core Repertoire lists and it is way cool.

Try it and tell me if you like it!

database

· · Posted by Anselm Lingnau · 16 August 2013 14:17 (last edited on 14 February 2014 12:54)

See more stuff