Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Convert from tps to csv

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:

  • Data Management Center (only lets me do the first 20 and also like 600 dollars)
  • tpsUtil (returns database must start with lm= however I can't modify database)
  • DBFView (lied, can't handle TPS files)
  • Clarion Conversion Assistant (only generates the code necessary to convert with Clarion, this still requires I buy TopSpeed)

If you know how to convert TPS to CSV you will be my hero...

like image 437
Snymax Avatar asked Dec 19 '22 19:12

Snymax


1 Answers

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.

like image 196
ctrl-alt-dev Avatar answered Dec 22 '22 07:12

ctrl-alt-dev