[pksage]

A much sexier version of this functionality is now available in C3 CON Tools (Setlist Manager).

 

I’ve been working on this tool for the last week or so, and I’m happy to announce its initial release! Check it out:

 

RB3 Song Cache Exporter Web Tool

 

This tool reads your song library from the cache maintained by Rock Band 3, producing the data needed for a karaoke-style song booklet almost instantly. The link above explains the process, but it’s not very hard. No extensive nerd knowledge is required.

 

Please check it out! I’m very proud of this tool, and I look forward to fielding your questions, comments, and feature requests. Here’s hoping this will usher in a new era of freakin’ sweet Rock Band song booklets!

[TrojanNemo]

I’ve said it before but it bears repeating. Awesome work. Truly, genius.

[columbo777]

This, my friend, is very cool.

 

v2 request: be able to write it back! (that way we could save our scores and the like)

[pksage]

The song cache does not contain scores, unfortunately. ” src=”/wp-content/uploads/invision_emoticons/default_SA_frown.gif”> Our best guess is that scores are kept in the save game file, which may or may not be encrypted, and RB3 wipes them whenever it rebuilds the cache from scratch (which doesn’t happen over the course of regular, non-haxxor gameplay).

[troipoison]

I used to print off the list of all available songs, then run a highlighter across the songs I had. It wasn’t very effective and took longer to sift through than just browsing through the xbox.

What I’m getting at is; this kicks ass!!!

[espher]

I’ve said it once before but it bears repeating. Ahhh ah-ah-ah-ahhh ah. Ahhh ah-ah-ah-ahhh ah.

 

ftfy.

[solamen2]

This is incredible and much better than what I asked for. Thank you! I’ll be using it next time I update my playlist and will be happy to give feedback then. I’m particularly looking forward to all my dates being actual years; I crawled Wikipedia for the current info in it, and many of those entries only list decades.

 

There’s two features of my spreadsheet that aren’t in here, though, that I thought I could mention. One would probably be relatively easy to implement, but the other one would probably be pretty hard.

 

The first feature is that I mark out specially which songs are “As Made Famous By” in italics. This could be duplicated by marking those songs in a separate field somehow. Would be cool if this could be included.

 

The second feature is that I have a field for the source for each song — which Rock Band disc (if there’s a disc), or if it’s an official DLC or custom (if there isn’t a disc). I doubt there’s any reasonable way to add this, but I find this field useful if there’s any way you can add something like it. If you can’t I can always do a little spreadsheet magic by merging your spreadsheet with my current one for each release, so I won’t lose this info even if you can’t.

 

EDIT: Oh, one more thing I forgot — does this tool move “The” and “A” to the end of band names? This helps my sorting out a lot (much like in regular karaoke songbooks), so it would be great if this could be a feature too.

[TrojanNemo]

The first feature is that I mark out specially which songs are “As Made Famous By” in italics. This could be duplicated by marking those songs in a separate field somehow. Would be cool if this could be included.

Each song contains a ‘master’ ‘0’ or ‘1’ field that pksage could easily pick up for this. As to the italics, well I don’t know if he can do it but you sure can on Excel once you get the file.

 

The second feature is that I have a field for the source for each song — which Rock Band disc (if there’s a disc), or if it’s an official DLC or custom (if there isn’t a disc). I doubt there’s any reasonable way to add this, but I find this field useful if there’s any way you can add something like it.

Isn’t that what the “source” check box is for? When I tested the tool it was telling me “rbn2” “rb1” “custom” and so on.

[pksage]

As Nemo pointed out, the “Source” field already does exactly what you ask for. ” src=”/wp-content/uploads/invision_emoticons/default_SA_smile.gif”> It’s not able to do sources WITHIN customs (i.e. a GH5 port vs. a GH6 port vs. a C3 custom), but it knows each disc, DLC, RBN1, and RBN2.

 

The first feature is that I mark out specially which songs are “As Made Famous By” in italics. This could be duplicated by marking those songs in a separate field somehow. Would be cool if this could be included.

I do this too! Rock Band Chronicle lists them as non-bolded tracks, for instance. I haven’t found the field that denotes master vs. cover in the hex for each song, but it’s in one of a few possible places, so I’ll find that and add it today. It won’t auto-italicize for you, but conditional formatting in Excel can do that very easily.

 

EDIT: Oh, one more thing I forgot — does this tool move “The” and “A” to the end of band names? This helps my sorting out a lot (much like in regular karaoke songbooks), so it would be great if this could be a feature too.

It doesn’t right now, no. That’s another thing you could make Excel do, but it would be a bit more trouble than conditional formatting, so I’ll add an option to change it. I hesitate to do it for “A”, though. If I’m looking through a song booklet, I’d expect “A Day to Remember” or “A Flock of Seagulls” to be in “A” and not “D” or “F”. But hey, that’s the joy of making it a toggle. ” src=”/wp-content/uploads/invision_emoticons/default_SA_smile.gif”>

[TrojanNemo]

I hesitate to do it for “A”, though. If I’m looking through a song booklet, I’d expect “A Day to Remember” or “A Flock of Seagulls” to be in “A” and not “D” or “F”. But hey, that’s the joy of making it a toggle. ” src=”/wp-content/uploads/invision_emoticons/default_SA_smile.gif” />

 

You would be incorrect. The game sorts artists with “The” and “A” starting names by the following word. “A Day to Remember” is listed following “David Guetta” and “A Flock of Seagulls” follows “Flobots”…at least with the songs I have on my setlist.

[solamen2]

As Nemo pointed out, the “Source” field already does exactly what you ask for. ” src=”/wp-content/uploads/invision_emoticons/default_SA_smile.gif” /> It’s not able to do sources WITHIN customs (i.e. a GH5 port vs. a GH6 port vs. a C3 custom), but it knows each disc, DLC, RBN1, and RBN2.

 

Oh, I didn’t realize that was a disc source and not a pack source. Awesome! Yeah, that’s exactly what I wanted.

 

I do this too! Rock Band Chronicle lists them as non-bolded tracks, for instance. I haven’t found the field that denotes master vs. cover in the hex for each song, but it’s in one of a few possible places, so I’ll find that and add it today. It won’t auto-italicize for you, but conditional formatting in Excel can do that very easily.

 

Oh yeah, definitely wasn’t expecting any auto-formatting, just would be nice to have the info somewhere so that I could do whatever formatting myself. I’m a programmer too so a little Excel doesn’t scare me. ” src=”/wp-content/uploads/invision_emoticons/default_SA_smile.gif” /> But glad to hear that you’ll probably be able to add that field.

 

It doesn’t right now, no. That’s another thing you could make Excel do, but it would be a bit more trouble than conditional formatting, so I’ll add an option to change it. I hesitate to do it for “A”, though. If I’m looking through a song booklet, I’d expect “A Day to Remember” or “A Flock of Seagulls” to be in “A” and not “D” or “F”. But hey, that’s the joy of making it a toggle. ” src=”/wp-content/uploads/invision_emoticons/default_SA_smile.gif” />

Yeah, this is something I can do in Excel too, but I figured other people might want that functionality, and the less I’m doing post-export the better.

[pksage]

The tool now includes a “Master?” column to distinguish between master tracks and covers, and an option to put “, The” and “, A” at the end of the artist instead of the start. Enjoy!

 

http://pksage.com/ccc/cache2csv.php

[solamen2]

The tool now includes a “Master?” column to distinguish between master tracks and covers, and an option to put “, The” and “, A” at the end of the artist instead of the start. Enjoy!

 

http://pksage.com/ccc/cache2csv.php

Great! Thanks for adding this. It’s wonderful to see devs that are so responsive to feedback.

[questionmark]

This is an awesome tool. Thanks so much for creating it. I’m hoping to make my own personal excel sheet, and am stoked that I won’t have to type it out manually.

 

Hey, I saw that you (pksage) posted about this in the SA forums, eliciting suggestions for categories. I was wondering, would it be possible to have people create their own custom categories? Or am I betraying my lack of knowledge with how complicated that would be?

 

If customs fields/tagging is out, here are a couple suggestions for categories that I think would be useful:

 

Male or Female vocals

Instrumentals

Songs with Sparse parts — ie, a way to remember which songs hardly have any notes for a given part (especially keyboard)

 

If any of that is out of reach, no worries. I will enjoy the songlist creator regardless.

[pksage]

Hey, I saw that you (pksage) posted about this in the SA forums, eliciting suggestions for categories. I was wondering, would it be possible to have people create their own custom categories? Or am I betraying my lack of knowledge with how complicated that would be?

I’ve been thinking about how to do this. Making something that tracks individual tags online would be a lot of work, but….I dunno. Let me think about it some more. I’d like to come up with a permanent solution and not a band-aid, so I might just need to buckle down and do the work.

[Author]

Posts