nakijun / qspatialite Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/qspatialite
Automatically exported from code.google.com/p/qspatialite
What steps will reproduce the problem?
1. Use the [Export Tables to txt] button in Qspatialite
2. Select any user loaded non-spatial table (do not select a spatial table) to
export as either csv dbf or sqlite output
3. an [Operation Done] dialog pops up: click [ok] to that
What is the expected output? Either a csv, dbf or sqlite, depending on the
user option selected.
What do you see instead?
NO OUTPUT IS GENERATED AT ALL
What version of the product are you using? On what operating system?
QGIS 1.8.0 with Qspatilite 6.0.5
Please provide any additional information below.
Note: the [Export Tables to txt] button will export a spatial table to a
non-spatial table, either csv, dbf or sqlite, depending on the user option, but
will not export a user loaded non-spatial table. The button [Export Spatial
Tables to OGR Format] works to export spatial tables to output OGR shapefiles
And note, in addition to failing to export non-spatial tables, there is no also
option to export to txt (tab separated) , as the button indicates.
Original issue reported on code.google.com by [email protected]
on 8 Feb 2013 at 5:08
What steps will reproduce the problem?
1.open Qgis
2.open qSpatialLite
3.open/create new database
What is the expected output? What do you see instead?
expected : full sys. Table
seen : "no such table: views_geometry_columns"
Tehn : "This DataBase seems to be a valid db DataBase but not a valid
SpatiaLite One
Would you like QSpatiaLite to automatically transform it to SpatiaLite
(information won't be lost) ?"
What version of the product are you using? On what operating system?
Qgis 1.8 ; QspatiaLite 6.0.6 ; WIN 7 Pro 64
Please provide any additional information below.
Impossible de creer la table initiale sys.
J'ai essayé d'ajouter une couche à une base existante qui avait le sys table
remplie : echec, table vide après un message "no such function : CastToMulti".
J'ai transformé les couches multipoint en point : même résultat.
S'il s'agit de deux problemes differents (creation/import), alors desolé pour
l'amalgame.
Original issue reported on code.google.com by [email protected]
on 27 Feb 2013 at 9:14
quelque soit la méthode utilisée :
1. via qgis, import d'un csv, puis import de ce csv via qspatialite
2. ou directement via qspatialite.
code d'erreur (1er type)
-----------------------
Traceback (most recent call last):
File "C:/Users/jean-philippe.gallar/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 1442, in upload_qgis_layers
SQL,params=self.saveLayer(layer, name, charset, srid, selected,False)
File "C:/Users/jean-philippe.gallar/.qgis/python/plugins\QspatiaLite\qspatialite.py", line 156, in save_layer
geometry=geom[vlayer.geometryType()]
IndexError: list index out of range
Version de Python :
2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)]
Version de QGIS :
1.7.0-Wroclaw Wroclaw, 63ecdd7
Chemin vers Python :
['C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\GeoCoding',
'C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\GeoCoding',
'C:/PROGRA~1/QUANTU~1/apps/qgis/./python',
'C:/Users/jean-philippe.gallar/.qgis/python',
'C:/Users/jean-philippe.gallar/.qgis/python/plugins',
'C:/PROGRA~1/QUANTU~1/apps/qgis/./python/plugins',
'C:\\PROGRA~1\\QUANTU~1\\bin\\python25.zip',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\DLLs',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\plat-win',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\lib-tk',
'C:\\PROGRA~1\\QUANTU~1\\apps\\qgis\\bin',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\win32',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\win32\\lib',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\Pythonwin',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\wx-2.8-msw-unicode'
, 'C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\fTools\\tools',
'Z:/Am\xc3\xa9nagement urbain/0--Projets et \xc3\xa9tudes en cours--0/Plans
pour le Service D.P/Signal\xc3\xa9tique verticale']
code d'erreur 2eme type
----------------------------------
Une erreur est apparue lors de l'exécution du code python :
Traceback (most recent call last):
File "C:/Users/jean-philippe.gallar/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 1442, in upload_qgis_layers
SQL,params=self.saveLayer(layer, name, charset, srid, selected,False)
File "C:/Users/jean-philippe.gallar/.qgis/python/plugins\QspatiaLite\qspatialite.py", line 156, in save_layer
geometry=geom[vlayer.geometryType()]
IndexError: list index out of range
Version de Python :
2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)]
Version de QGIS :
1.7.0-Wroclaw Wroclaw, 63ecdd7
Chemin vers Python :
['C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\GeoCoding',
'C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\GeoCoding',
'C:/PROGRA~1/QUANTU~1/apps/qgis/./python',
'C:/Users/jean-philippe.gallar/.qgis/python',
'C:/Users/jean-philippe.gallar/.qgis/python/plugins',
'C:/PROGRA~1/QUANTU~1/apps/qgis/./python/plugins',
'C:\\PROGRA~1\\QUANTU~1\\bin\\python25.zip',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\DLLs',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\plat-win',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\lib-tk',
'C:\\PROGRA~1\\QUANTU~1\\apps\\qgis\\bin',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\win32',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\win32\\lib',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\Pythonwin',
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\wx-2.8-msw-unicode'
, 'C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\fTools\\tools',
'Z:/Am\xc3\xa9nagement urbain/0--Projets et \xc3\xa9tudes en cours--0/Plans
pour le Service D.P/Signal\xc3\xa9tique verticale']
Original issue reported on code.google.com by [email protected]
on 16 Aug 2011 at 12:58
What steps will reproduce the problem?
join a attribute table to a spatial table
then load in qspatialite
no joined field is present
This forces the user to join data in SQLITE afterward, and break possible
existing workflow. Many user do not know SQL to join data in sqlite.
Original issue reported on code.google.com by [email protected]
on 12 Jun 2014 at 9:11
When trying to install plugin I get
"This plugin is broken
invalid literal for int() with base 10: '2-spatialite'"
When I first tried to install the plugin it failed complaining that it could
not find pyspatialite. I installed
pip install pyspatialite==2.6.2-spatialite.2.4.0-4
after using brew to install headers of proj.
Oops -- I think I see part of what is going on -- the installer is expecting an
integer subversion version for pyspatialite
Original issue reported on code.google.com by [email protected]
on 19 Jul 2014 at 2:02
What steps will reproduce the problem?
1. create layer " test'layer "
2. upload via QSpatiaLite
I'm working on it,
try to avoid filenames with special characters.
Original issue reported on code.google.com by [email protected]
on 6 Jun 2011 at 9:56
--> What steps will reproduce the problem?
1. Load a shapefile on QGIS -> Select some features on that layer
2. QSpatiaLite -> Import QGIS Layer -> Import only selected values
--> What is the expected output? What do you see instead?
I get the following error:
An error has occured while executing Python code:
Traceback (most recent call last):
File "/home/pedro/.qgis//python/plugins/QspatiaLite/importQgis/importQgis.py", line 64, in run
if not self.parent.db.uploadQgisVectorLayer(layer, tableName=self.tablenames[i], srid=self.srid, selected=self.selected):
File "/home/pedro/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 140, in uploadQgisVectorLayer
select_ids=vlayer.selectedFeaturesIds()
NameError: global name 'vlayer' is not defined
Python version:
2.7.3 (default, Aug 1 2012, 05:27:35)
[GCC 4.6.3]
QGIS version:
1.9.0-Master Master, exported
--> What version of the product are you using? On what operating system?
QGIS version 1.9.0-Master
QSpatiaLite 6.0.4
Xubuntu 12.04
Original issue reported on code.google.com by [email protected]
on 8 Dec 2012 at 10:29
Geometry Type not recognized on linux
Qgis geotypes:
Polygon
Point
LineString
MultiPolygon
MultiPoint
MultiLineString
Original issue reported on code.google.com by [email protected]
on 9 Jun 2011 at 8:56
Hi,
After the API cleanup merged to Git by Alexander Bruy
https://github.com/qgis/Quantum-GIS/commit/5e45a22d061942f9e4cdaf09416dd5f3ee659
b13
I get an AttributeError when doing 'Import QGIS Layers'.
--> What steps will reproduce the problem?
1. Load a shapefile on QGIS
2. QSpatiaLite -> Import QGIS Layer
--> What is the expected output? What do you see instead?
An error has occured while executing Python code:
Traceback (most recent call last):
File "/home/pedro/.qgis//python/plugins/QspatiaLite/importQgis/importQgis.py", line 29, in browseSRID
self.ui.SRID.setText(dialog.getProjection())
File "/home/pedro/.qgis//python/plugins/QspatiaLite/Classes/dialogSRS.py", line 32, in getProjection
if self.selector.selectedEpsg() != 0:
AttributeError: 'QgsProjectionSelector' object has no attribute 'selectedEpsg'
Python version:
2.7.3 (default, Aug 1 2012, 05:27:35)
[GCC 4.6.3]
QGIS version:
1.9.0-Master Master, exported
--> What version of the product are you using? On what operating system?
QGIS version 1.9.0-Master
QSpatiaLite 6.0.5
Xubuntu 12.04
--> Please provide any additional information below.
More information about this API cleanup:
http://osgeo-org.1560.n6.nabble.com/API-cleanup-td5023896.html
http://hub.qgis.org/wiki/quantum-gis/API_changes_for_version_20
Original issue reported on code.google.com by [email protected]
on 29 Dec 2012 at 4:52
What steps will reproduce the problem?
1. load in qgis 'commune.shp' SRID IGNF:RGF93CC47 ID:10110
2. In Qspatialite new db : myDB.sqlite
3. uploag Tables : QGIS layer = commune.shp, New Table = commune, SRID = ...
select SRID IGNF:RGF93CC47 ID:10110
What is the expected output? What do you see instead?
SRID must be INTEGER
4. or if SRID = 10110
What is the expected output? What do you see instead?
Invalid SRID
What version of the product are you using? On what operating system?
qspatialite 2.4 on ubuntu 11.04 AMD 64 with qgis 1.8 and gdal 1.9
Please provide any additional information below.
Perhaps Select Qgis ID instead of EPSG ID ?
Original issue reported on code.google.com by [email protected]
on 11 Jul 2011 at 12:29
This is not an issue, but an enhancement request.
Using "import QGIS/GDAL layer" from qspatialite you can't specify the ogr/gdal
option of -gt which should improve performance.
The backend, ogr2ogr uses -gt 200 which is very low for importing data to
spatialite. Increasing that value increases performance dramatically.
The only way to use that option is to put it into the "Data Source" creation
options in the layer "Save As..." window. But this way you can only do one
layer at a time, whereas in qspatialite I can do them in batch, but because I
can't specify a custom -gt (like -gt 1024) it is slow to import shapefiles from
qspatialite.
This is a much needed improvement to this utility.
Original issue reported on code.google.com by [email protected]
on 8 Jan 2013 at 10:45
What steps will reproduce the problem?
1. delete a database from outside of qgis
2. open qspatialite, you get the errors shown below and qspatialite does not
load
3. workaround is to remove the database from qgis db manager
message box:
Can't connect to DataBase: /backup/Etienne/tmp/myDB.sqlite
Error unable to open database file
python error:
An error has occured while executing Python code:
Traceback (most recent call last):
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/qspatialite.py", line 68, in run
dlg = QspatiaLiteApp(self.iface)
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py", line 79, in __init__
self.changeDb(max(0,self.connections['idx']))
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py", line 143, in changeDb
self.drawTreeView()
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py", line 148, in drawTreeView
model=self.db.createTreeModel()
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 100, in createTreeModel
self.getTables()
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 73, in getTables
header,data=self.executeQuery(query)
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 44, in executeQuery
cursor=self.connectionObject.cursor()
AttributeError: Database instance has no attribute 'connectionObject'
Python version:
2.7.2+ (default, Oct 4 2011, 20:41:12)
[GCC 4.6.1]
QGIS version:
1.8.0-Lisboa Lisboa, c64bb9d
Original issue reported on code.google.com by [email protected]
on 27 Aug 2012 at 7:01
What steps will reproduce the problem?
1. import two tables in QSpatilaite
2. create spatial indexes
select createspatialindex( 'GeoSirene_2006_27561' ,'geometry' )
select createspatialindex( 'Communes_pm_recues','geometry' )
3. trying to use an RTree in an SQL query
select
s.'FID',
c.'NOM_COMM'
from "GeoSirene_2006_27561" as s
join "Communes_pm_recues" as c on (
st_intersects(s.geometry, c.geometry)
) and s.'PKUID' in (
select 'pkid'
from "idx_Communes_pm_recues_Geometry"
where 'pkid' match RTreeintersects (
MbrMinX(s.geometry),
MbrMinY(s.geometry),
MbrMaxX(s.geometry),
MbrMaxY(s.geometry)))
4. run SQL
What is the expected output? What do you see instead?
an error message
The SQL query seems to be invalid.
no such function: RTreeintersects
What version of the product are you using? On what operating system?
QSpatialite V7
QGIS 2.6
Ubuntu 14.04
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 23 Dec 2014 at 3:18
What steps will reproduce the problem?
1.Load Qspatialite plugin
2.
3.
What is the expected output? What do you see instead?
"
Une erreur est apparue lors de l'exécution du code Python :
Traceback (most recent call last):
File "/Users/my_account/.qgis2/python/plugins/QspatiaLite/qspatialite.py", line 68, in run
dlg = QspatiaLiteApp(self.iface)
File "/Users/my_account/.qgis2/python/plugins/QspatiaLite/QspatiaLiteApp.py", line 80, in __init__
self.changeDb(max(0,self.connections['idx']))
File "/Users/my_account/.qgis2/python/plugins/QspatiaLite/QspatiaLiteApp.py", line 141, in changeDb
self.db=Database(self.connections['path'][index])
File "/Users/my_account/.qgis2/python/plugins/QspatiaLite/Classes/Database.py", line 19, in __init__
self.connection()
File "/Users/my_account/.qgis2/python/plugins/QspatiaLite/Classes/Database.py", line 34, in connection
self.connectionObject.enable_load_extension(True)
AttributeError: 'pysqlite2.dbapi2.Connection' object has no attribute
'enable_load_extension'
Version de Python :
2.7.6 (default, Sep 9 2014, 15:04:36)
[GCC 4.2.1 Compatible Apple LLVM 6.0 (clang-600.0.39)]
Version de QGIS :
2.6.1-Brighton Brighton,
Chemin vers Python : ['/Users/my_account/.qgis2/python/plugins/processing',
'/Applications/QGIS.app/Contents/MacOS/../Resources/python',
u'/Users/my_account/.qgis2/python', u'/Users/my_account/.qgis2/python/plugins',
'/Applications/QGIS.app/Contents/MacOS/../Resources/python/plugins',
'/Library/Frameworks/SQLite3.framework/Versions/C/Python/2.7',
'/Library/Frameworks/GEOS.framework/Versions/3/Python/2.7',
'/Library/Python/2.7/site-packages/numpy-override',
'/Library/Python/2.7/site-packages/matplotlib-override',
'/Library/Frameworks/GDAL.framework/Versions/1.11/Python/2.7/site-packages',
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python27.zip',
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7',
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-dar
win',
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac
',
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac
/lib-scriptpackages',
'/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python',
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-tk',
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-old'
,
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynl
oad',
'/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/PyOb
jC', '/Library/Python/2.7/site-packages',
'/Users/my_account/.qgis2/python/plugins/MetaSearch/ext-libs',
'/Users/my_account/.qgis2/python/plugins/mmqgis/forms',
'/Users/my_account/.qgis2/python/plugins/QuickMultiAttributeEdit/forms',
'/Applications/QGIS.app/Contents/Resources/python/plugins/fTools/tools']
"
What version of the product are you using? On what operating system?
7.0.3 on QGIS 2.6.1 Mac OS Yosomite
Please provide any additional information below.
Version 7.0 works.
Original issue reported on code.google.com by [email protected]
on 6 Feb 2015 at 1:29
What steps will reproduce the problem?
1. removed old sqlite file, just open before
2. try to open spatialite
3. warning file doesn't exist, then crash
What is the expected output? What do you see instead?
Open with no error if removed file doesn't exist
What version of the product are you using? On what operating system?
Ubuntu 4.04 64 bit
Qgis 2.6.1-Brighton
qspatialite 7.0.4 (in /home/ubuntu/.qgis2/python/plugins/QspatiaLite)
Please provide any additional information below.
workaround restore the old file, even with different content, into
path/filename.sqlite showed by dialog...
Original issue reported on code.google.com by [email protected]
on 20 Feb 2015 at 1:57
--> What steps will reproduce the problem?
1. Create a Spatialite database on a folder with non ascii characters (accents,
spaces, etc.) as name, or with that characters within the path to the folder,
eg, /home/pedro/Área de Trabalho/dbtest.sqlite;
2. Create a SQL query;
3. Make 'Create Spatial Table & Load in QGIS'.
--> What is the expected output? What do you see instead?
I get the following error:
An error has occured while executing Python code:
Traceback (most recent call last):
File "/home/pedro/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py", line 221, in runQuery
table[0].loadToQgis()
File "/home/pedro/.qgis//python/plugins/QspatiaLite/Classes/Table.py", line 76, in loadToQgis
print uri.uri()
UnicodeEncodeError: 'ascii' codec can't encode character u'\xc1' in position
20: ordinal not in range(128)
Python version:
2.7.3 (default, Aug 1 2012, 05:27:35)
[GCC 4.6.3]
QGIS version:
1.9.0-Master Master, exported
--> What version of the product are you using? On what operating system?
QGIS version 1.9.0-Master
QSpatiaLite 6.0.4
Xubuntu 12.04
Original issue reported on code.google.com by [email protected]
on 8 Dec 2012 at 10:58
What steps will reproduce the problem?
1.When I try create a new DataBase, Spatialite plugin return the dialog error
box:
The SQL query seems to be invalid. no suck table: views_goemetry_columns
2.This DataBase seems to be a valid SQLite DataBase but not a valid SpatiaLite
One
Would you like QSpatiaLite to automatically transform it to SpatiaLite
(information won't be lost) ?
3.When I click in the YES button, a new dialog error box open with the text:
Unable to convert Database to SpatiaLite
4.When I click in OK button, another dialog error box open with the text:
The SQL query seems to be invalid.
What is the expected output? What do you see instead?
I whant create a nem DB and import geometry layers. The DataBase was set up,
but I cant import spatial layers.
What version of the product are you using? On what operating system?
I use Qgis 1.8.0 and QSpatialite 6.0.4. My OS is Windows 7, 64 bits, Running in
network.
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 18 Sep 2012 at 2:42
What about compatibility with QGIS 2.0.1
What version of the product are you using? On what operating system?
QSpatiallite 6.0.7
QGIS 2.0.1 64-bit
Windows 7
Original issue reported on code.google.com by [email protected]
on 1 Nov 2013 at 4:50
What steps will reproduce the problem?
1. Execute a query based on joined tables (geometry in one table with a common
id field for the join)
2. Select option 'Load in QGIS as spatial layer' before executing query
3. In QGIS:
a) open the attribute table for the new layer,
b) or select the 'identify features' function,
c) or select the 'select features by...' function
What is the expected output? What do you see instead?
The geometry is present and visible, the records exist in the attribute table
but
a) all fields are listed as 'error'.
b) The 'identify features' function does not - no data is found
c) only one feature is selected irrespective of how many are within the area
selected (and within the attribute table the selected row is marked with
'error' in each field)
What version of the product are you using? On what operating system?
QGIS 1.8.0 ; qspatialite 6.0.5 ; Windows XP SP3
Please provide any additional information below.
This issue did not occur with the previous version (prior to the interface
being updated) on QGIS 1.7.x - I found it a really useful plugin and generated
a project database specifically because I could manipulate the spatial data
(which I'd never been able to do until I found qspatialite).
I can get around this if I execute the SQL statement with the option 'create
spatial table and load in QGIS' but I think that this then breaks the link with
the original dataset, which makes it more of a static snapshot than a dynamic
database.
Thanks for your great work on this plugin.
Original issue reported on code.google.com by [email protected]
on 11 Feb 2013 at 10:07
What steps will reproduce the problem?
1. Going to the SQL free text entry tab
2. Writing any SQL code of length
3. Trying to observe the huge code font without scrolling around.
What is the expected output? Output is normal. The font is too large.
What version of the product are you using? Qspatialite 6.0.8 On what operating
system? Windows XP with QGIS 1.8
Please provide any additional information below.
I appreciate large fonts, but this is even huge by my standard.
Original issue reported on code.google.com by [email protected]
on 8 Aug 2013 at 1:25
Hi Romain,
a very convenient and small feature would be to allow executing SQL query only
for selected text in SQL dialog.
This is very usefull in PGadmin and DBMmanager.
A bientôt
Régis
Original issue reported on code.google.com by [email protected]
on 26 Apr 2013 at 10:45
The plugin does not load in QGIS master due to lack of a metadata.txt file.
Find attached a metadata.txt which works for me.
Original issue reported on code.google.com by [email protected]
on 2 Apr 2013 at 10:22
Attachments:
What steps will reproduce the problem?
1. Attempt to activate plugin from menu or shortcut
2.
3.
What is the expected output? What do you see instead?
AttributeError: 'pysqlite2.dbapi2.Connection' object has no attribute
'enable_load_extension'
What version of the product are you using? On what operating system?
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 1 Sep 2014 at 10:16
Hi (bonjour Romain),
In versions 7.0.2 et 7.0.1, on QGIS 2.2, we can't import correctly date
fields. They are converted to PyQt4.Core.Qdate text objects.
See attached image.
Quite a severe bug preventing us from using Qspatialite.
Cheers
Régis
Original issue reported on code.google.com by [email protected]
on 20 Mar 2014 at 3:35
Attachments:
I'm not sure what causes database to init itself so long. What I found out is
that adding:
h,d=self.executeQuery("Select InitSpatialMetadata()",commit=True)
h,d=self.executeQuery("Select InitSpatialMetadata(1)",commit=True) to your
Database class really helps.
Thanks for great peace of code !
Original issue reported on code.google.com by [email protected]
on 1 Feb 2015 at 12:33
I just started using qspatialite today, and I really like ot. I came up with
some simple UI improvements.
- add close button to the main window
- set the title for the main window (was Dialog)
- wait cursor when loading OGR file(s)
- use .shp by default instead of .dbf as this can be confusing
attaching a patch againt 6.0.1
Original issue reported on code.google.com by [email protected]
on 20 Mar 2012 at 7:18
Attachments:
With 4.08 it is again giving the message:
"Plugin has disappeared
The plugin seems to have been installed but I don't know where. Probably the
plugin package contained a wrong named directory.
Please search the list of installed plugins. I'm nearly sure you'll find the
plugin there, but I just can't determine which of them it is. It also means
that I won't be able to determine if this plugin is installed and inform you
about available updates. However the plugin may work. Please contact the plugin
author and submit this issue."
Original issue reported on code.google.com by [email protected]
on 11 Jul 2011 at 3:04
What steps will reproduce the problem?
1. click on import ogr layer
2. select shapefile and add to list of files
3. click ok
What is the expected output? What do you see instead?
An error has occured while executing Python code:
Traceback (most recent call last):
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/importOgr/importOgr.py", line 147, in validate
if not self.parent.db.importGisFile( item[0], item[1], int(item[2]),item[3]):
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 271, in importGisFile
return self.uploadQgisVectorLayer(layer, srid, tableName=tableName)
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 161, in uploadQgisVectorLayer
for id,name in provider.fields().iteritems():
AttributeError: 'QgsFields' object has no attribute 'iteritems'
Python version:
2.7.3 (default, Sep 26 2012, 21:53:55)
[GCC 4.7.2]
QGIS version:
1.9.0-Master Master, db7b46a
Python path: ['/home/soft/share/qgis/python', '/home/tourigny/.qgis//python',
'/home/tourigny/.qgis//python/plugins', '/home/soft/share/qgis/python/plugins',
'/home/soft/lib/python2.7/site-packages', '/usr/lib/python2.7',
'/usr/lib/python2.7/plat-linux2', '/usr/lib/python2.7/lib-tk',
'/usr/lib/python2.7/lib-old', '/usr/lib/python2.7/lib-dynload',
'/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages',
'/usr/lib/python2.7/dist-packages/PIL',
'/usr/lib/python2.7/dist-packages/gst-0.10',
'/usr/lib/python2.7/dist-packages/gtk-2.0', '/usr/lib/pymodules/python2.7',
'/usr/lib/python2.7/dist-packages/ubuntu-sso-client',
'/home/soft/share/qgis/python/plugins/fTools/tools']
What version of the product are you using? On what operating system?
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 4 Apr 2013 at 12:29
An error has occured while executing Python code:
Traceback (most recent call last):
File "C:/Users/Roman/.qgis/python/plugins\QspatiaLite\qspatialite.py", line 68, in run
dlg = QspatiaLiteDialog(self.load_to_canvas,self.get_layer_names,self.save_layer,self.delete_tmpshp, self.import_gis_files, self.viewresult, self.export2ogr, self.iface.mainWindow())
File "C:/Users/Roman/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 103, in __init__
if not self.connect_to_spatialite(): #get connectionSettings and connection to spatialite DB
File "C:/Users/Roman/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 1225, in connect_to_spatialite
self.prepare_tree() # prepare tree for new DB
File "C:/Users/Roman/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 726, in prepare_tree
columnsList = self.get_columns(record[0])
File "C:/Users/Roman/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 1182, in get_columns
rep=cursor.execute(query)
OperationalError: no such module: VirtualSpatialIndex
Python version:
2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)]
QGIS version:
1.7.0-Wroclaw Wroclaw, 63ecdd7
Original issue reported on code.google.com by [email protected]
on 30 Sep 2011 at 8:19
What steps will reproduce the problem?
1.click on import ogr layer
2.choose shapefile
3.click on SRID selector button
What is the expected output? What do you see instead?
An error has occured while executing Python code:
Traceback (most recent call last):
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/importOgr/importOgr.py", line 46, in browseSRID
self.ui.SRID.setText(dialog.getProjection())
File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/dialogSRS.py", line 32, in getProjection
if self.selector.selectedEpsg() != 0:
AttributeError: 'QgsProjectionSelector' object has no attribute 'selectedEpsg'
Python version:
2.7.3 (default, Sep 26 2012, 21:53:55)
[GCC 4.7.2]
QGIS version:
1.9.0-Master Master, db7b46a
Python path: ['/home/soft/share/qgis/python', '/home/tourigny/.qgis//python',
'/home/tourigny/.qgis//python/plugins', '/home/soft/share/qgis/python/plugins',
'/home/soft/lib/python2.7/site-packages', '/usr/lib/python2.7',
'/usr/lib/python2.7/plat-linux2', '/usr/lib/python2.7/lib-tk',
'/usr/lib/python2.7/lib-old', '/usr/lib/python2.7/lib-dynload',
'/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages',
'/usr/lib/python2.7/dist-packages/PIL',
'/usr/lib/python2.7/dist-packages/gst-0.10',
'/usr/lib/python2.7/dist-packages/gtk-2.0', '/usr/lib/pymodules/python2.7',
'/usr/lib/python2.7/dist-packages/ubuntu-sso-client',
'/home/soft/share/qgis/python/plugins/fTools/tools']
What version of the product are you using? On what operating system?
Please provide any additional information below.
this with latest plugin, using master (1.9)
Original issue reported on code.google.com by [email protected]
on 4 Apr 2013 at 12:28
I cannot run the plugin because of module missing.
I can't find that module in the OpenSuse repository, and python community
repository.
I'm using QGIS 2,0 and OpenSuse 13,1
Where can I find module pyspatialite with dependencies, because I've found that
module at:
packages.altlinux.org/en/Sisyphus/srpms/python-module-pyspatialite/get
but if I try install it I get:
nothing provides python-modules needed by
python-module-pyspatialite-3.0.1-alt1.i586.
Thanks for answer, Tom
Original issue reported on code.google.com by [email protected]
on 20 Nov 2013 at 9:50
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.