Ensign
Gold Contributor
Gold Contributor
Very Rare (100 Points)
Subscribe to a monthly Gold Subscription
Unlocked Sun 24 Dec, 2023 11:04 AM
0.36% have received this achievement
Silver Contributor
Rare (50 Points)
Subscribe to a monthly Silver Subscription
Unlocked Sun 24 Dec, 2023 11:04 AM
0.43% have received this achievement
Deans List
Uncommon (25 Points)
Pass all three Academy exams
Unlocked Sun 24 Dec, 2023 6:01 PM
3.97% have received this achievement
Bronze Contributor
Uncommon (25 Points)
Subscribe to a monthly Bronze Subscription
Unlocked Sun 24 Dec, 2023 11:04 AM
0.60% have received this achievement
Ensign
Common (10 Points)
Receive a promotion to the rank of Ensign
Unlocked Sun 24 Dec, 2023 11:27 AM
3.58% have received this achievement
Starfleet's Finest
Common (10 Points)
Be a member of Starfleet Operations
Unlocked Sun 24 Dec, 2023 12:06 PM
28.02% have received this achievement
1
- Users who liked
- WelshAvenger
Quote
Post ID: 486897
#1
Posted Fri 29 Dec, 2023 7:29 PM
–
Last edited by Mephiztophelez; Fri 29 Dec, 2023 6:00 PM.
Hey. I'm in the process of building up a comprehensive baseline table for ALL consoles in STO. I've been playing STO for a long time but I don't have tons of knowledge. However, when this is complete I will be opening this up to the community, especially to those on here known to be experts in STO to fine tune and perfect it (I know it won't be perfect because of playstyle but it will be the next best thing and provide enough info that makes things easier for newer/less knowledgable captains).
Based on my own experience, I want to help educate myself and others so they can feel more confident and comfortable building their own ships. Not having certain consoles for a build and not having info on a good alternative (I know STO BETTER does a decent job of this on their builds but it's not always there (still a fantastic resource though)) is a pain in the neck. This resource will help to, hopefully, full a gap in the STO resources that I think we have.
As my knowledge here is well below the experts, I will be using ChatGPT 4 to build most of this out (I did say it would be a baseline, to a certain extent
).
I will be adding columns, such as, Console Name, Console Description, Console Type, Passive Ability, Active Ability, Baseline Active Ability Duration, Cooldown, Where To Get It, Recommended Build Types, Weapon Flavour (if boosts), Weapon Type (if boosts), Best Alternative, Ship Compatibility, Set Name, Bridge Officer Abilities Affected. The order of these won't be as above.
I've definitely forgotten some stuff here so if there's anything else that I should aim to add, please let me know.
Alternatively, if there's already something like this in the community, that I haven't found, then please point me in the right direction so I can have a look. I will also be using as much up to date information I can find to make it more accurate eventually. Fire me any resources you might have. Even if I know about it already, this will be a good space to contain it all for reference.
PS - I'm just building this out and putting it together. The hard work and the more important information will hopefully be added by a few of the community that have the best knowledge of everything, so please don't poop on it. Thanks
- - - Updated - - -
UPDATE: ChatGPT is no longer in the mix. I'll be doing this manually for a majority.
As useful as ChatGPT is, it has gotten so much wrong already. So, it will take longer than anticipated but will be worth the effort
Rear Admiral
Quartermaster
Commendation
Commendation (150 Points)
Awarded during the UFP Award Ceremony to those who go above and beyond for the community
Unlocked Sat 25 Mar, 2023 10:30 PM
0.24% have received this achievement
The Fool
Rare (50 Points)
Got pranked on April 1st
Unlocked Thu 01 Apr, 2021 2:04 PM
0.46% have received this achievement
Dedicated
Rare (50 Points)
Volunteer for 1+ year
Unlocked Sat 20 Feb, 2021 11:02 PM
0.55% have received this achievement
To Boldly Go On and On
Rare (50 Points)
Reach one-thousand posts on the forums
Unlocked Wed 02 Feb, 2022 3:03 AM
0.71% have received this achievement
Rear Admiral
Rare (50 Points)
Receive a promotion to the rank of Rear Admiral
Unlocked Sat 24 Sep, 2022 8:37 PM
0.47% have received this achievement
Aspiring Author
Uncommon (25 Points)
Participate in a Short Story Competition
Unlocked Tue 29 Dec, 2020 5:16 PM
0.12% have received this achievement
3
- Users who liked
- Mephiztophelez
- T'Tan
- Jestersmith
Quote
Post ID: 487021
#2
Posted Sun 31 Dec, 2023 2:12 AM
You might want to check out VGER before embarking on this one. It is a solution the community set up to mine stowiki.net to provide a visual library to every trait and all ground and space gear. The solution webscrapes the STO wiki, so it is as up to date as the wiki itself is and the players that maintain it usually keep it pretty well updated.
Link to VGER documentation on STObuilds.com
https://stobuilds.com/VGER/
VGER app direct link
https://vger.netlify.app/
Ensign
Gold Contributor
Gold Contributor
Very Rare (100 Points)
Subscribe to a monthly Gold Subscription
Unlocked Sun 24 Dec, 2023 11:04 AM
0.36% have received this achievement
Silver Contributor
Rare (50 Points)
Subscribe to a monthly Silver Subscription
Unlocked Sun 24 Dec, 2023 11:04 AM
0.43% have received this achievement
Deans List
Uncommon (25 Points)
Pass all three Academy exams
Unlocked Sun 24 Dec, 2023 6:01 PM
3.97% have received this achievement
Bronze Contributor
Uncommon (25 Points)
Subscribe to a monthly Bronze Subscription
Unlocked Sun 24 Dec, 2023 11:04 AM
0.60% have received this achievement
Ensign
Common (10 Points)
Receive a promotion to the rank of Ensign
Unlocked Sun 24 Dec, 2023 11:27 AM
3.58% have received this achievement
Starfleet's Finest
Common (10 Points)
Be a member of Starfleet Operations
Unlocked Sun 24 Dec, 2023 12:06 PM
28.02% have received this achievement
1
- Users who liked
- darthnovawave
Quote
Post ID: 487038
#3
Posted Sun 31 Dec, 2023 10:13 AM
You might want to check out VGER before embarking on this one. It is a solution the community set up to mine stowiki.net to provide a visual library to every trait and all ground and space gear. The solution webscrapes the STO wiki, so it is as up to date as the wiki itself is and the players that maintain it usually keep it pretty well updated.
Link to VGER documentation on STObuilds.com
https://stobuilds.com/VGER/
VGER app direct link
https://vger.netlify.app/
Thanks, Darth.
Didn't notice the consoles when I first came across this. I did a visual scan for Epic colours but didn't see it so I moved on.
Rear Admiral
Quartermaster
Commendation
Commendation (150 Points)
Awarded during the UFP Award Ceremony to those who go above and beyond for the community
Unlocked Sat 25 Mar, 2023 10:30 PM
0.24% have received this achievement
The Fool
Rare (50 Points)
Got pranked on April 1st
Unlocked Thu 01 Apr, 2021 2:04 PM
0.46% have received this achievement
Dedicated
Rare (50 Points)
Volunteer for 1+ year
Unlocked Sat 20 Feb, 2021 11:02 PM
0.55% have received this achievement
To Boldly Go On and On
Rare (50 Points)
Reach one-thousand posts on the forums
Unlocked Wed 02 Feb, 2022 3:03 AM
0.71% have received this achievement
Rear Admiral
Rare (50 Points)
Receive a promotion to the rank of Rear Admiral
Unlocked Sat 24 Sep, 2022 8:37 PM
0.47% have received this achievement
Aspiring Author
Uncommon (25 Points)
Participate in a Short Story Competition
Unlocked Tue 29 Dec, 2020 5:16 PM
0.12% have received this achievement
Posted Mon 01 Jan, 2024 5:31 AM
Thanks, Darth.
Didn't notice the consoles when I first came across this. I did a visual scan for Epic colours but didn't see it so I moved on.
Yeah, that kind of bugs me that they made common "white" icons for everything...even when the item in question doesn't actually exist in that state. The APIs used for the VGER tool are open source and on available from the first link. Haven't tried it myself, but I think it should be possible to run their main API to call the Wiki data, then use a JSON parser to read the API output, filter it to just consoles (assuming there is a common "console" tagging of some sort in there), and dump it to a spreadsheet instead of the VGER website.
Ensign
Gold Contributor
Gold Contributor
Very Rare (100 Points)
Subscribe to a monthly Gold Subscription
Unlocked Sun 24 Dec, 2023 11:04 AM
0.36% have received this achievement
Silver Contributor
Rare (50 Points)
Subscribe to a monthly Silver Subscription
Unlocked Sun 24 Dec, 2023 11:04 AM
0.43% have received this achievement
Deans List
Uncommon (25 Points)
Pass all three Academy exams
Unlocked Sun 24 Dec, 2023 6:01 PM
3.97% have received this achievement
Bronze Contributor
Uncommon (25 Points)
Subscribe to a monthly Bronze Subscription
Unlocked Sun 24 Dec, 2023 11:04 AM
0.60% have received this achievement
Ensign
Common (10 Points)
Receive a promotion to the rank of Ensign
Unlocked Sun 24 Dec, 2023 11:27 AM
3.58% have received this achievement
Starfleet's Finest
Common (10 Points)
Be a member of Starfleet Operations
Unlocked Sun 24 Dec, 2023 12:06 PM
28.02% have received this achievement
1
- Users who liked
- darthnovawave
Quote
Post ID: 487111
#5
Posted Mon 01 Jan, 2024 9:54 AM
–
Last edited by Mephiztophelez; Mon 01 Jan, 2024 11:16 AM.
Yeah, that kind of bugs me that they made common "white" icons for everything...even when the item in question doesn't actually exist in that state. The APIs used for the VGER tool are open source and on available from the first link. Haven't tried it myself, but I think it should be possible to run their main API to call the Wiki data, then use a JSON parser to read the API output, filter it to just consoles (assuming there is a common "console" tagging of some sort in there), and dump it to a spreadsheet instead of the VGER website.
Yup, it all looks so out of place without the rarity colours there
. I actually did this yesterday. I was able to pull the Startship Traits into the Type column (along with all the other columns like name, description, etc) but that was all the 'Type' that I got. Will be fixing it today and hopefully having the foundation in place for the next stage. Here's hoping
UPDATE: Success!!! The issue was in the amount of columns each different component had (Traits vs Space Equipment). I have the raw data in an excel file. Operation Clean-Up will start soon
Vice Admiral
Special OPS Commander
Commendation
Commendation (150 Points)
Awarded during the UFP Award Ceremony to those who go above and beyond for the community
Unlocked Sat 30 Dec, 2023 10:13 PM
0.24% have received this achievement
Pillar of the Community
Very Rare (100 Points)
Be a registered user for 10 years
Unlocked Mon 01 Aug, 2022 5:06 AM
34.84% have received this achievement
Dedicated
Rare (50 Points)
Volunteer for 1+ year
Unlocked Thu 16 Mar, 2023 2:02 AM
0.55% have received this achievement
Vice Admiral
Rare (50 Points)
Receive a promotion to the rank of Vice Admiral
Unlocked Sat 30 Dec, 2023 9:58 PM
0.27% have received this achievement
Rear Admiral
Rare (50 Points)
Receive a promotion to the rank of Rear Admiral
Unlocked Sun 25 Jun, 2023 9:19 PM
0.47% have received this achievement
Commodore
Rare (50 Points)
Receive a promotion to the rank of Commodore
Unlocked Sat 25 Mar, 2023 10:14 PM
0.50% have received this achievement
3
- Users who liked
- Mephiztophelez
- darthnovawave
- Morris
Quote
Post ID: 487115
#6
Posted Mon 01 Jan, 2024 12:54 PM
VGER (and XVGER if you want to include the outdated fandom wiki) use the wiki's Cargo Tables to fetch the info about items, traits, etc.
The one you could use fetches all items and outputs them in json format, but it's a terribly long link (this one's for stowiki).
You want a filter for 'Ship Tactical Console', 'Ship Science Console', 'Ship Engineering Console', 'Universal Console' across the json's 'type'.
The tables on fandom are complete to the point of them becoming outdated, the stowiki ones are not completely built yet (still in the process) afaik.