Page 35 of 37

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

Posted: Tue Nov 04, 2014 2:18 pm
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..

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

Posted: Fri Nov 07, 2014 7:52 am
by trixmoto
"D" is used for dividing, do you mean "FY-m-d" for formatting dates?

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

Posted: Fri Nov 07, 2014 8:20 am
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?

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

Posted: Sun Nov 09, 2014 7:53 am
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.

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

Posted: Sun Nov 09, 2014 3:53 pm
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

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

Posted: Thu Nov 13, 2014 7:24 am
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

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

Posted: Tue Jan 06, 2015 5:26 pm
by Bensvine
Hello,

Is it possible to read the albumid with the Report?

Thanks for your reply.

Bensvine

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

Posted: Sat Jan 17, 2015 6:20 pm
by trixmoto
At the moment there isn't a field for this, no. I'll add it in the next version though.

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

Posted: Thu Mar 05, 2015 2:37 pm
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

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

Posted: Thu Mar 12, 2015 5:38 pm
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.

Trixmoto Custom Report format field

Posted: Tue Mar 17, 2015 2:02 am
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?

Re: Trixmoto Custom Report format field

Posted: Tue Mar 17, 2015 6:11 am
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"

Re: Trixmoto Custom Report format field

Posted: Tue Mar 17, 2015 6:28 am
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.

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

Posted: Tue Mar 24, 2015 1:09 pm
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.

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

Posted: Wed Apr 29, 2015 1:38 pm
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.