How to extract data from a .tps topscan Clarion file?

Question

I have to make a MySQL database from a Clarion database. The tables are .tps files.

I don't know how to do it, for now I only found applications that work with .dat files.

I found one, even if you don't have Clarion. – AlexDev Oct 19 '12 at 11:56 — AlexDev, Oct 19 '12 at 11:56

score 10 · Answer 1 · answered Jan 23 '13 at 15:59

10

I made an open-source bulk tps-to-csv conversion utility.

Its based on reverse engineering the TPS file format, so make sure you double check the results. The source (Java) can be found is available on github.

answered Jan 23 '13 at 15:59

ctrl-alt-dev

This probably only works on non-encrypted TPS files? Clarion-made EXE can have a symmetric crypto password embedded, then TPS files are different... – Arioch 'The Oct 09 '19 at 07:59
While blog posts mention encryption, the jar download page does not seem to listen command line option for the password... – Arioch 'The Oct 09 '19 at 08:16

score 2 · Answer 2 · answered Mar 29 '12 at 19:10

2

If you have a copy of Clarion, you should have the topscan.exe utility. It has an export feature.

answered Mar 29 '12 at 19:10

riffrazor

2 Answers2