Delimited text issue

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Delimited text issue

Taimur al said
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
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: Delimited text issue

Andreas Neumann-4

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
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: Delimited text issue

Nicolas Cadieux
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 <[hidden email]> 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
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: Delimited text issue

Taimur al said
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 <[hidden email]> 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 <[hidden email]>
Sent: Monday, December 3, 2018 8:47 PM
To: Andreas Neumann
Cc: Taimur al said; [hidden email]
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 <[hidden email]> 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
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
<Screenshot (1).png>
<Screenshot (4).png>
<Screenshot (5).png>

_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user