Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Location
    Wonder Lake, Illinois, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing from Clarion??? (2ksr1)

    There used to be a gentleman that worked here...He used Clarion to create some applications (his own time and software). He now, no longer works here....

    I need to get the data that was entered in with those Clarion applications into Microsoft Access 2000. All of the databases have a .tps extension.

    Anyone have any ideas on how to convert these .tps files into any format that's usable for me??

    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Importing from Clarion??? (2ksr1)

    I don't think Access knows about Clarion databases. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Can you use Clarion to export their tables to txt files (comma delimited or fixed width), if so it's then a breeze to import them from txt files into Access.
    Is a Clarion database made up of many files, or is it just one file like Access?
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Location
    Wonder Lake, Illinois, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing from Clarion??? (2ksr1)

    YUP...Dat's my problem.... MS Access does not seem to wanna play with those tps files created by that Clarion app. The person that created the applications used his personal copy of the software to create the applications on his own time at home....for some reason, people here started using them. SO, I don't have Clarion here. I don't even know anything about Clarion with the exception of what I've learned trying to extract the data.

    It appears that there is an odbc driver that I could purchace however, I'm not in the mood to pay $250 for a one time conversion. The applications themselves will no longer work as this guy coded per server name instead of drive letter (e.g servernamesharenamefolderfile as opposed to M:blablawoofwooffile.tps) meaning, that I cannot even run the apps to see if there is an export option. AND others beyond my control have already re-ghosted the old server so I cannot get the old path restored for the files in order for the screwy clarion app to open the data

    I'm not MR. Clarion so... It does seem like the database is composed of a single file.... filename.tps like Access' filename.mdb

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Importing from Clarion??? (2ksr1)

    It seems to me that the purchase of the ODBC driver is your best bet, the $250 could be well worth the spend. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Will your workplace purchase it for you?
    Pat

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing from Clarion??? (2ksr1)

    You could try this link. You might then be able to use Perl to extract the data and make a text file. I haven't tried it but if you want to spend TIME rather than MONEY it could be the way to go.

    http://www.openclarion.org/
    David Grugeon
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •