I could have been playing but instead I did this....
-
@Dolenz_PSN said in I could have been playing but instead I did this....:
and see if I could build an app.
Let me know when this goes GA. I will pay an annual subscription
Great work!
-
Very, very nicely done! SDS should be a little embarrassed that one guy and ChatGPT created functionality that their app should have had years ago. Reminds me of this:
“Tony Stark was able to build this in a cave! With a box of scraps!”
-
@MarioMendoza935_XBL said in I could have been playing but instead I did this....:
@Dolenz_PSN said in I could have been playing but instead I did this....:
and see if I could build an app.
Let me know when this goes GA. I will pay an annual subscription
Great work!
I did this with the free version. I downloaded the files but I apparently have to install something and then input my Gemini API key, which I did not bother with because I don't think I have one, in order for it to work that way.
Just as an FYI, I had previously used it to build an easy web based idle/clicker (mostly idle) game.
@SchnauzerFace_MLBTS said in I could have been playing but instead I did this....:
Very, very nicely done! SDS should be a little embarrassed that one guy and ChatGPT created functionality that their app should have had years ago. Reminds me of this:
“Tony Stark was able to build this in a cave! With a box of scraps!”
It was actually Google's AI Studio. While I use ChatGPT a lot and it was how I used to get my counts and my chart it was not used for this project.
What may not be evident on the screenshots is that the results of the search/filter are all sortable by clicking on the headers.
-
@Dolenz_PSN said in I could have been playing but instead I did this....:
What may not be evident on the screenshots is that the results of the search/filter are all sortable by clicking on the headers.
I did something similar, but using Excel... because Excel is the best thing ever...
I started with a cool video from @Blind_Bleeder_PSN , located here: https://www.youtube.com/watch?v=GEniyAm5ZGw Long story short, he's using the MLB the Show "API" to pull data. I did the same thing, but just using Excel/Power Query. Here's a sample of the Market data (located here: https://mlb25.theshow.com/community_market ). I mainly use this to track the LS collection prices. Keep in mind - this is only for cards on the Market, not "free" cards. All you have to do is click "refresh" and you'll have the latest data. Then you can filter/pivot table to your heart's content.
-
@MarioMendoza935_XBL said in I could have been playing but instead I did this....:
@Dolenz_PSN said in I could have been playing but instead I did this....:
What may not be evident on the screenshots is that the results of the search/filter are all sortable by clicking on the headers.
I did something similar, but using Excel... because Excel is the best thing ever...
I started with a cool video from @Blind_Bleeder_PSN , located here: https://www.youtube.com/watch?v=GEniyAm5ZGw Long story short, he's using the MLB the Show "API" to pull data. I did the same thing, but just using Excel/Power Query. Here's a sample of the Market data (located here: https://mlb25.theshow.com/community_market ). I mainly use this to track the LS collection prices. Keep in mind - this is only for cards on the Market, not "free" cards. All you have to do is click "refresh" and you'll have the latest data.
That's great. I don't deal with the market much or do major collections so I don't really care much about that. The only thing is that I have to wait until whoever it is maintains that spreadsheet updates it. The only field I wish was in the spreadsheet I am pulling data from had is the release date of the card like this
https://www.showdd.io/25/updates/6-27-25
That way I could do an easy search for the number of cards certain teams received between two dates
The other thing I like is the search searches all fields so if I type in May it returns Willie Mays, Marcelo Mayer, Coby Mayo and all of the May spotlight cards
For those who may not know this was created simply by telling the program what I wanted it to do in plain English. There is over 1,000 lines of code driving this and I did not write a single one.
-
@Dolenz_PSN said in I could have been playing but instead I did this....:
There is over 1,000 lines of code driving this and I did not write a single one
I, for one, welcome our robot overlords.
-
@MarioMendoza935_XBL Did you know there is an Excel World Championship?
-
@GixxerRyder750_PSN said in I could have been playing but instead I did this....:
@MarioMendoza935_XBL Did you know there is an Excel World Championship?
Sadly (according to my wife), yes, I know this exists...
-
Okay, I have been playing more with google ai studio to create a program using the API data instead of using a manually updated spreadsheet. Here is what I have so far. I may look into expanding it more and maybe implement some more reports if I come up with them.
There were definitely some false starts and bugs along the way.
Here is the main Screen
-
The ability to manually fetch data from the servers and then the ability to export and import that data so I don't need to pull the data every time
-
Imported player count
-
Reports - I currently have two implemented. My flashbacks and legends per team count and a list and count of a specific teams card series
-
Search and filters
-
A details link that displays more info on the card including the art, location and secondary positions.
-
-
@Dolenz_PSN said in I could have been playing but instead I did this....:
NOTE TO SDS - I am not scraping any data from your servers. This comes from a google sheet that someone maintains manually.
Yes, this is what I did tonight instead of playing the game.
So tonight I sat down and decided to play in Google AI studio and see if I could build an app. As you know I do card counts every so often and wondered if I could streamline the task as it was a little cumbersome before.
So I had AI help me build an app. It is a little slow loading initially but once it does it is very fast. Some of the things it can do
-
Fast searches and filters. Here is one I don't think you can do on the website. Show Me all Cardinals that have 3B as a secondary
-
Forgot who the June Spotlight players were?
-
Quick way to get my card count? Just click Team Counts
-
Want to see what a teams cards series breakdown is?
I might try and add more functionality later because this was a strangely satisfying little project.
When SDS decides to have a program with certain cards u would think it would include a filter in game but guess makes too much sense
-
