Cool,<div>I did all that and it works kind of but I now get:</div><div>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">PySpatiaLite python module is required for QSpatiaLite</p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">I have installed every available Spatialite package:</p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">libspatialite-dev<span class="Apple-tab-span" style="white-space:pre"> </span>install</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">libspatialite2<span class="Apple-tab-span" style="white-space:pre"> </span>install</p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
libspatialite3<span class="Apple-tab-span" style="white-space:pre"> </span>install</p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">spatialite-bin<span class="Apple-tab-span" style="white-space:pre"> </span>install</p>
<div><br></div><p></p><div>Thoughts? Maybe 2 and 3 is clashing? I can try and remove spatialite and qgis completely again and try a reinstall. I did not remove spatialite when I did the qgis reinstall.</div><div><br></div>
<div>Regars</div><br><div class="gmail_quote">On 30 January 2012 19:13, Alex Mandel <span dir="ltr"><<a href="mailto:tech_dev@wildintellect.com">tech_dev@wildintellect.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Add 3rd Party Repos.<br>
<a href="http://www.qgisworkshop.org/html/workshop/python_in_qgis_tutorial1.html" target="_blank">http://www.qgisworkshop.org/html/workshop/python_in_qgis_tutorial1.html</a><br>
<br>
Then look for the QSpatialite plugin.<br>
<br>
Enjoy,<br>
Alex<br>
<div class="HOEnZb"><div class="h5"><br>
On 01/30/2012 11:04 AM, Gerhardus Geldenhuis wrote:<br>
> Ok,<br>
> Complete removal and re-installation seem to have done the trick.<br>
> Thank you very much for all the help so far.<br>
><br>
> I can see the correct menus now and the Plugin Installer Plugin is<br>
> installed and working. However the plugin listings is very limited. Any way<br>
> to get more python plugins listed?<br>
> This is the repositories I have listed:<br>
> <a href="http://pyqgis.org/repo/official" target="_blank">http://pyqgis.org/repo/official</a><br>
><br>
> after browsing to that I have now added user contributed. Could this be<br>
> installed by default perhaps?<br>
><br>
> Regards<br>
><br>
> On 30 January 2012 18:18, Alex Mandel <<a href="mailto:tech_dev@wildintellect.com">tech_dev@wildintellect.com</a>> wrote:<br>
><br>
>> Gerhardus,<br>
>><br>
>> I wonder if something is strange with the main qgis packages. I suggest<br>
>> trying the packages from Ubuntugis repositories instead, as detailed here:<br>
>><br>
>><br>
>> <a href="http://hub.qgis.org/projects/quantum-gis/wiki/Download#Ubuntu-With-updated-dependencies" target="_blank">http://hub.qgis.org/projects/quantum-gis/wiki/Download#Ubuntu-With-updated-dependencies</a><br>
>><br>
>> So try to remove your current install, change your repos, and the update<br>
>> and install again, making sure to grab the python-qgis too.<br>
>><br>
>> Thanks,<br>
>> Alex<br>
>><br>
>> On 01/30/2012 09:18 AM, Gerhardus Geldenhuis wrote:<br>
>>> Hi Alex,<br>
>>> The Plugin Installer if that is a plugin itself then it is not listed.<br>
>>><br>
>>> The keyservers have not been working for a while and that breaks any<br>
>> other<br>
>>> updates. Which means I have to deselect any QGIS related updates every<br>
>> time<br>
>>> ubuntu updates my laptop.<br>
>>><br>
>>> This is my listed repositories:<br>
>>> deb <a href="http://qgis.org/debian" target="_blank">http://qgis.org/debian</a> natty main<br>
>>> deb-src <a href="http://qgis.org/debian" target="_blank">http://qgis.org/debian</a> natty main<br>
>>><br>
>>> and I am definitely using natty and have not upgraded my OS.<br>
>>><br>
>>> Regards<br>
>>><br>
>>> On 29 January 2012 19:10, Alex Mandel <<a href="mailto:tech_dev@wildintellect.com">tech_dev@wildintellect.com</a>><br>
>> wrote:<br>
>>><br>
>>>> Check in the Manage Plugins menu that you have the Plugin Installer<br>
>>>> enabled.<br>
>>>><br>
>>>> The authentication thing is no big deal sometimes the keyservers just<br>
>>>> aren't working. As a question of clarification which repository are you<br>
>>>> installing QGIS from?<br>
>>>><br>
>>>> Thanks,<br>
>>>> Alex<br>
>>>><br>
>>>> On 01/29/2012 04:40 AM, Gerhardus Geldenhuis wrote:<br>
>>>>> Hi<br>
>>>>> That installation unfortunately had no effect. Still no python plugin<br>
>>>> menu<br>
>>>>> option. In addition I also get the message:<br>
>>>>><br>
>>>>> WARNING: The following packages cannot be authenticated!<br>
>>>>> libqgis1.7.3 python-qgis python-qgis-common<br>
>>>>> Install these packages without verification [y/N]? y<br>
>>>>><br>
>>>>> which I ignored<br>
>>>>><br>
>>>>> I ran sudo ldconfig thinking maybe a link somewhere is missing but that<br>
>>>> did<br>
>>>>> not do the trick either. The packages were installed previously:<br>
>>>>><br>
>>>>> Preparing to replace python-qgis 1.4.0+12730-5ubuntu1 (using<br>
>>>>> .../python-qgis_1.7.3-1~natty1_i386.deb) ...<br>
>>>>> Unpacking replacement python-qgis ...<br>
>>>>> Preparing to replace python-qgis-common 1.4.0+12730-5ubuntu1 (using<br>
>>>>> .../python-qgis-common_1.7.3-1~natty1_all.deb) ...<br>
>>>>><br>
>>>>> so maybe there is something else wrong?<br>
>>>>><br>
>>>>> Regards<br>
>>>>><br>
>>>>> On 28 January 2012 21:46, Alex Mandel <<a href="mailto:tech_dev@wildintellect.com">tech_dev@wildintellect.com</a>><br>
>>>> wrote:<br>
>>>>><br>
>>>>>> A classic problem we really need to tackle better: you're missing the<br>
>>>>>> python-qgis package or maybe the base plugins<br>
>>>>>><br>
>>>>>> sudo apt-get install python-qgis python-qgis-common<br>
>>>>>><br>
>>>>>> Give that a try, restart qgis and see if you have python plugin<br>
>> access.<br>
>>>>>><br>
>>>>>> Thanks,<br>
>>>>>> Alex<br>
>>>>>><br>
>>>>>><br>
>>>>>> On 01/28/2012 01:39 PM, Gerhardus Geldenhuis wrote:<br>
>>>>>>> Thanks Alex,<br>
>>>>>>><br>
>>>>>>> I only have "Manage Plugins" and "Python Console" on my Plugins menu<br>
>>>> and<br>
>>>>>> my<br>
>>>>>>> list of plugins does not contain qspatialite plugin. I am using 1.7.0<br>
>>>> on<br>
>>>>>>> Ubuntu. I am trying to get the spatialite gui working at the moment<br>
>> as<br>
>>>>>> the<br>
>>>>>>> alternative.<br>
>>>>>>><br>
>>>>>>> Regards<br>
>>>>>>><br>
>>>>>>> <a href="http://www.gaia-gis.it" target="_blank">http://www.gaia-gis.it</a><br>
>>>>>>> On 28 January 2012 21:16, Alex Mandel <<a href="mailto:tech_dev@wildintellect.com">tech_dev@wildintellect.com</a>><br>
>>>>>> wrote:<br>
>>>>>>><br>
>>>>>>>> On 01/28/2012 01:08 PM, Gerhardus Geldenhuis wrote:<br>
>>>>>>>>> Hi<br>
>>>>>>>>> I have spend some time polishing the data I have and it is in csv<br>
>>>>>>>> format. I<br>
>>>>>>>>> would like to run queries on it and display a number of custom<br>
>>>>>> queries's<br>
>>>>>>>>> data on my map. I thought spatialite would be the answer but I am<br>
>>>>>>>>> struggling to connect the dots. I first tried to import the csv<br>
>> file<br>
>>>>>>>>> directly which worked a treat. I then exported the csv file as a<br>
>>>> SQLite<br>
>>>>>>>>> database and tried to add it as Spatialite database, that failed<br>
>> for<br>
>>>>>>>>> obvious reasons.<br>
>>>>>>>>><br>
>>>>>>>>> I then thought that maybe I can directly do queries on the csv<br>
>>>>>> data.... I<br>
>>>>>>>>> managed to get a query working on the data and that query now<br>
>>>> displays<br>
>>>>>>>>> different coloured dots. However I could not find this query again<br>
>>>> nor<br>
>>>>>>>> seem<br>
>>>>>>>>> to be able to change the symbology based on the query type.<br>
>>>>>>>>><br>
>>>>>>>>> My csv file contain multiple types of points which I would like to<br>
>>>> map<br>
>>>>>>>> with<br>
>>>>>>>>> different symbology. Any help would be appreciated. The manual<br>
>>>> explains<br>
>>>>>>>> how<br>
>>>>>>>>> to create a spatialite db but makes no mention of how to get data<br>
>>>> into<br>
>>>>>> a<br>
>>>>>>>>> spatialite db,<br>
>>>>>>>>><br>
>>>>>>>>> Any help would be greatly appreciated.<br>
>>>>>>>>><br>
>>>>>>>>> Best Regards<br>
>>>>>>>>><br>
>>>>>>>><br>
>>>>>>>> Try the QSpatialite plugin (from Fetch python plugins).<br>
>>>>>>>> 1. Create an empty spatial database<br>
>>>>>>>> 2. Connect and use the Upload Tables tab under which you can pick<br>
>> CSV<br>
>>>> as<br>
>>>>>>>> the source.<br>
>>>>>>>><br>
>>>>>>>> Alternative method, download the spatialite gui from spatialite<br>
>>>> website<br>
>>>>>>>> and use that to import the csv. Once imported QGIS will be able to<br>
>> see<br>
>>>>>>>> it, though you may need to create a geometry column and run an<br>
>> update<br>
>>>>>>>> query to populate it.<br>
>>>>>>>><br>
>>>>>>>> Enjoy,<br>
>>>>>>>> Alex<br>
>>>><br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Gerhardus Geldenhuis<br>
</div>