Page 1 of 1

Prospect to CSV

Posted: Sat Feb 18, 2017 11:28 pm
by BRHL Hockey
Is there a way to export the prospects with their team name, to a CSV?

Re: Prospect to CSV

Posted: Sun Feb 19, 2017 9:41 am
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.