<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:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Time new Roman";
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* 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;}
span.gmailsignatureprefix
{mso-style-name:gmail_signature_prefix;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
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="DE" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Tahoma",sans-serif;mso-fareast-language:EN-US">Dear Totò,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Tahoma",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Tahoma",sans-serif;mso-fareast-language:EN-US">thank you very much. This solves my problem. Explicitly defining datatypes that are allowed in a geopackage and formatting the date and time values in
the csv-file accordingly leads to the required result.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Tahoma",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Tahoma",sans-serif;mso-fareast-language:EN-US">Best regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Tahoma",sans-serif;mso-fareast-language:EN-US">Michael<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Von:</b> Totò Fiandaca <pigrecoinfinito@gmail.com> <br>
<b>Gesendet:</b> Mittwoch, 20. <span lang="EN-GB">November 2024 17:18<br>
<b>An:</b> Reetz, Michael (NLPVW) <Michael.Reetz@nlpvw.niedersachsen.de><br>
<b>Cc:</b> qgis-user@lists.osgeo.org<br>
<b>Betreff:</b> Re: [Qgis-user] Export from csv layer to geopackage changes date and time attributes to string<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="background:white;padding:.75pt .75pt .75pt .75pt">
<p style="margin-bottom:11.25pt"><span style="font-size:10.0pt;font-family:"Time new Roman",serif;color:red;background:#DBE5F1;mso-fareast-language:EN-US">ACHTUNG!!</span><span style="font-size:10.0pt;font-family:"Time new Roman",serif;color:black;background:#DBE5F1;mso-fareast-language:EN-US"> Diese
E-Mail erreicht Sie von einem Absender außerhalb der niedersächsischen Landesverwaltungs-Infrastruktur mit TLS-Verschlüsselung. Bitte klicken Sie auf keine Links oder öffnen Sie keine E-Mail-Anhänge, falls Sie den Absender nicht kennen und nicht wissen, ob
der Inhalt sicher ist.</span><span style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:EN-US"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<div>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:18.0pt;font-family:"Garamond",serif;color:white">Try to create the auxiliary file of the cs</span><span lang="EN-GB" style="font-size:18.0pt;font-family:"Garamond",serif">v file, that is, the file with
the same name as the csv file, but with the extension csvt.<br>
The csvt file has only one line and contains the data type.<br>
<br>
</span><a href="https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/"><span style="font-size:18.0pt;font-family:"Garamond",serif">https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/</span></a><span style="font-size:18.0pt;font-family:"Garamond",serif"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:18.0pt;font-family:"Garamond",serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="FR" style="font-size:18.0pt;font-family:"Garamond",serif">saluti<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt">Il giorno mer 20 nov 2024 alle ore 17:02 Reetz, Michael (NLPVW) via QGIS-User <</span><a href="mailto:qgis-user@lists.osgeo.org"><span lang="FR" style="font-size:10.0pt">qgis-user@lists.osgeo.org</span></a><span lang="FR" style="font-size:10.0pt">>
ha scritto:<o:p></o:p></span></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB" style="font-family:"Tahoma",sans-serif">Dear all,</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB" style="font-family:"Tahoma",sans-serif"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB" style="font-family:"Tahoma",sans-serif">I have added a csv file as layer to my project. Date and time columns are identified correctly. Now I’m trying to export
the layer into a geopackage. The date and time attributes are all changed into strings although date and datetime are possible in a geopackage (as far as I know). Any idea why this happens and how to work around this?</span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB" style="font-family:"Tahoma",sans-serif"> </span><span lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">Best regards</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif">Michael</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:9.0pt;font-family:"Tahoma",sans-serif">*****************************************
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:9.0pt;font-family:"Tahoma",sans-serif">Michael Reetz</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:9.0pt;font-family:"Tahoma",sans-serif">Datenbanken und Anwendungsentwicklung<br>
Nationalpark-Verwaltung Niedersächsisches Wattenmeer <br>
Virchowstr. 1 | 26382 Wilhelmshaven <br>
Tel.: +49 (0) 4421 911 291 <br>
e-mail: </span><a href="mailto:michael.reetz@nlpv-wattenmeer.niedersachsen.de" target="_blank"><span style="font-size:9.0pt;font-family:"Tahoma",sans-serif">michael.reetz@nlpvw.niedersachsen.de</span></a><span style="font-size:9.0pt;font-family:"Tahoma",sans-serif">
<br>
Web: </span><a href="https://www./" target="_blank"><span style="font-size:9.0pt;font-family:"Tahoma",sans-serif">https://www.</span></a><a href="http://nationalpark-wattenmeer.de" target="_blank"><span style="font-size:9.0pt;font-family:"Tahoma",sans-serif">nationalpark-wattenmeer.de</span></a><span style="font-size:9.0pt;font-family:"Tahoma",sans-serif">
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><img border="0" width="219" height="118" style="width:2.2812in;height:1.2291in" id="m_-749140457519929684Grafik_x0020_1" src="cid:image001.png@01DB3BEA.D1E3B9B0"><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-GB"> <o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt">_______________________________________________<br>
QGIS-User mailing list<br>
</span><a href="mailto:QGIS-User@lists.osgeo.org" target="_blank"><span lang="EN-GB" style="font-size:10.0pt">QGIS-User@lists.osgeo.org</span></a><span lang="EN-GB" style="font-size:10.0pt"><br>
List info: </span><a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank"><span lang="EN-GB" style="font-size:10.0pt">https://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><span lang="EN-GB" style="font-size:10.0pt"><br>
Unsubscribe: </span><a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank"><span lang="EN-GB" style="font-size:10.0pt">https://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><span lang="EN-GB" style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
</blockquote>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt"><br clear="all">
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span class="gmailsignatureprefix"><span lang="EN-GB" style="font-size:10.0pt">--
</span></span><span lang="EN-GB" style="font-size:10.0pt"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">Ing. Salvatore Fiandaca</span></b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif"><br>
<b>mobile</b>.:+39 327.493.8955 <br>
<b>m</b>: </span><a href="mailto:pigrecoinfinito@gmail.com" target="_blank"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">pigrecoinfinito@gmail.com</span></b></a><span lang="EN-GB" style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">C.F</span></b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">.: FNDSVT71E29Z103G</span><span lang="EN-GB" style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">P.IVA</span></b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">: 06597870820</span><span lang="EN-GB" style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">membro QGIS Italia -
</span></b><a href="http://qgis.it/" target="_blank"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">http://qgis.it/</span></b></a><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif"><br>
<b>socio GFOSS.it - </b></span><a href="http://gfoss.it/" target="_blank"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">http://gfoss.it/</span></b></a><span lang="EN-GB" style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span lang="EN-GB" style="font-size:10.0pt">member OSGeo</span></b><span lang="EN-GB" style="font-size:10.0pt"> - </span><a href="https://www.osgeo.org/member/fiandaca/" target="_blank"><b><span lang="EN-GB" style="font-size:10.0pt">https://www.osgeo.org/member/fiandaca/</span></b></a><span lang="EN-GB" style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">blog:</span></b><a href="https://pigrecoinfinito.com/" target="_blank"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif"> https://pigrecoinfinito.com/</span></b></a><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif"> <br>
FB: Co-admin - </span></b><a href="https://www.facebook.com/qgis.it/" target="_blank"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Garamond",serif">https://www.facebook.com/qgis.it/</span></b></a><a href="https://www.facebook.com/qgis.it/" target="_blank"><b><span lang="EN-GB" style="font-size:12.0pt;font-family:"Garamond",serif"> </span></b></a><b><span lang="EN-GB" style="font-size:12.0pt;font-family:"Garamond",serif"> </span></b><span lang="EN-GB" style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Garamond",serif">TW:</span></b><a href="http://goog_95411464" target="_blank"><b><span style="font-size:12.0pt;font-family:"Garamond",serif"> </span></b></a><a href="https://twitter.com/totofiandaca" target="_blank"><b><span style="font-size:10.0pt;font-family:"Garamond",serif">https://twitter.com/totofiandaca</span></b></a><span style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif">37°35'11.4"N 14°10'25.1"E - EPSG:4326</span><span style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">“Se la conoscenza deve essere aperta a tutti,</span><span lang="FR" style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">perchè mai limitarne l’accesso?” </span><span lang="FR" style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">R. Stallman<br>
<br>
</span><span lang="FR" style="font-size:7.5pt;font-family:"Trebuchet MS",sans-serif">Questo documento, allegati inclusi, contiene informazioni di proprietà di FIANDACA SALVATORE e deve essere utilizzato esclusivamente dal destinatario in relazione alle finalità
per le quali è stato ricevuto. E' vietata qualsiasi forma di riproduzione o divulgazione senza l'esplicito consenso di FIANDACA SALVATORE. Qualora fosse stato ricevuto per errore si prega di informare tempestivamente il mittente e distruggere la copia in proprio
possesso.<br>
</span><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif"><br>
<br>
</span><span lang="FR" style="font-size:10.0pt"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>