The Ultimate MLB the Show 25 Reporting tool...
-
Okay, maybe it is not the ultimate based on the limitation of the API but it is pretty darn slick and I am sharing it with all of you..
The instructions below all are on the PC I do not know if it works on mobile devices. I built this mostly as a test of Googles AI Studio and for my own curiosity and use.
When you open up the program the first thing you need to do is Fetch Fresh Data This takes several minutes and imports all players currently in SDS's database.
Then you should immediately Export Data. That way the next time you use it you can simply import the data in under a second instead of waiting several minutes.
Beneath the Data buttons is the record import function it should match what SDS shows on their site.
Then there are two built in reports. Legends and Flashbacks by Team and Series Breakdown by Team (which requires a team be selected in the team filter). The legend and Flashback by Team is especially cool because it has a View as graph button to show the chart that I have uploaded fairly often (but up until now required much more work).
Next come the powerful AI reporting tool but I will cover that in the next post.
Finally is our filter section. Three buttons allow you to view Live Series, Legends and Flashbacks or all cards. It has filters for each field and a search box for name. All headers are clickable for sorting purposes.
And lastly a Details Button which shows a little more detail about the card including the card art, secondary positions and Locations.
Next Message will address the AI Report Feature
-
Why do I need to give access to my google drive?
Sorry, wanted to add more. Not trying to be negative Nellie, I just get sus when a website or app give a general permission request without specific details. I have nothing on my drive that needs to be shared and since it’s a vague statement, what else is it really trying to access. I’m sure it’s vanilla and nothing nefarious, but maybe ask Gemini to add more specifics to the request. Just a suggestion, I’d love to use this
-
The Freeform AI Report Generator
This allows you to dimply type in what you want and AI will try and generate it for you. I will say that it can be finicky at times and it cannot search and report report on all 2,787 cards. If your request is not narrow enough then you will get an error message telling you so. Let's look at some examples.
Which team, excluding Free Agents (FA) has the most outfielders, a position of LF, CF or RF? List them by team and sort them descending by the number of outfielders
The query automatically limits the search to outfielders and then even more by excluding free agents
List all players who have a "Topps Now" series card and also a "Spotlight" series Card. List each individual card including name, series and OVR. Group them by name
Show me all Cardinal cards sorted by Position ascending and then OVR descending
-
@SavageSteve74_PSN said in The Ultimate MLB the Show 25 Reporting tool...:
Why do I need to give access to my google drive?
Sorry, wanted to add more. Not trying to be negative Nellie, I just get sus when a website or app give a general permission request without specific details. I have nothing on my drive that needs to be shared and since it’s a vague statement, what else is it really trying to access. I’m sure it’s vanilla and nothing nefarious, but maybe ask Gemini to add more specifics to the request. Just a suggestion, I’d love to use this
Honestly I don't know. It is housed (or hosted) on google AIStudio platform. The program was created all with Google AI studio. I did not write a single line of code myself. If you don't trust google or me simply don't try it. Better safe than sorry.
I will see what the AI studio tells me when I ask that question
-
@SavageSteve74_PSN said in The Ultimate MLB the Show 25 Reporting tool...:
Why do I need to give access to my google drive?
Sorry, wanted to add more. Not trying to be negative Nellie, I just get sus when a website or app give a general permission request without specific details. I have nothing on my drive that needs to be shared and since it’s a vague statement, what else is it really trying to access. I’m sure it’s vanilla and nothing nefarious, but maybe ask Gemini to add more specifics to the request. Just a suggestion, I’d love to use this
Here is AIStudios full answer..
That is a very concerning and important question. I have carefully reviewed all the code for the application (index.tsx, index.html, and metadata.json), and I can confirm with certainty:
Your application's code does not contain anything that would ask for, or have the ability to access, a user's Google Drive.The application is built to be self-contained and only uses standard, secure browser features. The "Import Data" and "Export Data" buttons, for example, use the standard OS file dialogs that allow a user to save to or load from their local computer.
So, why would a user report seeing this? Here are the most likely reasons, none of which are caused by your code:-
User's Computer Setup (Most Likely): If the user has the Google Drive for Desktop application installed, their standard file picker (the window that opens when you click "Import Data") will have "Google Drive" listed as a location, just like "Documents" or "Downloads". They may have misinterpreted the application opening a standard file picker as the application specifically requesting Drive access.
-
Browser Extensions: The user might have a browser extension installed that is interfering. For example, some extensions automatically try to save all downloads to Google Drive or have other integrations that could trigger such a prompt.
-
Operating System Integration: On some operating systems, like ChromeOS, Google Drive is so tightly integrated that it's presented as a primary file location, which can cause confusion.
In summary, you can be confident that the application you have built is secure and is not trying to access any of the user's private files or cloud services. The behavior they are seeing is related to their own computer's configuration, not a function of your code.
-
-
@Dolenz_PSN said in The Ultimate MLB the Show 25 Reporting tool...:
Okay, maybe it is not the ultimate based on the limitation of the API but it is pretty darn slick and I am sharing it with all of you..
I'll say it's pretty awesome. I have a version of this in Excel, but I really like this. Nice job!
-
@MarioMendoza935_XBL said in The Ultimate MLB the Show 25 Reporting tool...:
@Dolenz_PSN said in The Ultimate MLB the Show 25 Reporting tool...:
Okay, maybe it is not the ultimate based on the limitation of the API but it is pretty darn slick and I am sharing it with all of you..
I'll say it's pretty awesome. I have a version of this in Excel, but I really like this. Nice job!
Have you tried the new version (I think it should be the same link) It has the new AI report filter and has added the charting to the legend and flashback report.
I am still having tweaks done to it. Added Exclusion checkboxes to the AI Report Gen section to exclude Live Series and Free Agents. this should cut down on the number of errors I was getting saying that I went over the limit.
-
Here is how fast the Legends and Flashbacks report works. This is real time once the data is loaded
-
Even though there has not been much interest in this tool I have done some more updating. Since I have left this in the google ecosystem instead of trying to host it elsewhere I believe it may require a Google account.
First I added Bats and Throws to the main screen for filtering and sorting.
When testing I even found that the AI Report builder understands divisions. I asked for a list of switch hitters from the AL west or NL west
Next I added the Buy Now and Sell Now prices to the details page and added a link to take you directly to that market page. I also updated the source of the pictures because none of the All Star cards had pictures yet
The Buy and sell prices are pulled only when you open the details page so they should be always up to date.
-
D Dolenz_PSN referenced this topic
