Re: [Qgis-user] Delimited text issue
Dear all, Thank you Nicolas and Andreas. I have tried many tests cutting and pasting to a new sheet and saving the excel sheet as CSV files but still only 20 rows are showing. I think the sheet is fine but seems there is a problem with some settings on my QGIS. Is there any specific settings you would like me share with you? I also took a few screen shots of the excel sheet and on Qgis Much appreciated and thank you with regards, Taimur Al Said Taimur Al Said On Dec 4, 2018, at 10:54 AM, Taimur al said mailto:taimur_a_als...@hotmail.com>> wrote: Dear all, Thank you Nicolas and Andreas. I have tried many tests cutting and pasting to a new sheet and saving the excel sheet as CSV files but still only 20 rows are showing. I think the sheet is fine but seems there is a problem with some settings on my QGIS. Is there any specific settings you would like me share with you? I also took a few screen shots of the excel sheet and on Qgis Much appreciated and thank you with regards, Taimur Al Said From: Nicolas Cadieux mailto:nicolas.cadi...@archeotec.ca>> Sent: Monday, December 3, 2018 8:47 PM To: Andreas Neumann Cc: Taimur al said; qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org> Subject: Re: [Qgis-user] Delimited text issue Hi, Yes that seems to be the problem. Excel has a tendency to add empty delimiters in rows that have been erased. One way of dealing with that is to cut and paste to data you want in a new spreadsheet and then to export that to csv. I don’t think libreoffice has that problem. Nicolas Le 3 déc. 2018 à 06:47, Andreas Neumann mailto:a.neum...@carto.net>> a écrit : Hi, You seem to have an issue in your data around row 20. Probably not enough delimeters, or an unescaped character within an attribute that makes QGIS believe that parts of the data belongs to a different, potentially incompatible, attribute. Please check your data against mistakes. If you can't find it out yourself, upload it somewhere to share it and we can have a look. Without having access to your data and the setting you used (e.g. a screenshot of your settings), it is impossible to help. Another potential trouble could be that you have chosen more than one delimiter and QGIS chokes on that because that other delimiter is part of your data in a certain attribute. Andreas On 2018-12-03 12:07, Taimur al said wrote: Hi, I'm emailing regarding an issue i'm facing with the latest version of Qgis 3.4.2. Currently im trying to upload an excel sheet converted to (CSV format) on Qgis, this sheet has over 100 rows but only 20 rows are shown and then after adding these rows to the canvas only 20 points show. I have tried with other excel sheets (CSV) i have tried and worked with in the past with the older version and still only 20 rows show. May i ask if im doing anything wrong / is there a new way to do it? Hope to hear from you soon. Regards, Taimur Al Said Wildlife Biologist ___ Qgis-user mailing list Qgis-user@lists.osgeo.org<mailto:Qgis-user@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@lists.osgeo.org<mailto:Qgis-user@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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Delimited text issue
Hi, Yes that seems to be the problem. Excel has a tendency to add empty delimiters in rows that have been erased. One way of dealing with that is to cut and paste to data you want in a new spreadsheet and then to export that to csv. I don’t think libreoffice has that problem. Nicolas > Le 3 déc. 2018 à 06:47, Andreas Neumann a écrit : > > Hi, > > You seem to have an issue in your data around row 20. Probably not enough > delimeters, or an unescaped character within an attribute that makes QGIS > believe that parts of the data belongs to a different, potentially > incompatible, attribute. > > Please check your data against mistakes. If you can't find it out yourself, > upload it somewhere to share it and we can have a look. Without having access > to your data and the setting you used (e.g. a screenshot of your settings), > it is impossible to help. > > Another potential trouble could be that you have chosen more than one > delimiter and QGIS chokes on that because that other delimiter is part of > your data in a certain attribute. > > Andreas > >> On 2018-12-03 12:07, Taimur al said wrote: >> >> >> Hi, >> >> I'm emailing regarding an issue i'm facing with the latest version of Qgis >> 3.4.2. >> >> Currently im trying to upload an excel sheet converted to (CSV format) on >> Qgis, this sheet has over 100 rows but only 20 rows are shown and then after >> adding these rows to the canvas only 20 points show. I have tried with other >> excel sheets (CSV) i have tried and worked with in the past with the older >> version and still only 20 rows show. >> >> >> May i ask if im doing anything wrong / is there a new way to do it? >> >> Hope to hear from you soon. >> >> Regards, >> >> Taimur Al Said >> Wildlife Biologist >> >> ___ >> Qgis-user mailing list >> Qgis-user@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@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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Delimited text issue
Hi, You seem to have an issue in your data around row 20. Probably not enough delimeters, or an unescaped character within an attribute that makes QGIS believe that parts of the data belongs to a different, potentially incompatible, attribute. Please check your data against mistakes. If you can't find it out yourself, upload it somewhere to share it and we can have a look. Without having access to your data and the setting you used (e.g. a screenshot of your settings), it is impossible to help. Another potential trouble could be that you have chosen more than one delimiter and QGIS chokes on that because that other delimiter is part of your data in a certain attribute. Andreas On 2018-12-03 12:07, Taimur al said wrote: > Hi, > > I'm emailing regarding an issue i'm facing with the latest version of Qgis > 3.4.2. > > Currently im trying to upload an excel sheet converted to (CSV format) on > Qgis, this sheet has over 100 rows but only 20 rows are shown and then after > adding these rows to the canvas only 20 points show. I have tried with other > excel sheets (CSV) i have tried and worked with in the past with the older > version and still only 20 rows show. > > May i ask if im doing anything wrong / is there a new way to do it? > > Hope to hear from you soon. > > Regards, > > Taimur Al Said > Wildlife Biologist > ___ > Qgis-user mailing list > Qgis-user@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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Delimited text issue
Hi, I'm emailing regarding an issue i'm facing with the latest version of Qgis 3.4.2. Currently im trying to upload an excel sheet converted to (CSV format) on Qgis, this sheet has over 100 rows but only 20 rows are shown and then after adding these rows to the canvas only 20 points show. I have tried with other excel sheets (CSV) i have tried and worked with in the past with the older version and still only 20 rows show. May i ask if im doing anything wrong / is there a new way to do it? Hope to hear from you soon. Regards, Taimur Al Said Wildlife Biologist ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user