|
|
Post by eleclerc on May 13, 2018 18:29:06 GMT
FHLSim - Online DRS/ROS/CSV Converter LinkSince the original tool is broken on Windows 7-8-10, I was hoping to release a web version of it. It's the same tool, just simplier and more complete. Now, you can easily extract your .ros file to .csv file and edit it with Excel or another program. The same for the reverse way, the .csv file to .drs file. Release date: 2018-05-13 Last Update: 2023-07-13
DFC Mode
Quite simple, it works like the DFC tool. Good for All-Star Skill Competition. When you enter your .ros or .drs and it will creates a .csv with the same data as in DFC. When you enter your .csv with the same data as in DFC, it will creates a .drs.
Delimiter Mode (eleclerc)My mode is just simplier when you use excel to edit your .csv file. It will opens in table. CSV Template Order
Free or Used;Name;Position;Number;Rookie or Veteran;Handling (L or R);Height (in inches);Weight;Age;IT;SP;ST;EN;DU;DI;SK;PA;PC;DF;SC;EX;LD;Salary;Contract;Birthplace CSV Template Order Example (New player)
Free;Éric Leclerc;D;22;Rookie;L;66;130;33;70;70;70;70;70;70;70;70;70;70;70;70;70;1000000;5;CAN CSV Template Order Example (Rerate player)Used;Éric Leclerc;D;22;Veteran;L;66;130;33;70;70;70;70;70;70;70;70;70;70;70;70;70;3000000;2;CAN |
|
|
|
Post by blaster69 on May 15, 2018 2:03:59 GMT
Woohoo !  Thanks Eric ! |
|
|
|
Post by fchladmin on May 15, 2018 16:24:45 GMT
my one question that i seem to always have problems with is after the converter puts in to CSV.
So you use text to columns to take it out of the CSV format for editing.
How do you get it back in to the correct format CSV (Used;Éric Leclerc;D;22;Veteran;L;66;130;33;70;70;70;70;70;70;70;70;70;70;70;70;70;3000000;2;CAN) to input back to the sim?
|
|
|
|
Post by eleclerc on May 15, 2018 20:31:59 GMT
MS Excel
You can convert your excel table to CSV. Just save as CSV. It will add the ";" by itself, just make sure to get all the correct infos
Notepad
You can do use Notepad and save your file as yourLeague.csv and it will saves as an .csv.
This way, you have to enter the text:
Used;Éric Leclerc1;D;22;Veteran;L;66;130;33;70;70;70;70;70;70;70;70;70;70;70;70;70;3000000;2;CAN
Used;Éric Leclerc2;D;22;Veteran;L;66;130;33;70;70;70;70;70;70;70;70;70;70;70;70;70;3000000;2;CAN
Used;Éric Leclerc3;D;22;Veteran;L;66;130;33;70;70;70;70;70;70;70;70;70;70;70;70;70;3000000;2;CAN
Convert your CSV back to DRS
When you get your new CSV done, you need to use the page to create the DRS from your new CSV. Once the new DRS is created, overwrite your existing league DRS with your new DRS.
MergeDB or Add Player or Activate in FHLSim
MergeDB: Usually used when you do rerate. File -> Player Database -> MergeDB. FHLSim will matches players from database and a player with a team.
Add Player: You shouldn't add player by this way but you can. Select your team -> Team Roster -> Add Player.
Activate: When you create new prospect player. Manager -> View Team Prospects -> Select your team -> Select the player -> Activate. It will automaticly selects the same player name from the database!
Always save your files before overwriting it!
I hope this help you.
|
|
|
|
Post by fchladmin on May 15, 2018 20:36:35 GMT
Right on thanks Eric It looks like it will save a ton a time very helpful!!! Now all we need is a customizable rerate tool  |
|
|
|
Post by eleclerc on May 15, 2018 20:42:09 GMT
It's very hard to create a rerate system that will fits all the leagues...
|
|
|
|
Post by fchladmin on May 15, 2018 20:45:05 GMT
Yeah I kind of thought about that after I posted
Thanks for all you do to keep FHL alive
|
|
|
|
Post by eleclerc on May 21, 2018 22:22:47 GMT
But, if I create one rerate system, maybe it can be the choice of some leagues because of the time it takes to do it correctly!
In my ideas, you enter your .ros file in the upload input and it will gives you the new .drs of it. The rerate should be done with the season stats farm & pro base on the age.
|
|
|
|
Post by fchladmin on May 22, 2018 12:41:11 GMT
That could be an idea or build where you can enter parameters that will change based on what you enter
|
|
|
|
Post by eleclerc on May 22, 2018 20:03:53 GMT
But this is a big work to get a working formulas. If someone want to share is calculation is going to be great.
|
|
|
|
Post by fchladmin on May 25, 2018 0:39:52 GMT
I can try to figure mine out been awhile since putting mine together.
|
|
|
|
Post by yodacheeks on Jun 6, 2018 14:03:41 GMT
|
|
|
|
Post by eleclerc on Aug 13, 2018 23:29:16 GMT
I updated the code to be able to choose witch version you want to be DFC or eleclerc (By delimiter ";").
DFC Mode
Quite simple, it works like the DFC tool.
When you enter your .ros or .drs and it will creates a .csv with the same data as in DFC.
When you enter your .csv with the same data as in DFC, it will creates a .drs.
By Delimiter (eleclerc)
My mode is just simplier when you use excel to edit your .csv file. It will opens in table.
Why I give this choice?
Some FHLSim Tool uses the DFC template in order to run porperly. Also, I manage to get a good copy of the All Star Competition!
|
|
|
|
Post by trefilov22 on Sept 6, 2021 16:11:05 GMT
Trying to use the converter to change a csv to the drs and get the following error:
CSV Error - Wrong mode!
Not sure what I am doing wrong. the delimiter is a , so I made sure to put that in as the delimiter. Any suggestions?
B
|
|
|
|
Post by eleclerc on Sept 6, 2021 16:43:29 GMT
If I don't have your file or 2-3 lines of your .CSV, it will be hard to tell...
|
|
Thanks Eric !
