# Sample TPS Files

**URL:** <https://clarionhub.com/t/sample-tps-files/9108>\
**Category:** questions\
**Tags:** tps\
**Created:** [May 14, 2026, 9:30am UTC](https://clarionhub.com/t/sample-tps-files/9108 "2026-05-14T09:30:38Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![E.Mike](https://clarionhub.com/letter_avatar_proxy/v4/letter/e/6de8d8/32.png) [@E.Mike](https://clarionhub.com/u/E.Mike)\
**Post date:** [May 14, 2026, 9:30am UTC](https://clarionhub.com/t/sample-tps-files/9108/1 "2026-05-14T09:30:38Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Clarion\_clarion](https://clarionhub.com/user_avatar/clarionhub.com/clarion_clarion/32/636_2.png) [@Clarion\_clarion](https://clarionhub.com/u/Clarion_clarion)\
**Post date:** [May 14, 2026, 10:02am UTC](https://clarionhub.com/t/sample-tps-files/9108/2 "2026-05-14T10:02:54Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![E.Mike](https://clarionhub.com/letter_avatar_proxy/v4/letter/e/6de8d8/32.png) [@E.Mike](https://clarionhub.com/u/E.Mike)\
**Post date:** [May 14, 2026, 10:09am UTC](https://clarionhub.com/t/sample-tps-files/9108/3 "2026-05-14T10:09:24Z")

</div>

We do not have it either

---

<div class="post-metadata">

**Author:** ![vitesse](https://clarionhub.com/user_avatar/clarionhub.com/vitesse/32/837_2.png) [@vitesse](https://clarionhub.com/u/vitesse)\
**Post date:** [May 14, 2026, 11:19am UTC](https://clarionhub.com/t/sample-tps-files/9108/4 "2026-05-14T11:19:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![E.Mike](https://clarionhub.com/letter_avatar_proxy/v4/letter/e/6de8d8/32.png) [@E.Mike](https://clarionhub.com/u/E.Mike)\
**Post date:** [May 14, 2026, 12:04pm UTC](https://clarionhub.com/t/sample-tps-files/9108/5 "2026-05-14T12:04:47Z")

</div>

Mixture of technologies mostly Pascal (Delphi)

---

<div class="post-metadata">

**Author:** ![KevinErskine](https://clarionhub.com/user_avatar/clarionhub.com/kevinerskine/32/711_2.png) [@KevinErskine](https://clarionhub.com/u/KevinErskine)\
**Post date:** [May 14, 2026, 2:32pm UTC](https://clarionhub.com/t/sample-tps-files/9108/6 "2026-05-14T14:32:29Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![E.Mike](https://clarionhub.com/letter_avatar_proxy/v4/letter/e/6de8d8/32.png) [@E.Mike](https://clarionhub.com/u/E.Mike)\
**Post date:** [May 14, 2026, 2:37pm UTC](https://clarionhub.com/t/sample-tps-files/9108/7 "2026-05-14T14:37:32Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![KevinErskine](https://clarionhub.com/user_avatar/clarionhub.com/kevinerskine/32/711_2.png) [@KevinErskine](https://clarionhub.com/u/KevinErskine)\
**Post date:** [May 14, 2026, 2:45pm UTC](https://clarionhub.com/t/sample-tps-files/9108/8 "2026-05-14T14:45:52Z")

</div>

correct - windows handles 32-bit just fine

---

<div class="post-metadata">

**Author:** ![Bruce](https://clarionhub.com/letter_avatar_proxy/v4/letter/b/ccd318/32.png) [@Bruce](https://clarionhub.com/u/Bruce)\
**Post date:** [May 14, 2026, 3:52pm UTC](https://clarionhub.com/t/sample-tps-files/9108/9 "2026-05-14T15:52:04Z")

</div>

[exampleTps.zip](https://clarionhub.com/uploads/short-url/tSRXRMiZIs6wTJVOS1Ec1I2bSJ.zip) (13.4 KB)

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

---

<div class="post-metadata">

**Author:** ![E.Mike](https://clarionhub.com/letter_avatar_proxy/v4/letter/e/6de8d8/32.png) [@E.Mike](https://clarionhub.com/u/E.Mike)\
**Post date:** [May 14, 2026, 3:56pm UTC](https://clarionhub.com/t/sample-tps-files/9108/10 "2026-05-14T15:56:13Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![CarlBarnes](https://clarionhub.com/user_avatar/clarionhub.com/carlbarnes/32/1859_2.png) [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\
**Post date:** [May 14, 2026, 6:46pm UTC](https://clarionhub.com/t/sample-tps-files/9108/11 "2026-05-14T18:46:09Z")

</div>

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

> **[GitHub - CarlTBarnes/Legacy-ABC-Coexist: Legacy and ABC Coexisting in the same solution](https://github.com/CarlTBarnes/Legacy-ABC-Coexist)**
>
> Legacy and ABC Coexisting in the same solution

---

<div class="post-metadata">

**Author:** ![vitesse](https://clarionhub.com/user_avatar/clarionhub.com/vitesse/32/837_2.png) [@vitesse](https://clarionhub.com/u/vitesse)\
**Post date:** [May 15, 2026, 1:39am UTC](https://clarionhub.com/t/sample-tps-files/9108/12 "2026-05-15T01:39:49Z")

</div>

> [@E.Mike](#):
>
> Mixture of technologies mostly Pascal (Delphi)

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.

---

<div class="post-metadata">

**Author:** ![E.Mike](https://clarionhub.com/letter_avatar_proxy/v4/letter/e/6de8d8/32.png) [@E.Mike](https://clarionhub.com/u/E.Mike)\
**Post date:** [May 18, 2026, 12:29pm UTC](https://clarionhub.com/t/sample-tps-files/9108/13 "2026-05-18T12:29:10Z")

</div>

Good point,

We just need two more files:

- one file with multiple tables
- and one encrypted file

And than our testing will be completed 😀

---

<div class="post-metadata">

**Author:** ![CarlBarnes](https://clarionhub.com/user_avatar/clarionhub.com/carlbarnes/32/1859_2.png) [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\
**Post date:** [May 18, 2026, 2:02pm UTC](https://clarionhub.com/t/sample-tps-files/9108/14 "2026-05-18T14:02:40Z")

</div>

> [@E.Mike](#):
>
> one file with multiple tables

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

> [@Generically Remove or Rename a specific TPS Table in a Superfile](https://clarionhub.com/t/generically-remove-or-rename-a-specific-tps-table-in-a-superfile/8887/12):
>
> A way to list all the Tables inside a Super TPS file e.g. TpsTableList Zuper This is done using a feature of the TPS Driver SEND(File,'PNM=...). This requires a Table be Open … so you have to know the Structure unamused_face. To work around that I Create() my own Table \_\_List-Tps-Temp-File\_\_ that I can open. To not alter the original TPS file I make a Copy() and Create() in that. This is what I came up … alternative ways or ideas ??? PROGRAM !TpsTableList.exe Utility by Carl Ba…

 ![image](https://clarionhub-uploads.s3.dualstack.eu-north-1.amazonaws.com/original/2X/7/7785fe756ce3f59918d186f055644fc450e5bb32.png)

---

<div class="post-metadata">

**Author:** ![E.Mike](https://clarionhub.com/letter_avatar_proxy/v4/letter/e/6de8d8/32.png) [@E.Mike](https://clarionhub.com/u/E.Mike)\
**Post date:** [May 18, 2026, 2:11pm UTC](https://clarionhub.com/t/sample-tps-files/9108/15 "2026-05-18T14:11:35Z")

</div>

Excellent, thank you

 ![image](https://clarionhub-uploads.s3.dualstack.eu-north-1.amazonaws.com/original/2X/1/1cc59405fcb9b58366ee1d5afc43ec90dad4fb80.png)

---

<div class="post-metadata">

**Author:** ![CarlBarnes](https://clarionhub.com/user_avatar/clarionhub.com/carlbarnes/32/1859_2.png) [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\
**Post date:** [May 18, 2026, 4:17pm UTC](https://clarionhub.com/t/sample-tps-files/9108/16 "2026-05-18T16:17:27Z")

</div>

> [@E.Mike](#):
>
> and one encrypted file

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

 ![image](https://clarionhub-uploads.s3.dualstack.eu-north-1.amazonaws.com/original/2X/a/a4eb1a43132da5c9caa861e92973687e5053cae9.png)

[SampleTps\_Zuper\_Pwd=Password.zip|attachment](https://clarionhub.com/uploads/short-url/q6MxbmVgLWDb5rBl8Z46kgsQVVF.zip) (32.1 KB)

---

<div class="post-metadata">

**Author:** ![E.Mike](https://clarionhub.com/letter_avatar_proxy/v4/letter/e/6de8d8/32.png) [@E.Mike](https://clarionhub.com/u/E.Mike)\
**Post date:** [May 20, 2026, 8:19am UTC](https://clarionhub.com/t/sample-tps-files/9108/17 "2026-05-20T08:19:35Z")

</div>

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

> **[Advanced ETL Processor - 6.5.0](https://www.etl-tools.com/articles/advanced-etl-processor-6-5-0.html)**
>
> Advanced ETL Processor 6.5.0 introduces Clarion Top Speed Source support, and various bug fixes and performance enhancements . Download the latest version today.
