On 3/9/22 00:41, Johanna Botman via Qgis-user wrote:
I am trying to use the Model Designer to automate the creation of Tab files
from SQL Database Tables.
I am using GDAL – Vector Conversion – Convert format
The resulting Tab file is missing the Primary Key field.
If use that same algorithm to export to a Geopackage, the PK is there.
I know that I can right click the SQL Table and select Export. That Tab file
contains the PK. I need to export 30 tables so am looking for some automation.
Why does the algorithm produce a table without the key field?
Hi Johanna,
Are you using 'Convert Format' which 'uses' ogr2ogr to convert?
Because in that dialog you can add 'Advanced parameters' and if I am right you
can add specific driver params there.
The 'tab'-driver though:
https://gdal.org/drivers/vector/mitab.html
does not mention a primary key...
I also found:
https://github.com/OSGeo/gdal/issues/2651
which mentions a -preserve_fid (advanced param)
see https://gdal.org/programs/ogr2ogr.html
So you can actually add some specific gdal params there...?
HTH, Regards,
Richard Duivenvoorde
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user