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. 🙂
I use Google Translate to help me with Japanese CD listings. It works pretty good for the most part. It also gives you a romanji translation which is pretty accurate. The English translation needs some work though. I tried to translate a song title from my Gunbuster soundtrack. The title was:
いけいけぼくらのガンバスター!! (TVサイズ カラオケ)
Google came up with a pretty good romanji translation:
Ike ike boku-ra no ganbasutā! ! (TV saizu karaoke)
Hinotori has a great soundtrack including a great orchestral opening. BTW, the opening has the second movement of Beethoven’s Pathétique Sonata as background melody. The CD artwork is beautiful. I thought this came with Mika Nakamisha’s Hi no Tori (the anime’s ED) but I guess not. That’s okay as I have it on her Music CD.
I finally received my Momoe Shimano CD which I ordered March 15th. Her music sounds like jazzy R&B. Rurouni Kenshin – The Best Theme Collection arrived as well. I bought it used and came in great shape. I’m pretty sure it has all the openings and endings. My favorite songs are “1/2” and Heart of the Sword. Infinite Stratos came too from RightStuf. I’m hoping it’ll be funny.
I’d buy this right now if the box set came with subtitles. I’d like to see the extra footage and bonus material but the lack of subtitling was the deal-breaker for me. I could get by though. I’ve seen it many times and could get the jist of what’s being said. I’m not sure if this Blu-ray will make it here given Bandai’s downsizing in the U.S. I’m hoping a Hong Kong version with subtitles will come about so I can buy it. The Box set comes with 3 discs including extra footage. I’ll be disappointed for now and hope it will be release here.
Running Time: 170 minutes
Region Code: Region-free
Audio Tracks: Japanese 5.1ch, Linear PCM Stereo
Aspect Ratio: 4:3
Most of the time I’m listening to my songs on my Dell which has a tiny speaker attached below the monitor. I use the JBL speaker dock mostly at work. I also use my Droid Charge to watch Crunchyroll when I’m not home. I al
so have a stereo system with Bose 901s but I don’t even use that anymore. My wife complains when I play music too loud. She even complains when I’m listening to music on my Dell.
I had 3 CDs arrive from Japan yesterday which is unusual. One was my Gunbuster CD which came by DHL. Two others came by mail. I haven’t had time to listen to them yet. I’m wondering if my You’re Under Arrest Original Soundtrack is the same as You’re Under Arrest 1 1/2? They both seem to have the same tracks. Both CDs pictured were purchased used but in good condition.