Custom Report 3.2 - Updated 29/07/2014

Download and get help for different MediaMonkey for Windows 4 Addons.

Moderators: Peke, Gurus

beg
Posts: 193
Joined: Wed Feb 04, 2009 12:36 pm

Re: Custom Report 3.2 - Updated 29/07/2014

Post by beg »

with "DY-m-d" a year only field is given as it is e.g. "1937", but a mixed date is given as "27.3.1937", so wrong order..
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 3.2 - Updated 29/07/2014

Post by trixmoto »

"D" is used for dividing, do you mean "FY-m-d" for formatting dates?
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.
beg
Posts: 193
Joined: Wed Feb 04, 2009 12:36 pm

Re: Custom Report 3.2 - Updated 29/07/2014

Post by beg »

ok, "FY-m-d" is giving a full date correctly as 2014-11-07 in the order we need, but the tags with a year only are given as "2014-01-01" which can not be used like this.

what we would need is this:
tag (dd.mm.yyyy): 7.11.2014 => report output: 2014/11/07
tag (mm.yyyy): 11.2014 => report output: 2014/11
tag (yyyy): 2014 => report output: 2014

any chance this is possible?
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 3.2 - Updated 29/07/2014

Post by trixmoto »

Well the first and third should work already if you're using "MixedDate" - are you sure the month and day are definitely blank for this track?

The middle one doesn't currently work, but I can look at adding that 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.
beg
Posts: 193
Joined: Wed Feb 04, 2009 12:36 pm

Re: Custom Report 3.2 - Updated 29/07/2014

Post by beg »

Well in the tagging software I write the year only in the date field. I don't know the exact format how it is saved afterwards. So when tagging the files I fill in:
YYYY: "1937"
or
MM.YYYY: "11.1937"
or
DD.MM.YYYY: "9.11.1937"

and it would help for later processing (sorting) if the report would change the output for those fields into YYYY/MM/DD where there is a date given and skip the part where is none.

at the moment with "FY-m-d" there is 1 January added for the fields with year given only.

Btw. as far as bugfixes are concerened:
When exporting into a CSV-file it is impossible to configure/set and save no first or last delimiter. I only use the middle delimiter and no first or last one. But this is the only thing not being saved, so it has to be deleted for every new export..

thx for looking into this!
Bernhard
beg
Posts: 193
Joined: Wed Feb 04, 2009 12:36 pm

Re: Custom Report 3.2 - Updated 29/07/2014

Post by beg »

I just found out by chance that when adding a sorting table in Media Monkey on top listing "Date" the existing dates are displayed in exactly the form I'd like to have it exported:

e.g.:
1927
1927-01
1927-02-05
1927-02-17

and so on... So obviously in order to sort the date correctly Media Monkey is doing exactly what I'd like to have exported as report - sorting the date as yyyy-mm-dd
Bensvine
Posts: 9
Joined: Sun Feb 17, 2008 3:48 am

Re: Custom Report 3.2 - Updated 29/07/2014

Post by Bensvine »

Hello,

Is it possible to read the albumid with the Report?

Thanks for your reply.

Bensvine
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 3.2 - Updated 29/07/2014

Post by trixmoto »

At the moment there isn't a field for this, no. I'll add it in the next version though.
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.
imaginecomplex

Re: Custom Report 3.2 - Updated 29/07/2014

Post by imaginecomplex »

I try running the export and get the error:

Error #52 - Microsoft VBScript runtime error
Bad file name or number
File: "C:\Users\myusername\AppData\Roaming\MediaMonkey\Scripts\Customreport.vbs", Line: 2178, Column: 6

Please let me know if there is a workaround for this. This script seems fantastic in principle, I just want it to run!

Thanks for any help you may have.

Best,
imaginecomplex
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 3.2 - Updated 29/07/2014

Post by trixmoto »

Not sure, that's just the loop that creates the folder location you've selected for the report, if it doesn't exist. You could try adding "MsgBox pFolderPath" on the line before. Then when you run the script, you'll get a popup each time it's about to run that line. Hopefully that will help to determine what part of the path is causing 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.
KyleHxAgain

Trixmoto Custom Report format field

Post by KyleHxAgain »

re: Trixmoto Custom Report 3.2
Checked around both sites: MM & trixmoto.net
Can't seem to find any instructions.
The "format" fields needs codes.
What are they?
Guest

Re: Trixmoto Custom Report format field

Post by Guest »

Code: Select all

FORMAT:
Add: A1 - "1" becomes "2"
Newline char: C*** - Newline character
Divide: D100 - "1" becomes "0.01"
Extract: E()2 - "A B C" becomes "B"
Format date: Fd/m/Y - "30th Oct 2009" becomes "30/10/2009" - http://uk.php.net/manual/en/function.date.php
Hyperlink: H... - Create link in HTML
Hyperlink: I... - Create link in HTML using mask 
Justify: JL for left, JR for right, JC for centre
Lowercase: L - "Word" becomes "word"
Multiply: M100 - "1" becomes "100"
Number: N2 - "1" becomes "1.00"
Prefix: P( - "Word" becomes "(Word"
Replace: R1=One - "1" becomes "One"
Suffix: S) - "Word" becomes "Word)"
Title case: T - "WORD" becomes "Word"
Uppercase: U - "Word" becomes "WORD"
Width: W25% - Column width in HTML/Excel
Leading zeros: Z2 - "1" becomes "01"
Traverse: \1 - "C:\Music\Test.mp3" becomes "Music\Test.mp3"
KyleHxAgain

Re: Trixmoto Custom Report format field

Post by KyleHxAgain »

Thanks. Is there a source of documentation of the trixmoto stuff?
There's seems to be quite a bit of useful stuff there (even if dated),
but sorting through isn't so easy.
jeffsang
Posts: 4
Joined: Tue Mar 24, 2015 1:00 pm

Re: Custom Report 3.2 - Updated 29/07/2014

Post by jeffsang »

Video Resolution in Report:

I regularly use the Custom Report 3.2 script. While it offers a wide variety of fields for export into the report, I would like for it to include either the "Dimensions" or "Frame Height/Width" attributes as part of the report. It doesn't seem like I'm able to add this though from the drop down list. Does anyone know a way I can export this info?

Thanks.
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Custom Report 3.2 - Updated 29/07/2014

Post by trixmoto »

@KyleHxAgain - sorry, I don't really do documentation. Scripting is a hobby for me and documentation doesn't fall into the "fun" category :) If you've got any questions though, myself and others on the forum will do our best to answer. I try to make my scripts as intuitive as possible, but I understand the formatting for this script isn't really - hopefully it's useful though!

@jeffsang - this script reports on the values made available by the MM scripting API, and the fields you're asking for aren't available. Having said that, there are other ways of getting the information, so I could look at trying to add them in.
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.
Post Reply