从tps转换为csv [英] Convert from tps to csv

问题描述

我正在编写一个基于SQL数据库的程序，以使用一个即将无法使用的Clarion 16位程序。但是，我需要得到他们的旧记录，该程序不提供远至出口，TopScan是600美元一年。有没有什么办法让我把.tps文件转换为.csv？在你开始吐出想法之前，我尝试了：

• 数据管理中心（只允许我做前20个，美元）


• tpsUtil（返回数据库必须以lm = 开头，但我无法修改数据库）


• DBFView（已处理，无法处理TPS档案）


• Clarion Conversion Assistant（只产生转换Clarion所需的程式码，这还需要我购买TopSpeed）

如果你知道如何将TPS转换为CSV，你将是我的英雄...

其名为 tps-to-csv 。 （开放）源代码位于 github

我希望您觉得有用，但请检查结果并报告任何不一致。

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...

解决方案

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.

这篇关于从tps转换为csv的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！