pete
Junior Member
Posts: 93
|
Post by pete on May 28, 2019 17:50:28 GMT
Was about to prepare the drs file for the rerates but got stuck in the FHL tools.
After I created my csv as normal, I have imported it to the FHL tools. When trying to export it to a drs file I get the following error:
Run-time error '13': Type mismatch
Once I click ok, FHL tool closes. It does create a drs file but that seems to be buggy. When I tried to import it to the Sim, i get endless error messages (salary number out of integer or something like that, i forgot) and after that it seems most teams have only about 8 players on their roster.
Any idea what i did wrong? I assume my CSV has some issues but cant figure it out. Weight and height are within the limits, no issues with the handedness (had that before) and no name is longer than 21 characters (22 is the limit as far as i know). I am running out of ideas here.
|
|
|
Post by eleclerc on May 28, 2019 20:32:24 GMT
Send me your CSV, maybe I can found the problem.
|
|
pete
Junior Member
Posts: 93
|
Post by pete on May 28, 2019 20:43:40 GMT
Send me your CSV, maybe I can found the problem.
Have dropped you mail with 2 CSV. I figured out the original problem, when peparing evering in the xlsm file and then saving it to a csv it did split names like "Dal Colle" from one cell into 2 cells ("Dal" and "Colle") moving every cell behind one to the right. But even after fixing that I get a (different) error message.
|
|
pete
Junior Member
Posts: 93
|
Post by pete on May 29, 2019 21:13:29 GMT
Just want to say thanks to Eric for his patience with me in this trying to figure out what went wrong. A few observations: Error 13: you have copied something in a place where its not supposed to be, this can happen when converting into a CSV Error 5: You are an idiot and have a column to many in your csv (OV) Last not least, have your beer only after you finish this not right in between. Even the slightest mistake in the CSV can give you nightmares, try to be as careful as you can.
|
|