How do I import my Excel Sheet?

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
Otrebor13
New in Town / Le Ptit Nouveau
Posts: 31
Joined: Fri Mar 26, 2010 6:03 pm

How do I import my Excel Sheet?

Post by Otrebor13 »

I have looked around the V2 Simulator for a way to import ratings but it seems as though you can only import them if they're saved as .STR

My Excel sheet ratings are a .csv file and I was wondering if there was any way for me to import them into the simulator of if there was a way for me to convert the .csv file to a .STR file so I can import them into the simulator.

Thanks in advance
myRPHA.com
The Accomplished One / L'Accompli
Posts: 101
Joined: Sat May 01, 2010 11:55 am
Location: P.E.I. Canada
Contact:

Re: How do I import my Excel Sheet?

Post by myRPHA.com »

You have to convert it to a .str using the STHS V2 Utility program found on the download page of the STHS website.
Stephen Clow
RPHA Administrator (Ret.)

http://www.myRPHA.ca
Otrebor13
New in Town / Le Ptit Nouveau
Posts: 31
Joined: Fri Mar 26, 2010 6:03 pm

Re: How do I import my Excel Sheet?

Post by Otrebor13 »

I did that, but when I select the "Import Players CSV V2 File" and I select the file I want to import I get the message saying:

Exception Type
-------------------------------------------------------
--------------------------------------------------------
System.InvalidCastException

Message - Source
----------------------------------------
-------------------------------------------
Conversion from string "1986-2-29" to type 'Data' is not valid - Microsoft.Visual Basic

Strack Trace
------------------------------------------------------
------------------------------------------------------
at Microsoft.VisualBasic.CompilerServices.Conversions.ToDate(StringValue)
at
SimonTHockeySimulator.VariableSharedMainUtility.AddPlayerToRatingV2(String strPlayerFile)
Otrebor13
New in Town / Le Ptit Nouveau
Posts: 31
Joined: Fri Mar 26, 2010 6:03 pm

Re: How do I import my Excel Sheet?

Post by Otrebor13 »

I don't know what to do when it gives me that message. Am I doing something wrong?
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14777
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: How do I import my Excel Sheet?

Post by SimonT »

You have a players date who is 29 of February 1986. That date doesn't exist in 1986, it's either 1984 or 1988 if you want a 29 of February.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Post Reply