[gdal-dev] odbc issue

[Andreas Oxenstierna]

I would use this method https://community.claris.com/en/s/question/0D50H00006h95LvSAI/quick-setup-for-filemaker-15-postgres-on-a-local-mac
to transfer all FileMaker data to PostgreSQL with the option to directly add geography locations as spatial geometries, 2D and 3D (PostGIS)

Best Regards / Vänliga hälsningar

Andreas Oxenstierna
Senior Strategic Advisor

+46 733 206831
andreas.oxenstierna at t-kartor.com
connect on Linkedin<https://www.linkedin.com/in/andreas-oxenstierna-52876325/>

T-Kartor Geospatial AB
Olof Mohlins väg 12
291 62 Kristianstad
www.t-kartor.com
+46 44 206 800
info at t-kartor.com

This e-mail is private and confidential between the sender and the addressee. In the event of misdirection, the recipient is prohibited from using, copying or disseminating it or any information in it. Please notify the above of any such misdirection.
On 17 Sep 2022, 02:58 +0200, Richard Greenwood <richard.greenwood at gmail.com>, wrote:
Filemaker is an old proprietary database isn't it? Is there a reason that you have to use it? QGIS has quite a bit of data processing power built in and easily connects to many FOSS databases. So I wonder if you might be better off using something better than Filemaker in the first place. Can you give us more details?

On Fri, Sep 16, 2022, 5:07 AM Marghe via gdal-dev <gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>> wrote:
Good morning,

I write because I’ve a big issue. I’m an italian archaeologist and I’m doing a PhD in an archaeological site in Spain. My project was based on doing a gis on this site, but after an year working on it, my Professor told me I need to create an automatic connection between Filemaker and QGIS, otherwise I won’t be allow to continue my Phd, that for me it’s kind of like life and death.

After some months of attempts I was able to connect the softwares through ODBC (but there are some bugs and it works only using some specific versions), but currently only filemaker can dialogue with QGIS but not vice versa. I think that the issue is that ODBC driver that filemaker use for connecting to QGIS is “read only”. I did some attempts also between filemaker and LibreOffice and I’ve the same issue, so I doubt could be that filemaker doesn’t give the permission for driver “writ”.

Anyway I read here (https://gdal.org/drivers/vector/odbc.html?fbclid=IwAR2mUiMTb9hsGLpDdSaSY_qnpny8DUTDKc49WVkPw4yvizBBnPB9JoOByX8#creation-issues) that could be also a QGIS issue, so I want to know what do you think about that and if this problem could be solved implementing that. My PhD is without scholarship (so I’m not paid for this), but I’m so desperate that I’m willing to pay for resolve this problem and, in this cane, I need to know how much would be.

Thank you so much.

Margherita Zannini

_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/gdal-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20220917/ede34d5e/attachment-0001.htm>