How to restore missing green tick marks in the scenario list

[Chacal]

When you complete a scenario successfully in Railworks, it gets a green tick mark in the scenario list.
This is important for keeping track of your progress and so you don't keep playing the same scenarios all over again.
Railworks (TS2014) keeps information about this and other achievements in your local database.
For some reason, this database sometimes gets corrupted and some or all of your green tick marks get erased.

You may not immediately notice it if only some of them disappear. This is quite annoying.

The only way to preserve this information is to back up your local scenario database, which is a file named SDBCache.bin in the Railworks/Content folder. Of course if you back up your whole Railworks folder then you also back up the database.

The problem lies in restoring this information. If you copy the backup over the current database, you will recover the information in the state it was at the time of the backup. You will lose all tick marks gathered after the backup. If you don't back up regularly, this can be a lot of tick marks.

A better solution would be to open both the old and the new databases and recover only the lost tick marks. This can be done manually, but for 200 scenarios it can take hours, and if you make a single mistake you may end up with a corrupt database. Clearly this needs to be automated.

This new tutorial in the RWA learning center explains how to get and use the RWDBRepair script, which automates this process in a secure and user-friendly way, and completes the whole operation in a few seconds.

[OldProf]

Well, this is interesting, but I find myself with the opposite problem. I'm helping test scenarios for a new route that's still in development. Every so often, the developers send me the latest version of the route; following their advice, I uninstall the old version and, just for good measure, also delete its route folder before installing the latest one. When I next look at the route in TS, the scenarios I've previously tested still have green check-marks beside them -- and now I think I understand why. This is, of course, one of those minor inconveniences, but getting rid of those checks would help me keep track of what I'm doing more easily.

[stresstool]

Hmmmm...After the update, none of the scenarios on my third party routes would work, they all resulted in a SBHH. So I did the trick of completely deleting the Railworks folder and let Steam re-download the whole shebang.* Then I re-installed three of my third party routes: NERW, OhioSteel2 and IIR and low, all the green checks were still present on all the scenarios I had run, both of the default routes and of the 3 add-ons. If the SDBCache file was replaced, how was it able to remember this? And, BTW, this trick fixed all the SBHH's.

*The delete process consisted of first renaming the railworks folder to something else then starting steam and choosing "Delete local files" (or whatever that is called). Afterwards verifying no railworks folder was present I somehow convinced Steam to download the game (I forget exactly what I did). It downloaded TS2014 plus all my DLC (I recall it was ~13GB and took about 1.5 hours). The new folder created by steam was named RailWorks where previously it was named railworks.

[RvA944]

Do you guys have the cloud on in steam? Maybe and I'm not sure but it might be pulling user files off there and restoring them.

[dgallina]

Good point. I didn't see it in TS2013, but in TS2014 I *do* see completion status being synchronized across installs!

Diego

[Chacal]

Good point. I had no idea RW could upload local files to the cloud, but it makes sense to synchronize achievements.

[Chacal]

Well, this is interesting, but I find myself with the opposite problem. I'm helping test scenarios for a new route that's still in development. Every so often, the developers send me the latest version of the route; following their advice, I uninstall the old version and, just for good measure, also delete its route folder before installing the latest one. When I next look at the route in TS, the scenarios I've previously tested still have green check-marks beside them -- and now I think I understand why. This is, of course, one of those minor inconveniences, but getting rid of those checks would help me keep track of what I'm doing more easily.

Just tell me the route name and ID (its folder name).

[Samwolf]

Thanks for this.

[albertend]

Hi all,
RWDBRepair really good tool but I think it is not enough for TS2014.
In TS2014 they added several new nodes for example medals
Mr. Chacal do you have any plans to upgrade the utility that can fully matches with TS2014?


If you advice me may be I can rewrite the Vbscript and send you

Thx
Albert

[Chacal]

No, I fear it would be a very bad idea to mess with anything career-related in the scenario database.
Steam is rather blunt when it suspects suspicious activity and quickly interprets that as cheating, which can lead to your whole account being locked, along with all your DLC.

I suggest you leave this part alone.

[wozzie]

Used this little program and all my green ticks are back, also the few career ones and my achievements are back.
Cliff

[hyaxasa]