Skip to main content
Archived

Support CSV data types through .csvt-files

Related products:FME Form
  • July 11, 2017
  • 1 reply
  • 31 views
dollargis
Contributor
Forum|alt.badge.img+6

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.

1 reply

bruceharold
Influencer
Forum|alt.badge.img+19
  • bruceharoldInfluencer
  • Influencer
  • August 9, 2017

A custom format can achieve this.

Community Stats

32,725
Posts
124,150
Replies
41,217
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.