TIP: How to "Import CSV File" from "Prior Season Stats" - FAQ

We will try and answer Questions in this forum. If you are having any issues with iScore Baseball, this is probably the best place to start. You can also search historical posts here.
User avatar
OhioTex
Posts: 5378
Joined: Sun May 10, 2009 6:48 am
Location: Columbus OH

Re: TIP: How to "Import CSV File" from "Prior Season Stats" - FAQ

Post by OhioTex » Sat Mar 24, 2018 8:44 am

I am not sure i am tracking with your follow up question..

On my.iscorecentral.com > import tab ...
The sample csv (file) and legend (button) are intended to be aligned. And represent the fields iscore will recognize.
..........................................
iScore Baseball/Softball
* FAQ http://iscoresports.com//baseball/support.php
* Updated Manual http://iscoresports.com/baseball/manual.php?gd=1
* Stat Formulas http://data.iscorecentral.com/legend.ph ... internal=1
duff49
Posts: 4
Joined: Fri Mar 23, 2018 7:34 am

Re: TIP: How to "Import CSV File" from "Prior Season Stats" - FAQ

Post by duff49 » Sat Mar 24, 2018 11:40 am

Another issue I have just discovered. Somehow I have an import on the admin/team website side of the server that I can’t see the listed game “import”, however the stats are shown on the team website. I have tried an export on my device and it still shows up in stats. I’ve tried import on my device and no new games “imports” come across. So now my issue is I’ve got a import stuck in limbo on the server side that I can’t see in the games list on either side but is contributing to stats. Uggghhh! Luckily this is only two games into the season but kinda thinking I should have stuck with gc at this point.
User avatar
OhioTex
Posts: 5378
Joined: Sun May 10, 2009 6:48 am
Location: Columbus OH

Re: TIP: How to "Import CSV File" from "Prior Season Stats" - FAQ

Post by OhioTex » Sat Mar 24, 2018 12:46 pm

Probably league settings..


On your mobile device... go to league manager and turn on the special ALL LEAGUE to reveal all data on your device. Then go to game manager and your import game should be there.. the date may put it at end of list or perhaps hiding in the middle based on dates
..........................................
iScore Baseball/Softball
* FAQ http://iscoresports.com//baseball/support.php
* Updated Manual http://iscoresports.com/baseball/manual.php?gd=1
* Stat Formulas http://data.iscorecentral.com/legend.ph ... internal=1
duff49
Posts: 4
Joined: Fri Mar 23, 2018 7:34 am

Re: TIP: How to "Import CSV File" from "Prior Season Stats" - FAQ

Post by duff49 » Mon Mar 26, 2018 5:37 am

alright so after going to maintenance and optimizing it appears the import in limbo was cleared up. now the question is does anyone have a ready to use template to convert Game Changer stats over to Iscore. Ive google searched but have been unsuccessful in finding a template.

I have also found that Iscore auto populates some stats off of other criteria. I was looking for the pitch count command ie. pit_total or pit_pit. For whatever reason the legend doesn't include this but it does seem to calculate this field off of strikes and balls thrown.
User avatar
OhioTex
Posts: 5378
Joined: Sun May 10, 2009 6:48 am
Location: Columbus OH

Re: TIP: How to "Import CSV File" from "Prior Season Stats" - FAQ

Post by OhioTex » Mon Mar 26, 2018 6:22 am

I created a reuseable GC conversion template a few years back with a user and posted excerpts in following post viewtopic.php?f=3&t=11420&start=10#p46522. I have not updated that conversion template for the most current versions of GC and iscore. If no one else responds, and you still need help, perhaps we could connect off forum by email and see if i can help.

to be clear the more basic stats will transfer 1:1. but when you get down to some of the more specialized stats.. you will not have 100% 1:1 conversion and have some gaps.. each program maintains some specialized stats when you score in that program that would not transfer to the other.

Excerpt from the Prior post
viewtopic.php?f=3&t=11420&start=10#p46522
GC Conversion Template (excerpt)
( Column labels are iscore text specific but order is game changer specific. Players in Rows)

jersey, last_name, first_name, bat_games, bat_pa, REMOVE(AB), REMOVE(H), bat_1b, bat_2b, bat_3b, bat_hr ...

....
the complete source data and conversion template is much longer of course, this was just an excerpt for illustration of the process
As i noted in the thread, you need to decode and match the fields, and it is not perfect 1:1. and yes - there are number of stats that are 'calculated' in score (not imported) like you found for total pitches, another example is AB which you would not import from GC as iscore calculates it based on elements it imports.
note: to prepare this conversion template , I not only had to decode, match and reorder the iscore field names to match source data sequence, but I also added a special REMOVE placeholder for any source data columns that iscore does not want - example , Hits and AB (because iscore calculates vs imports). I also removed iscore stats the source data does not provide (example bat_seq, bat_bunt_singles) .
viewtopic.php?f=3&t=11420&start=10#p46522
..........................................
iScore Baseball/Softball
* FAQ http://iscoresports.com//baseball/support.php
* Updated Manual http://iscoresports.com/baseball/manual.php?gd=1
* Stat Formulas http://data.iscorecentral.com/legend.ph ... internal=1
Post Reply