If I have a shape file with one or more fields "string" type and I import into PostGIS get all fields string set to varchar (10485760): why? How do I get a value other than 10485760 (for example varchar (30)? Is Possible?
Another question: can I import into PostGIS more shape files in one job?
Hi, For the time being String fields are mapped to varchar(10485760) as this is the default GeoTools mapping. We are currently working on improving that point and allowing to insert/update/append data to an existing PostGIS table.
> Another question: can I import into PostGIS more shape files in one job?
Yep, just add another ShapefileInput and another sPostgisOutput components.
If you want to merge two Shape into one postgis table use a tMerge Component in between.
For more than 10 shapefiles, you could use a tFileList component, select your directory, search pattern will be *.shp and could be recursive. Then iterate tFileList on tShapefileInput and then use tMerge to append all shape's features.
That way, it will search for all file *.shp, read all shape one after the other and the tMerge will append all geometries. You should have shapefile with the same attributes.
Hi, what is automatic mode ?
If you have 10 inputs and 10 outputs components, just define all transformations on the workspace.
Schema will be defined for each inputs and outputs components. If you always use the same schema, you can save it as a flat XML file (from the schema editor) or use the metadata section in the repository to save it.