Page 4 of 51

Posted: Mon Mar 13, 2006 4:08 pm
by confused
what does this do can you please put a screen shot up of what the script does thanks.


Posted: Mon Mar 13, 2006 5:26 pm
by Guest
On the other hand, go to Trixmoto's website and download his installer for the script. Once installed, go to File>Create Reports>Advanced Report.

Type in a directory path. Click report and watch the magic.

The script will create an html file in your chosen directory along with a copied set of the associated Album Art in a separate 'images' folder.

Then open the html file and see whether you like it. I think you will. :)

Posted: Mon Mar 13, 2006 7:31 pm
by O
MarineBrat wrote:
OK, got it to run. And I notice that it lists unrated tracks as "Bombs".
You can change this yourself by creating your own .png image. Copy it to the folder 'images' created by the report.

Open Trixmoto's script in a suitable Editor and look for line 795 which should read as:
If getstars = "" Then getstars = "<img src='images\bomb.png'>"
Edit bomb.png to yourfilename.png, and save the changes.

Run the Report again and your image will display instead of the bomb.

Posted: Mon Mar 13, 2006 8:21 pm
by Lowlander
Rating -1 is no rating and rating 0 is bomb.

Posted: Tue Mar 14, 2006 6:05 am
by trixmoto
I wrote the code for the "save as" button but forgot to put it on the screen! Will do this for the next release.

I will also correct the ratings images. What do people want if there is no rating? No image, or an image with a crossed out star or something?

@ holterpolter - there should be no limit because this script uses SQL so I have no idea what your problem is. The only thing I can suggest is that you have blank values in your ratings field in the database (should be -1 if there's no rating). If this is not the case, I'll have to investigate further.

You can view what version 2.3 of the script created on my collection by going to - however this has not been updated to the new version yet (as my music collection is in the middle of being reorganised!)

Posted: Tue Mar 14, 2006 11:12 am
by holterpolter
i would prefer a crossed out star if there is no rating.

Back to the overflow error:
I checked my Database and i canĀ“t see any unusal or blank ratings.
So i tested your script with a database which included only the problematic Album and it goes through without any errors.

If i comment the line 820 out of your script it goes through my whole Database without further errors.

Info: I am using a German Win XP System with a German Monkey
Perhaps this could cause any trouble?

Thanks for your work

Posted: Tue Mar 14, 2006 11:30 am
by MarineBrat
trixmoto wrote:What do people want if there is no rating? No image, or an image with a crossed out star or something?
I think it should have a simple "N/R". Does it have to be an image that's presented? Can I simply edit the script and put "N/R" in that spot?

Posted: Tue Mar 14, 2006 2:02 pm
by trixmoto
Yes, you can put any HTML you want in that string.

I'll look into line 820 for you - hopefully I can find and fix the problem.

Posted: Wed Mar 15, 2006 1:38 am
by onkel_enno
@holterpolter + trix
I get the same error. I'll have a look at it too. Maybe I can help.

I have it.
CLng tries ty convert to an integer value, but Avg(Rating) sometimes return a real number. Using Rating = iter.ValueByName("Nombre") should work better. You can then Round it if you want (Rating = Round(iter.ValueByName("Nombre"), 0)).

Posted: Wed Mar 15, 2006 5:39 am
by trixmoto
Cheers onkel_enno - fixed in the next version! :)

Posted: Wed Mar 15, 2006 6:17 am
by onkel_enno
No Problem :)

Posted: Wed Mar 15, 2006 9:46 am
by trixmoto
New version (3.1) is basically a bugfix.

- Rating bug fixed (thanks to onkel_enno)
- Rating images corrected
- Browse button added for output path
- Tooltips added listing available mask fields

Also you can specify a different image size for the artist list of albums, and the album list of tracks. The "width" field specifies the album list of tracks as it did previously, but the "height" field (which was pointless because images are square) has been changed to "icon" which specifies the artist list of albums image size.

New rating image -


Posted: Thu Mar 16, 2006 7:10 am
by trixmoto
New version (3.2) has a bug fixed with the <rating> field. Also the option has been added to have no artwork. (If you wish to have images but not icons, or vice versa, then just set the size to 0. However if you wish to temporarily switch off the artwork without losing your size values, use the mode dropdown).


Posted: Thu Mar 16, 2006 8:33 am
by kanski
mini bug:
Save As Dialog is not modal. When dialog open, user may use Advanced Report - Option window.

Posted: Thu Mar 16, 2006 8:54 am
by kanski
Trouble with separate files = True. Russian artist title not displayed correctly, but russian albums - ok.

If separate files = False, then I have not this problem.