[Qgis-user] Recurrent problem importing .CSV files : Numbers seen like text
Ludovic Cepre
ludovic.cepre at gmail.com
Tue Mar 31 11:37:55 PDT 2020
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... !!
Ludovic
Le 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) is
> https://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 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
>
> ------------------------------
>
> 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/342c3132/attachment-0001.html>
More information about the Qgis-user
mailing list