+- Python Forum (https://python-forum.io)
+-- Forum: Forum & Off Topic (https://python-forum.io/forum-23.html)
+--- Forum: Bar (https://python-forum.io/forum-27.html)
+--- Thread: Legacy database (/thread-42085.html)
Legacy database - DPaul - May-07-2024
Hi,
I have been handed a legacy database. It's something called 'filemaker pro',
and I have reason to believe : release 13.
Next to a bunch of dlls, there is something that might be the database with an extension "xxx.fmpur"
Anybody any idea of how to read this with python?
Paul
RE: Legacy database - Larz60+ - May-07-2024
this looks promising: Convert FileMaker Pro databases to several convenient formats
RE: Legacy database - DPaul - May-07-2024
(May-07-2024, 06:32 AM)Larz60+ Wrote: this looks promising: Convert FileMaker Pro databases to several convenient formatsHi Larz,
Thanks.
Promising indeed, but very far from my confort zone.
Hacking on a bit level ? The extension (.fmpur) seems to point at an fmp12 type database.
But compiled on an Apple computer?
The presumed "database" is 126 mb , that is a lot of text. Somebody spent many years transcribing all this stuff.
I believe it's notary records from centuries ago. Pity.
I'll post something on the FMP forum, but unless somebody has an Apple with a very old release of FMP, .....
Paul
RE: Legacy database - Larz60+ - May-08-2024
Actually, 126 Mb for a database is quite small, a good part of it is DBMS management overhead.
There is a filemaker server for python here.
I'm not going to spend the time to see if it will do what you need, but you should be able to determaine that with small effort.
RE: Legacy database - DPaul - May-08-2024
(May-08-2024, 08:45 AM)Larz60+ Wrote: There is a filemaker server for python here.Almost
They require you to open filemaker pro and activate some feature.
That is exactly what I can't do.
I tried to post my question on 2 Filemaker pro fora. Release 12 is filed under "archive",
they don't accept questions for it any more.
But the source data are not lost. Somebody will have to redo the whole transcription.
We have a vague idea what it is. And if it are 16 -17th century handwritten texts, you are in for a treat.
Thanks,
Paul