Custom Report 3.2 - Updated 29/07/2014

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

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

Postby beg » Tue Nov 04, 2014 2:18 pm

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..
beg
 
Posts: 171
Joined: Wed Feb 04, 2009 12:36 pm

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

Postby trixmoto » Fri Nov 07, 2014 7:52 am

"D" is used for dividing, do you mean "FY-m-d" for formatting dates?
Download my scripts at trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

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

Postby beg » Fri Nov 07, 2014 8:20 am

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?
beg
 
Posts: 171
Joined: Wed Feb 04, 2009 12:36 pm

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

Postby trixmoto » Sun Nov 09, 2014 7:53 am

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 trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

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

Postby beg » Sun Nov 09, 2014 3:53 pm

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: 171
Joined: Wed Feb 04, 2009 12:36 pm

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

Postby beg » Thu Nov 13, 2014 7:24 am

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
beg
 
Posts: 171
Joined: Wed Feb 04, 2009 12:36 pm

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

Postby Bensvine » Tue Jan 06, 2015 5:26 pm

Hello,

Is it possible to read the albumid with the Report?

Thanks for your reply.

Bensvine
Bensvine
 
Posts: 9
Joined: Sun Feb 17, 2008 3:48 am

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

Postby trixmoto » Sat Jan 17, 2015 6:20 pm

At the moment there isn't a field for this, no. I'll add it in the next version though.
Download my scripts at trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

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

Postby imaginecomplex » Thu Mar 05, 2015 2:37 pm

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
imaginecomplex
 

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

Postby trixmoto » Thu Mar 12, 2015 5:38 pm

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 trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

Trixmoto Custom Report format field

Postby KyleHxAgain » Tue Mar 17, 2015 2:02 am

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?
KyleHxAgain
 

Re: Trixmoto Custom Report format field

Postby Guest » Tue Mar 17, 2015 6:11 am

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"
Guest
 

Re: Trixmoto Custom Report format field

Postby KyleHxAgain » Tue Mar 17, 2015 6:28 am

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

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

Postby jeffsang » Tue Mar 24, 2015 1:09 pm

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.
jeffsang
 
Posts: 3
Joined: Tue Mar 24, 2015 1:00 pm

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

Postby trixmoto » Wed Apr 29, 2015 1:38 pm

@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 trixmoto.net.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

PreviousNext

Return to Need Help with Addons?

Who is online

Users browsing this forum: No registered users and 15 guests