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 made a CSVT file to change desired real data to string data. After importing the original CSV file, that was linked by file name to the CSVT file, the string data appears as normal however all the real data has been replaced with NULL values! Why is this happening?

With in the CSVT I have made sure there are no spaces, and I have also made sure the file name is exactly the same as the CSV. Any suggestions would be helpful!

share|improve this question
2  
perhaps you could post a couple of samples lines from the csv, plus the csvt line? –  Russell at ISC Jul 2 '13 at 14:35
add comment

1 Answer

You should convert/export your tabular data to .DBF instead of CSVT.

I tried to do this CSVT thing and it was a big pain and the results weren't great.

Instead, I exported my tabular data out of LibreCalc / OpenOffice Calc to a .DBF table.

I then added that to QGIS through the add vector layer (yes vector layer) dialogue - be sure to change data type to "All Files"

Sure enough, it read all the field formats spot on...I was off and running!

share|improve this answer
add comment

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.