Archived

Support CSV data types through .csvt-files

Related products:FME Form

Forum|Forum|9 years ago
July 11, 2017
1 reply
31 views

+6

dollargis
Contributor

Currently, importing attribute data from CSV results in all attribute fields being of type 'string'.

The GeoCSV-specs (http://giswiki.hsr.ch/GeoCSV) describes and ogr2ogr in version 2 and newer implements the use of a .csvt-file that denominates the data type of a column. To quote from the gdal docs:

Limited type recognition can be done for Integer, Real, String, Date (YYYY-MM-DD), Time (HH:MM:SS+nn), DateTime (YYYY-MM-DD HH:MM:SS+nn) columns through a descriptive file with the same name as the CSV file, but a .csvt extension.

This mechanism would make the possibility to import data in CSV-format much more useful.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.