[solamen2]

Just wanted to say I tried this out today and it worked great. Now I have correct years for my songs, hooray. ” src=”/wp-content/uploads/invision_emoticons/default_SA_smile.gif” /> And some other useful new info too. Thanks again for this pksage! Just wish I’d had this BEFORE I typed in all those songs, heh.

 

For the record, the XLS does not import into Google Docs, only the CSV file. Not a big deal since the CSV works, but I figured you might be interested to know.

[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.

[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.

[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.

[solamen2]

Is there any way you could add copy (that is, copy-and-paste copy) to the database rows? I use the data from this database to update my own Google Docs spreadsheet that has all the available songs for my Rock Band 3, and the only way I could get the data out was to use your old database. It doesn’t have all the info the new database has, though, and this way may not work forever, so it would be nice if this functionality could be added somehow to the new database too.

[solamen2]

Awesome! Thanks for taking the time to figure this out. I’ll just download the fixed files whenever you get around to uploading them, no rush.

 

This is a seriously great project, by the way. Can’t thank you all enough for the hard work you do. Hope you keep putting out customs and harmonies and whatever else for a good long time! ” src=”/wp-content/uploads/invision_emoticons/default_SA_smile.gif” />

[Author]

Posts