Everyone has their funny little quirks, one of mine is spreadsheets, specifically excel (I love it), although other spreadsheeting software is available. I was shown this fantastic tool by fellow blog member Nick, @NTR9798. It was created by @zickofonac on twitter, and can be downloaded using this link ZickoCM9798WorkingStation_v2.1. The tool allows us to download the database to a spreadsheet, make any changes we want to and reupload it all without having to use the actual editor. This can be a huge time saver for bulk changes!
I don’t claim to be an expert using this tool, I just want to provide some tips and pointers to help people edit the CM9798 databases more easily. When you download the software, there is a README file that contains a lot of information on how to use this tool. Obviously the first time I read that file was before I began writing this blog, because instructions right, who needs those! If I had read the instructions, one of the issues I noticed when exporting the TMDATA could have been easily avoided, because information about this issue was, surprise surprise, in the instructions. I’ll explain more later.
In this blog I will cover:
- Setting up CM9798 Working Station (CM9798 WS)
- Exporting the *.DB1 files to make a *.CSV file
- Things you can do in excel to make editing easier
- Importing the *.CSV files to make a *.DB1 file
Continue reading →