In a couple of weeks I will be embarking on an attempt to convert an SKCARD format database from Sidekick to a modern DBMS.
I would much rather do this using a bash script as the alternative option is controlling mouse movements to copy/paste data from sidekick on a VM.
My issue is that the SKCARD format doesn't make much sense to me, the file seems to have an uninterpretable header, some spaces, followed by what looks like a record index with maybe record headers? The remainder of the file is the record data with separators between the fields - but no separators between the actual records?! Could the index be pointing to these locations?
Unfortunately I cannot use the Sidekick export features as the client needs the records notes which are not included in this export.
If anyone could shed some light/point me in the right direction I would be extremely grateful. I will also happily share this program with anyone who might find it useful.