Custom Report 3.2 - Updated 29/07/2014

[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]

"D" is used for dividing, do you mean "FY-m-d" for formatting dates?

[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]

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.

[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]

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]

Hello,

Is it possible to read the albumid with the Report?

Thanks for your reply.

Bensvine

[trixmoto]

At the moment there isn't a field for this, no. I'll add it in the next version though.

[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]

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.

[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]

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]

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]

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]

@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.