Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • I have a csv with no column names hat has a code field and northing/easting data . I need to split out the csv by code and map to a template gdb using the code to map to the correct table and map columns to the correct column

Currently I set the projection in the reader for the csv to match the gdb. I then added a Feature Writer transformer for the fanout creating feature classes in a staging gdb. My problem now is how do I get the feature classes the feature writer created back into the workspace so I can then use the attribute manager to map to my final gdb. I tried to use the Feature Reader transformer to add these back but have not been able to figure that out yet.

Hi @patrick17​ 

Technically you do not need temp gdb, you should be able to write directly to the final geodatabase if you are satisfied with the workflow.

Although, using FeatureWriter/FeatureReader should work. Are there any particular issues you are having when reading the data back? Example here

I have the majority of things figured out but I am stuck. I am writing from a csv where all the fields are text. One of these fields contains a date 10/11/2021. I need to load this to a geodatabase that has the field formatted as a date. I have tried many different things and am probably just missing something but I can't get this to map. Attached is what my current workspace looks like. I believe I need to do this in the attribute manager using the dat time format but I am not figuring out how to dot his properly. imageimage

I have the majority of things figured out but I am stuck. I am writing from a csv where all the fields are text. One of these fields contains a date 10/11/2021. I need to load this to a geodatabase that has the field formatted as a date. I have tried many different things and am probably just missing something but I can't get this to map. Attached is what my current workspace looks like. I believe I need to do this in the attribute manager using the dat time format but I am not figuring out how to dot his properly. imageimage

@patrick17​ You should be able to use the functions you have set in the Attribute Manager it might be hard for me to troubleshoot without sample data.

I would recommend using the DataTimeConvertor transformer instead.

Alternative, you can Manually map the attribute type in CSV reader parameter windows as well

see here CSV_Parameters

Reply


Community Stats

30,167
Posts
114,522
Replies
37,824
Members
Terms & ConditionsCookie settings
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.