Prospect to CSV

Any questions related to version 2 or version 3 should be ask here. / Toutes les questions sur la version 2 ou la version 3 devraient être demandées ici.
Post Reply
BRHL Hockey
The Passion One / Le Passionné
Posts: 246
Joined: Mon May 04, 2009 12:46 pm
Location: Denver, Colorado
Contact:

Prospect to CSV

Post by BRHL Hockey »

Is there a way to export the prospects with their team name, to a CSV?
Image
Bryce Shuck
[email protected]
The #1 source for STHS ratings since 2006!
BRHL $ League est. 2006 - http://new.brhl.net/
Cash Hockey, Football & Baseball Leagues
STHS, FHM7, OOTP, FanGm Platforms
JimToupet
STHS Dynamic Website Contributor
Posts: 363
Joined: Wed Jul 02, 2014 10:55 am

Re: Prospect to CSV

Post by JimToupet »

If you use the V3 of STHS, Using the DB Browser for SQLite you can run this query :

Code: Select all

SELECT P.Name AS Name, T.Name AS Team From Prospects P, TeamProInfo T where P.TeamNumber = T.Number;
And export it to CSV

Or Using Excel and the VLOOKUP function.

But from the STHS itself, I don't think it's possible.
Post Reply