Say you want to make a playlist out of all your j-pop CDs but not all of them have the j-pop genre. Right-click on an album or a track and select Get Info. In the comments box add your tag “jpop.” I would use letters and numbers only with no spaces. If you would like to add a another tag for anime soundtrack add “animesoundtrack.” You don’t need commas between your tags just leave a space, “jpop animesoundtrack.”
Now you can create a playlist from your tags. On the toolbar select File then select New Smart Playlist. On the first drop down box select Comments. On the next drop down box select “contains” then type your tag in the box. If you would like to add multiple tags, click the + button then repeat the previous step as needed (make sure to change the “all” button to “any”).
Best of Playlist
To make a “best of” playlist you’ll have to rate tracks first then make a smart playlist. On the toolbar select File then select New Smart Playlist. On the first drop down box select Rating. iTunes will automatically make this 5 stars. Next, click the ellipsis button to add your tags. On the next drop down box select Comments. On the following drop down box select “contains” then type your tag in the box. If you would like to add multiple tags, click the + button then repeat the previous step as needed. Make sure to change the “all” button above your tags to “any.” Compare your options with my example below.
Yes, you can buy them and use them for purchases on the Japan iTunes Store. I’ve been buying mine from JBOX since last year. Someone on the AN forum suggested JBOX after I told them I was dying to get a song on iTunes but was presented with “This Apple ID is only valid for purchases in the US iTunes Store” notice. The iTunes page on JBOX will show you how to set up your account to redeem an iTunes card.
I recommend purchasing the ￥3,000 yen card since it costs about 8 dollars less than buying two ￥1,500 yen cards. JBOX also gives you the option of having your card’s redemption code e-mailed to you–a real time saver. These cards aren’t cheap so I recommend searching for your music through U.S. iTunes or Amazon first. I’ve found some great deals on Amazon. I buy used CDs from Amazon all the time.
Many times I have chosen the wrong CD title when given the option to choose one. There have also been times when I have accidentally rewritten and lost a track’s title by clicking on it. If iTunes retrieved more than one possible title for your CD and you chose the wrong one or iTunes retrieved your CD information but you manually entered your own, you can reset it. From the toolbar select Advanced then choose Get Track Names.
Note: Requires MS Excel and Dreamweaver
- 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. 🙂