New as of 12-19-2009: You can now add Album Track, Vocal Gender, Vocal Tracks, and Song Length as options for columns and sorting.

New features have been added to the website to allow you to customize your print booklets, a much asked for feature!

You'll now be able to:

• Pick songs from All Songs Owned, RB1, RB2, DLC, Beatles, Lego + Family Friendly Songs, Not Purchased, Rated Songs, or your Wishlist
• Group items (ex: showing artist only once) together
• Order the songs by your choice (up to 3 sorting options)
• Pick the columns
• Order the columns
• Change the font size
• Change the color scheme (currently 1, but more will be added!)
• Save your booklets and name them for future use.

I'm adding the ability for this for all those who have donated at least $5.00 to help support the costs to run this website. If you're interested, please visit the donations page! The link will show up where the current print link is once you've been entered in as a donor.

Example Booklet 1
Example Booklet 2

Screenshot:


Note: Currently it isn't automated to mark you as a donor, so please be patient for the new page to be available. You should receive an email upon your donation being entered, if your settings allow for e-mails to be sent from this website. I'll be working to automate this process, but for the meantime thank you for understanding, and most importantly thank you for supporting myrockbandsongs.com!

Np, glad you enjoy it! Currently there isn't, but I'll definitely look into that as an additional feature. Thanks for the suggestion!

Thank you iwasjesus2! I've added yours, and I've also added an option which will email you're account once your donation is applied.

It is available right now, the option is added if you've donated to the website (read above for more details). It's my thanks for those who can contribute to keep this site up and running :)

Thanks for all your hard work!

My request may be a bit too heavy on the database to really apply, or it might be too much work, but I would like to ask it anyway: Is there any way we can create custom print booklets based on an individualized selection of songs you already have? While I'm a bit of a DLC fiend, I'd like to create a print booklet with a shortlist of songs my friends would actually play.

I'll totally understand if it doesn't go in effect, but thankful if it does!

Is it possible to make these into A5 booklets?

Easier to deal with (and an excuse to play with a duplex printer I just got :D)

I've not printed yet :) Just enquiring :)

Thanks for the fast response though :D

I've updated the print booklets so it now includes a Lego + Family Friendly songs booklet. This way you can print a specific booklet that can be played with the Lego disc. I've also added a new column called "Rating" which specifies if the song is Family Friend, or Supervision Recommended.

Thanks! That shouldn't be a problem to add the pack name to the list of available columns. I'll add it to my list to do :)

@ricecake I've also updated the "Print Newest" option, so if you select Beatles it will only pull in Beatles songs. All the rest of the options will pull from everything.

I just tested it, and when printing using the old style printing options, it is still showing the regular list, not the Beatles.

I was just testing it out.

I really like all the flexibility that the new print options provide, and have a couple booklets saved, ready to print for an upcoming RB get-together I'm going to in a couple weeks (I'll print them right before so that they are current, since I plan on getting some more DLC and the RB1 exports before then).

I did have some other suggestions, but then I saw that they were already implemented in the new print options :) (mainly wishlist and unpurchased songs printing). I already suggested adding the pack name as a column choice, and you said you would put it on your to-do list, so other than that, I can't think of anything else at the moment. Any other issues I come across, I will be sure to report. This site is awesome!

@ricecake I've added the ability to display the Pack Name and also sort by Pack.

@criese I do have this on my list of things to look into. I'd like to refine the design of the booklets and provide a drop down option for the "Display Style" of the booklet to accommodate this type of view, along with some others.

Thanks for the suggestion! :)

Here is more info on the above error, since I tried it with my owned songs and my wishlist and it worked fine. It seems to only be an issue for Not Purchased songs.

I selected to show "Not Purchased" songs, order by Pack, then Song, then Artist. Display Pack, Song, and Artist, in that order.

@ricecake this issue has been corrected... should work fine now printing not purchased songs. Sorry about that!

I just tried previewing new booklets, and my saved booklets are coming out all funky. My RB2 booklets give me the same error as the one I posted in the new thread. My Beatles lists are coming out with each song duplicated many times.

Thanks. My Beatles lists now look correct, but my Wishlist (http://myrockbandsongs.com/ricecake/print-booklet/226/) is now showing the duplicates. Also, my booklet sorted by Genre (http://myrockbandsongs.com/ricecake/print-booklet/202/) is incorrectly sorted: it is sorted by artist.

Thanks! Everything seems to be working beautifully now!

@DeeJay-Mat I like the idea! I'll add it to my list of things to look into. Do you know for sure, if those are the only 3 types of images needed? or are all the other disc imports just using the arrow for DLC?

Actually, the LEGO imports use the regular DLC icon. There is a big thread on the official forums of people debating whether or not it should be changed. Personally, I wish they had a separate icon/category in-game.

Therefore, I would prefer it to be like this:

RB1: (1)
RB2: (2)
LRB: (L) or (LEGO brick)
ACDC: (lightning bolt)

I don't think the other track packs/disc exports need a different icon from regular DLC since they may be purchased as regular DLC (or should be available soon for the track pack exclusives).

@ricecake Thanks for letting me know that! I don't own lego RB yet... so I wasn't sure how it looked from within RB2... but I guess regardless I can customize images and associate them to types. I'll basically just add another column for "Type (as an Image)" instead of RB1, RB2 etc... it will show the image.

Thanks, rob! It's nice you hear all the suggestions. As ricecake says, in RB2 songs from LEGO have an arrow icon, cause you download the songs instead of import them from the disc game, but in LEGO game they have a LEGO brick.

For me it's the same an "L" than a brick icon. And for Trackpacks or downloaded songs, I would try with the "DLC" word or the arrow icon.

Thanks! I really like how it turned out as well! :)

Unfortunately its impossible for me to tell when a page break is going to occur, because its always different depending what browser your using, margin settings, paper size... etc. There is to many variables out of my control to do something like that.

The only way I can think it may work, is if I can dynamically create PDFs which are created and then downloaded, which can then be printed. That way I believe I may have more control over it. Probably still not guaranteed... but its something I can look at later.

I've been wanting to making it simple for someone to download a booklet as a PDF if they can't figure out how to print it to a PDF on their own.

Hey just donated using my paypal which has a different email then the one i signed up with, it's the same username but its just a Hotmail account instead of the Gmail account I signed up with.

Glad I donated a few days ago. Thank you for this awesome site, it's saved me so much trouble.

@DeeJay-Mat Many... If you donate to the website you will be able to make booklets in the current way for the life of the website, which I except Rock Band to be around for a long time, and so will the website :)

I added some example print booklets on the first post... just so everyone can see what the output looks like. They are saved as .pdfs.

@LoopyChew Hmm...it shouldn't have to do with that, I've printed booklets like that, which I've rated songs but not displaying it. It may have to do with the amount of rated songs between everyone now, I'll have to take a look at the query that is pulling the songs to make sure I didn't leave something out. I'll post back when I fix the problem.

Looks like it is! I didn't expect it to be fixed that quickly, but am mighty glad it did! :-)

I fixed it so it sorts properly. Yeah a lot of the songs don't have the length, but hopefully through the new song report feature (click a song name them report changes) we can collect all this data.

I'll try to run a script against that file and add in which ones it can match up. Thanks!

Yea I meant to add that in as well. I've added vocal tracks now.

I'm kind of confused by your second request, are you just saying to display vocal tracks on the song listing page? http://myrockbandsongs.com/songs/

If so I don't have plans to do that just yet, since it really only applies to Rock Band Beatles as of right now.

actually it was ricecake that provided the file, but here Kawigi's website can also list song lengths so you can verify and cross-reference:

http://rockband.yajags.com/songinfo/?parameter0=length&comparator0=greaterthan&const0=0&orderby=songname&sortdirection=Ascending&action=Search

Regarding the file I posted, the "short_name" is the actual name of the .mid file used in-game for the note chart. If you view his webpage (for example, http://charts.ajanata.com/rb/guitar/index_expert.html is the expert guitar page), he lists the full song name. For the "Testify" example, you can see that "testify" is the Rage Against the Machine version, and "testify_srv" is the Stevie Ray Vaughn version.

Maybe if I'm bored over the holiday I might be able to whip up a file with the short name to full song name and artist mapping.

I'm working on the file now, I'm about a quarter of the way through. A few songs seem to be missing from the data file, but this should give you huge progress for entering the times. I have been copy-and-pasting the song names and artists from your page so they should match.

OK, I've finished it. You can find it here:

http://spreadsheets.google.com/ccc?key=0Apm-lkjZhgQ7dHMtSXhLRUV0WDVKelFGaU9DVnlMa2c&hl=en

Columns included are short_name (the name from the original file), name (the full name stored in your database), artist, length (in seconds), and length (in minutes:seconds). The minutes:seconds column always rounded partial seconds down (e.g. 232.958276 seconds is rounded to 3:52 and not up to 3:53), so I left the original value in seconds in case you wanted to do the conversion/rounding yourself.

Google Docs should let you download the file in a variety of formats.

Some notes:
It doesn't seem to have the most recent DLC, the Country Track Pack Exclusives, nor the Metal Track Pack Exclusives. Since this is the bulk of the songs, the remaining few shouldn't be hard to add manually once we get accurate values for them.

The following songs from Rock Band 1 have a "short" version that gets picked when playing solo vocals:
Foreplay/Long Time (5:50 vs. 8:14)
Green Grass and High Tides (5:08 vs. 9:49)
Train Kept A Rollin' (3:59 vs. 5:36)
Won't Get Fooled Again (7:33 vs. 8:46)
I included them in the file, but left the Name and Artist fields blank for those so they can easily be picked out if necessary.

The spreadsheet treats "666" by Anvil as a number field instead of a text field.

"(Don't Fear) The Reaper" is missing the parentheses in your database.

"Caprici Di Diablo", "Red Devil", and "Damnation Game" should have "Yngwie Malmsteen's Rising Force" as the artist instead of just "Yngwie Malmsteen". Also, http://www.rockband.com/music/songs says that the "di" in "Caprici di Diablo" shouldn't be capitalized.

"Aces High (live)", "Chest Fever (LIVE)", "Fear of the Dark (live)", "Hallowed Be Thy Name (live)", "Iron Maiden (live)", and "Wilson (live)" have inconsistent capitalization in the "live" part of their names.

I hope this helps! Keep up the great work on the site!

No problem, I really like this site and appreciate all the work you put into it, so I feel good about giving something back :)

I found the song lengths for the Beatles songs, but since there aren't as many of those, I'll just enter those by hand.

EDIT: The file didn't have all the Beatles songs, but it had a good chunk of them. I found it here if you want to double-check them:
http://rockband.scorehero.com/images/notecharts/contrib/ajanata/tbrb/

Thanks! I just applied your donation, so you should be able to log out and back in, then click the same print link as before, except it will go to the new page.

Adding the date you purchased the song as a column shouldn't be a problem. I'll add it to my list!

@haylo75 I've added "Date Purchased" as a column and also you can sort by it as well.

Np! Glad you like that feature, it is really nice... makes for a clean looking booklet.

Yea that is mainly because each "Date Purchased" has a time to it, so they could all be different, but added on the same day.. which is why they are not grouping. I'll keep that in mind though, and maybe just do the comparison against the date only, disregarding what time.

Another thought... creating a view that truncates the datetime column to a date and grouping by all the other columns in the table would provide an extensible solution.

Obviously I'm biased so I'm going to say its totally worth it ;)... but if you choose to donate and don't like the features... I have no problem in refunding you the money back, or looking at giving you the chance to try it out first. Most people think of it as a donation to help run the website as well as getting these extra features :)

Let me know if you have any questions... you can also contact me directly via the feedback page: http://www.myrockbandsongs.com/feedback/

I think a donation, whatever the size is money well spent. This is a great site ... did you have any idea what DLC you had or hadn't got before you came across this site - I bet I know the answer!
Rob works hard to accommodate all requests and suggestions and is constantly updating as a consequence - it's the most useful site I have ever used ...
Go ahead ... donate a few quid - this site is worth every penny!