[Qgis-user] Version 3.4.7 (LTR) is locking MapInfo tab files

[Bo Victor Thomsen]

The original bug: https://github.com/qgis/QGIS/issues/29885

The original fix: https://github.com/qgis/QGIS/pull/3034

Excerpt from the bugfix:


      *rouault <https://github.com/rouault> * commented on 27 Apr 2016
      <https://github.com/qgis/QGIS/pull/3034#issuecomment-214999338>


      "Additional precision for completness. The name of the PR is maybe
      a bit misleading. It should read "concurrent opening".
      Modification in MapInfo while a dataset is opened by QGIS is not
      possible. But this was already the case with GDAL 1.X. But
      modification in QGIS is possible and MapInfo will see the changes.
      MapInfo apparently needs an exclusive access to the files to allow
      saving them. Fixing that isn't in the immediate scope of interest
      and would require both changes in GDAL and QGIS so that QGIS asks
      GDAL to close file descriptors when it doesn't need access to the
      files."

As I read this excerpt, it means that it's not possible for MapInfo to 
update a tab-file while an instance QGIS is using it whether it's for 
update or for read purposes.

I don't know if there is other bugfixes that has addressed this issue.

I've been in the same situation a while back with an organisation having 
2000 - 3000 tab files. My solution was to put all data from the tab 
files into a Postgres database and create tab files that "pointed" to 
the new tables, and let both MapInfo and QGIS users use the Postgres 
tables in stead. This was a long and exhausting process but it - for 
once and all - solved the concurrency problems.

It not the mechanical process to convert the tab-file to a table that is 
the problem. That is a task that can be solved using ex. ogr2ogr. The 
worst problem is deciding which version of each and every tab file that 
is the most current and complete and choosing this tab file for 
conversion to postgres.

Regards

Bo Victor Thomsen
GIS & Database specialist
AestasGIS Denmark






Den 25-06-2019 kl. 15:34 skrev Paul Wittle:
>
> Hi,
>
> I believe there may already be a bug ticket for this but I’ve found my 
> deployment of QGIS is causing MapInfo errors when opening MapInfo tab 
> files. It happens when you load the TAB file and also when you open 
> the project and it even happens when a TAB file is open but not 
> rendering.
>
> This is a pretty major issue for people that are looking at a 
> migration as we are so we need to get this one fixed asap. Does anyone 
> know if there is a fix being worked on or is funding required to get 
> this one fixed asap?
>
> Paul
>
> This e-mail and any files transmitted with it are intended solely for 
> the use of the individual or entity to whom they are addressed. It may 
> contain unclassified but sensitive or protectively marked material and 
> should be handled accordingly. Unless you are the named addressee (or 
> authorised to receive it for the addressee) you may not copy or use 
> it, or disclose it to anyone else. If you have received this 
> transmission in error please notify the sender immediately. All 
> traffic may be subject to recording and/or monitoring in accordance 
> with relevant legislation. Any views expressed in this message are 
> those of the individual sender, except where the sender specifies and 
> with authority, states them to be the views of Dorset Council. Dorset 
> Council does not accept service of documents by fax or other 
> electronic means. Virus checking: Whilst all reasonable steps have 
> been taken to ensure that this electronic communication and its 
> attachments whether encoded, encrypted or otherwise supplied are free 
> from computer viruses, Dorset Council accepts no liability in respect 
> of any loss, cost, damage or expense suffered as a result of accessing 
> this message or any of its attachments. For information on how Dorset 
> Council processes your information, please see 
> www.dorsetcouncil.gov.uk/416433
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190625/7387668d/attachment.html>