<html><head></head><body>Può essere che il problema nasca dal campo id già popolato?<br><br><div class="gmail_quote">On 14 August 2019 11:29:01 EEST, antonio valanzano <anvalanz@gmail.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr"><div>Il contenuto del log "Generale" è il seguente:</div><div><font size="1"><br></font></div><div><font size="1">
</font><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><font size="1"><span style="color:rgb(0,0,0)">2019-08-14T10:01:34 INFO </span>Avvio di QGIS...</font></p><font size="1">
</font><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><font size="1"><span style="color:rgb(0,0,0)">2019-08-14T10:01:37 INFO </span>Supporto Python ABILITATO :-) </font></p><font size="1">
</font><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><font size="1"><span style="color:rgb(0,0,0)">2019-08-14T10:02:23 INFO </span>Stato applicazione:<br> QGIS_PREFIX_PATH var amb: C:/OSGeo4W/apps/qgis<br> Prefisso: C:/OSGeo4W/apps/qgis<br> Percorso del plugin: C:/OSGeo4W/apps/qgis/plugins<br> Percorso pacchetto dati: C:/OSGeo4W/apps/qgis/.<br> Nome tema attivo: default<br> Percorso tema attivo: C:/OSGeo4W/apps/qgis/./resources/themes\default\icons/<br> Percorso tema di default: :/images/themes/default/<br> Percorso di ricerca SVG: C:/OSGeo4W/apps/qgis/./svg/|C:/Users/anvalanz/.qgis2//svg/<br> C:/OSGeo4W/apps/qgis/./svg/<br> C:/Users/anvalanz/AppData/Roaming/QGIS/QGIS3\profiles\default/svg/<br> C:/OSGeo4W/apps/qgis-ltr/./svg/<br> Percorso DB utente: C:/OSGeo4W/apps/qgis/./resources/qgis.db<br> Percorso DB Auth: C:/Users/anvalanz/AppData/Roaming/QGIS/QGIS3\profiles\default/qgis-auth.db<br> </font></p><font size="1">
</font><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><font size="1"><span style="color:rgb(0,0,0)">2019-08-14T10:02:23 INFO </span>QGIS è pronto!</font></p><font size="1">
</font><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><font size="1"><span style="color:rgb(220,125,0)">2019-08-14T10:04:45 WARNING </span>Impossibile caricare gli stili da C:/Temp/NGD.sqlite (Query: SELECT styleQML FROM layer_styles WHERE f_table_schema IS NULL AND f_table_name='nhdflowline' AND f_geometry_column ='geometry' ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1)</font></p><font size="1">
</font><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><font size="1"><span style="color:rgb(220,125,0)">2019-08-14T10:04:45 WARNING </span>Impossibile caricare gli stili da C:/Temp/NGD.sqlite (Query: SELECT styleQML FROM layer_styles WHERE f_table_schema IS NULL AND f_table_name='nhdwaterbody' AND f_geometry_column ='geometry' ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1)</font></p><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><br></p><p style="margin:0px;text-indent:0px;white-space:pre-wrap">il log "Plugin" è il seguente:</p><p style="margin:0px;text-indent:0px;white-space:pre-wrap">
</p><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(220,125,0)">2019-08-14T10:01:37 WARNING </span>Impossibile caricare C:/OSGeo4W/apps/qgis/plugins/grassplugin7.dll (Motivo: Impossibile caricare la libreria C:\OSGeo4W\apps\qgis\plugins\grassplugin7.dll: Impossibile trovare il modulo specificato.)</p>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(220,125,0)">2019-08-14T10:01:37 WARNING </span>Impossibile caricare C:/OSGeo4W/apps/qgis/plugins/grassprovider7.dll (Motivo: Impossibile caricare la libreria C:\OSGeo4W\apps\qgis\plugins\grassprovider7.dll: Impossibile trovare il modulo specificato.)</p>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(220,125,0)">2019-08-14T10:01:37 WARNING </span>Impossibile caricare C:/OSGeo4W/apps/qgis/plugins/grassrasterprovider7.dll (Motivo: Impossibile caricare la libreria C:\OSGeo4W\apps\qgis\plugins\grassrasterprovider7.dll: Impossibile trovare il modulo specificato.)</p>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(0,0,0)">2019-08-14T10:01:41 INFO </span>Caricato go2streetview (pacchetto: go2streetview)</p>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(0,0,0)">2019-08-14T10:01:42 INFO </span>Caricato ImportPhotos (pacchetto: ImportPhotos)</p>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(0,0,0)">2019-08-14T10:02:00 INFO </span>Caricato qgis2web (pacchetto: qgis2web)</p>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(0,0,0)">2019-08-14T10:02:06 INFO </span>Caricato QuickMapServices (pacchetto: quick_map_services)</p>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(0,0,0)">2019-08-14T10:02:07 INFO </span>Caricato Spreadsheet Layers (pacchetto: SpreadsheetLayers)</p>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(0,0,0)">2019-08-14T10:02:07 INFO </span>Caricato DB Manager (pacchetto: db_manager)</p>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(0,0,0)">2019-08-14T10:02:10 INFO </span>Caricato MetaSearch Catalog Client (pacchetto: MetaSearch)</p>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><span style="color:rgb(0,0,0)">2019-08-14T10:02:21 INFO </span>Caricato Processing (pacchetto: processing)</p><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><br></p><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><br></p><p style="margin:0px;text-indent:0px;white-space:pre-wrap">Non c'è alcuna informazione circa l'errore di tipo 7 indicato nello screenshot allegato (Errore_DB_Manager.JPG).</p><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><br></p><p style="margin:0px;text-indent:0px;white-space:pre-wrap">Dopo l'esecuzione del tentativo di importazione viene creata una tabella vuota e mancante anche del campo della geometria (allegato: tabella_creata.JPG)</p><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><br></p><p style="margin:0px;text-indent:0px;white-space:pre-wrap">Ho provato a caricare lo stesso shapefile nel db spatialite usando la GUI di Spatialite e non si è verificato alcun problema.</p><p style="margin:0px;text-indent:0px;white-space:pre-wrap"><br></p><br></div>-- tabella creata da Spatialite GUI<br>-- 29 righe e geometria<br>-----------------------------------------<br>CREATE TABLE "NHDPOINT" (<br>"pk_uid" INTEGER PRIMARY KEY AUTOINCREMENT,<br>"comid" INTEGER,<br>"fdate" DOUBLE,<br>"resolution" INTEGER,<br>"gnis_id" TEXT,<br>"gnis_name" TEXT,<br>"reachcode" TEXT,<br>"ftype" INTEGER,<br>"fcode" INTEGER,<br><div>"geometry" POINT)</div><div><br></div><div>Confrontando le strutture delle 2 tabelle noto una differenza nei campi.</div><div><br></div><div>Antonio Valanzano<br></div></div>
</blockquote></div><br>-- <br>Sorry for being short</body></html>