I am writing a program based on an SQL database to take the base of a Clarion 16 bit program which is soon to be non functional. However, I need to get their old records and the program does not offer much as far as export, and TopScan is like 600 dollars for a year. Is there any way for me to convert the .tps files they have to .csv? Before you start spitting out ideas here's what I've tried:
database must start with lm=
however I can't modify database)If you know how to convert TPS to CSV you will be my hero...
Faced with a similar situation last year I reverse engineered the Clarion TPS file format and wrote a utility to do the conversion to proper CSV.
Its called tps-to-csv. It's (open) source code is on github
I hope you find it useful, but please do check the results and report any inconsistencies.