Jaikoz- Discussion Forum

Paul,

Where did you hear about the covers archive for musicbrainz? It sounds interesting. Do you have any links or anything to it? I did not see any posts on their blog, but I have not scoured their forums yet.

EDIT: oh, found an interesting article on it http://musicbrainz-mailing-lists.2986109.n2.nabble.com/Announcing-The-long-awaited-beta-of-the-Cover-Art-Archive-td7393735.html

Sent to support. Thanks

I found the problem, it was 1 lyrics field on 1 file. It appears excel couldnt open the xls with that files info in it. It appeared as a broken formula or something. Not sure why excel would see it as a formula though.

Paul,

I could email you the file if you like. I made a copy of the unmodified file in case you're interested. Then cleared out the lyrics field of my main file and it went through just fine. Only file out of 300k files that would cause the jaikoz xls exporter not to provide a valid xls file. So not an issue any more for me, but I don't know if you want to see it to find out what would cause the exporter to not produce valid xls files.

Upon further testing, it appears to not be all xls files. I have found it is only 1 file that I create from about 50k songs. Currently I am breaking down this group of folders into smaller ones so I can hopefully identify what file(s) would be causing data in an xls file to error out excel.

Just an update. I decided to install openoffice.org calc as it handles csv utf-8 files a lot better than excel (wishes MS would go full utf-8 everywhere). I tried opening the xls file in calc and it crashes the program. So it looks like the xls file is corrupt and unviewable by both programs.

I am unable to open up any xls files created by the export feature in jaikoz. I am using windows 7 64bit Pro along with MS Office Excel 2010. I am using jaikoz 4.5.7 in 64bit mode.

When I try to open the file, I get an error box:

"Excel found unreadable content in 'A.xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

I then click Yes, and get the following:

"Unable to read file."

followed by,

"The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt."

I can save the file as a csv and open it just fine in Excel. Any ideas why the xls file will not open? I have tries exporting it thrice now and every time I get the same results. I can also send you a copy of the file if you like.

Thank you.

Ahh, nice source. Thanks for the link. Been playing around with setting up a htpc. Still undecided between wmc 7 and xmbc both have some really nice features.

Hmm, just noticed the music section #1 submitter for the month is dkoh, is that you?

I just got done setting up a bunch of my From and To settings in the Preferences:File and Folder Correct:Flie and Folder Naming. I have the Replace non ascii characters and the replace from character with to character checked. I was able to type in and add all the rules I wanted for replacing a character with a different character(s). However I can not figure out how to just remove certain characters as it will not let me use the Add button if the To field is empty. I have about 2 dozen characters that I want jaikoz to just replace with nothing, ie just delete them. Is there an easy way to do this?

Thank you.

Make sure you have your file name mask setup correctly in the preferences. Should be under File and Folder Correct tab and then the Rename File from Metadatab. My guess it would be something like:

Code:

  title + ' - ' + artist

Then just load your songs into jaikoz and click on Action -> File and Folder Correct -> Correct Filenames from Metadata

Spam post. There were a few of these in the filters that started out exactly the same way.

i have mine set to only show the xxxx date. It does not include the month or day. I think it might be the setting in the preferences under the local correct tab, and then under the year correct tab. Make sure the year is set to store year and not store date.

My year section in my rename mask looks like this:

Code:

  (year.length>0  ? '(' + year + ') ' : '')

basically verifies there is a year, then if there is, adds it in parenthesis, like (2012)

I have mine so it creates sub folders called disc 1, disc 2, disc 3, etc, and puts in the corresponding music only if the album has more than 1 cd in the set. You can see http://www.jaikoz.com/jaikozforum/posts/list/4418.page for an example of how I did it.

Windows has a bunch of annoying limitations in the file system. There are quite a few different characters that are not allowed in the file names as well as certain combinations of characters. As far as length goes, one is limited to a total of 260 characters. This includes all characters, including spaces, and all the folders in the file path.

Sometimes you can get files that were named on a mac or in linux and that are near impossible to edit in windows as they have an invalid file name structure. This can be a real pain to have to edit through DOS.

I like to stream a lot of my music online through my own website, so I prep my files to be as file system friendly as possible to play nicely with my win home server NAS as well as php code friendly for my website and flash/html5 player.

I bought this program a long time back to run my files through after I tag and rename them to verify there are no problems with length or characters or breaking any windows file structure rules. It is a commercial program, and the UI is horrible, but it does a wonderful job at identifying any issue. It also allows one to edit files that windows won't allow direct editing access to. It is called DelInvFile and can be found here: http://www.purgeie.com/delinv/

Loving the changes made in 4.5.6 / 4.5.7! Program is running smoothly and the musicbrainz matching is returning even greater results.

Keep up the awesome work!

Are you using the latest version of jaikoz?

I also found on my win7 64bit system, that it was best for me to uninstall and delete all versions of java then go to the java.com and download the latest java 6 versions of both the 32bit and 64bit installs and install them.

On my system, java 7 did not work with jaikoz, so I chose not to install it and only use java 6. I find the jaikoz executable uses the 32bit, where as my batch (jaikoz.bat) file that I increased the memory to 4gb will use the 64bit version. Both of them work well with just java 6.