http://iscoresports.com/

I have convinced my daughter's softball team to start using iScore instead of GameChanger since I do most of the scoring and use an Android OS, but I need to be able to give cumulative stats. There was one game that I wasn't able to attend last season, and the sub created all new players. Up to this point, I have just had to be okay with being unable to have truly cumulative stats, but your program allows merging, so I thought it would be "problem solved." I exported from gamechanger a CSV file and then imported it to iScore. When I tried to merge the 2 players, one or the other just ended up with duplicated numbers. So instead of having 24 games on one line and 1 game on the other, the 2 lines are identical -- some players with 48 games total and others with 2 games total.

Welcome to iScore Forum..

I think you will find iScore more robust than game changer. Sounds like you agree.. but need some help with the import ..

be glad to try and help but going to need more details on your situation and what you have already done (so we can see if we can correct or undo)

Are you importing one game to existing 24 games on your device. or importing 24 games to add to one already scored and on your device.?

How did you import the CSV file into your device ? did you follow these steps?
http://iscoresports.com/baseball/kb/faq ... _stats.php

Importing via CSV can be very robust, but also time consuming , and does take precise work to prepare the import file correctly. first step is to MAP your source data extract to the format and sequence that iscore expects - did you do that? is that in one cvs file or multiple? Then while importing on the admin site, did you map the players . the import is additive, you should not get double counted. you name your import data set (Season stats, Missed Game, Stats from Prior Year, etc) and it will be treated like a separate game in your device for the players and the team. you can also assign to leagues and filter by leagues.

What did you do more specifically, so we can help you

I tried a lot of things, and nothing seemed to work, so I've deleted and uninstalled several times to start with a blank slate. To answer your questions, I'll give you the current status.

I exported the team without any players from iScore and then imported the CSV file, which represents 25 games, on the admin site. I created unique names for each line of data and imported each as a new player. I then went to the player manager and merged a player who aged up this season. Looking at her player card, she has stats for 48 games, 2 identical lines of 24 games. That's when I gave up and posted my question. Since I am going to be scoring a scrimmage this afternoon, I have created new players without stats on the team roster, so the players who have data from last season are currently listed as three separate players, the 2 "historical" ones, which I have assigned to a unique league, and the 1 "blank" one. That way, if I just can't have cumulative data, I can delete the extra players.
When I previously tried mapping both lines of player data to the one existing player in iScore, only one line of data showed up, 24 games or 1 game, so I deleted and uninstalled and started over. I then tried mapping one line and merging with the other and got duplicate lines, so delete/uninstall. Then I tried treating each line of data as a unique player and merging each with an existing "blank" player and actually got 4 lines of the same data, 96 games -- delete/uninstall.

There is only the one CSV file, and I looked at it, thinking I might manually merge the data into a single line and just delete the other one, but after getting past the basic info, I noticed there were calculated values being imported, like batting average. That one's easy, but it was surprising to see, so I looked further, and there are situational and advanced metrics that I have no way of recalculating (like batting average with runners in scoring position), so I abandoned that. Looking at the sequence of information and assigned mapping, it appears to be correct.

That extra info helps. Sorry for the challenges.

With a clean slate to start over, I am sure we can get it resolved. I am confident, the program can handle what you need. However, i am going to suggest different steps. You should not need to merge on your handheld. When done correctly, 'merge' is done w player mapping upon csv file import on admin site. Then you option import and the csv file data shows up as a 'special game' in game manager. You then manage that game like any other. You assign this game to leagues and then Use league filters To include or exclude the stats in team and player cumulative stats.

I dont do this often but As this is sometimes confusing, if you want to take this off line and work on it by email .. post back and i will Reprovide my email ( i had it posted today but just edited it out )

Also below statement confused me ..

I exported the team without any players from iScore and then imported the CSV file, which represents 25 games, on the admin site.

What is the source of the Original Data, sounds like it is another iScore device. If that is true, there are easier ways to IMPORT from iscore to iscore than cvs file . (regardless if iOS or android). I thought from original post you had Game Changer data trying to move to iScore..but if you have iScore data and access to the original device, you want to do OPTION > DATA SHARE.


If you do need to use csv file, here is an excel CSV template for Setting up the import file . http://my.iscorecentral.com/baseball_stats.csv

@bwasson - I did not hear back from you yesterday. I hope your game went well. if still needing help importing cvs file data into iScore post back.

In the meantime , i posted some more stepwise instructions on this topic at viewtopic.php?f=3&t=11420&p=46453#p46453. It is more detailed than the FAQ i provided in earlier post.

if you wanted to start over and try again on your own, those steps should walk you through the process

If you still need/want more personalized response, Post back and we can go off line by email. but in general, as i read your post, i think you have over complicated it with the three players. And Merging on your device. When importing a cvs file correctly, there is no merging on the device no need for duplicative players. no double counting.

When done correctly, the imported cvs data comes into the device as a special "season stats' game, for your Team/Players - that you can then assign leagues to and filter on like any other game to include/exclude from a Team/Player cumulative, or season stats.

Again, If you need more personalized help or now help 'cleaning' up your prior attempts. Post back

Regards
Ohio tex

The problem with mapping on import is that because of that one game that new players were created, there are 2 lines of data for most of the players, and when I tried to map both lines to a single player, only one line of data was imported. However, I have now invested the time to putting the data from the GameChanger CSV file into the template, and that original problem is now solved. The iScore template does not have calculated data (except the ERA) -- it's all raw data from which the calculations are made. Therefore, I was able to manually add the 2 values together and eliminate the duplication issue.
To clarify my confusing statement, although it doesn't matter anymore, I created a team on my device but had no players on the roster or player manager when I exported to the admin website. I then imported the CSV file on the admin website and then imported to my device. The original source is/was GameChanger. New potential problem, though. I need to undo the previous import. If I delete the special game that was created, will that do it? I now have a game from this season that I need to keep, so I can't just delete/uninstall like I did before.
Sorry that I didn't have a chance to check back here yesterday. Scoring the scrimmage was great. I love this program. Quick second question that came up: if I forget to specify that an error would have resulted in an out (if not for the error), is there a way to put that detail back in on the pitch by pitch editor? I'm pretty sure it won't matter for this particular game, but for future purposes. I looked and couldn't find it.

(1 of 2 response posts)

On importing csv file..


If you have players with two lines of source stat data. Simply seperate them into Two seperate csv files imports. Just like it was two previous seasons.

Yes you only need to map core data.

Yes on what i think i understand you did, you want to deleate the bad original "special 'season stats' game". To be safe, Do an option > export.( create an updated backup on admin aerver) Then with confidence you can delete the wrong special game on your device. and not put any of your new scores game at riak. see if it does what you expect. It should. If it 'goes south' you have a backup to restore option > import

(Second of 2 response posts)

The error question ..

Iscore uses the "would player have been out without the error question"? to help calculate earned/unearned runs - behind the scenes. it does not show up in play by play, isocrecast or in pitch by pitch - so you can't edit it after the fact . But You can always go into editor and add a note on any play.

Iscore does a pretty good job on earned/ unearned - but not perfect. Look on a score card you will solid diamonds are earned runs. Half shaded are unearned. It is mot uncommon to have to manually override earned run stat. Hard for computer to 'recreate the inning' like a human'

Male sense? Post back if need more info/explanation