Some of you may remember the post about the TPS parser class that came out of a corrupted file at a customer site, and the .NET reader and CLI that followed. For the last few months, that work has quietly turned into a finished product, and today I am releasing it.
It is called TPS Repair: https://tpsrep.com
What it does
It solves the two TPS problems I keep running into:
- Recovering a damaged file. It reads every record that can still be reached and rebuilds the complete table structure. If the structure stored in the damaged file is unreadable, it reads it from the Clarion
.EXEor.DLLthat uses the file. - Migrating data after Error 47. It reads the old structure from the data and the new one from a
.TPS,.CLW,.EXE, or.DLL, maps the fields, and converts the values. The report lists every field that would be narrowed, dropped, or otherwise changed.
You can process a single file or every .TPS file in a folder, from the window or from the command line for unattended runs.
How it tries to be safe
The input file is opened read-only and never written to. The new file is built beside it in a separate directory. Before anything is replaced, TPS Repair compares the new fields, keys, and indexes against the intended structure, reopens every table through the Clarion TopSpeed driver, and confirms the stored record count against the records written. Only then does it replace the original, which is kept in a verified, dated backup ZIP.
Every run produces a self-contained HTML report that distinguishes readable, unreadable, damaged, written, and withheld records. Here is a sample report.
It cannot recover deleted records, and complete recovery is never guaranteed. The report is explicit about what it could not read.
Practical details
It is a handcoded Clarion 11.1 Win32 executable. No installer, no .NET runtime, no activation, no account, no network access, and no telemetry. The program and the manual are in English and Spanish.
There is a three minute narrated recording on the home page showing a repair, an Error 47 migration, and the command line.
The free evaluation runs the complete analysis on your own data, writes the full report, and saves a limited sample you can open with your application. It never replaces or modifies your originals, so you can see exactly what it would recover before deciding anything.
Licenses are perpetual, and each includes twelve months of updates and support. Versions released during your coverage stay licensed permanently.
- Company, internal use: US$249
- Solo Consultant: US$449
- Consultancy: US$699
Introductory coupon for ClarionHub
Use the code CLARIONHUB20 at checkout for 20% off a new license:
- Valid until October 31, 2026.
- Limited to the first 50 customers.
- One use per customer.
- Applies to a new license purchase only.
- The discount applies to what you pay today. It does not change the catalog price your license is recorded at, which is the basis used to calculate any later renewal.
Finally
This has been my personal project for the last few months, built in the time I could take from regular work. I hope it is useful to someone else who opens a TPS file and finds it damaged, or ships an update and gets Error 47 from the field.
If you try it, I would really like to hear how it goes, especially on files that give it trouble. Questions and comments are welcome here, and pre-purchase or technical questions can go to tpsrep@sca.mx