Question

Converting CSV Char. schema to Date

  • 3 December 2013
  • 2 replies
  • 3 views

I have a csv files that I am creating a point shapefile. Currenty, I am only able to create string fields for the shapefile, but I want some of the fields to be dates. How do I convert the csv schema within a workbench to export data fields?

 

 

Thank you

2 replies

Userlevel 2
Badge +17
Hi,

 

 

I think you can write a date string formatted in "YYYYmmdd" (e.g. 20131203) into a date type field of the shape file. Consider using the DateFormatter transformer to format the date string.

 

 

Takashi
Userlevel 2
Badge +17
ah... your question was how to create date type fields on the Shape writer? Open "Feature Type Properties" dialog box of the writer feature type, move to "User Attributes" tab page. You can see Name, Type etc. of the fields; then change Type of required fields to "date".

Reply