RB3 Cache Exporter – Make song booklets in seconds! Now in C3 CON Tools!
- This topic has 71 replies, 2 voices, and was last updated 2 years, 11 months ago by
.
-
Posts
-
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).
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.
” src=”/wp-content/uploads/invision_emoticons/default_SA_frown.gif” />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…
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.
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.
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.
The booklet maker works great. Thanks for this awesome tool that doesn’t require manually entering all my songs!
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.
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…
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.
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.
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
” src=”/wp-content/uploads/invision_emoticons/default_SA_biggrin.gif” /> And huge thanks to pksage for figuring it all out, and for being cool and not getting all offended that I stole his idea
- You must be logged in to reply to this topic.