Reply to thread

Message

<blockquote data-quote="HappyTalk" data-source="post: 74809" data-attributes="member: 22671">Yer I've been looking into this also and wondering how best it would be implemented. Currently it takes about a minute to enter Music if left in 'Songs' View (40k tracks). I tried the sms remote way but it's just too awkward and time consuming. The feedback from the remote is not very responsive so it always ends up wrong, drove me crazy. For now I set the genre field in the database for each song to match the first letter of the artist which kinda helps, but in genera I am forced to just use the shares view to match my folder hierarchy, bypassing the database:-I figured that the least intrusive and most powerful would be too add an extra column called 'index' to 'configuration|music|Music Views'. Then you could choose to subdivide Artist, Album,Songs. If used on an already indexed column it could further subdivide, as on songs even just the letter A would result in too many entries. A slightly easier implementation might be to just add an 'Index' field to the already existing 'Operat' column in music views, using the 'restrict' &amp; 'limit' fields to determine how it operates.Setting this index value to 0 = Leave as is with no subdivision1 = 0, A, B, C..Z OR AA, AB, AC if used on an already subdivided Letter2..999 =&gt; group based on that number of entries.In Config I would then set up a view 'songs' thus:-SELECTION&nbsp; &nbsp; &nbsp; INDEXtitle&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1title&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1title&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0to get a hierarchy:-A-------------&gt;AAB ................ AB-------------&gt;Absolute Beginners C ................ AC ................ Absolution For 'Artists' view I would useSELECTION&nbsp; &nbsp; &nbsp; INDEXartist&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1artist&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15title&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 Which would Go 0, A,B,C..Z then would further subdivide if there were more than 15 artists in that letter :-0A-------------&gt;A Cer------------&gt;A Certain RatioB ................ Alaba ................ A Guy Called GeraldC ................ ArcaI reckon this would give most flexibility with minimal changes to the front end. I appreciate that from a coding viewpoint it would be a lot more complicated. I'd like to have a go (now I have my dev system all sorted out), BUT would not start until I was sure this concept is the most useable solution. For now if you wanna use genre for artists A..Z as i did you can use this SQL to do it. Save to a file, open the music database in SQLite database browser by doing 'File|Import|Database from SQL', select the saved sql file and answer No to create new DB.[code]DROP&nbsp; TABLE genre;CREATE TABLE genre ( idGenre integer primary key, strGenre text);INSERT INTO genre VALUES(1,'A');INSERT INTO genre VALUES(2,'B');INSERT INTO genre VALUES(3,'C');INSERT INTO genre VALUES(4,'D');INSERT INTO genre VALUES(5,'E');INSERT INTO genre VALUES(6,'F');INSERT INTO genre VALUES(7,'G');INSERT INTO genre VALUES(8,'H');INSERT INTO genre VALUES(9,'I');INSERT INTO genre VALUES(10,'J');INSERT INTO genre VALUES(11,'K');INSERT INTO genre VALUES(12,'L');INSERT INTO genre VALUES(13,'M');INSERT INTO genre VALUES(14,'N');INSERT INTO genre VALUES(15,'O');INSERT INTO genre VALUES(16,'P');INSERT INTO genre VALUES(17,'Q');INSERT INTO genre VALUES(18,'R');INSERT INTO genre VALUES(19,'S');INSERT INTO genre VALUES(20,'T');INSERT INTO genre VALUES(21,'U');INSERT INTO genre VALUES(22,'V');INSERT INTO genre VALUES(23,'W');INSERT INTO genre VALUES(24,'X');INSERT INTO genre VALUES(25,'Y');INSERT INTO genre VALUES(26,'Z');INSERT INTO genre VALUES(27,'0');UPDATE song SET idGenre = (SELECT SUBSTR(strArtist,1,1) FROM artist WHERE song.idArtist=artist.idArtist);UPDATE song SET idGenre = '0' WHERE idGenre &gt;= 0 AND idGenre &lt;= 9;UPDATE song SET idGenre = (SELECT idGenre FROM genre WHERE song.idGenre=genre.strGenre);[/code]Then you can adjust your music views in config to insert genre above them, poor mans solution&nbsp; but for now it works. Needs to be re-run if you ever add new music.</blockquote>

[QUOTE="HappyTalk, post: 74809, member: 22671"] Yer I've been looking into this also and wondering how best it would be implemented. Currently it takes about a minute to enter Music if left in 'Songs' View (40k tracks). I tried the sms remote way but it's just too awkward and time consuming. The feedback from the remote is not very responsive so it always ends up wrong, drove me crazy. For now I set the genre field in the database for each song to match the first letter of the artist which kinda helps, but in genera I am forced to just use the shares view to match my folder hierarchy, bypassing the database:- I figured that the least intrusive and most powerful would be too add an extra column called 'index' to 'configuration|music|Music Views'. Then you could choose to subdivide Artist, Album,Songs. If used on an already indexed column it could further subdivide, as on songs even just the letter A would result in too many entries. A slightly easier implementation might be to just add an 'Index' field to the already existing 'Operat' column in music views, using the 'restrict' & 'limit' fields to determine how it operates. Setting this index value to 0 = Leave as is with no subdivision 1 = 0, A, B, C..Z OR AA, AB, AC if used on an already subdivided Letter 2..999 => group based on that number of entries. In Config I would then set up a view 'songs' thus:- SELECTION INDEX title 1 title 1 title 0 to get a hierarchy:- A------------->AA B ................ AB------------->Absolute Beginners C ................ AC ................ Absolution For 'Artists' view I would use SELECTION INDEX artist 1 artist 15 title 0 Which would Go 0, A,B,C..Z then would further subdivide if there were more than 15 artists in that letter :- 0 A------------->A Cer------------>A Certain Ratio B ................ Alaba ................ A Guy Called Gerald C ................ Arca I reckon this would give most flexibility with minimal changes to the front end. I appreciate that from a coding viewpoint it would be a lot more complicated. I'd like to have a go (now I have my dev system all sorted out), BUT would not start until I was sure this concept is the most useable solution. For now if you wanna use genre for artists A..Z as i did you can use this SQL to do it. Save to a file, open the music database in SQLite database browser by doing 'File|Import|Database from SQL', select the saved sql file and answer No to create new DB.[code] DROP TABLE genre; CREATE TABLE genre ( idGenre integer primary key, strGenre text); INSERT INTO genre VALUES(1,'A'); INSERT INTO genre VALUES(2,'B'); INSERT INTO genre VALUES(3,'C'); INSERT INTO genre VALUES(4,'D'); INSERT INTO genre VALUES(5,'E'); INSERT INTO genre VALUES(6,'F'); INSERT INTO genre VALUES(7,'G'); INSERT INTO genre VALUES(8,'H'); INSERT INTO genre VALUES(9,'I'); INSERT INTO genre VALUES(10,'J'); INSERT INTO genre VALUES(11,'K'); INSERT INTO genre VALUES(12,'L'); INSERT INTO genre VALUES(13,'M'); INSERT INTO genre VALUES(14,'N'); INSERT INTO genre VALUES(15,'O'); INSERT INTO genre VALUES(16,'P'); INSERT INTO genre VALUES(17,'Q'); INSERT INTO genre VALUES(18,'R'); INSERT INTO genre VALUES(19,'S'); INSERT INTO genre VALUES(20,'T'); INSERT INTO genre VALUES(21,'U'); INSERT INTO genre VALUES(22,'V'); INSERT INTO genre VALUES(23,'W'); INSERT INTO genre VALUES(24,'X'); INSERT INTO genre VALUES(25,'Y'); INSERT INTO genre VALUES(26,'Z'); INSERT INTO genre VALUES(27,'0'); UPDATE song SET idGenre = (SELECT SUBSTR(strArtist,1,1) FROM artist WHERE song.idArtist=artist.idArtist); UPDATE song SET idGenre = '0' WHERE idGenre >= 0 AND idGenre <= 9; UPDATE song SET idGenre = (SELECT idGenre FROM genre WHERE song.idGenre=genre.strGenre);[/code] Then you can adjust your music views in config to insert genre above them, poor mans solution but for now it works. Needs to be re-run if you ever add new music. [/QUOTE]

Verification