Legendary - Damn Dividers

Started by Melbosa, November 27, 2017, 02:04:13 PM

Previous topic - Next topic

Melbosa

So I think most of you know that I have a huge collection when it comes to Legendary (Upper Deck) Board Games.... and because it is getting so large, setup times are getting longer and longer as I have to manually look at the card groups to figure out which ones to play with.

Well I started down a rabbit whole at one point of making my own labels, but fell behind and now face the problem again of manually creating them by typing them out and pasting in images...

Well this is where I thought I would see if I could leverage a tiny side project for you fancy devs out there.

Here is what I have:

  • A data set that contains (Set#1): Hero's Name, Faction, 5 Common Cards of one kind, 5 Common Cards of another kind, 3 Rare Cards, 1 Epic card - showing Powers of some type (See Attached PDF)
  • A data set of images representing (Set#2): Faction, Ranged Powers, Strength Powers, Intellect Powers, Covert Powers, Technology Powers, or a combination of any of the Powers - I have the Vectored Images for all of these
With these data sets I want to build either labels or divider cards that search the data from Set #1 and produce from Set #2 the final product (See attached Example).

Anyone want to help a bro out?
Sometimes I Think Before I Type... Sometimes!

Melbosa

I know that BGG has lots of people whom have done this, but what happens there is people loose interest and don't keep their collections updated as expansions come out so if I invest in someone's design there I run the chance that they won't have the one I want down the road.  If I could maintain my own listing of heroes, villans, etc and had a way to generate labels/dividers as I go this would never be a problem for me in the future.
Sometimes I Think Before I Type... Sometimes!

Melbosa

I should also mention: I've been looking for someone whom has done this already, either using Excel/Word or DB/Website for over a year, but my googling has been failing me :(.  So if you find something that is like what I am asking, by all means tell me so - can even make fun of me for not finding it - as I really just want to get to the finish line on this request :D.
Sometimes I Think Before I Type... Sometimes!

Lazybones

I love the collection attention to detail.

Looks like there might be several subreddits on Reddit that would be a good place to ask.

Melbosa

Quote from: Lazybones on November 27, 2017, 02:23:17 PM
I love the collection attention to detail.

Looks like there might be several subreddits on Reddit that would be a good place to ask.
If you ever have a chance to play the game they are very fun, and very replayable as no single game is the same, but with that comes a lot of setup requirements.
Sometimes I Think Before I Type... Sometimes!

Mr. Analog

Question: are there core game attributes and then expansion attributes that define each item?

You could define attributes as a tag cloud and then build canned context-based searches for specific things.

For example:

"Granny Smith" #Fruit #Apple #Green #Tart #Crispy
"Fuji" #Fruit #Apple #Red #Sweet #Japan
"Crab" #Fruit #Apple #Green #Small

Apple Search: Fruit+Apple (3 results)
Green Apple Search: Fruit+Apple+Green (2 results)
Japanese Fruit: Fruit+Japan (1 result)

This is a good way of organizing content if it evolves over time with evolving rules, etc, just make sure you put core information in at the beginning (in the above example which fruit is seedless might become important in the future)

This kind of contextual mapping is easy to implement and datamine either with a DB or with a flat file (like excel or csv)
By Grabthar's Hammer

Melbosa

Yeah I'm not really looking for a searchable thing.  I'm looking to use Data from Set#1 to pull data from Set#2 to make a Final result that can be used in a Label/Divider printout.  Does that make sense?
Sometimes I Think Before I Type... Sometimes!

Mr. Analog

Quote from: Melbosa on November 27, 2017, 03:27:14 PM
Yeah I'm not really looking for a searchable thing.  I'm looking to use Data from Set#1 to pull data from Set#2 to make a Final result that can be used in a Label/Divider printout.  Does that make sense?

Ah ok, you may be able to do it from Excel and create a report you can print as labels:
https://support.office.com/en-us/article/Merge-queries-Power-Query-fd157620-5470-4c0f-b132-7ca2616d17f9

If that's not an option you could create a basic program in C#, load your data from CSV into POCO object lists then use LINQ to merge them, take the resultant list and output that as HTML or some other markup you can print
By Grabthar's Hammer

Melbosa

Awesome info, if I end up doing it myself.  But yeah I was seeing if anyone wanted to put something together for me...
Sometimes I Think Before I Type... Sometimes!

Mr. Analog

Do you have the data in lists already?

And do you know what data you want to join on?
By Grabthar's Hammer

Melbosa

Quote from: Mr. Analog on November 27, 2017, 04:11:16 PM
Do you have the data in lists already?

And do you know what data you want to join on?
PDF in OP is the list in a table, and Set#1.  Data Sets explained in OP.  Set#2 is images, so need something that can either use Image Path or store images.
Sometimes I Think Before I Type... Sometimes!

Mr. Analog

Quote from: Melbosa on November 27, 2017, 04:16:34 PM
Quote from: Mr. Analog on November 27, 2017, 04:11:16 PM
Do you have the data in lists already?

And do you know what data you want to join on?
PDF in OP is the list in a table, and Set#1.  Data Sets explained in OP.  Set#2 is images, so need something that can either use Image Path or store images.

Oooh okay, I thought you already had your datasets and you just needed to do a logical merge on them or something
By Grabthar's Hammer

Melbosa

Hmmm well guess I'm on my own with this one... time to relearn some coding stuffs :D
Sometimes I Think Before I Type... Sometimes!

Lazybones


Melbosa

Quote from: Lazybones on December 01, 2017, 03:57:45 PM
https://www.reddit.com/r/LegendaryGoH/comments/5z1k4x/evolution_database/

This thread indicates there is a Google spreadsheet of data.
LOL Wrong game.  I didn't know there was another game with that many cards called Legendary.  I am talking about Legendary card games from Upper Deck: https://upperdeckstore.com/games-collectibles/legendary.html?limit=all

My bad... noticed that wasn't in the OP
Sometimes I Think Before I Type... Sometimes!

Melbosa

Sometimes I Think Before I Type... Sometimes!


Melbosa

I'm not looking for a character listing or db of characters/cards.  I have that.

As per my OP, I'm looking to have a label maker/divider maker developed because the ones that show up on BGG eventually go stale as people eventually loose interest on keeping theirs up-to-date so eventually the designs no longer are produced for new expansions.  If I could just keep the data up-to-date and generate the labels after I update the data, then this wouldn't be a problem moving forward.

Again I have the data for the cards, and the images for the labels, I just wanted a GUI to let me generate the Labels/Dividers, and if I'm lucky update the datasets when new expansions are released as well (otherwise I can always update the data outside the GUI).
Sometimes I Think Before I Type... Sometimes!