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

#41 GandWuser

GandWuser
  • 88 posts

Posted October 12, 2013 - 02:34 AM

BTW, looks like "Difficulty: Pro Drums" is not an available checkbox. Is that intentional or a mistake?
thx!

The pro drums difficulty is always the same as the regular drums difficulty.
Suckers!

#42 katkill

katkill
  • 66 posts

Posted November 12, 2013 - 07:01 PM

Thanks for putting this up. Makes it a whole lot easier to create a song list. It's hard to believe that I'm past 900 songs. This post needs to be pinned so it's not hard to find as time goes by.

#43 TrojanNemo

TrojanNemo

    The Programmer

  • 4,689 posts
  • Location
    Miami, Florida

Posted November 12, 2013 - 07:04 PM

done.

#44 Deadly Robots

Deadly Robots
  • 139 posts
  • Location
    Los Angeles

Posted November 30, 2013 - 12:55 PM

This is a fantastic tool. I don't suppose you have a projection for how far off PDF generation is, do you?
[PortsCenter] - A webseries about change. And video games.

#45 Deadly Robots

Deadly Robots
  • 139 posts
  • Location
    Los Angeles

Posted December 2, 2013 - 08:24 AM

I now have two questions.

Firstly, I've been keeping track of my customs using a manually-updated spreadsheet. By my count I have a total of 1,139 songs including on-disc, DLC, exports and customs. My cache export confirms this. However in-game it only shows 1,136 songs (and it says "Showing all 1,136 songs", as opposed to "Showing 1,136 of 1,139 songs"). So where are my four missing songs, and how do I figure out what they are? Edit: I'm going through my list manually and it looks like not only did I accidentally include DLC songs I didn't buy into my list, but I'd also included them in RBHP compiles, which is how they'd ended up in my cache. D'oh! I'm an idiot. Ignore this question.

And my next question, which is a little more on-topic for this thread: just how do you print off such a booklet from the generated spreadsheet using LibreOffice? I'm stumped. I've seen a lot of people talking about how easy it is, but no actual instructions on how to do it.
[PortsCenter] - A webseries about change. And video games.

#46 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted December 2, 2013 - 06:37 PM

PDF generation has been on the back burner for a while because the code is totally new to me, and because I'm (apparently) spoiled with Excel song booklets. I can't promise anything, but I AM working on some other stuff for this tool right now, so maybe I'll get energized and do PDFs too.

I'm not familiar with LibreOffice, unfortunately. First-party Excel has a Page Layout view option that lets you edit the workbook like a Word document, seeing the margins and page clipping and stuff like that. I just Googled a bit, and you might want this? Once you've got it looking how you want, just go find a laser printer and print it, ideally duplexed (double-sided).

#47 Deadly Robots

Deadly Robots
  • 139 posts
  • Location
    Los Angeles

Posted December 2, 2013 - 09:29 PM

Yeah, I don't think LibreOffice is robust enough to allow that kind of printing. I've been playing around with it but it's a no-go. Oh well.

What's I'd really like, I think, is a tool like this one, but instead of entering your DLCQuickplay or MyRockBandSongs.com username you upload your spreadsheet. Or maybe I just need to bite the bullet and purchase Microsoft Office. :(
[PortsCenter] - A webseries about change. And video games.

#48 MikeysRBLounge

MikeysRBLounge
  • 32 posts

Posted December 28, 2013 - 09:44 PM

T Davis' Karaoke page just pulls XML from ANY website link. the PKSage tool could create that page on the fly as an alternate option to the file download, OR somebody could create a small program to turn the xls into properly formatted XML. Unfortunately, if somebody made a separate program, it would also have to get that file published n the web somewhere that the Karaoke maker could see it...

#49 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted January 2, 2014 - 06:17 PM

I like this idea. I'll see what kind of XML format his tool expects from DLCQuickplay and save it on my server for a week (or whatever) to let you paste it like a DLCQP link. Shouldn't be too hard.

#50 Deadly Robots

Deadly Robots
  • 139 posts
  • Location
    Los Angeles

Posted January 4, 2014 - 02:50 AM

I bloody love you.
[PortsCenter] - A webseries about change. And video games.

#51 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted January 7, 2014 - 04:51 AM

I've finished this on my end, and reached out to TDavis to see if he can change the tool to accept my URLs. (Currently, if the URL isn't from myrockbandsongs, it will reject it.) You can generate XMLs right now, but they won't do anything, so hold off; I'll be deleting every uploaded cache after it's been up for a week anyway.

#52 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted January 8, 2014 - 03:17 PM

TDavis has gone above and beyond what I asked of him, and has not only added support for this tool, but has added a bunch of instructions and C3-specific branding to his booklet maker. Awesome!

http://www.tdavis.org/rockband/

I've given it a shot and it worked for my cache, but there may still be issues with special characters and other edge cases. If you experience any issues, post them here, and I'll fix it up. TDavis is also monitoring this thread for changes on the booklet maker side of things.

#53 beastman

beastman
  • 149 posts

Posted January 10, 2014 - 02:51 PM

The booklet maker works great. Thanks for this awesome tool that doesn't require manually entering all my songs!

#54 BoboFro

BoboFro
  • 27 posts

Posted January 10, 2014 - 07:22 PM

I used this for Wii and then used the pdf generator, worked great. Thanks!

#55 Deadly Robots

Deadly Robots
  • 139 posts
  • Location
    Los Angeles

Posted January 10, 2014 - 11:31 PM

Anyone else having a problem where the Cache Exporter doesn't include "Yoshimi Battles the Pink Robots, Pt. 1" in the export? It's an on-disc game and is, of course, appearing in game, but for some reason the exporter isn't including this song, and only this song, in its export, regardless of chosen export format.
[PortsCenter] - A webseries about change. And video games.

#56 Farottone

Farottone

    The Lean Mean Customs Charting Machine

  • Administrator
  • 5,840 posts

Posted January 11, 2014 - 12:57 AM

Anyone else having a problem where the Cache Exporter doesn't include "Yoshimi Battles the Pink Robots, Pt. 1" in the export? It's an on-disc game and is, of course, appearing in game, but for some reason the exporter isn't including this song, and only this song, in its export, regardless of chosen export format.


That comma, maybe...

#57 pksage

pksage

    Mostly-Benevolent Overlord

  • Administrator
  • 1,109 posts

Posted January 11, 2014 - 02:19 AM

I'll take a look, thanks for the report.

#58 grep

grep
  • 29 posts

Posted January 14, 2014 - 09:01 PM

Anyone else having a problem where the Cache Exporter doesn't include "Yoshimi Battles the Pink Robots, Pt. 1" in the export? It's an on-disc game and is, of course, appearing in game, but for some reason the exporter isn't including this song, and only this song, in its export, regardless of chosen export format.


It shows up in my xml->pdf.

#59 grep

grep
  • 29 posts

Posted January 14, 2014 - 09:19 PM

I'm looking over my pdf from tdavis and noticed the following minor nits:
  • Alice In Chains songs are broken up into three different groups, although the band name looks the same for each group. Man In The Box and Rooster in the first, Them Bones in the second, and Would? in the third.
  • Blue Öyster Cult band name listed as "Blue". It's probably the umlaut.
  • Mötley Crue listed as "M". It's definitely the umlaut, upper and lower case.
  • Motörhead listed as "Mot". More umlaut
  • "ock of Seagulls, A". That's pretty weird.

Nothing earth-shattering or show stopping in there. AiC and 'ock of Seagulls are the weird ones.

#60 TrojanNemo

TrojanNemo

    The Programmer

  • 4,689 posts
  • Location
    Miami, Florida

Posted January 17, 2014 - 06:46 AM

New Le Fluffie version is out which integrates the ability to read the song cache figured out by our own pksage and my crazy OCD, so now you can import, then modify in a million ways to make it perfect to your liking, then export to Excel or PDF right from Le Fluffie.
Enjoy :D

And huge thanks to pksage for figuring it all out, and for being cool and not getting all offended that I stole his idea :dance:




3 user(s) are reading this topic

0 members, 3 guests, 0 anonymous users