Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to add a delimited text layer, and I think I've formatted it correctly as a CSV file. There are no errors when I import the data. But even though there are 1300 rows total, only 189 appear in the table when I right click on the layer and open the attribute table. Is there any reason why it would import so few rows?

Thanks!

share|improve this question

1 Answer 1

There is a good chance that there are commas within some of your text fields. Even if the commas are surrounded by quotes, the delimiter plugin will parse a string into separate fields. These records will not be imported into your vector layer.

As an example, look at the second record in the 'text' field in the csv file below. It contains a comma within the string.

enter image description here

When you try to create your layer, the comma between "a,bc" is parsed as two different fields without an error message.

enter image description here

.. and the record with the comma is not included in the output:

enter image description here

You might try saving your file using a different delimiter. I often use "|" myself.

Hope that helps,

Cyrus

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.