BackEnd

Autoplay, reporting, all those clever things it does. Discuss.

Moderator: kirkm

kirkm
Platinum Record (Admin)
Platinum Record (Admin)
Posts: 694
Joined: Wed Mar 07, 2007 8:50 am

BackEnd

Postby kirkm » Fri Jan 14, 2011 2:37 am

Hi All,

Further testing with the macro spreadsheet and the Access BackEnd is showing results well in excess of what was hoped for :D

Apart from the lryrics, the three Britburn sheets will also exist in the backend allowing searches and queries to use that, rather than Excel.

With this ability, the forthcoming 'playlist wizard' should be very powerful, when complete, but there are a few things ahead of that.

In the current version,the Titles Report has been set OFF in user config because it was too slow.
It allows a double click e.g. on 'Sway' to display all performers and stats for title 'Sway'. This is now fast enough to be set ON, but only shows if more than one instance of 'Sway' exists.

Of course there's many differnt songs with the same title and the spreadsheet doesn't distinguish them, but with the composers names shown you can identify which is which.

For some time similar , but not identical, artist and titles have been grouped into seperate columns. The was to allow selection of items that aren't the same but should be treated as the same e.g. 'Three Bells','The Three Bells (Les Trois Cloches)', 'The Three Bells (The Jimmy Brown Song)', also names like 'Rick Nelson' and 'Ricky Nelson'.
This now becomes more practical and will be expanded on. Eventually each song and performer will have a unique number (matching its Website data) but that's yet to happen.

One issue has been looming - concerning multiple acts like "Diana Ross & The Supremes & The Temptations" (which is 3 acts). To handle this, a new option in User Config lets you select 'Distinct' or 'Combined'.

If you click "Diana Ross & The Supremes & The Temptations" with Distinct set, you'll get a Report with just "Diana Ross & The Supremes & The Temptations". With 'Combined' selected
the report will also include anything by "Supremes', 'Temptations' and Diana Ross.

Cheers - Kirk

Return to “The Spreadsheet”

Who is online

Users browsing this forum: No registered users and 3 guests