[Qgis-user] Model Designer - GDAL - Vector Conversion

Johanna Botman johannab at melton.vic.gov.au
Tue Mar 8 15:53:54 PST 2022


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 <Brent.Wood at niwa.co.nz>
Sent: Wednesday, 9 March 2022 10:50 AM
To: qgis-user at lists.osgeo.org; Johanna Botman <johannab at melton.vic.gov.au>
Subject: Re: Model Designer - GDAL - Vector Conversion

You don't often get email from brent.wood at niwa.co.nz. Learn why this is important<http://aka.ms/LearnAboutSenderIdentification>
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 <qgis-user-bounces at lists.osgeo.org> on behalf of Johanna Botman via Qgis-user <qgis-user at lists.osgeo.org>
Sent: Wednesday, March 9, 2022 12:41
To: qgis-user at lists.osgeo.org <qgis-user at lists.osgeo.org>
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.
***********************************************************************************
[Image removed by sender.]<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.niwa.co.nz%2F&data=04%7C01%7Cjohannab%40melton.vic.gov.au%7C35497b52fc6249b468a008da015e7723%7C3c254d694e4641f79684759dce781c6a%7C0%7C0%7C637823803053600261%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=VSV7IfG5u91AGnLYvr8ylQmjLpgHhJ%2BW3NibjZKF37k%3D&reserved=0>
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<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.niwa.co.nz%2F&data=04%7C01%7Cjohannab%40melton.vic.gov.au%7C35497b52fc6249b468a008da015e7723%7C3c254d694e4641f79684759dce781c6a%7C0%7C0%7C637823803053600261%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=VSV7IfG5u91AGnLYvr8ylQmjLpgHhJ%2BW3NibjZKF37k%3D&reserved=0> Facebook<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Fnzniwa&data=04%7C01%7Cjohannab%40melton.vic.gov.au%7C35497b52fc6249b468a008da015e7723%7C3c254d694e4641f79684759dce781c6a%7C0%7C0%7C637823803053600261%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=DLCcu%2FD09Mf2yorZo7IUo3TJ2BtuAZrVsCPiTUL%2BeMc%3D&reserved=0> LinkedIn<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fniwa&data=04%7C01%7Cjohannab%40melton.vic.gov.au%7C35497b52fc6249b468a008da015e7723%7C3c254d694e4641f79684759dce781c6a%7C0%7C0%7C637823803053600261%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=51IDCM2rd5aubYCqFtEd0oScjzUTOARrfFrctXT%2BakU%3D&reserved=0> Twitter<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Fniwa_nz&data=04%7C01%7Cjohannab%40melton.vic.gov.au%7C35497b52fc6249b468a008da015e7723%7C3c254d694e4641f79684759dce781c6a%7C0%7C0%7C637823803053600261%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=qJOa9nDthJ6VOixtl%2B47cXTAjQVvm2O9EMB84OpzmFg%3D&reserved=0> Instagram<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fniwa_science&data=04%7C01%7Cjohannab%40melton.vic.gov.au%7C35497b52fc6249b468a008da015e7723%7C3c254d694e4641f79684759dce781c6a%7C0%7C0%7C637823803053600261%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=SUHp123tXGidXH0IUfVcE9dxChMBbWIsJv52pQiKGIU%3D&reserved=0>
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.
***********************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220308/2fce3edb/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ~WRD0001.jpg
Type: image/jpeg
Size: 823 bytes
Desc: ~WRD0001.jpg
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220308/2fce3edb/attachment-0001.jpg>


More information about the Qgis-user mailing list