Custom Report 3.2 - Updated 29/07/2014

[Big Isch]

Thanks.

I tried the modification, but it did not help. So I looked
into the CSV with texteditor and found that it was OK in the first place (I'm sorry).

Problem is the german Excel, that requires a CSV file with delimiter ";" not ",".
(Which of course causes big troubles all the time, especially when using libraries to read CSV)
To use CSV on german (and maybe other) systems, an option to specify the separator would be needed.
Above, excel took entire line with 5 items as first column.

Using e.g. "<*>" or "|" as delimiter in TXT files would be easy to parse in any program.



Please help !

[trixmoto]

Ok, I'll see what I can do in the next version.

[Big Isch]

Good news.

Just found out that TXT format delimits with TAB characters.
So the TXT file is easy to import into german excel now !

Having CSV file with separator ";" would be great for easier workflow.

[nynaevelan]

TM:

Is there a way to set up the format of the LastPlayed output to only output the date without the time?

Nyn

[trixmoto]

I don't think so at the moment, but I'll try to come up with something for the next release.

[nynaevelan]

Thanks.

[Eyal]

Hi guys.
Excellent upgrade Trix!

Now it's easier than ever to create CD covers

Good job.

Greetings
Eyal

[Piko]

no laughing ok? i been trying to add a new format option

Case "H" 'hyperlink
tmp = "<a href=""'"str"'"">"str"</a>"

and yer it wont work, what syntax i need to do that? = / i know most people wouldnt have a use for this format option, hence i'm just aking what syntax i'd need rather than for it to be added as future functionality

[trixmoto]

This should do it...

Code: Select all

tmp = "<a href="""&str&""">"&str&"</a>"

It's a nice idea though, I'll add it to the next version!

[sommo]

I would just like to say a thank you trixmoto, for this addon!
This is one of the reason why I use MediaMonkey!
It is really helpful and I do use it
Keep up the good work & Happy coding!

[Big Isch]

I think there is a problem with the XML export because it does not have a root-node.
Thus, it is not well-formed and cannot be displayed in IE or Firefox.

[trixmoto]

New version (1.7) is now available to download from my website. Changes include...

- Added format "H"yperlink for creating links
- Added format "E"xtract for extracting parts of value
- Added fields "TrackBackupIdent", "AlbumComment" and "AlbumTracks"
- Added button to set delimiters for CSV files

For the "H"yperlink format you can either specify the link ("Hhttp://trixmoto.net") or if you don't ("H") then the value will be used as the link.

For the "E"xtract format you need to specify a delimiter in brackets and the item number to be used ("E(delimiter)#"). If you want to use a space then use balnk (as spaces are the delimiter between formats!) So for example with the value "07/07/2008 09:11:03 AM"...

E()1 = 07/07/2008
E()2 = 09:11:03
E()3 = AM
E(/)1 = 07
E(/)2 = 07
E(/)3 = 2008 09:11:03 AM
E(:)1 = 07/07/2008 09
E(:)2 = 11
E(:)3 = 03 AM

[Big Isch]

- Added button to set delimiters for CSV files

Thanks a lot for this functionallity.
It seems that saving the settings to the ".Dat" file does not include the delimiter setting
(which would be fine ).

[trixmoto]

Ooops! I'll get that sorted in the next version.

[thorgal67]

Hi Trixmoto
Just experiencing something crazy with your script:

1 month ago, running the script went fine for both a HTML and an Excel lIst of my songs (28544 songs), but today, after some seconds, it terminates my MM3 without any error message and without even showing the setting window. In the meantime, my songslist counts 31343 items and my MM3-DB is over 80MB (cleaned and compacted).

As all of the other scripts run fine and produce the desired results (most of them are your scripts , the bug should be in CustomReport and you or any other experiencing something similar can maybe help me with it, I really love your script because it helps me managing my large number of files.

From a machine perspective, i run XP SP3 with MM3 1183 and have all the needed additional sw/sp installed, my machine hw-profile is http://www.sysprofile.de/id60442.

Thanks in advance for any hint and best regards. Christophe.