Page 1 of 2

CSV Converter Question

PostPosted: Wed Sep 13, 2017 8:35 pm
by regenerator
What about JSON to CSV? I am trying to create my custom league using the same rating ranges as the '18 version. I noticed the CPU-generated Ratings are much higher in the 18 version than that of the 16 version. I would like to use those, as for instance my CPU-generated league in '16 only had like 5 people in the 90's OVERALL ratings, whereas there were like 20+ in '18.

Does this make sense? I'm not sure why the CPU-generated ratings are different between the two versions, but I assume I should base my own created players on the '18 ratings.

Re: CSV Converter

PostPosted: Wed Sep 13, 2017 9:01 pm
by brooks_piggott
We changed the overall formula between the games since the generated players in '18 were coming in under 90... in some cases zero 90's for an entire position. That didn't seem realistic to me, so we updated the OVR calc. The underlying ratings didn't change, so you should be able to use similar ones in '16.

Since the '18 game doesn't require CSV for players anywhere there isn't much need for a JSON to CSV converter.

Re: CSV Converter

PostPosted: Wed Sep 13, 2017 10:27 pm
by regenerator
I CPU-generated a new league in 16, and these are the top results (position and overall - listed below) - as you can see, there are only 6 ratings 90+ in the league. There were over 20 90+ ratings in a '18 CPU-generated leagues. So, in summation, basing my custom ratings off the 18 model is fine but there's no way to do this since I can't export from 2018 into CSV.

QB 95
QB 94
QB 92
RB 91
QB 90
K 90
P 89
QB 88
P 88
QB 87
RB 87
WR 87
K 87
P 87
QB 86
QB 86
RB 86
RB 86
RB 86
RB 86
SS 86
QB 85
QB 85
RB 85
RB 85
G 85

Re: CSV Converter

PostPosted: Wed Sep 13, 2017 10:30 pm
by regenerator
Oh wait Brooks I think I see what you mean use the non-overall ratings from '16 and let '18 generate OVR?

Re: CSV Converter

PostPosted: Thu Sep 14, 2017 12:30 am
by regenerator
I tried converting the my CSV file to a JSON, but all that was in the JSON was this - {"Players":[]}
Can I send my CSV file to you? I tried attaching it but seems like attachment aren't working.

Re: CSV Converter Question

PostPosted: Thu Sep 14, 2017 8:55 am
by brooks_piggott
You can post it up on google docs or onedrive or something like that and I can take a look. If you post it here some other folks that have been using the convert maybe able to help as well.

Re: CSV Converter Question

PostPosted: Thu Sep 14, 2017 12:00 pm
by regenerator

Re: CSV Converter Question

PostPosted: Thu Sep 14, 2017 12:17 pm
by Tigerman
regenerator wrote:https://drive.google.com/open?id=0B40F_MfWKReSSU5ZYTZqXzM4YlE

Sort it by PlayerID, maybe that will help.

Re: CSV Converter Question

PostPosted: Thu Sep 14, 2017 12:18 pm
by brooks_piggott
I took a look, but it looks tab delimited instead of comma delimited.

Re: CSV Converter Question

PostPosted: Thu Sep 14, 2017 9:58 pm
by regenerator
Hi Brooks,

Here is the comma-delimited file:

https://drive.google.com/open?id=0B40F_ ... mRDYTFQbms

Again, the problem is, this is generated by '16 and the ratings seem very low. There are only 5 players with 90+ ratings. Were you saying to ignore that and just convert the file to '18, where the OVR will be boosted?

Thanks in advance