Sample TPS Files

questions
1

Hello.

I am working on adding Clarion support to our ETL Software: Advanced ETL Processor and
I was wondering if someone can provide us with some sample files we can use for testing,
so far I was not able to find something useful.

Thank You,
Mike

2

I’m sure you can find many simple TPS files in the standard Clarion example folders.

3

We do not have it either

4

Just curious what approach you are taking to reading the TPS files? What language are you using? (Not Clarion by the sound of it).

5

Mixture of technologies mostly Pascal (Delphi)

6

you will only be able to read them outside of clarion with the topspeed ODBC, unless you want to do file hacking. there are unsanctioned sites that tell you how to jailbreak the topspeed file format.
As for sample files ask the client you are doing this for - they should be able to provide you with what you need and verify your access is correct.

7

As far is I am aware there are there no 64bit ODBC drivers,

Our internal release can read TPS files already, we just need some examples for testing

8

correct - windows handles 32-bit just fine

9

exampleTps.zip (13.4 KB)

These are all files without a password. Files with a password are encrypted.

10

Thank you, if any one knows where I can get some large files let me know

11

This Repo has School example TPS files in the subfolders in School.Files.TPS.zip

12

Thanks. Delphi has some shared history with Clarion in that the Topspeed guys came from Borland. I saw that Delphi got 64 bit in 2011 while Clarion is still waiting some 15 years later.

Two things to be aware of

  • as mentioned above TPS files can be encrypted

  • TPS files can contain multiple tables

Sorry I am travelling with only my phone so do not have access to any files to share but if you do a web search I would think that you could find some.

13

Good point,

We just need two more files:

  • one file with multiple tables
  • and one encrypted file

And than our testing will be completed :grinning_face:

14

In this post my Zip attachment contains example Zuper.TPS with 8 tables

image
image366Ă—236 12.7 KB

15

Excellent, thank you

image
image826Ă—612 41.1 KB

16

Attached I added Password as “Password” to Zuper.TPS using TopCopy.

image
image444Ă—239 5.62 KB

SampleTps_Zuper_Pwd=Password.zip|attachment (32.1 KB)

17

Thank you everyone for your help.

We have just published a new release of Advanced ETL Processor with support for Clarion TPS files. If someone wants to try it drop us an email we will provide you with a free license