[Qgis-user] Recurrent problem importing .CSV files : Numbers seen like text

Marcin prokes95 at interia.pl
Tue Mar 31 11:40:53 PDT 2020 

This is code and how to prepare csv correctly Temat: [Qgis-user] Recurrent problem importing .CSV files : Numbers seen	like textData: 2020-03-31 20:38Nadawca: "Ludovic Cepre" Adresat: qgis-user at lists.osgeo.org; Hello all,I frequently have problems in importing data from Excel to Qgis : often the numbers are imported like text, and i cannot manage to understand why sometimes it works correctly and sometimes not.Perhaps i missed a very basical way of importing... ??I precise that i know that it's possible to import directly data from Excel, but I use .CSV format so as to have more reliable files.Thanks to all... !!LudovicLe mar. 31 mars 2020 à 18:53, <qgis-user-request at lists.osgeo.org> a écrit :Send Qgis-user mailing list submissions to
        qgis-user at lists.osgeo.org
To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.osgeo.org/mailman/listinfo/qgis-user
or, via email, send a message with subject or body 'help' to
        qgis-user-request at lists.osgeo.org
You can reach the person managing the list at
        qgis-user-owner at lists.osgeo.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Qgis-user digest..."
Today's Topics:
   1. Re: Should be easy? Open csv in Graphical Modeller (Yann Voté)
   2. Re: Should be easy? Open csv in Graphical Modeller (Ujaval Gandhi)
   3. Re: DataPlotly questions/suggestions (matteo)
   4. Embedded projects and QGIS server (Karl Magnus Jönsson)
   5. Re: Plugin Processing crashes QGIS and computer (Sabine Vanhuysse)
   6. Re: DataPlotly questions/suggestions (Tom Chadwin)
   7. Problem with upgrade to QGIS 3.12.1 (QGIS.USER)
   8. Re: Plugin Processing crashes QGIS and computer (Sabine Vanhuysse)
----------------------------------------------------------------------
Message: 1
Date: Tue, 31 Mar 2020 13:08:26 +0200
From: Yann Voté <ygversil at lilo.org>
To: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] Should be easy? Open csv in Graphical
        Modeller
Message-ID: <00db00a4-2d9e-c7a6-baaa-4dbd3bc10949 at lilo.org>
Content-Type: text/plain; charset=utf-8; format=flowed
Hi,
Not sure if this will help you, but I recently wrote a processing plugin 
to deal with CSV files. The plugin is named CSV Tools. It aims to be a 
little more generic than the "create points layer from table" since it 
can handle WKT geometries and hence can load lines and polygons.
The plugin is *highly* experimental, and thus is available in QGIS only 
when experimental plugins are allowed.
It works for me at the moment, I use it in models. But I've plans to 
make it more usable so that it can be useful to more people. I'd love to 
have feedback : if it works or not and would gladly fix bugs.
Regards.
Yann
Le 31/03/2020 à 12:43, magerlin a écrit :
> Thanks for your comment.
> 
> But I am trying to setup a model for reading GTFS data (General Transit Feed
> Specification) which are sets of like 10 csv files and I am right now
> working with 3 sets so like 30 csv files in total.
> 
> So the aim was to automate tedious work and not have to remember every time
> how these 10 csv files relate to each other.
> 
> I am aware of two plugins reading GTFS data but they both break down with
> python errors ...
> 
> 
> 
> -----
> Regards Morten
> 
> Currently using Qgis 3.10.0
> Windows 10, 64bit
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> 
------------------------------
Message: 2
Date: Tue, 31 Mar 2020 16:54:15 +0530
From: Ujaval Gandhi <ujaval at spatialthoughts.com>
To: Yann Voté <ygversil at lilo.org>
Cc: QGIS User List <qgis-user at lists.osgeo.org>
Subject: Re: [Qgis-user] Should be easy? Open csv in Graphical
        Modeller
Message-ID:
        <CALymcQDobAFFWxVnsE8B7NnttRsRuF_B1ZpD5rES_4RBtxWJMA at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Processing Toolbox has a 'Create point layer from table' algorithm that can
read a CSV and give you a vector layer that can be used in the model.
[image: Logo] <https://spatialthoughts.com/>
Ujaval Gandhi
Spatial Thoughts
mobile: +91-8095684687
email: ujaval at spatialthoughts.com
[image: LinkedIn icon] <https://www.linkedin.com/in/spatialthoughts/>  [image:
Twitter icon] <https://twitter.com/spatialthoughts>
Subscribe to our newsletter http://bit.ly/spatialthoughts-newsletter
On Tue, Mar 31, 2020 at 4:48 PM Yann Voté <ygversil at lilo.org> wrote:
> Hi,
>
> Not sure if this will help you, but I recently wrote a processing plugin
> to deal with CSV files. The plugin is named CSV Tools. It aims to be a
> little more generic than the "create points layer from table" since it
> can handle WKT geometries and hence can load lines and polygons.
>
> The plugin is *highly* experimental, and thus is available in QGIS only
> when experimental plugins are allowed.
>
> It works for me at the moment, I use it in models. But I've plans to
> make it more usable so that it can be useful to more people. I'd love to
> have feedback : if it works or not and would gladly fix bugs.
>
> Regards.
>
> Yann
>
>
> Le 31/03/2020 à 12:43, magerlin a écrit :
> > Thanks for your comment.
> >
> > But I am trying to setup a model for reading GTFS data (General Transit
> Feed
> > Specification) which are sets of like 10 csv files and I am right now
> > working with 3 sets so like 30 csv files in total.
> >
> > So the aim was to automate tedious work and not have to remember every
> time
> > how these 10 csv files relate to each other.
> >
> > I am aware of two plugins reading GTFS data but they both break down with
> > python errors ...
> >
> >
> >
> > -----
> > Regards Morten
> >
> > Currently using Qgis 3.10.0
> > Windows 10, 64bit
> > --
> > Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200331/dce10c4e/attachment-0001.html>
------------------------------
Message: 3
Date: Tue, 31 Mar 2020 16:16:38 +0200
From: matteo <matteo.ghetta at gmail.com>
To: qgis-user at lists.osgeo.org
Cc: Tom Chadwin <tom.chadwin at nnpa.org.uk>, Federico Gianoli
        <gianoli.federico at gmail.com>
Subject: Re: [Qgis-user] DataPlotly questions/suggestions
Message-ID: <8cbc55a2-f364-8770-e3b5-8393ca258bd0 at gmail.com>
Content-Type: text/plain; charset=utf-8
Hi Magnus,
> I recently tested the DataPlotly (impressive work!) plugin and I have a few
> questions/suggestions:
thanks! Appreciations are always welcome!
> - Can I change the font for the plot title, legend title and X/Y labels? I
> don´t see a setting for this.
not yet, but plotly let's you easily do it. Do you mind open a feature
request on the DataPlotly repository?https://github.com/ghtmtt/DataPlotly/issues
> - Wouldn´t it be great if one could publish a layout as an online resource
> for additional interactivity? As an alternative to Power BI presentations
> but with a geodata focus? I guess this a rather massive task.
yep, massive task ;) maps on plotly side lack for some ore
functionalities (currently it is only possible via mapbox while it would
be great to have it also with leaflet and openlayer).
Anyway merging (part) of DataPlotly with QGIS2WEB plugin could also be
an idea (also massive work (ping @Tom Chadwin)
another alternative (still in beta due to a migration to django) ishttps://www.talkingmaps.eu/ (ping @Federico Gianoli)
> - When I try adding DataPlotly in a processing model, I get an error:
> 
> 
> Exception: unknown Traceback (most recent call last):
>   File
> "C:/PROGRA~1/QGIS3~1.4/apps/qgis-ltr/./python/plugins\processing\modeler\ModelerDialog.py",
> line 796, in addAlgorithm
>     alg =
> QgsApplication.processingRegistry().createAlgorithmById(algorithm.id())
> Exception: unknown
> 
> Python version: 3.7.0 (v3.7.0:1bf9cc5093, Jun 27 2018, 04:59:51) [MSC v.1914
> 64 bit (AMD64)] 
> QGIS version: 3.4.11-Madeira Madeira, 9a8a6d4687
same of above, could you open an issue?https://github.com/ghtmtt/DataPlotly/issues/
there is already one (https://github.com/ghtmtt/DataPlotly/issues/92)
Cheers
Matteo
------------------------------
Message: 4
Date: Tue, 31 Mar 2020 14:19:19 +0000
From: Karl Magnus Jönsson  <Karl-Magnus.Jonsson at kristianstad.se>
To: "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org>
Subject: [Qgis-user] Embedded projects and QGIS server
Message-ID: <2f0f4cef47f7482e83a44aa3b935eff8 at kristianstad.se>
Content-Type: text/plain; charset="iso-8859-1"
Hi all!
I'm trying to embed some thematic projects into a master project containing all themes for publishing a service in QGIS Server. Works nice in desktop but the WMS service just contains empty group layers for the embedded projects. Paths seems to be relative. It would have been nice to be able to publish layers or projects in different master projects and not have to duplicate the cartography and settings in several projects. Does anyone know if it is intended to work with embedded projects in QGIS Server? Or have another smart solution for this? Thanks in advance.
Karl-Magnus Jönsson
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200331/6285137b/attachment-0001.html>
------------------------------
Message: 5
Date: Tue, 31 Mar 2020 16:20:26 +0200
From: "Sabine Vanhuysse" <svhuysse at ulb.ac.be>
To: <qgis-user at lists.osgeo.org>
Subject: Re: [Qgis-user] Plugin Processing crashes QGIS and computer
Message-ID: <000f01d60767$8c074180$a415c480$@ulb.ac.be>
Content-Type: text/plain; charset="iso-8859-1"
Hi Phil,
Thanks for your speedy reply. I have checked what you suggested: my windows
installation is up to date and the memory diagnostic tool couldn’t find any
problem. I have also installed monitor drivers from the manufacturer, as I
had the windows defaults. Unfortunately, the issue was not fixed. 
I would be grateful for any other suggestion.
Cheers,
Sabine
De : Phil Wyatt <phil at wyatt-family.com> 
Envoyé : mardi 31 mars 2020 12:36
À : 'Sabine Vanhuysse' <svhuysse at ulb.ac.be>; qgis-user at lists.osgeo.org
Objet : RE: [Qgis-user] Plugin Processing crashes QGIS and computer
Hi Sabine,
I would also try making sure that your windows installation is up to date,
memory is all OK and also check drivers for your monitors. I had a similar
error (WHEA) that bugged me for ages and it was fixed with new monitor
drivers from the manufacturer (not the windows defaults!)
Cheers - Phil
From: Qgis-user <qgis-user-bounces at lists.osgeo.org
<mailto:qgis-user-bounces at lists.osgeo.org> > On Behalf Of Sabine Vanhuysse
Sent: Tuesday, 31 March 2020 8:40 PM
To: qgis-user at lists.osgeo.org <mailto:qgis-user at lists.osgeo.org> 
Subject: [Qgis-user] Plugin Processing crashes QGIS and computer
Hi all,
I have recently installed QGIS 3.10.4 LTR, as some of the new features would
be very useful to my work. Unfortunately, the Processing plugin which I use
quite a lot causes QGIS and my computer to crash nearly systematically.
After each fresh install - I uninstalled/installed QGIS a few times - and
the first crash, I get this message when I open QGIS again : « Plugin
processing : The plugin will be disabled because it crashed QGIS during last
startup. Please report an issue and re-enable the plugin when the problem
has been solved.” When I try to activate the plugin by ticking the box in
the ‘Manage and Install Plugins’ menu, my computer crashes again.
I have tried to install other standalone versions of QGIS, ie, 3.12.0-2 and
3.8.3-1, and the version that comes with the osgeo4w installer, and they all
cause the same problem. Only when I revert to my old 3.4.7 version does the
plugin function without any problem.
I have also tried to use a new user profile, and even to delete the QGIS
folder in the user/appdata/roaming folder, but this didn’t work.
I should add that the crashes are not totally systematic, as after one fresh
install, there was no crash when I opened QGIS without Grass functions for
the first time. However, the second time (QGIS with Grass functions), it
crashed again. The next times, it crashed be it with or without Grass
functions.
I am using Windows 10 Family edition and I have 2 monitors. When my computer
crashes, I get a blue screen with an error message that is not always the
same, but often it is a WHEA message. I have tried to unplug one of my
monitors before restarting the computer, but this did not solve the issue.
Of course, I can go on using QGIS 3.4.7, but it would be very helpful to
work with a more recent version, so I would very much appreciate your help
with this issue.
Thanks!
Best wishes,
Sabine
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200331/858bfcfe/attachment-0001.html>
------------------------------
Message: 6
Date: Tue, 31 Mar 2020 07:32:39 -0700 (MST)
From: Tom Chadwin <tom.chadwin at nnpa.org.uk>
To: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] DataPlotly questions/suggestions
Message-ID: <1585665159541-0.post at n6.nabble.com>
Content-Type: text/plain; charset=us-ascii
ghtmtt wrote
> merging (part) of DataPlotly with QGIS2WEB plugin could also be
> an idea
This would indeed be amazing, but it would require each chart type to be
prototyped in d3, and then hooked into the exported qgis2web map. Given the
three qgis2web export formats, this would indeed be a big job.
Anyone up for it? Very happy to answer questions, but definitely not
something I can take on myself.
All the best
Tom
-----
Buy Pie Spy: Adventures in British pastry 2010-11 on Amazon 
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
------------------------------
Message: 7
Date: Tue, 31 Mar 2020 16:34:27 +0100
From: "QGIS.USER" <qgis.user at raycar.plus.com>
To: <qgis-user at lists.osgeo.org>
Subject: [Qgis-user] Problem with upgrade to QGIS 3.12.1
Message-ID: <007601d60771$dddb1630$99914290$@raycar.plus.com>
Content-Type: text/plain;       charset="UTF-8"
Hi All,
OS Win 7 & Win10. 
UK based and always use UK CRS EPSG:27700 (OSGB 1936/ British National Grid) so I have an enhanced conversion utility (OSTN15_NTv2_OSGBtoETRS.gsb) installed in my QGIS profile.
After upgrading 3.12.1, I get an error message that I need to install OSTN15_NTv2_OSGBtoETRS.gsb (despite it already being in my profile). Attempting to install it (via the warning) results in an error message about unable to access the relevant folder in my profile. I can solve that problem by deleting the existing copy of OSTN15_NTv2_OSGBtoETRS.gsb in my profile and it will then install correctly. However, even then I still get a warning that the best conversion is not available. Reverting to 3.12.0 solves the problem So for the moment, I am staying with that version.
Is this a known issue please? 
Stay Safe,
Ray Carpenter.
------------------------------
Message: 8
Date: Tue, 31 Mar 2020 18:52:19 +0200
From: "Sabine Vanhuysse" <svhuysse at ulb.ac.be>
To: <qgis-user at lists.osgeo.org>
Subject: Re: [Qgis-user] Plugin Processing crashes QGIS and computer
Message-ID: <000201d6077c$ca7d5980$5f780c80$@ulb.ac.be>
Content-Type: text/plain; charset="iso-8859-1"
If this gives any hint, I have the same issue with the Semi-Automatic
Classification plugin and with the Lecos plugin.
Thank you !
Sabine
De : Sabine Vanhuysse <svhuysse at ulb.ac.be> 
Envoyé : mardi 31 mars 2020 16:20
À : 'qgis-user at lists.osgeo.org' <qgis-user at lists.osgeo.org>
Objet : RE: [Qgis-user] Plugin Processing crashes QGIS and computer
Hi Phil,
Thanks for your speedy reply. I have checked what you suggested: my windows
installation is up to date and the memory diagnostic tool couldn’t find any
problem. I have also installed monitor drivers from the manufacturer, as I
had the windows defaults. Unfortunately, the issue was not fixed. 
I would be grateful for any other suggestion.
Cheers,
Sabine
De : Phil Wyatt <phil at wyatt-family.com <mailto:phil at wyatt-family.com> > 
Envoyé : mardi 31 mars 2020 12:36
À : 'Sabine Vanhuysse' <svhuysse at ulb.ac.be <mailto:svhuysse at ulb.ac.be> >;qgis-user at lists.osgeo.org <mailto:qgis-user at lists.osgeo.org> 
Objet : RE: [Qgis-user] Plugin Processing crashes QGIS and computer
Hi Sabine,
I would also try making sure that your windows installation is up to date,
memory is all OK and also check drivers for your monitors. I had a similar
error (WHEA) that bugged me for ages and it was fixed with new monitor
drivers from the manufacturer (not the windows defaults!)
Cheers - Phil
From: Qgis-user <qgis-user-bounces at lists.osgeo.org
<mailto:qgis-user-bounces at lists.osgeo.org> > On Behalf Of Sabine Vanhuysse
Sent: Tuesday, 31 March 2020 8:40 PM
To: qgis-user at lists.osgeo.org <mailto:qgis-user at lists.osgeo.org> 
Subject: [Qgis-user] Plugin Processing crashes QGIS and computer
Hi all,
I have recently installed QGIS 3.10.4 LTR, as some of the new features would
be very useful to my work. Unfortunately, the Processing plugin which I use
quite a lot causes QGIS and my computer to crash nearly systematically.
After each fresh install - I uninstalled/installed QGIS a few times - and
the first crash, I get this message when I open QGIS again : « Plugin
processing : The plugin will be disabled because it crashed QGIS during last
startup. Please report an issue and re-enable the plugin when the problem
has been solved.” When I try to activate the plugin by ticking the box in
the ‘Manage and Install Plugins’ menu, my computer crashes again.
I have tried to install other standalone versions of QGIS, ie, 3.12.0-2 and
3.8.3-1, and the version that comes with the osgeo4w installer, and they all
cause the same problem. Only when I revert to my old 3.4.7 version does the
plugin function without any problem.
I have also tried to use a new user profile, and even to delete the QGIS
folder in the user/appdata/roaming folder, but this didn’t work.
I should add that the crashes are not totally systematic, as after one fresh
install, there was no crash when I opened QGIS without Grass functions for
the first time. However, the second time (QGIS with Grass functions), it
crashed again. The next times, it crashed be it with or without Grass
functions.
I am using Windows 10 Family edition and I have 2 monitors. When my computer
crashes, I get a blue screen with an error message that is not always the
same, but often it is a WHEA message. I have tried to unplug one of my
monitors before restarting the computer, but this did not solve the issue.
Of course, I can go on using QGIS 3.4.7, but it would be very helpful to
work with a more recent version, so I would very much appreciate your help
with this issue.
Thanks!
Best wishes,
Sabine
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200331/bc99416d/attachment.html>
------------------------------
Subject: Digest Footer
_______________________________________________
Qgis-user mailing listQgis-user at lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
------------------------------
End of Qgis-user Digest, Vol 169, Issue 50
******************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200331/dd0e1cac/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kod.py
Type: text/x-python
Size: 878 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200331/dd0e1cac/attachment.py>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: plik.csv.txt
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200331/dd0e1cac/attachment.txt>

More information about the Qgis-user mailing list