Righteous Wrath Online Community

General => Game Chat => Archaic Games (non-electronic) => Topic started by: Melbosa on November 27, 2017, 02:04:13 PM

Title: Legendary - Damn Dividers
Post by: Melbosa on November 27, 2017, 02:04:13 PM
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:
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?
Title: Re: Legendary - Damn Dividers
Post by: Melbosa on November 27, 2017, 02:07:32 PM
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.
Title: Re: Legendary - Damn Dividers
Post by: Melbosa on November 27, 2017, 02:10:05 PM
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.
Title: Re: Legendary - Damn Dividers
Post by: 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.
Title: Re: Legendary - Damn Dividers
Post by: Melbosa on November 27, 2017, 03:13:34 PM
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.
Title: Re: Legendary - Damn Dividers
Post by: Mr. Analog on November 27, 2017, 03:22:24 PM
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)
Title: Re: Legendary - Damn Dividers
Post by: 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?
Title: Re: Legendary - Damn Dividers
Post by: Mr. Analog on November 27, 2017, 03:49:28 PM
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
Title: Re: Legendary - Damn Dividers
Post by: Melbosa on November 27, 2017, 04:08:12 PM
Awesome info, if I end up doing it myself.  But yeah I was seeing if anyone wanted to put something together for me...
Title: Re: Legendary - Damn Dividers
Post by: 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?
Title: Re: Legendary - Damn Dividers
Post by: 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.
Title: Re: Legendary - Damn Dividers
Post by: Mr. Analog on November 27, 2017, 05:20:49 PM
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
Title: Re: Legendary - Damn Dividers
Post by: Melbosa on December 01, 2017, 03:13:34 PM
Hmmm well guess I'm on my own with this one... time to relearn some coding stuffs :D
Title: Re: Legendary - Damn Dividers
Post by: 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.
Title: Re: Legendary - Damn Dividers
Post by: Melbosa on December 01, 2017, 04:13:04 PM
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
Title: Re: Legendary - Damn Dividers
Post by: Melbosa on December 01, 2017, 04:15:28 PM
Subreddit for the game: https://www.reddit.com/r/legendarymarvel/
Title: Re: Legendary - Damn Dividers
Post by: Lazybones on December 01, 2017, 04:18:10 PM
Maybe this then?

https://www.reddit.com/r/legendarymarvel/comments/65zssv/image_database/

https://www.reddit.com/r/legendarymarvel/comments/4v2fs3/list_of_herosvillainsmasterminds/
Title: Re: Legendary - Damn Dividers
Post by: Melbosa on December 01, 2017, 04:21:50 PM
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).