<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=us-ascii">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Arial",sans-serif;
color:black;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">Im using QGIS 3.4.4 on windows, it’s have issue when using the offline tool using either GeoPackage or SQLite , dates are producing this error:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:41 WARNING Offline Editing Plugin : FEATREL: Unknown data type QDate. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:41 WARNING Offline Editing Plugin : ATTRREL: Unknown data type QDate. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:41 WARNING Offline Editing Plugin : CREATED: Unknown data type QDate. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:42 WARNING Offline Editing Plugin : RETIRED: Unknown data type QDate. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:49 WARNING Offline Editing Plugin : ERROR: 101905 feature(s) not added - geometry type is not compatible with the current layer.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:49 WARNING Offline Editing Plugin : DateCollected: Unknown data type QDate. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:49 WARNING Offline Editing Plugin : DateModified: Unknown data type QDate. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : ERROR: 10 feature(s) not added - geometry type is not compatible with the current layer.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : Reg_Date: Unknown data type QDateTime. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : Reg_Renew_Date: Unknown data type QDateTime. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : Rep_Date: Unknown data type QDateTime. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : Ann_Exp_Date: Unknown data type QDateTime. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : Start_Date: Unknown data type QDate. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : Start_Time: Unknown data type QTime. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : End_Date: Unknown data type QDate. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : End_Time: Unknown data type QTime. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : Grant_Date: Unknown data type QDate. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:50 WARNING Offline Editing Plugin : Grant_Time: Unknown data type QTime. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:51 WARNING Offline Editing Plugin : Load_Date: Unknown data type QDateTime. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:51 WARNING Offline Editing Plugin : Modified_Date: Unknown data type QDateTime. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:15:51 WARNING Offline Editing Plugin : Expiry_Date: Unknown data type QDateTime. Not using type affinity for the field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">2019-01-30T10:17:15 WARNING Commit errors : Could not commit changes to layer tblSPAUSTRoadNetwork (offline)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">In the DB Manager I can see the dates are missing type in the table structure<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">The source for this data is MSSQL 2012.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black">Kind Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td width="155" valign="top" style="width:116.3pt;border:none;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><img width="153" height="143" style="width:1.5937in;height:1.4895in" id="Picture_x0020_1" src="cid:image001.jpg@01D4B885.5B531640" alt="RDG-Logo-Tagline"></span><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:JA"><o:p></o:p></span></p>
</td>
<td width="424" valign="top" style="width:317.8pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal" style="margin-bottom:6.0pt"><b><span lang="EN-GB" style="font-size:13.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:JA">Chris Franklin
<br>
</span></b><b><i><span lang="EN-GB" style="font-family:"Arial",sans-serif;color:black;mso-fareast-language:JA">Senior GIS Officer</span></i></b><span lang="EN-GB" style="font-family:"Arial",sans-serif;color:black;mso-fareast-language:JA">
<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:6.0pt"><span lang="EN-GB" style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:JA">Level 2, Australia Place, 15 - 17 William Street<br>
Perth, Western Australia 6000<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:3.0pt"><b><span lang="EN-GB" style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:JA">T:</span></b><span lang="EN-GB" style="font-size:9.5pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:JA">
+61 8 9261 6100 <b>|</b> <b>D:</b> +61 8 9261 6127 <b>|</b> <b>M:</b> +61 420 665660<b><o:p></o:p></b></span></p>
<p class="MsoNormal" style="margin-bottom:3.0pt"><span style="color:black;mso-fareast-language:EN-AU"><a href="http://www.rml.com.au/"><b><span lang="EN-GB" style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#0563C1;mso-fareast-language:JA">www.rml.com.au</span></b></a></span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:JA"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:JA"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:7.0pt;color:#A6A6A6;mso-fareast-language:EN-AU">Please consider the environment before printing this email.<o:p></o:p></span></b></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:7.0pt;color:#A6A6A6;mso-fareast-language:EN-AU">This email and any attached files are confidential and may be legally privileged. If you are not the intended recipient, any disclosure, reproduction, copying,
distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error, please notify the sender immediately and then delete this email. Email transmission cannot be guaranteed to be secure
or error free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore is in no way liable for any errors or omissions in the content of this message, which may arise as a result of
email transmission. If verification is required, please request a hard copy.<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>