Editing .csv files.

upthestix · 10-13-2013, 01:21 PM

I've been trying to edit fighter .csv files to alter the fighter stats (probably not the intended use, but it looked like a reasonable shot). The idea is reasonably simple; export a batch of fighters, use another program to edit certain stats and then import them back into tbcb.

I've managed to get it to work for individual boxers, editing their height, weight, reach, hometown, hand and punch % (although the boxer type seems to have no correlation to the value in the .csv file). However, it doesn't work for multiple boxers. I guess that I have an error somewhere in the boxer line which then messes everything up after it.

I'm not posting this as a plea for help but simply incase someone else wants to have a mess around with it. I've run out of time and am not going to use it, but it could be useful for someone else. My thoughts were mainly for quickly tweaking randomly generated boxers (for example, decreasing the number of southpaws or giving them personal information).

This is the method that I used. Most of the later steps are there to try and get the final file to be in the same form as the intial .csv file:

Import the .csv file into excel, separating using commas to get the data into columns
Alter the data (reach, for example) for the boxers.
Format the entire spreadsheet using a custom category to make all the text have quotation marks around them: \"@\"
Format the numerical values for reach, height, weight and the punches % so that they have 6 decimals (0.000000)
Save the file as a .csv
Open the .csv in notepad and replace all """ with " and ,, with ,"", two times.
Save and import into title bout.

10-13-2013, 01:21 PM	#1
upthestix Bat Boy Join Date: Apr 2013 Posts: 1	Editing .csv files. I've been trying to edit fighter .csv files to alter the fighter stats (probably not the intended use, but it looked like a reasonable shot). The idea is reasonably simple; export a batch of fighters, use another program to edit certain stats and then import them back into tbcb. I've managed to get it to work for individual boxers, editing their height, weight, reach, hometown, hand and punch % (although the boxer type seems to have no correlation to the value in the .csv file). However, it doesn't work for multiple boxers. I guess that I have an error somewhere in the boxer line which then messes everything up after it. I'm not posting this as a plea for help but simply incase someone else wants to have a mess around with it. I've run out of time and am not going to use it, but it could be useful for someone else. My thoughts were mainly for quickly tweaking randomly generated boxers (for example, decreasing the number of southpaws or giving them personal information). This is the method that I used. Most of the later steps are there to try and get the final file to be in the same form as the intial .csv file: Import the .csv file into excel, separating using commas to get the data into columns Alter the data (reach, for example) for the boxers. Format the entire spreadsheet using a custom category to make all the text have quotation marks around them: \"@\" Format the numerical values for reach, height, weight and the punches % so that they have 6 decimals (0.000000) Save the file as a .csv Open the .csv in notepad and replace all """ with " and ,, with ,"", two times. Save and import into title bout.