Hi, To my knowledge, the tab file does not need a FID column to work. I may be wrong but a geopackage must have a FID column. I am sure you could create that field afterwards in the model or create a geopackage and then a tab file.
Nicolas Cadieux https://gitlab.com/njacadieux > Le 8 mars 2022 à 18:54, Johanna Botman via Qgis-user > <[email protected]> a écrit : > > > Hi Brent, > I think that is the way that I have to go. I was hoping that it would be a > good use of the Modeller > > Johanna Botman > > Assets / GIS Officer – Melton City Council > > > > From: Brent Wood <[email protected]> > Sent: Wednesday, 9 March 2022 10:50 AM > To: [email protected]; Johanna Botman <[email protected]> > Subject: Re: Model Designer - GDAL - Vector Conversion > > You don't often get email from [email protected]. Learn why this is > important > Have you considered a script or batch file using ogr2ogr to do this for you? > > Brent Wood > > Principal Technician, Fisheries > NIWA > DDI: +64 (4) 3860529 > From: Qgis-user <[email protected]> on behalf of Johanna > Botman via Qgis-user <[email protected]> > Sent: Wednesday, March 9, 2022 12:41 > To: [email protected] <[email protected]> > Subject: [Qgis-user] Model Designer - GDAL - Vector Conversion > > 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? > > > > Johanna Botman > > Assets / GIS Officer – Melton City Council > > > > > > > *********************************************************************************** > The information in this message is privileged and confidential, intended only > for the use of the individual or entity named above. If you are not the > intended recipient you are hereby notified to delete the message and that any > dissemination, copying or use of its content is strictly prohibited. If you > have received this message in error please notify the Melton City Council. > *********************************************************************************** > > > Brent Wood > Principal Technician - GIS and Spatial Data Management > Programme Leader - Environmental Information Delivery > +64-4-386-0529 > > National Institute of Water & Atmospheric Research Ltd (NIWA) > 301 Evans Bay Parade Hataitai Wellington New Zealand > Connect with NIWA: niwa.co.nz Facebook LinkedIn Twitter Instagram > To ensure compliance with legal requirements and to maintain cyber security > standards, NIWA's IT systems are subject to ongoing monitoring, activity > logging and auditing. This monitoring and auditing service may be provided by > third parties. Such third parties can access information transmitted to, > processed by and stored on NIWA's IT systems > > *********************************************************************************** > The information in this message is privileged and confidential, intended only > for the use of the individual or entity named above. If you are not the > intended recipient you are hereby notified to delete the message and that any > dissemination, copying or use of its content is strictly prohibited. If you > have received this message in error please notify the Melton City Council. > *********************************************************************************** > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
