Jump to content

Avatar

RB3 Cache Exporter - Make song booklets in seconds! Now in C3 CON Tools!


  • Please log in to reply
67 replies to this topic

#1 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted September 16, 2013 - 10:07 PM

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!

#2 TrojanNemo

TrojanNemo

    The Programmer

  • 4,689 posts
  • Location
    Miami, Florida

Posted September 16, 2013 - 10:39 PM

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

#3 columbo777

columbo777

    The Pro Wannabe

  • 353 posts

Posted September 16, 2013 - 11:09 PM

This, my friend, is very cool.

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

Find all the known Guitar PRO upgrades on the RB PRO upgrades tracker google-sheet:

https://docs.google....SV_o/edit#gid=0

 


#4 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted September 16, 2013 - 11:36 PM

The song cache does not contain scores, unfortunately. :( 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).

#5 troipoison

troipoison
  • 168 posts
  • Location
    Vileville

Posted September 17, 2013 - 02:11 PM

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!!!

#6 espher

espher

    Harmonies Hacker

  • Administrator
  • 1,900 posts
  • Location
    Canada

Posted September 17, 2013 - 02:26 PM

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


ftfy.

C3 Author/Admin, Project Lead for the Rock Band: Harmonies Project


#7 solamen2

solamen2
  • 7 posts

Posted September 19, 2013 - 05:13 AM

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.

#8 TrojanNemo

TrojanNemo

    The Programmer

  • 4,689 posts
  • Location
    Miami, Florida

Posted September 19, 2013 - 05:34 AM

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.

#9 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted September 19, 2013 - 03:26 PM

As Nemo pointed out, the "Source" field already does exactly what you ask for. :) 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. :)

#10 TrojanNemo

TrojanNemo

    The Programmer

  • 4,689 posts
  • Location
    Miami, Florida

Posted September 19, 2013 - 03:31 PM

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. :)


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.

#11 solamen2

solamen2
  • 7 posts

Posted September 19, 2013 - 08:34 PM

As Nemo pointed out, the "Source" field already does exactly what you ask for. :) 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. :) 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. :)

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.

#12 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted September 19, 2013 - 08:49 PM

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

#13 solamen2

solamen2
  • 7 posts

Posted September 20, 2013 - 02:56 AM

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.

#14 questionmark

questionmark
  • 548 posts

Posted September 20, 2013 - 05:39 AM

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.

#15 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted September 20, 2013 - 03:51 PM

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.

#16 Jerry1gman

Jerry1gman
  • 95 posts

Posted September 20, 2013 - 08:16 PM

Thanks for the sort by Pro tunings!
If there was only a way to remove over half of the on-disc songs from the in-game list.

#17 RavenShadow

RavenShadow
  • 23 posts
  • Location
    France

Posted September 21, 2013 - 04:53 PM

Great tool ! Thank you very much.
I was using DLC Quickplay to get all the information before I get customs songs. But now, with all the customs, your tool is perfect.
Now, I just need to tweak my little libreoffice base to edit my pdf booklet (or wait for your pdf gerenation ;) )

#18 Sid Kafizz

Sid Kafizz
  • 264 posts

Posted September 21, 2013 - 05:10 PM

I'm trying to extract my song cache from the CON file with LeFluffie, but I'm not bright enough to figure it out. How is this done? LeFluffie seems to have no utility for anything like what it needs to do. I tried the DTA Extractor, but that gave me nothing when I pointed it at my songcache.

#19 clintilona

clintilona
  • 593 posts
  • Location
    Michigan

Posted September 21, 2013 - 05:14 PM

I'm trying to extract my song cache from the CON file with LeFluffie, but I'm not bright enough to figure it out. How is this done? LeFluffie seems to have no utility for anything like what it needs to do. I tried the DTA Extractor, but that gave me nothing when I pointed it at my songcache.


I was having the same issue. Go download the latest Le Fluffie update and the Song Explorer button will extract the songcache file.
**Rock Band needs more Power Metal**

#20 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted September 21, 2013 - 06:10 PM

Yep! I got Nemo to re-add song cache support just for this tool. :) Thanks, Nemo!




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users