Expert Needed: Clarion 5 / TopSpeed Data Extraction & Relational Key Mapping

Posted 3 weeks ago

Worldwide

Summary

What I have I have the data directory of an old Greek medical application built in Clarion (Clarion 5 — the install includes C5runx.dll, C5TPS.DLL, C5clax.dll and related library DLLs). It's a straightforward export job, not a big migration. The files - *.mfi — the data tables. Each starts with signature bytes C3, is XOR-encrypted, and holds Greek text in the windows-1253 codepage. - *.K01 … .K0E — the matching Clarion index/key files. - *.MEM — memo/long-text fields (signature M3, also XOR-encrypted). - I also have the original application EXE and library DLLs, which contain the table/field definitions. What I actually need I only need 4 specific tables exported — the patient table plus a few related clinical data tables. I do NOT need the whole database (it has ~200 tables); just these four, complete and correct. What's wrong right now I already have a working extraction attempt (a Python script) that decrypts the files and reads the data — so reading the format is basically solved. The problem is it doesn't reconstruct the relationships between tables: it can't reliably link a patient record to that patient's rows in the related data tables (the foreign-key / linking field isn't being matched correctly). So I get the data, but it isn't joined back to the right patient. So the task is: 1. Read these 4 tables correctly (fields, types, Greek text, memos). 2. Identify the key field(s) that link the patient table to the related tables, and join them properly so every data row is tied to the correct patient. 3. Export the result to clean CSV (or Excel/SQL — your call), correctly aligned and complete. Ideal experience - Hands-on with Clarion (Clarion 5 / TopSpeed) and its file drivers (.DAT / .TPS / .Kxx index files). Bonus for the TopSpeed ODBC driver or writing Clarion export utilities. - Comfortable identifying Clarion keys/relations and Greek (windows-1253) encoding. Important: This is medical data, so an NDA is required before any files are shared. I can provide redacted/sample files first so you can confirm you can read the format and the relations before we commit. Timeline: No hard deadline, but since this is a simple export I'd like it done fast. Deliverables: the 4 tables exported to CSV (or SQL), correctly joined patient-to-data, plus a short note on the method so it's reproducible. Please tell me your approach (Clarion itself / TopSpeed driver / custom parser) and a rough cost. This project is instantly paid upon completion.

  • $80.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Data Integration
Data Extraction
Activity on this job
  • Proposals:10 to 15
  • Last viewed by client:5 days ago
  • Interviewing:
    9
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Dec 29, 2025
  • GRC
    Koropi5:57 PM
  • $650 total spent
    1 hire, 0 active
  • Tech & IT
    Small company (2-9 people)

Explore similar jobs on Upwork

Local Lead GenerationHourly‐ Posted 2 weeks ago
Web Scraping
Data Scraping
Data Extraction
Lead Generation
Data Entry
Data Mining
Data Collection
Data Processing
Web Scraping Framework
Web Crawler Framework
Web Scraping Software
Web Scraping Plugin
Web API
Search Tool
Search Engine
Microsoft Word
Data Entry
Administrative Support
Microsoft Excel

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo