I am busy writing a Loader program for the Freebox Jukebox program. The program will automate a lot of stuff like update music, install and activate skins, handle playlist and requests, read from .dat and .cvr files into access database for statistical analysis, and cash-ups.
If there is anything that you think I should add, remove or do differently, please let me know. When I am finished with the program(and this is when I feel its done), I will share.
If you could automate the adding of new music to the music db by ripping CD's and adding the cover art and tags to the mp3's I'm sure that would make alot of people happy here.... Welcome to the forum...
Compare all album artists to current fanart and and give a spreadsheet layout of needed fanart.
Quote from: bzpilot on April 15, 2011, 08:18:49 PM
Compare all album artists to current fanart and and give a spreadsheet layout of needed fanart.
On the same line, while comparing for missed fanart, hows about also comparing for missing artists as well?
Thanx all for the input. The loader is going smoothly.
Barry, I have run into a little issue with the Album names. Manny of the Afrikaans albums has the ê char in it. Whenever I come across this the Jukebox doesn't recognize the character and every album after that has white album art and the songs for those albums are the same as the album with the ê.
Quote from: MrZedSven on May 05, 2011, 07:25:36 AM
Thanx all for the input. The loader is going smoothly.
Barry, I have run into a little issue with the Album names. Manny of the Afrikaans albums has the ê char in it. Whenever I come across this the Jukebox doesn't recognize the character and every album after that has white album art and the songs for those albums are the same as the album with the ê.
Is this a problem with using that character in the filename or in the tag?
Its in the tag.
We are using early versions of the loader in our company. And its almost at the point where I can release it on the forum. There is still a couple of thing that needs to be added. I am looking more towards a back office software suite that jukebox operators can use.
I'm busy with the help files for the software and will upload it by this weekend. By reading the help files you will have a fairly good idea what the software is all about.
https://skydrive.live.com/embedphoto.aspx/CoinplayLoader/untitled.JPG?cid=2a447d77443b7119&sc=photos (https://skydrive.live.com/embedphoto.aspx/CoinplayLoader/untitled.JPG?cid=2a447d77443b7119&sc=photos)
Help files... You sir have more time than I. I remeber when we had a dream of creating a manual, that went down the shitter.
Quote from: Barcrest on May 05, 2011, 12:51:31 PM
Is this a problem with using that character in the filename or in the tag?
Sorry it took me so long to reply. But the problem seemed to be song titles and album titles longer than 60 chars. I was busy with other stuff and when I started again this week it just seemed so obvious. :tommy
I have done a bit of work this past week on the database builder app of mine. It seem to build the database perfectly, but the search function does not work. It only shows results for audio and while typing it doesn't display the tracks above.
What do you think may be the error.
Quote from: MrZedSven on November 14, 2011, 06:10:20 AM
I have done a bit of work this past week on the database builder app of mine. It seem to build the database perfectly, but the search function does not work. It only shows results for audio and while typing it doesn't display the tracks above.
What do you think may be the error.
The DB consists of 2 parts. the CVR file and the REC file. Are you creating both of those? The REC file is an alphabetical list of the tracks and the CVR is an alphetcical list of albums.
Yes. Even the cvr files in the artist, year and genre folders so my quick jumps work. Its just the search function that doesn't work properly. ???
The rec file. Is it alphabetical for the track names or the artist and album names?
Quote from: MrZedSven on November 15, 2011, 07:04:33 AM
Yes. Even the cvr files in the artist, year and genre folders so my quick jumps work. Its just the search function that doesn't work properly. ???
So you have the rec file as well. Are both files alphabetically sorted by artist with the numbers first then the artists with A then B etc.
Quote from: Barcrest on November 15, 2011, 07:42:20 AM
So you have the rec file as well. Are both files alphabetically sorted by artist with the numbers first then the artists with A then B etc.
I have the rec files as well. I have alphabetically sorted both files by artist. When I sort the rec files alphabetically by track names the search seem to go better, but only for the audio part.
When you press search on the jukebox, the search by album and artist works perfectly. With search by track the intelligent search doesn't work and if you click search it only shows audio tracks.
I think you are correct the REC file needs to be sorted on track name, I don't have the source with me to be 100% sure.
Quote from: Barcrest on November 15, 2011, 09:27:27 AM
I think you are correct the REC file needs to be sorted on track name, I don't have the source with me to be 100% sure.
Okay the rec file doesn't need to be sorted by name, only the cvr file. But I fixed that part.
I want to know about the hot hits. It seems to get the hot hits from the user_history.dat except when there is a most_played.dat file, is this correct? We also found that the most_played.dat file does not match the most played files in the user_history.dat. By deleting the most_played.dat file the hot hits worked fine.
What I want to know is the use of the most_played.dat file and is it even necessary to have it.
Quote from: MrZedSven on February 07, 2012, 01:39:34 PM
Quote from: Barcrest on November 15, 2011, 09:27:27 AM
I think you are correct the REC file needs to be sorted on track name, I don't have the source with me to be 100% sure.
Okay the rec file doesn't need to be sorted by name, only the cvr file. But I fixed that part.
I want to know about the hot hits. It seems to get the hot hits from the user_history.dat except when there is a most_played.dat file, is this correct? We also found that the most_played.dat file does not match the most played files in the user_history.dat. By deleting the most_played.dat file the hot hits worked fine.
What I want to know is the use of the most_played.dat file and is it even necessary to have it.
most_played.dat was there to speed up loading time so the history didn't have to be built into the most played everytime. It seems like it doesn't work for some reason so i might just not bother with and put up with the longer load times.
Just how long does the jukebox take to start without the mostplayed.dat file? Will it take a couple of minutes or seconds?
Quote from: MrSven on April 17, 2012, 09:28:38 AM
Just how long does the jukebox take to start without the mostplayed.dat file? Will it take a couple of minutes or seconds?
Not sure but this has been dropped, the bulk of the load time is down to the skin and loading the skin images.
Building the most_played is built from the history file so the bigger that is obviously the longer it will take.
Is it possible to have etouch update the database on startup rather than clicking on update database in the config tool when you update the library, or has this already been done?
Quote from: GlennCarnell on April 17, 2012, 10:26:24 AM
Is it possible to have etouch update the database on startup rather than clicking on update database in the config tool when you update the library, or has this already been done?
You wouldn't want it to do that everytime if you had a DB the size of mine. If you want it to run an update everytime then you are better off using a BAT file that calls the config with appropriate flags to update the DB before launching E-Touch.