<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-AU" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Thank you for the follow up, Nicolas,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">I’ll spend a little more time on learning to insert that ID column. I tried the Convert to Geopackage and then to TAB files, but that was not satisfactory. The ID column was still missing</span><b><span style="font-size:12.0pt"><o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt">Johanna Botman<o:p></o:p></span></b></p>
<p class="MsoNormal">Assets / GIS Officer – Melton City Council<o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Nicolas Cadieux <njacadieux.gitlab@gmail.com>
<br>
<b>Sent:</b> Thursday, 10 March 2022 9:25 AM<br>
<b>To:</b> Johanna Botman <johannab@melton.vic.gov.au><br>
<b>Cc:</b> Brent Wood <Brent.Wood@niwa.co.nz>; qgis-user@lists.osgeo.org<br>
<b>Subject:</b> Re: [Qgis-user] Model Designer - GDAL - Vector Conversion<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt">
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:10.0pt"><o:p> </o:p></span></p>
</td>
<td width="100%" style="width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt">
<div>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121">You don't often get email from
<a href="mailto:njacadieux.gitlab@gmail.com">njacadieux.gitlab@gmail.com</a>. <a href="http://aka.ms/LearnAboutSenderIdentification">
Learn why this is important</a><o:p></o:p></span></p>
</div>
</td>
<td width="75" style="width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt;align:left">
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal">Hi, <o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">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. <o:p></o:p></p>
<div>
<p class="MsoNormal">Nicolas Cadieux <o:p></o:p></p>
<div>
<p class="MsoNormal"><a href="https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgitlab.com%2Fnjacadieux&data=04%7C01%7Cjohannab%40melton.vic.gov.au%7Cae271fe7ceb24fff072908da021ba93c%7C3c254d694e4641f79684759dce781c6a%7C0%7C0%7C637824615822762561%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=9c4yD6%2BappZe3O6nztd2pReFpgLP4qjZNe5VWREHH3E%3D&reserved=0">https://gitlab.com/njacadieux</a><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="margin-bottom:12.0pt">Le 8 mars 2022 à 18:54, Johanna Botman via Qgis-user <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>> a écrit :<o:p></o:p></p>
</blockquote>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hi Brent,</span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">I think that is the way that I have to go. I was hoping that it would be a good use of the Modeller</span><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt"> </span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt">Johanna Botman</span></b><o:p></o:p></p>
<p class="MsoNormal">Assets / GIS Officer – Melton City Council<span style="mso-fareast-language:EN-US"> </span><o:p></o:p></p>
</div>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Brent Wood <<a href="mailto:Brent.Wood@niwa.co.nz">Brent.Wood@niwa.co.nz</a>>
<br>
<b>Sent:</b> Wednesday, 9 March 2022 10:50 AM<br>
<b>To:</b> <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>; Johanna Botman <<a href="mailto:johannab@melton.vic.gov.au">johannab@melton.vic.gov.au</a>><br>
<b>Subject:</b> Re: Model Designer - GDAL - Vector Conversion</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt"></td>
<td width="100%" style="width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt">
<div>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121">You don't often get email from
<a href="mailto:brent.wood@niwa.co.nz">brent.wood@niwa.co.nz</a>. <a href="http://aka.ms/LearnAboutSenderIdentification">
Learn why this is important</a></span><o:p></o:p></p>
</div>
</td>
<td width="75" style="width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt;align:left">
</td>
</tr>
</tbody>
</table>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Have you considered a script or batch file using ogr2ogr to do this for you?</span><o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> </span><o:p></o:p></p>
</div>
<div id="Signature">
<div>
<div name="divtagdefaultwrapper">
<div>
<div>
<p class="MsoNormal">Brent Wood<br>
<br>
Principal Technician, Fisheries<br>
NIWA<br>
DDI: +64 (4) 3860529<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> Qgis-user <<a href="mailto:qgis-user-bounces@lists.osgeo.org">qgis-user-bounces@lists.osgeo.org</a>> on behalf of Johanna Botman via Qgis-user <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>
<b>Sent:</b> Wednesday, March 9, 2022 12:41<br>
<b>To:</b> <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a> <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>
<b>Subject:</b> [Qgis-user] Model Designer - GDAL - Vector Conversion</span> <o:p>
</o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal">I am trying to use the Model Designer to automate the creation of Tab files from SQL Database Tables.<o:p></o:p></p>
<p class="xmsonormal">I am using GDAL – Vector Conversion – Convert format<o:p></o:p></p>
<p class="xmsonormal">The resulting Tab file is missing the Primary Key field.<o:p></o:p></p>
<p class="xmsonormal">If use that same algorithm to export to a Geopackage, the PK is there.<o:p></o:p></p>
<p class="xmsonormal">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.<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Why does the algorithm produce a table without the key field?<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"><b><span style="font-size:12.0pt">Johanna Botman</span></b><o:p></o:p></p>
<p class="xmsonormal">Assets / GIS Officer – Melton City Council<o:p></o:p></p>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<p><br>
***********************************************************************************<br>
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.<br>
***********************************************************************************</p>
</body>
</html>