Expert Needed: Clarion 5 / TopSpeed Data Extraction & Relational Key Mapping
Budget: $80.0
FIXED /
⭐ 4.80 (1)
GRC
data-source-integration, data-extraction, data-scraping, data-analysis
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.
Open job