If you rename your iTunes albums (i.e. foreign language) be prepared for problems. I recently moved my iTunes from one computer to another. Many of the albums reverted back to Japanese. Here’s a list of problems I experienced:
Text changed back to Japanese
Split up albums
No more playlists
No more ratings
No more number of plays
I moved from Windows 7 to Windows 8.1. I’m not sure if that was the cause. I used iTunes “import” feature to move files from one computer to another. Maybe I would have been better off transferring my iTunes folder instead.
Believe it or not, the “get info” function reverted many of the albums back to English (restored my changes). Sometimes it wasn’t even necessary to click “ok.” I fixed the albums iTunes split up by checking for changes in the title or artist. I was baffled why one album was split so I deleted it then downloaded it again from the cloud which fixed the problem. I had to import each of my playlists individually from the old computer. You can get ratings back by importing rating based playlists then doing a select-all to rate all of them. The only thing I couldn’t get back was the number of plays.
There’s over 2,000 songs in my anime and jpop playlist that I want to hear but my iPod keeps playing the same songs over and over. The Shuffle feature doesn’t seem to help either. I’ve played around with the Last Played feature and achieved the desired results.
Create a Smart Playlist with the Last Played and “is not in the last” option. Go back in time as far as possible then stop where there is still music. This is your first playlist. It may only have a few songs–songs you haven’t heard in the longest time. Your first few playlists will be sparse. Keep adjusting the time forward to keep songs in your playlist. The drawback to this playlist is having to adjust it.
I’ve already posted about Gunbuster Music Collection on iTunes ($11.99). Gunbuster 2 is also on iTunes for ($11.99). Gunbuster 2 has 44 tracks including Groovin’ Magic by ROUND TABLE featuring Nino as well as the ending theme “Hoshi Kuzu Namida” by ACKO–both songs are full versions. If you have trouble finding it search “top wo nerae.”
I’m not good at navigating iTunes Japan yet let alone iTunes. I just found a bunch of Bandai collections. They’re called Bandai Channel Special Selection. Searching “Bandai” doesn’t give you much. This link to the King Gainer Pack will pull up some more Bandai collections. These links will help you find anime on iTunes U.S. and iTunes Japan.
Select the playlist in iTunes by clicking on it. Right-click and select “Export…” from the pop-up menu.
Save as a text file .txt
Import the text file in Excel (I’m using Office 2010). Choose delimited and select unicode UTF-8 as the file origin IF you have a foreign language like Japanese. Click finish.
Delete any columns you like. You will need a plug-in for Excel to create an xml and xsd file. Go to this Microsoft page. Follow the instructions on that page.
In Dreamweaver click the Spry tab and click the Spry Data Set icon.
Select XML as the data set. Browse the the XML file you created with Excel. Dreamweaver will also ask you for the xsd file you created with Excel. You’ll be walked through a wizard. Make sure and choose the options you want (i.e. sortable columns).
Upload the files to your site.
Here is an anime music playlist I created. Clicking the table headers lets you sort the column data.
To change iTunes bytes column to megabytes create a new column and enter the following formula =ROUND((D2/1024/1024),1) where “D2″ equals your first cell with bytes. When your cursor changes to a thin plus sign drag that formula into all the cells below. Format the new column as text. Copy and past it again using the values option. Delete the original bytes column and the 1st column you created.
To change iTunes seconds column to mm:ss create a new column and enter the following formula =INT(E2/60)&”:”&INT(MOD(E2,60)) where E2 contains the first cell with seconds. Use the same instructions above to populate and delete columns. Unfortunately, using this method will not allow you to properly sort this column so keep it as seconds if you want to sort it. What I did was sorting the data by time before editing then leave “sort column” as “none” using the wizard for a default time sort.
Remember to format your number cells as numbers so they properly sort.
You can also use Google Docs if you don’t have your own site. You can skip the XML steps that way too.