thunderchero wrote: ↑Mon May 08, 2023 6:42 pm QD created a tool some time ago, but don't know if his spreadsheet would work or not.
"Tool for editing and importing the ship list to stbof.res"
viewtopic.php?p=37706#p37706
Adding some advanced CSV Import- & Export option to UE ihas become one of the core features implemented with the upcoming version of UE.adi wrote: ↑Wed May 15, 2013 4:25 pm I have made a tool in excel that uses some base values and generates the stats for the ships based on race, ship type and tech levels (like Mentat's, but simpler and friendlier ). The tool can also import the htlm ship list from UE on a different page and compare the UE values with the generated values and flags the differences so one can go back to UE and fix the mistype.
If one of you Java guys can add the import feature and state the list format for input, it will save the moder days.
In private I rather use Libre Office, but I tested and checked on the Ship_List_Modifier2.1.xlsm Excel file from adi and made sure to match same data format, with a few columns added. It asks for permission to execute Excel scripts, but beside that it's auto-recorded and pretty messed, the code looks fine to me.
The xlsm is included with upcoming UE or can be downloaded from viewtopic.php?t=2710
If scripts aren't relevant, the exported CSV of course can be viewed and edited with any CSV editing tool or text editor.
Most importantly I also implemented to import it back to the game!
To help on translations, I added additional import options, see middle screenshot in above posting:Spocks-cuddly-tribble wrote: ↑Tue May 16, 2023 8:54 amNote that it's not only about two description strings and the pointer for shipdesc.sst but also various edits in lexicon.dic and trek.exe for monsters.
The english/german sorting in the ECM shiplist(s).sst might differ? I haven't tested any german BotF version in years, so I couldn't even determine the right vanilla descriptions to match them with the right ships without studying german vanilla before.
Plus I remember more than 20 years ago I edited some german vanilla ship descriptions since they were confusing/incorrect...
These allow to skip overwrite ship names and descriptions, so you can export -> import data from another stbof.res file that uses different language.
Plus if ship sorting is messed, like when you try to import back translations only from a previous version, and you are too lazy to manually match all the ship ids, you can try the match by gfx function.
In addition, you can also selectively import ships, but they still must match by id or gfx.
Or you can limit to import existing ships only, to just update the data stats.
Furthermore I improved trek.exe and stbof.res ship id updates. And when it's about the lexicon.dic, to simplify editing it has an import / export option for a while already. I even added CSV import & export options to the "Group Edit Of Building Stats"-GUI. Yet missing is tech tree and races.
I am sure there is much what still can be improved on the import / export options. But before I continue to invest time, I think it needs some testing and feedback. Maybe you guys have additional suggestions. I am sure you have.