Advanced Report 6.4 - Updated 24/06/2014
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.
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.
MarineBrat wrote:
Open Trixmoto's script in a suitable Editor and look for line 795 which should read as:
Run the Report again and your image will display instead of the bomb.
You can change this yourself by creating your own .png image. Copy it to the folder 'images' created by the report.OK, got it to run. And I notice that it lists unrated tracks as "Bombs".
Open Trixmoto's script in a suitable Editor and look for line 795 which should read as:
Edit bomb.png to yourfilename.png, and save the changes.If getstars = "" Then getstars = "<img src='images\bomb.png'>"
Run the Report again and your image will display instead of the bomb.
Rating -1 is no rating and rating 0 is bomb.
Download MediaMonkey | License
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
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 http://trixmoto.net/music/ - however this has not been updated to the new version yet (as my music collection is in the middle of being reorganised!)
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 http://trixmoto.net/music/ - however this has not been updated to the new version yet (as my music collection is in the middle of being reorganised!)
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
-
- Posts: 292
- Joined: Wed Feb 01, 2006 7:29 am
- Location: Germany
Hi,
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 2.5.2.950
Perhaps this could cause any trouble?
Thanks for your work
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 2.5.2.950
Perhaps this could cause any trouble?
Thanks for your work
-
- Posts: 490
- Joined: Tue Jun 14, 2005 12:12 am
- Location: Loony left coast, USA.
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.
I'll look into line 820 for you - hopefully I can find and fix the problem.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
-
- Posts: 2153
- Joined: Fri Jan 14, 2005 1:45 am
- Location: Germany
- Contact:
@holterpolter + trix
I get the same error. I'll have a look at it too. Maybe I can help.
EDIT:
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)).
I get the same error. I'll have a look at it too. Maybe I can help.
EDIT:
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)).
Cheers onkel_enno - fixed in the next version!
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
-
- Posts: 2153
- Joined: Fri Jan 14, 2005 1:45 am
- Location: Germany
- Contact:
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 - http://trixmoto.net/files/no-star.png
NEW CODE BELOW
- 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 - http://trixmoto.net/files/no-star.png
NEW CODE BELOW
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
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).
NEW CODE BELOW
NEW CODE BELOW
Last edited by trixmoto on Thu Mar 16, 2006 12:11 pm, edited 1 time in total.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.