Skip to main content

Hello, Below is a Concatenation of Schema from two shape file that have similar schema now put together. I send it in as SCHEMA{}.schema to the writer. Since this is basically a csv and the Writer see it in Dynamic mode i would think it would set the schema, but does not. any suggestions please?

 

AREA_MI fme_decimal(15,3),CENT_LAT fme_decimal(9,6),CENT_LONG fme_decimal(11,6),CFCC fme_varchar(3),COUNTY1 fme_varchar(100),COUNTY2 fme_varchar(100),COUNTY3 fme_varchar(100),CTY1FIPS fme_varchar(3),CTY2FIPS fme_varchar(3),CTY3FIPS fme_varchar(3),CTY_FIPS fme_int32,ENC_ZIP fme_varchar(5),ID fme_decimal(15,0),NAME fme_varchar(130),NAME1 fme_varchar(100),NAME2 fme_varchar(100),NAME3 fme_varchar(100),NAME4 fme_varchar(100),NAME5 fme_varchar(100),NAMETYPE fme_varchar(30),NAME_TYPE1 fme_varchar(30),NAME_TYPE2 fme_varchar(30),NAME_TYPE3 fme_varchar(30),NAME_TYPE4 fme_varchar(30),NAME_TYPE5 fme_varchar(30),PO_NAME fme_varchar(100),PT_LOC fme_varchar(1),RPO_FLAG fme_varchar(1),STATE fme_varchar(2),STATE_FIPS fme_int32,ST_FIPS fme_varchar(2),ZIP fme_varchar(5),ZIPTYPE fme_varchar(20)

 

I have tried SchemaSetter as well. not sure would is going on?

 

 


You could use a Dynamic writer for the GDB output and use the Shape file as the source for the schema.

First you need to add the Shape file as a resource:

Next you can use the schema from the Shape file to generate the schema for the dynamic GDB writer:

That will create a table in GDB that resembles the Shape file schema.

Hope this helps.


Hay thanks for the feed back . I am using FeatureReader that does not seem to have a selection to pick from in the Writer? Don't know why?


Hay thanks for the feed back . I am using FeatureReader that does not seem to have a selection to pick from in the Writer? Don't know why?

Do you read the Shape file in the FeatureReader?

 

In that case you can route both the Schema output and the Data to the GDB writer and use Dynamic schema with the option "Schema from schema feature".

 

(The Generic will be replaced by your Shape file).

 

 

 


Reply